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