protected void btnAdd_Click(object sender, EventArgs e) { string[] RuleDetail = GetRuleDetail(); try { DbHelper.GetInstance().ExecSqlText(string.Format(" select {0} from Workflow_Form where RequestID=0", RuleDetail[0])); } catch { ScriptManager.RegisterStartupScript(btnAdd, this.GetType(), "add", "alert('赋值表达式不正确,无法添加');", true); return; } DataTable dtComputeRouteDetail = (DataTable)ViewState["dtComputeRouteDetail"]; Workflow_NodeAddInOperation_Type0_DataSetParameterEntity _DataSetParameterEntity = new Workflow_NodeAddInOperation_Type0_DataSetParameterEntity(); _DataSetParameterEntity.AddInOPID = DNTRequest.GetInt("opid", 0); _DataSetParameterEntity.DSParameter = ddlParameterList.SelectedValue; _DataSetParameterEntity.TartgetValue = GetRuleDetail()[0]; DbHelper.GetInstance().UpdateWorkflow_NodeAddInOperation_Type0_DataSetParameter(_DataSetParameterEntity, dtComputeRouteDetail); dtComputeRouteDetail.Rows.Clear(); lblExpression.Text = ""; BindGridView(); System.Web.UI.ScriptManager.RegisterStartupScript(btnAdd, this.GetType(), "ButtonHideScript", strButtonHideScript, false); }
/// <summary> /// 修改信息 /// </summary> /// <param name="_DataSetParameterEntity"></param> /// <param name="dtComputeRouteDetail"></param> /// <returns></returns> public string UpdateWorkflow_NodeAddInOperation_Type0_DataSetParameter(Workflow_NodeAddInOperation_Type0_DataSetParameterEntity _DataSetParameterEntity, DataTable dtComputeRouteDetail) { DbParameter[] pramsUpdate = { MakeInParam("@AddInOPID",(DbType)SqlDbType.Int,4,_DataSetParameterEntity.AddInOPID ), MakeInParam("@DSParameter",(DbType)SqlDbType.VarChar,100,_DataSetParameterEntity.DSParameter ), MakeInParam("@TartgetValue",(DbType)SqlDbType.VarChar,2000,_DataSetParameterEntity.TartgetValue ), }; StringBuilder sb = new StringBuilder(); sb.Append("Update [dbo].[Workflow_NodeAddInOperation_Type0_DataSetParameter]"); sb.Append(" set "); sb.Append(" [TartgetValue]=@TartgetValue "); sb.Append(" where [AddInOPID]=@AddInOPID and [DSParameter]=@DSParameter"); ExecuteNonQuery(CommandType.Text, sb.ToString(), pramsUpdate); for (int i = 0; i < dtComputeRouteDetail.Rows.Count; i++) { DbParameter[] pramsRouteInsert = { MakeInParam("@AddInOPID",(DbType)SqlDbType.Int,4,_DataSetParameterEntity.AddInOPID ), MakeInParam("@DSParameter",(DbType)SqlDbType.VarChar,50,_DataSetParameterEntity.DSParameter ), MakeInParam("@ComputeType",(DbType)SqlDbType.Int,4,dtComputeRouteDetail.Rows[i]["ComputeType"] ), MakeInParam("@RouteValue",(DbType)SqlDbType.VarChar,50,dtComputeRouteDetail.Rows[i]["RouteValue"] ), MakeInParam("@RouteOrder",(DbType)SqlDbType.Int,4,dtComputeRouteDetail.Rows[i]["RouteOrder"] ), }; string sqlInsert = @" insert into Workflow_ComputeRouteDetail(AddInOPID,DSParameter,ComputeType,RouteValue,RouteOrder)values(@AddInOPID,@DSParameter,@ComputeType,@RouteValue,@RouteOrder) "; ExecuteScalar(CommandType.Text, sqlInsert, pramsRouteInsert); } return "1"; }