/// <summary>
/// 新增信息
/// </summary>
/// <param name="_NodeOperationType1ConditionEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string AddWorkflow_NodeOperationType1Condition(Workflow_NodeOperationType1ConditionEntity _NodeOperationType1ConditionEntity)
{
DbParameter[] pramsInsert = {
MakeInParam("@BatchSeq",(DbType)SqlDbType.Int,4,_NodeOperationType1ConditionEntity.BatchSeq ),
MakeInParam("@BranchBatchSeq",(DbType)SqlDbType.Int,4,_NodeOperationType1ConditionEntity.BranchBatchSeq ),
MakeInParam("@AddInOPID",(DbType)SqlDbType.Int,4,_NodeOperationType1ConditionEntity.AddInOPID ),
MakeInParam("@FieldID",(DbType)SqlDbType.Int,4,_NodeOperationType1ConditionEntity.FieldID ),
MakeInParam("@SymbolCode",(DbType)SqlDbType.VarChar,50,_NodeOperationType1ConditionEntity.SymbolCode ),
MakeInParam("@CompareToValue",(DbType)SqlDbType.VarChar,200,_NodeOperationType1ConditionEntity.CompareToValue ),
MakeInParam("@AndOr",(DbType)SqlDbType.VarChar,50,_NodeOperationType1ConditionEntity.AndOr ),
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[Workflow_NodeOperationType1Condition]");
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();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
DataTable dtConditonSeq = (DataTable)ViewState["dtConditonSeq"];
Workflow_NodeOperationType1ConditionEntity _NodeConditionEntity = new Workflow_NodeOperationType1ConditionEntity();
_NodeConditionEntity.AddInOPID = DNTRequest.GetInt("opid", 0);
DataTable dtMaxSeq = DbHelper.GetInstance().GetDBRecords("MaxBatchSeq=isnull(max(BatchSeq),0)+1", "Workflow_NodeOperationType1Condition", "AddInOPID=" + DNTRequest.GetString("opid"), "");
_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_NodeOperationType1Condition(_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();
UpdateSelectRange();
}
