protected void btnAdd_Click(object sender, EventArgs e)
{
DataTable dtConditonSeq = (DataTable)ViewState["dtConditonSeq"];
Workflow_NodeAddInOperation_Type0ConditionEntity _Type1ConditionEntity = new Workflow_NodeAddInOperation_Type0ConditionEntity();
_Type1ConditionEntity.AddInOPID = DNTRequest.GetInt("opid", 0);
DataTable dtMaxSeq = DbHelper.GetInstance().GetDBRecords("MaxBatchSeq=isnull(max(BatchSeq),0)+1", "Workflow_NodeAddInOperation_Type0Condition", "AddInOPID=" + DNTRequest.GetString("opid"), "");
_Type1ConditionEntity.BatchSeq = Convert.ToInt32(dtMaxSeq.Rows[0]["MaxBatchSeq"]);
for (int i = 0; i < dtConditonSeq.Rows.Count; i++)
{
_Type1ConditionEntity.BranchBatchSeq = Convert.ToInt32(dtConditonSeq.Rows[i]["BranchBatchSeq"]);
_Type1ConditionEntity.FieldID = Convert.ToInt32(dtConditonSeq.Rows[i]["FieldID"]);
_Type1ConditionEntity.SymbolCode = dtConditonSeq.Rows[i]["SymbolCode"].ToString();
_Type1ConditionEntity.CompareToValue = dtConditonSeq.Rows[i]["CompareToValue"].ToString();
_Type1ConditionEntity.AndOr = dtConditonSeq.Rows[i]["AndOr"].ToString();
DbHelper.GetInstance().AddWorkflow_NodeAddInOperation_Type0Condition(_Type1ConditionEntity);
}
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();
UpdateOPCondition();
}
/// <summary>
/// 新增信息
/// </summary>
/// <param name="_Type0ConditionEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string AddWorkflow_NodeAddInOperation_Type0Condition(Workflow_NodeAddInOperation_Type0ConditionEntity _Type0ConditionEntity)
{
DbParameter[] pramsInsert = {
MakeInParam("@BatchSeq",(DbType)SqlDbType.Int,4,_Type0ConditionEntity.BatchSeq ),
MakeInParam("@BranchBatchSeq",(DbType)SqlDbType.Int,4,_Type0ConditionEntity.BranchBatchSeq ),
MakeInParam("@AddInOPID",(DbType)SqlDbType.Int,4,_Type0ConditionEntity.AddInOPID ),
MakeInParam("@FieldID",(DbType)SqlDbType.Int,4,_Type0ConditionEntity.FieldID ),
MakeInParam("@SymbolCode",(DbType)SqlDbType.VarChar,50,_Type0ConditionEntity.SymbolCode ),
MakeInParam("@CompareToValue",(DbType)SqlDbType.VarChar,200,_Type0ConditionEntity.CompareToValue ),
MakeInParam("@AndOr",(DbType)SqlDbType.VarChar,50,_Type0ConditionEntity.AndOr ),
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[Workflow_NodeAddInOperation_Type0Condition]");
sb.Append("(");
sb.Append(" [BatchSeq]");
sb.Append(",[BranchBatchSeq]");
sb.Append(",[AddInOPID]");
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("@AddInOPID,");
sb.Append("@FieldID,");
sb.Append("@SymbolCode,");
sb.Append("@CompareToValue,");
sb.Append("@AndOr )");
sb.Append("select @@identity;");
return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
}
