123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210 |
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Text;
- using System.Linq;
- using System.Threading.Tasks;
- using System.Windows.Forms;
- using DevExpress.XtraEditors;
- using ProjectBase.Data.BaseDAL;
- using SIMDP.BLL;
- using ProjectBase.Data.Logs;
- using SIMDP.Model;
- using SIMDP.Util;
- namespace SIMDP
- {
- public partial class FormLogOperationSetting : DevExpress.XtraEditors.XtraForm
- {
- string condition = null;
- public FormLogOperationSetting()
- {
- InitializeComponent();
- }
- private void FormLogOperationSetting_Load(object sender, EventArgs e)
- {
- InitControl();
- InitGrid();
- }
- /// <summary>
- /// 初始化控件
- /// </summary>
- private void InitControl()
- {
- List<string> tableList = BLLFactory<BlLogOperationSetting>.Instance.GetTableNames();
- tableList.Insert(0,"全部表");
- this.lookUp_TableName.Properties.DataSource = tableList;
- this.lookUp_TableName.Properties.NullText = null;
- this.lookUp_TableName.EditValue = tableList[0];
- }
- /// <summary>
- /// 初始化表格控件
- /// </summary>
- private void InitGrid()
- {
- //entity
- this.winGridViewPager1.OnPageChanged += new EventHandler(winGridViewPager1_OnPageChanged);
- this.winGridViewPager1.OnStartExport += new EventHandler(winGridViewPager1_OnStartExport);
- this.winGridViewPager1.OnRefresh += new EventHandler(winGridViewPager1_OnRefresh);
- this.winGridViewPager1.OnEditSelected += new EventHandler(winGridViewPager1_OnEditSelected);
- this.winGridViewPager1.OnAddNew += new EventHandler(winGridViewPager1_OnAddNew);
- this.winGridViewPager1.OnDeleteSelected += new EventHandler(winGridViewPager1_OnDeleteSelected);
- this.winGridViewPager1.gridView1.CustomColumnDisplayText += new DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventHandler(gridView1_CustomColumnDisplayText);
- this.winGridViewPager1.ShowLineNumber = true;
- this.winGridViewPager1.BestFitColumnWith = true;
- this.winGridViewPager1.DisplayColumns = "TableName,Forbid,InsertLog,DeleteLog,UpdateLog,CreatorName,CreateTime,EditorName,EditTime";
- #region 添加别名解析
- this.winGridViewPager1.AddColumnAlias("ID", "");
- this.winGridViewPager1.AddColumnAlias("TableName", "数据库表名称");
- this.winGridViewPager1.AddColumnAlias("Forbid", "是否禁用");
- this.winGridViewPager1.AddColumnAlias("InsertLog", "记录插入日志");
- this.winGridViewPager1.AddColumnAlias("DeleteLog", "记录删除日志");
- this.winGridViewPager1.AddColumnAlias("UpdateLog", "记录更新日志");
- this.winGridViewPager1.AddColumnAlias("CreatorAccount", "");
- this.winGridViewPager1.AddColumnAlias("CreatorName", "创建人");
- this.winGridViewPager1.AddColumnAlias("CreateTime", "创建时间");
- this.winGridViewPager1.AddColumnAlias("EditorAccount", "");
- this.winGridViewPager1.AddColumnAlias("EditorName", "编辑人名称");
- this.winGridViewPager1.AddColumnAlias("EditTime", "编辑时间");
- #endregion
- this.winGridViewPager1.PrintTitle = "用户操作日志数据库表配置表";
- this.winGridViewPager1.gridView1.Appearance.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
- BindData(" 1=1");
- condition = " 1=1";
- }
- /// <summary>
- /// 绑定数据源
- /// </summary>
- /// <param name="condition"></param>
- private void BindData(string condition)
- {
- this.winGridViewPager1.DataSource = BLLFactory<BlLogOperationSetting>.Instance.FindWithPager(condition, this.winGridViewPager1.PagerInfo);
- for (int i = 0; i < this.winGridViewPager1.gridView1.Columns.Count; i++) //设置每列内容居中显示
- {
- this.winGridViewPager1.gridView1.Columns[i].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
- }
- }
- /// <summary>
- /// 分页控件翻页的操作
- /// </summary>
- private void winGridViewPager1_OnPageChanged(object sender, EventArgs e)
- {
- BindData(condition);
- }
- /// <summary>
- /// 分页控件全部导出操作前的操作
- /// </summary>
- private void winGridViewPager1_OnStartExport(object sender, EventArgs e)
- {
- this.winGridViewPager1.AllToExport = BLLFactory<BlLogOperationSetting>.Instance.Find(condition);
- }
- /// <summary>
- /// 分页控件刷新操作
- /// </summary>
- private void winGridViewPager1_OnRefresh(object sender, EventArgs e)
- {
- BindData(condition);
- }
- /// <summary>
- /// 分页控件编辑项操作
- /// </summary>
- private void winGridViewPager1_OnEditSelected(object sender, EventArgs e)
- {
- MoLogOperationSetting selectRow = this.winGridViewPager1.gridView1.GetFocusedRow() as MoLogOperationSetting;
- }
- /// <summary>
- /// 分页控件新增操作
- /// </summary>
- private void winGridViewPager1_OnAddNew(object sender, EventArgs e)
- {
- }
- /// <summary>
- /// 分页控件删除操作
- /// </summary>
- private void winGridViewPager1_OnDeleteSelected(object sender, EventArgs e)
- {
- try
- {
- if (DevExpress.XtraEditors.XtraMessageBox.Show("您确定删除选定的记录么?", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.No)
- {
- return;
- }
- MoLogOperationSetting selectRow = this.winGridViewPager1.gridView1.GetFocusedRow() as MoLogOperationSetting;
- int id = Convert.ToInt32(selectRow.ID);
- bool flag = BLLFactory<BlLogOperationSetting>.Instance.Delete(id, SysEnvironment.CurrentLoginID);
- if (flag)
- {
- DevExpress.XtraEditors.XtraMessageBox.Show("删除成功。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
- BindData(condition);
- }
- }
- catch (Exception ex)
- {
- DevExpress.XtraEditors.XtraMessageBox.Show("删除失败。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
- LogHelper.log.Error(string.Format("删除数据库log_operationSetting出现错误:{0}", ex));
- }
- }
- void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
- {
- if (e.Column.ColumnType == typeof(DateTime))
- {
- string columnName = e.Column.FieldName;
- if (e.Value != null)
- {
- if (Convert.ToDateTime(e.Value) <= Convert.ToDateTime("1900-1-1"))
- {
- e.DisplayText = "";
- }
- else
- {
- e.DisplayText = Convert.ToDateTime(e.Value).ToString("yyyy-MM-dd HH:mm");//yyyy-MM-dd
- }
- }
- }
- }
- private void btn_Query_Click(object sender, EventArgs e)
- {
- if (lookUp_TableName.Text == "全部表" && check_Forbid.CheckState != CheckState.Checked)
- {
- BindData(" 1=1");
- condition = " 1=1";
- return;
- }
- string sql = " 1=1";
- if (lookUp_TableName.Text != "全部表")
- {
- sql += string.Format(" AND setting_tableName = '{0}'",lookUp_TableName.Text);
- }
- if (check_Forbid.CheckState == CheckState.Checked)
- {
- sql += string.Format(" AND setting_forBid = {0}" ,1);
- }
- BindData(sql);
- condition = sql;
- }
- private void btn_Add_Click(object sender, EventArgs e)
- {
- winGridViewPager1_OnAddNew(sender, e);
- }
- }
- }
|