/// <summary>
/// 新增查询条件事件
/// </summary>
private void btnNew_Click(object sender, EventArgs e)
{
try
{
int minId = DataTypeConvert.GetInt(TableLineCondition.Compute("min(AutoId)", ""));
int newId = minId > 0 ? -1 : minId - 1;
DataTable copyTable = TableCondition.Copy();
FrmWorkFlowsLineSet_ConditionNew.workFlowsIdInt = workFlowsIdInt;
FrmWorkFlowsLineSet_ConditionNew.lineIdInt = lineIdInt;
FrmWorkFlowsLineSet_ConditionNew.lineTextStr = textLineText.Text.Trim();
FrmWorkFlowsLineSet_ConditionNew.conditionIdInt = newId;
FrmWorkFlowsLineSet_ConditionNew.conditionTextStr = "";
FrmWorkFlowsLineSet_ConditionNew condForm = new FrmWorkFlowsLineSet_ConditionNew();
condForm.bindingSource_Condition.DataSource = dSCondition;
condForm.bindingSource_Condition.DataMember = "Condition";
condForm.bindingSource_Condition.Filter = string.Format("ConditionId = {0}", newId);
if (condForm.ShowDialog() == DialogResult.OK)
{
string whereSql = FrmWorkFlowsLineSet_ConditionNew.lineTextStr;
string conditionTextStr = condForm.textConditionText.Text.Trim();
//int autoIdInt = setDAO.InsertWorkFlowsLineCondition(lineIdInt, conditionTextStr, whereSql, workFlowsIdInt);
//RefreshLineControlInfo();
//if (autoIdInt > 0)
// RefreshConditionInfo(autoIdInt);
DataRow dr = TableLineCondition.NewRow();
dr["AutoId"] = newId;
dr["LineId"] = lineIdInt;
dr["ConditionText"] = conditionTextStr;
dr["Condition"] = whereSql;
dr["Creator"] = SystemInfo.user.AutoId;
dr["GetTime"] = BaseSQL.GetServerDateTime();
dr["WorkFlowsId"] = workFlowsIdInt;
TableLineCondition.Rows.Add(dr);
bSLineCondition.MoveLast();
}
else
{
dSCondition.Tables[0].Rows.Clear();
foreach (DataRow copyRow in copyTable.Rows)
{
TableCondition.ImportRow(copyRow);
}
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--新增查询条件事件错误。", ex);
}
}
/// <summary>
/// 双击查询明细
/// </summary>
private void gridViewLineCondition_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
try
{
if (e.Clicks == 2 && e.Button == MouseButtons.Left)
{
DataTable copyTable = dSCondition.Tables[0].Copy();
int conditionIdInt = DataTypeConvert.GetInt(gridViewLineCondition.GetFocusedDataRow()["AutoId"]);
FrmWorkFlowsLineSet_ConditionNew.workFlowsIdInt = workFlowsIdInt;
FrmWorkFlowsLineSet_ConditionNew.lineIdInt = lineIdInt;
FrmWorkFlowsLineSet_ConditionNew.lineTextStr = textLineText.Text.Trim();
FrmWorkFlowsLineSet_ConditionNew.conditionIdInt = conditionIdInt;
FrmWorkFlowsLineSet_ConditionNew.conditionTextStr = DataTypeConvert.GetString(gridViewLineCondition.GetFocusedDataRow()["ConditionText"]);
FrmWorkFlowsLineSet_ConditionNew condForm = new FrmWorkFlowsLineSet_ConditionNew();
condForm.bindingSource_Condition.DataSource = dSCondition;
condForm.bindingSource_Condition.DataMember = "Condition";
condForm.bindingSource_Condition.Filter = string.Format("ConditionId = {0}", conditionIdInt);
if (condForm.ShowDialog() == DialogResult.OK)
{
gridViewLineCondition.GetFocusedDataRow()["ConditionText"] = condForm.textConditionText.Text.Trim();
gridViewLineCondition.GetFocusedDataRow()["Condition"] = FrmWorkFlowsLineSet_ConditionNew.lineTextStr;
}
else
{
dSCondition.Tables[0].Rows.Clear();
foreach (DataRow copyRow in copyTable.Rows)
{
TableCondition.ImportRow(copyRow);
}
}
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--双击查询明细错误。", ex);
}
}
