/// <summary>
/// 新增信息
/// </summary>
/// <param name="_Workflow_OperatorConditionEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string AddWorkflow_OperatorCondition(Workflow_OperatorConditionEntity _Workflow_OperatorConditionEntity)
{
DbParameter[] pramsInsert = {
MakeInParam("@BatchSeq",(DbType)SqlDbType.Int,4,_Workflow_OperatorConditionEntity.BatchSeq ),
MakeInParam("@BranchBatchSeq",(DbType)SqlDbType.Int,4,_Workflow_OperatorConditionEntity.BranchBatchSeq ),
MakeInParam("@RuleID",(DbType)SqlDbType.Int,4,_Workflow_OperatorConditionEntity.RuleID ),
MakeInParam("@FieldID",(DbType)SqlDbType.Int,4,_Workflow_OperatorConditionEntity.FieldID ),
MakeInParam("@SymbolCode",(DbType)SqlDbType.VarChar,50,_Workflow_OperatorConditionEntity.SymbolCode ),
MakeInParam("@CompareToValue",(DbType)SqlDbType.VarChar,200,_Workflow_OperatorConditionEntity.CompareToValue ),
MakeInParam("@AndOr",(DbType)SqlDbType.VarChar,50,_Workflow_OperatorConditionEntity.AndOr ),
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[Workflow_OperatorCondition]");
sb.Append("(");
sb.Append(" [BatchSeq]");
sb.Append(",[BranchBatchSeq]");
sb.Append(",[RuleID]");
sb.Append(",[FieldID]");
sb.Append(",[SymbolCode]");
sb.Append(",[CompareToValue]");
sb.Append(",[AndOr]");
sb.Append(") ");
sb.Append(" VALUES (");
sb.Append("@BatchSeq,");
sb.Append("@BranchBatchSeq,");
sb.Append("@RuleID,");
sb.Append("@FieldID,");
sb.Append("@SymbolCode,");
sb.Append("@CompareToValue,");
sb.Append("@AndOr )");
sb.Append("select @@identity;");
return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
DataTable dtConditonSeq = (DataTable)ViewState["dtConditonSeq"];
Workflow_OperatorConditionEntity _NodeConditionEntity = new Workflow_OperatorConditionEntity();
_NodeConditionEntity.RuleID = DNTRequest.GetInt("id", 0);
DataTable dtMaxSeq = DbHelper.GetInstance().GetDBRecords("MaxBatchSeq=isnull(max(BatchSeq),0)+1", "Workflow_OperatorCondition", "RuleID=" + DNTRequest.GetString("id"), "");
_NodeConditionEntity.BatchSeq = Convert.ToInt32(dtMaxSeq.Rows[0]["MaxBatchSeq"]);
for (int i = 0; i < dtConditonSeq.Rows.Count; i++)
{
_NodeConditionEntity.BranchBatchSeq = Convert.ToInt32(dtConditonSeq.Rows[i]["BranchBatchSeq"]);
_NodeConditionEntity.FieldID = Convert.ToInt32(dtConditonSeq.Rows[i]["FieldID"]);
_NodeConditionEntity.SymbolCode = dtConditonSeq.Rows[i]["SymbolCode"].ToString();
_NodeConditionEntity.CompareToValue = dtConditonSeq.Rows[i]["CompareToValue"].ToString();
_NodeConditionEntity.AndOr = dtConditonSeq.Rows[i]["AndOr"].ToString();
DbHelper.GetInstance().AddWorkflow_OperatorCondition(_NodeConditionEntity);
}
dtConditonSeq.Rows.Clear();
DataRow dr = dtConditonSeq.NewRow();
dr["BranchBatchSeq"] = 1;
dr["FieldID"] = 0;
dr["SymbolCode"] = "";
dr["CompareToValue"] = "";
dr["AndOr"] = "";
dtConditonSeq.Rows.Add(dr);
BindGridView();
BindGridView2();
UpdateSqlCondition();
}
