protected void btnAdd_Click(object sender, EventArgs e) { string[] RuleDetail = GetRuleDetail(); try { DbHelper.GetInstance().ExecSqlText(string.Format(" select {0} from Workflow_Form{1} where RequestID=0", RuleDetail[0], rblFieldType.SelectedValue == "1" ? "" : "Detail")); } catch { ScriptManager.RegisterStartupScript(btnAdd, this.GetType(), "add", "alert('赋值表达式不正确,无法添加');", true); return; } DataTable dtComputeRoute = (DataTable)ViewState["dtComputeRoute"]; Workflow_NodeAddInOperation_Type1_ColConditionEntity _NodeAddInOperation_Type1_ColConditionEntity = new Workflow_NodeAddInOperation_Type1_ColConditionEntity(); _NodeAddInOperation_Type1_ColConditionEntity.AddInOPID = DNTRequest.GetInt("opid", 0); _NodeAddInOperation_Type1_ColConditionEntity.TargetFieldName = ddlTargetFieldName.SelectedValue; _NodeAddInOperation_Type1_ColConditionEntity.CompareSymbol = ddlCompareSymbol.SelectedValue; _NodeAddInOperation_Type1_ColConditionEntity.TartgetValue = GetRuleDetail()[0]; _NodeAddInOperation_Type1_ColConditionEntity.FieldTypeID = Int32.Parse(rblFieldType.SelectedValue); DbHelper.GetInstance().AddWorkflow_NodeAddInOperation_Type1_ColCondition(_NodeAddInOperation_Type1_ColConditionEntity, dtComputeRoute); dtComputeRoute.Rows.Clear(); lblExpression.Text = ""; BindGridView(); System.Web.UI.ScriptManager.RegisterStartupScript(btnAdd, this.GetType(), "ButtonHideScript", strButtonHideScript, false); }
/// <summary> /// 新增信息 /// </summary> /// <param name="_Type1_ColConditionEntity"></param> /// <param name="dtComputeRoute"></param> /// <returns></returns> public string AddWorkflow_NodeAddInOperation_Type1_ColCondition(Workflow_NodeAddInOperation_Type1_ColConditionEntity _Type1_ColConditionEntity, DataTable dtComputeRoute) { //判断该记录是否已经存在 DbParameter[] prams = { MakeInParam("@AddInOPID",(DbType)SqlDbType.Int,4,_Type1_ColConditionEntity.AddInOPID ), MakeInParam("@TargetFieldName",(DbType)SqlDbType.VarChar,50,_Type1_ColConditionEntity.TargetFieldName ), }; string sql = " select * from [dbo].[Workflow_NodeAddInOperation_Type1_ColCondition] where AddInOPID=@AddInOPID and TargetFieldName=@TargetFieldName "; if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0) { return "-1";//该记录已经存在 } else { DbParameter[] pramsInsert = { MakeInParam("@AddInOPID",(DbType)SqlDbType.Int,4,_Type1_ColConditionEntity.AddInOPID ), MakeInParam("@TargetFieldName",(DbType)SqlDbType.VarChar,50,_Type1_ColConditionEntity.TargetFieldName ), MakeInParam("@CompareSymbol",(DbType)SqlDbType.VarChar,50,_Type1_ColConditionEntity.CompareSymbol ), MakeInParam("@TartgetValue",(DbType)SqlDbType.VarChar,2000,_Type1_ColConditionEntity.TartgetValue ), MakeInParam("@FieldTypeID",(DbType)SqlDbType.Int,4,_Type1_ColConditionEntity.FieldTypeID ), }; StringBuilder sb = new StringBuilder(); sb.Append("UPDATE [dbo].[Workflow_NodeAddInOperation_Type1_ColCondition] set AndOr='AND' where AddInOPID=@AddInOPID and (AndOr='' or AndOr is null)"); sb.Append("INSERT INTO [dbo].[Workflow_NodeAddInOperation_Type1_ColCondition]"); sb.Append("("); sb.Append(" [AddInOPID]"); sb.Append(",[TargetFieldName]"); sb.Append(",[CompareSymbol]"); sb.Append(",[TartgetValue]"); sb.Append(",[FieldTypeID]"); sb.Append(") "); sb.Append(" VALUES ("); sb.Append("@AddInOPID,"); sb.Append("@TargetFieldName,"); sb.Append("@CompareSymbol,"); sb.Append("@TartgetValue,"); sb.Append("@FieldTypeID )"); sb.Append("select @@identity;"); ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString(); for (int i = 0; i < dtComputeRoute.Rows.Count; i++) { DbParameter[] pramsRouteInsert = { MakeInParam("@AddInOPID",(DbType)SqlDbType.Int,4,_Type1_ColConditionEntity.AddInOPID ), MakeInParam("@TargetField",(DbType)SqlDbType.VarChar,50,_Type1_ColConditionEntity.TargetFieldName ), MakeInParam("@ComputeType",(DbType)SqlDbType.Int,4,dtComputeRoute.Rows[i]["ComputeType"] ), MakeInParam("@RouteValue",(DbType)SqlDbType.VarChar,50,dtComputeRoute.Rows[i]["RouteValue"] ), MakeInParam("@RouteOrder",(DbType)SqlDbType.Int,4,dtComputeRoute.Rows[i]["RouteOrder"] ), }; string sqlInsert = @" insert into Workflow_ComputeRouteColCondition(AddInOPID,TargetField,ComputeType,RouteValue,RouteOrder)values(@AddInOPID,@TargetField,@ComputeType,@RouteValue,@RouteOrder) "; ExecuteScalar(CommandType.Text, sqlInsert, pramsRouteInsert); } return "1"; } }