public UserControlOnBusiness(PlatformManagement.FunctionTreeNodeInfo nodeInfo) { InitializeComponent(); m_billMessageServer.BillType = "出差申请单"; m_authorityFlag = nodeInfo.Authority; #region 数据筛选 string[] strBillStatus = { "全部", OnBusinessBillStatus.新建单据.ToString(), OnBusinessBillStatus.等待随行人员部门确认.ToString(), OnBusinessBillStatus.等待部门负责人审核.ToString(), OnBusinessBillStatus.等待分管领导审批.ToString(), OnBusinessBillStatus.等待总经理批准.ToString(), OnBusinessBillStatus.等待销差人确认.ToString(), OnBusinessBillStatus.等待出差结果说明.ToString(), OnBusinessBillStatus.已完成.ToString() }; checkBillDateAndStatus1.InsertComBox(strBillStatus); checkBillDateAndStatus1.dtpStartTime.Value = ServerTime.Time.AddDays(1).AddMonths(-1); checkBillDateAndStatus1.dtpEndTime.Value = ServerTime.Time.AddDays(1); #endregion m_onBusinessServer.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text) + checkBillDateAndStatus1.GetSqlString("申请时间", "单据状态"); RefreshDataGridView(); }
private void Post(QueryFilterControl filter) { //var queryDb = new Query_DB(); var querySearchObjectDb = new QuerySearchObject_DB(); querySearchObjectDb.PostDetail(filter.QueryDataset, (int)PostType.FinalPosting, null); }
/// <summary> /// 刷新 /// </summary> void RefreshControl() { m_tcuRepairServer.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text) + checkBillDateAndStatus1.GetSqlString("记录时间", "单据状态"); IQueryResult result; if (!m_tcuRepairServer.GetAllData(out result, out m_error)) { MessageDialog.ShowPromptMessage(m_error); } if (dataGridView1.Rows.Count > 0) { dataGridView1.Columns["员工编号"].Visible = false; dataGridView1.Columns["确认人编号"].Visible = false; dataGridView1.Columns["报修人编号"].Visible = false; } if (result.DataCollection == null || result.DataCollection.Tables.Count == 0) { return; } dataGridView1.DataSource = result.DataCollection.Tables[0]; userControlDataLocalizer1.Init(dataGridView1, this.Name, UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID)); }
private QueryFilterControl CreateFilterControl(string lang = "en") { DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString")); ConnectionManager.DefaultInstance.SetCredentials(Config.GetSetting("EidssConnectionString")); EidssUserContext.Init(); context = ModelUserContext.Instance as EidssUserContext; Security = new EidssSecurityManager(); int result = Security.LogIn(Organizaton, Admin, AdminPassword); Assert.AreEqual(0, result); EIDSS_LookupCacheHelper.Init(); EidssUserContext.CurrentLanguage = lang; var queryDb = new Query_DB(); var querySearchObjectDb = new QuerySearchObject_DB(); var queryDs = queryDb.LoadDetailData(QueryId); DataRow row = queryDs.Tables[Query_DB.TasQueryObjectTree].Rows[0]; var searchObjectsDs = querySearchObjectDb.LoadDetailData(row["idfQuerySearchObject"]); var form = new Form(); var filter = new QueryFilterControl { Parent = form, Dock = DockStyle.Fill }; filter.Init(); filter.Bind((long)queryDs.Tables[1].Rows[0]["idfQuerySearchObject"], searchObjectsDs); return(filter); }
static void Main() { try { //Application.ThreadException += new ThreadExceptionEventHandler(UIThreadException); //Application.SetUnhandledExceptionMode(UnhandledExceptionMode.CatchException); //AppDomain.CurrentDomain.UnhandledException += // new UnhandledExceptionEventHandler(CurrentDomain_UnhandledException); // 虚拟打印机初始化 VirtualPrint.Init(); // 列宽控制类初始化 ColumnWidthControl.Init(); // 查询过滤器初始化 QueryFilterControl.Init(); GlobalObject.GlobalParameter.Init(); Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new FormMain()); // 保存设置 ColumnWidthControl.Save(); } catch (Exception exce) { MessageDialog.ShowErrorMessage(exce.Message); } }
public void QueryFilterRefreshTest() { QueryFilterControl filter = CreateFilterControl(); GroupOperator aggrGroup, rootGroup; CreateFilterCondition1(filter, out rootGroup, out aggrGroup); DataTable searchCriteriaTable = filter.QueryDataset.Tables[QuerySearchObject_DB.TasQueryConditionGroup]; filter.Flush(); Assert.AreEqual(6, searchCriteriaTable.Rows.Count); var querySearchObjectId = (long)filter.QueryDataset.Tables[QuerySearchObject_DB.TasQuerySearchObject].Rows[0]["idfQuerySearchObject"]; DataRow row = filter.QueryDataset.Tables[QuerySearchObject_DB.TasQuerySearchField].Rows.Find(HumanCaseIdField); if (row != null) { row.Delete(); } filter.RefreshNodes(); Assert.AreEqual(4, searchCriteriaTable.Rows.Count); CheckConditionRow(searchCriteriaTable.Rows[0], -1L, DBNull.Value, querySearchObjectId, 0); CheckConditionRow(searchCriteriaTable.Rows[1], -2L, -1L, querySearchObjectId, 0, SubQuerySearchObjectId - 1, DBNull.Value, "Exists"); CheckConditionRow(searchCriteriaTable.Rows[2], -3L, -2L, SubQuerySearchObjectId - 1, 0); CheckConditionRow(searchCriteriaTable.Rows[3], DBNull.Value, -3L, SubQuerySearchObjectId - 1, 0, DBNull.Value, SubQuerySearchFieldIdSeed - 1L, "Binary", 0, TestNameIdValue); }
/// <summary> /// 刷新 /// </summary> void RefreshDataGridView() { m_overTimeServer.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text) + checkBillDateAndStatus1.GetSqlString("申请时间", "单据状态"); IQueryResult result; if (!m_overTimeServer.GetAllOverTimeBill(out result, out error)) { MessageDialog.ShowErrorMessage(error); return; } //if (result.DataCollection.Tables[0].Rows.Count == 0) //{ // if (!m_overTimeServer.GetAllOverTimeBillByWorkID(out result, out error)) // { // MessageDialog.ShowErrorMessage(error); // return; // } //} dataGridView1.DataSource = result.DataCollection.Tables[0]; if (dataGridView1.Rows.Count > 0) { dataGridView1.Columns["员工编号"].Visible = false; dataGridView1.Columns["部门编码"].Visible = false; } this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler( this.dataGridView1_ColumnWidthChanged); ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1); this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler( this.dataGridView1_ColumnWidthChanged); // 添加查询用的列 if (m_findField == null) { List <string> lstColumnName = new List <string>(); for (int i = 0; i < dataGridView1.Columns.Count; i++) { if (dataGridView1.Columns[i].Visible) { lstColumnName.Add(dataGridView1.Columns[i].Name); } } m_findField = lstColumnName.ToArray(); } userControlDataLocalizer1.Init(dataGridView1, this.Name, UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID)); //dataGridView1.Refresh(); }
private void CheckFilterCondition2(QueryFilterControl filter) { DataTable searchCriteriaTable = filter.QueryDataset.Tables[QuerySearchObject_DB.TasQueryConditionGroup]; CheckFilterCondition1(filter); //Human case Test Type = 6618590000000 ('Anaplasma test') CheckConditionRow(searchCriteriaTable.Rows[6], DBNull.Value, -3L, SubQuerySearchObjectId, 1, DBNull.Value, SubQuerySearchFieldIdSeed, "Binary", 1, TestNameIdValue); }
/* * AND * Human Case ID = 'AAA' * Human Case ID = 'BBB' * Exists Human Case Test * AND * Human case Test Type = 6618590000000 ('Anaplasma test') * Human case Test Type <> 6618590000000 ('Anaplasma test') */ private void CreateFilterCondition2(QueryFilterControl filter, ref GroupOperator rootGroup, ref GroupOperator aggrGroup) { CriteriaOperator criteria = filter.FilterCriteria; CreateFilterCondition1(filter, out rootGroup, out aggrGroup); QueryFilterControl.AddFieldOperator(aggrGroup, TestNameAlias, TestNameIdValue, SearchOperator.Binary, BinaryOperatorType.NotEqual, false); filter.FilterCriteria = rootGroup; }
private void 设置数据过滤器_Click(object sender, EventArgs e) { FormFilterCondition form = new FormFilterCondition(labelTitle.Text, m_findField, labelTitle.Text); form.ShowDialog(); m_billServer.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text); RefreshData(); }
private void 设置数据过滤器ToolStripMenuItem_Click(object sender, EventArgs e) { FormFilterCondition form = new FormFilterCondition(labelTitle.Text, m_findField, labelTitle.Text); form.ShowDialog(); m_billServer.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text); menuItemReresh.PerformClick(); }
public void QueryFilterPostLoadTest() { QueryFilterControl filter = CreateFilterControl(); GroupOperator aggrGroup, rootGroup; CreateFilterCondition1(filter, out rootGroup, out aggrGroup); Post(filter); filter = CreateFilterControl(); CheckFilterCondition1(filter); }
/// <summary> /// 刷新数据 /// </summary> void RefreshData() { m_serverReviewProcess.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text) + checkBillDateAndStatus1.GetSqlString("申请日期", "流程状态"); dataGridView1.DataSource = m_serverReviewProcess.GetAllInfo(); userControlDataLocalizer1.Init(dataGridView1, this.Name, UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID)); }
/* * OR * Human Case ID = 'AAA' * Human Case ID = 'BBB' */ private void CreateFilterCondition3(QueryFilterControl filter, out GroupOperator rootGroup) { CriteriaOperator criteria; rootGroup = QueryFilterControl.AddGroupOperator(null, null, null, out criteria); rootGroup.OperatorType = GroupOperatorType.Or; QueryFilterControl.AddFieldOperator(rootGroup, CaseIDAlias, StrValue1, SearchOperator.Binary, BinaryOperatorType.Equal, false); QueryFilterControl.AddFieldOperator(rootGroup, CaseIDAlias, StrValue2, SearchOperator.Binary, BinaryOperatorType.Equal, false); filter.FilterCriteria = criteria; filter.HasChanges = true; }
/// <summary> /// 查找并刷新数据 /// </summary> private void RefreshData() { m_billServer.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text) + checkBillDateAndStatus1.GetSqlString("退货时间", "单据状态"); if (!m_billServer.GetAllBill(out m_queryResult, out m_error)) { MessageDialog.ShowErrorMessage(m_error); return; } RefreshDataGridView(m_queryResult); }
private void 设置数据过滤器ToolStripMenuItem_Click(object sender, EventArgs e) { FormFilterCondition form = new FormFilterCondition(labelTitle.Text, m_findField, labelTitle.Text); form.ShowDialog(); m_billServer.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text); if (m_billServer.GetAllBill(out m_queryResult, out m_error)) { RefreshDataGridView(m_queryResult); } }
private void btnRefresh_Click(object sender, EventArgs e) { m_billServer.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text) + checkBillDateAndStatus1.GetSqlString("单据提交时间", "单据状态"); if (!m_billServer.GetAllBill(out m_queryResult, out m_strErr)) { MessageDialog.ShowErrorMessage(m_strErr); return; } RefreshDataGridView(m_queryResult); }
/// <summary> /// 刷新 /// </summary> /// <param name="source">数据集</param> void DataBindGirdView() { m_serverFeedBack.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text) + checkBillDateAndStatus1.GetSqlString("反馈日期", "单据状态"); IQueryResult result; if (!m_serverFeedBack.GetAllBillFeedBack(out result, out error)) { MessageDialog.ShowErrorMessage(error); return; } dataGridView1.DataSource = result.DataCollection.Tables[0]; if (dataGridView1.Rows.Count > 0) { dataGridView1.Columns["反馈人编号"].Visible = false; dataGridView1.Columns["责任人编号"].Visible = false; dataGridView1.Columns["营销售后审核人编号"].Visible = false; dataGridView1.Columns["质管意见提出人编号"].Visible = false; dataGridView1.Columns["责任部门主管编号"].Visible = false; dataGridView1.Columns["部门编码"].Visible = false; dataGridView1.Columns["质管检查人编号"].Visible = false; } if (m_findField == null) { List <string> lstColumnName = new List <string>(); for (int i = 0; i < dataGridView1.Columns.Count; i++) { if (dataGridView1.Columns[i].Visible) { lstColumnName.Add(dataGridView1.Columns[i].Name); } } m_findField = lstColumnName.ToArray(); } if (m_dataLocalizer == null) { m_dataLocalizer = new UserControlDataLocalizer(dataGridView1, this.Name, UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID)); panelPara.Controls.Add(m_dataLocalizer); m_dataLocalizer.Dock = DockStyle.Bottom; } }
/// <summary> /// 刷新 /// </summary> private void RefreshDataGridView() { m_cultivateServer.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text) + "培训开始时间>='" + dtpQueryStartTime.Value.ToString() + "' and 培训开始时间<='" + dtpQueryEndTime.Value.ToString() + "'"; IQueryResult result; if (!m_cultivateServer.GetAllBill(out result, out m_error)) { MessageDialog.ShowErrorMessage(m_error); return; } dataGridView1.DataSource = result.DataCollection.Tables[0]; this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler( this.dataGridView1_ColumnWidthChanged); ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1); this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler( this.dataGridView1_ColumnWidthChanged); // 添加查询用的列 if (m_findField == null) { List <string> lstColumnName = new List <string>(); for (int i = 0; i < dataGridView1.Columns.Count; i++) { if (dataGridView1.Columns[i].Visible) { lstColumnName.Add(dataGridView1.Columns[i].Name); } } m_findField = lstColumnName.ToArray(); } userControlDataLocalizer1.Init(dataGridView1, this.Name, UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID)); dataGridView1.Refresh(); if (dataGridView1.Rows.Count > 0) { dataGridView1.Columns["序号"].Visible = false; } }
private void CheckFilterCondition3(QueryFilterControl filter) { DataTable searchCriteriaTable = filter.QueryDataset.Tables[QuerySearchObject_DB.TasQueryConditionGroup]; var querySearchObjectId = (long)filter.QueryDataset.Tables[QuerySearchObject_DB.TasQuerySearchObject].Rows[0]["idfQuerySearchObject"]; //root OR CheckConditionRow(searchCriteriaTable.Rows[0], -1L, DBNull.Value, querySearchObjectId, 0, null, null, null, null, null, null, true); //Human Case ID = 'AAA' CheckConditionRow(searchCriteriaTable.Rows[1], DBNull.Value, -1L, querySearchObjectId, 0, DBNull.Value, HumanCaseIdField, "Binary", 0, StrValue1, null, true); //Human Case ID = 'BBB' CheckConditionRow(searchCriteriaTable.Rows[2], DBNull.Value, -1L, querySearchObjectId, 1, DBNull.Value, HumanCaseIdField, "Binary", 0, StrValue2, null, true); }
public 报废单(PlatformManagement.FunctionTreeNodeInfo nodeInfo) { InitializeComponent(); m_msgPromulgator.BillType = "报废单"; m_billNoControl = new BillNumberControl(labelTitle.Text, m_billServer); m_authorityFlag = nodeInfo.Authority; dateTimePickerST.Value = ServerModule.ServerTime.Time; dateTimePickerET.Value = ServerModule.ServerTime.Time.AddDays(1); m_billServer.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text); RefreshData(); }
public void QueryFilterFlashTest() { QueryFilterControl filter = CreateFilterControl(); GroupOperator aggrGroup, rootGroup; CreateFilterCondition1(filter, out rootGroup, out aggrGroup); filter.Flush(); DataTable searchCriteriaTable = filter.QueryDataset.Tables[QuerySearchObject_DB.TasQueryConditionGroup]; Assert.AreEqual(6, searchCriteriaTable.Rows.Count); string filterText = filter.GetFilterText(filter.FilterCriteria, null, " "); CheckFilterCondition1(filter); var ds = filter.QueryDataset; filter = CreateFilterControl(); filter.Bind((long)ds.Tables[1].Rows[0]["idfQuerySearchObject"], ds); filter.Flush(); CheckFilterCondition1(filter); filter = CreateFilterControl(); CreateFilterCondition2(filter, ref rootGroup, ref aggrGroup); filter.Flush(); searchCriteriaTable = filter.QueryDataset.Tables[QuerySearchObject_DB.TasQueryConditionGroup]; Assert.AreEqual(7, searchCriteriaTable.Rows.Count); CheckFilterCondition2(filter); ds = filter.QueryDataset; filter = CreateFilterControl(); filter.Bind((long)ds.Tables[1].Rows[0]["idfQuerySearchObject"], ds); filter.Flush(); CheckFilterCondition2(filter); filter = CreateFilterControl(); CreateFilterCondition3(filter, out rootGroup); filter.Flush(); searchCriteriaTable = filter.QueryDataset.Tables[QuerySearchObject_DB.TasQueryConditionGroup]; Assert.AreEqual(3, searchCriteriaTable.Rows.Count); CheckFilterCondition3(filter); ds = filter.QueryDataset; filter = CreateFilterControl(); filter.Bind((long)ds.Tables[1].Rows[0]["idfQuerySearchObject"], ds); filter.Flush(); CheckFilterCondition3(filter); }
private QueryFilterControl CreateFilterControl(string lang = "en") { var queryDb = new Query_DB(); var querySearchObjectDb = new QuerySearchObject_DB(); DataSet queryDs = queryDb.LoadDetailData(QueryId); DataRow row = queryDs.Tables[Query_DB.TasQueryObjectTree].Rows[0]; DataSet searchObjectsDs = querySearchObjectDb.LoadDetailData(row["idfQuerySearchObject"]); var form = new Form(); var filter = new QueryFilterControl { Parent = form, Dock = DockStyle.Fill }; filter.Init(); filter.Bind((long)queryDs.Tables[1].Rows[0]["idfQuerySearchObject"], searchObjectsDs); return(filter); }
/* * AND * Human Case ID = 'AAA' * Human Case ID = 'BBB' * Exists Human Case Test * AND * Human case Test Type = 6618590000000 ('Anaplasma test') */ private void CreateFilterCondition1(QueryFilterControl filter, out GroupOperator rootGroup, out GroupOperator aggrGroup) { CriteriaOperator criteria; rootGroup = QueryFilterControl.AddGroupOperator(null, null, null, out criteria); QueryFilterControl.AddFieldOperator(rootGroup, CaseIDAlias, StrValue1, SearchOperator.Binary, BinaryOperatorType.Equal, false); QueryFilterControl.AddFieldOperator(rootGroup, CaseIDAlias, StrValue2, SearchOperator.Binary, BinaryOperatorType.Equal, false); AggregateOperand aggrOp = QueryFilterControl.AddAggregateOperand(rootGroup, "<Human Case Test>", false); CriteriaOperator aggrCriteria; aggrGroup = QueryFilterControl.AddGroupOperator(null, null, null, out aggrCriteria); QueryFilterControl.AddFieldOperator(aggrGroup, TestNameAlias, TestNameIdValue, SearchOperator.Binary, BinaryOperatorType.Equal, false); aggrOp.Condition = aggrCriteria; filter.FilterCriteria = criteria; filter.HasChanges = true; }
/// <summary> /// 刷新 /// </summary> void RefreshDataGridView() { m_marketPartBillServer.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text) + checkBillDateAndStatus1.GetSqlString("销售时间", "单据状态"); IQueryResult result; if (!m_marketPartBillServer.GetAllBill(out result, out m_error)) { MessageDialog.ShowErrorMessage(m_error); return; } dataGridView1.DataSource = result.DataCollection.Tables[0]; this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler( this.dataGridView1_ColumnWidthChanged); ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1); this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler( this.dataGridView1_ColumnWidthChanged); userControlDataLocalizer1.Init(dataGridView1, this.Name, UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID)); foreach (DataGridViewColumn item in dataGridView1.Columns) { if (item.Name != "选") { item.ReadOnly = true; } else { item.ReadOnly = false; item.Frozen = false; } } dataGridView1.Columns["ClientID"].Visible = false; dataGridView1.Columns["价格套用的整车厂"].Visible = false; dataGridView1.Columns["价格套用的整车厂编码"].Visible = false; }
private void CheckFilterCondition1(QueryFilterControl filter) { DataTable searchCriteriaTable = filter.QueryDataset.Tables[QuerySearchObject_DB.TasQueryConditionGroup]; var querySearchObjectId = (long)filter.QueryDataset.Tables[QuerySearchObject_DB.TasQuerySearchObject].Rows[0]["idfQuerySearchObject"]; //root AND CheckConditionRow(searchCriteriaTable.Rows[0], -1L, DBNull.Value, querySearchObjectId, 0); //Human Case ID = 'AAA' CheckConditionRow(searchCriteriaTable.Rows[1], DBNull.Value, -1L, querySearchObjectId, 0, DBNull.Value, HumanCaseIdField, "Binary", 0, StrValue1); //Human Case ID = 'BBB' CheckConditionRow(searchCriteriaTable.Rows[2], DBNull.Value, -1L, querySearchObjectId, 1, DBNull.Value, HumanCaseIdField, "Binary", 0, StrValue2); //Exists Human Case Test CheckConditionRow(searchCriteriaTable.Rows[3], -2L, -1L, querySearchObjectId, 2, SubQuerySearchObjectId, DBNull.Value, "Exists"); //Child Human Case Test AND CheckConditionRow(searchCriteriaTable.Rows[4], -3L, -2L, SubQuerySearchObjectId, 0); //Human case Test Type = 6618590000000 ('Anaplasma test') CheckConditionRow(searchCriteriaTable.Rows[5], DBNull.Value, -3L, SubQuerySearchObjectId, 0, DBNull.Value, SubQuerySearchFieldIdSeed, "Binary", 0, TestNameIdValue); }
/// <summary> /// 刷新 /// </summary> private void RefreshDataGridView() { m_minorBillServer.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text) + checkBillDateAndStatus1.GetSqlString("编制日期", "单据状态"); IQueryResult result; if (!m_minorBillServer.GetAllBillInfo(out result, out m_error)) { MessageDialog.ShowErrorMessage(m_error); return; } if (result.DataCollection == null || result.DataCollection.Tables.Count == 0) { return; } dataGridView1.DataSource = result.DataCollection.Tables[0]; dataGridView1.Columns["编号"].Visible = false; dataGridView1.Columns["部门月预算内"].Visible = false; this.dataGridView1.ColumnWidthChanged -= new System.Windows.Forms.DataGridViewColumnEventHandler( this.dataGridView1_ColumnWidthChanged); ColumnWidthControl.SetDataGridView(labelTitle.Text, dataGridView1); this.dataGridView1.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler( this.dataGridView1_ColumnWidthChanged); userControlDataLocalizer1.Init(dataGridView1, this.Name, UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID)); dataGridView1.Refresh(); }
/// <summary> /// 查找并刷新数据 /// </summary> private void RefreshData() { m_billServer.QueryResultFilter = QueryFilterControl.GetFilterString(labelTitle.Text) + checkBillDateAndStatus1.GetSqlString("建单时间", "单据状态"); RefreshDataGridView(m_billServer.GetAllBill()); }