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());
}
