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