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";
}
