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