protected void btnAdd_Click(object sender, EventArgs e)
{
Workflow_NodeAddInOperation_Type1Entity _Type1Entity = new Workflow_NodeAddInOperation_Type1Entity();
_Type1Entity.NodeID = DNTRequest.GetInt("id", 0);
_Type1Entity.CaculateType = Convert.ToInt32(ddlCaculateType.SelectedValue);
_Type1Entity.DataSourceID = Convert.ToInt32(txtDataSourceID.Value);
_Type1Entity.DataSourceTable = ddlDataSourceTable.SelectedValue;
_Type1Entity.GroupID = Convert.ToInt32(ddlGroupID.SelectedValue);
_Type1Entity.SelectRange = "(1=1)";
_Type1Entity.OPCycleType = Convert.ToInt32(ddlOPCycleType.SelectedValue);
_Type1Entity.OPTime = DNTRequest.GetInt("t", 0);
_Type1Entity.OPCondition = "(1=1)";
_Type1Entity.CreateSID = userEntity.UserSerialID;
_Type1Entity.CreateDate = DateTime.Now;
string AddInOPID = DbHelper.GetInstance().AddWorkflow_NodeAddInOperation_Type1(_Type1Entity);
if (ddlCaculateType.SelectedValue == "3")
{
DataTable dtSpParameter = DbHelper.GetInstance().GetAllStoredProcedureParameters(_Type1Entity.DataSourceID, _Type1Entity.DataSourceTable);
for (int i = 0; i < dtSpParameter.Rows.Count; i++)
{
if ("ReturnValue" == dtSpParameter.Rows[i]["ParameterDirection"].ToString())
{
continue;
}
Workflow_NodeAddInOperation_Type1_SpParameterEntity _Type1_SpParameterEntity = new Workflow_NodeAddInOperation_Type1_SpParameterEntity();
_Type1_SpParameterEntity.AddInOPID = Int32.Parse(AddInOPID);
_Type1_SpParameterEntity.SpParameter = dtSpParameter.Rows[i]["ParameterName"].ToString();
_Type1_SpParameterEntity.ParameterType = dtSpParameter.Rows[i]["ParameterType"].ToString();
_Type1_SpParameterEntity.ParameterSize = Convert.ToInt32(dtSpParameter.Rows[i]["ParameterSize"]);
_Type1_SpParameterEntity.ParameterDirection = dtSpParameter.Rows[i]["ParameterDirection"].ToString();
_Type1_SpParameterEntity.TartgetValue = "";
_Type1_SpParameterEntity.FieldTypeID = 0;
DbHelper.GetInstance().AddWorkflow_NodeAddInOperation_Type1_SpParameter(_Type1_SpParameterEntity);
}
}
BindGridView();
System.Web.UI.ScriptManager.RegisterStartupScript(btnAdd, this.GetType(), "ButtonHideScript", strButtonHideScript, false);
}
/// <summary>
/// 新增信息
/// </summary>
/// <param name="_Type1Entity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string AddWorkflow_NodeAddInOperation_Type1(Workflow_NodeAddInOperation_Type1Entity _Type1Entity)
{
DbParameter[] pramsInsert = {
MakeInParam("@AddInOPID",(DbType)SqlDbType.Int,4,_Type1Entity.AddInOPID ),
MakeInParam("@NodeID",(DbType)SqlDbType.Int,4,_Type1Entity.NodeID ),
MakeInParam("@CaculateType",(DbType)SqlDbType.Int,4,_Type1Entity.CaculateType ),
MakeInParam("@DataSourceID",(DbType)SqlDbType.Int,4,_Type1Entity.DataSourceID ),
MakeInParam("@DataSourceTable",(DbType)SqlDbType.VarChar,50,_Type1Entity.DataSourceTable ),
MakeInParam("@GroupID",(DbType)SqlDbType.Int,4,_Type1Entity.GroupID ),
MakeInParam("@SelectRange",(DbType)SqlDbType.VarChar,2000,_Type1Entity.SelectRange ),
MakeInParam("@OPCycleType",(DbType)SqlDbType.Int,4,_Type1Entity.OPCycleType ),
MakeInParam("@OPTime",(DbType)SqlDbType.Int,4,_Type1Entity.OPTime ),
MakeInParam("@OPCondition",(DbType)SqlDbType.VarChar,2000,_Type1Entity.OPCondition ),
MakeInParam("@CreateDate",(DbType)SqlDbType.DateTime,16,_Type1Entity.CreateDate ),
MakeInParam("@CreateSID",(DbType)SqlDbType.Int,4,_Type1Entity.CreateSID ),
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[Workflow_NodeAddInOperation_Type1]");
sb.Append("(");
sb.Append(" [NodeID]");
sb.Append(",[CaculateType]");
sb.Append(",[DataSourceID]");
sb.Append(",[DataSourceTable]");
sb.Append(",[GroupID]");
sb.Append(",[SelectRange]");
sb.Append(",[OPCycleType]");
sb.Append(",[OPTime]");
sb.Append(",[OPCondition]");
sb.Append(",[CreateDate]");
sb.Append(",[CreateSID]");
sb.Append(") ");
sb.Append(" VALUES (");
sb.Append("@NodeID,");
sb.Append("@CaculateType,");
sb.Append("@DataSourceID,");
sb.Append("@DataSourceTable,");
sb.Append("@GroupID,");
sb.Append("@SelectRange,");
sb.Append("@OPCycleType,");
sb.Append("@OPTime,");
sb.Append("@OPCondition,");
sb.Append("@CreateDate,");
sb.Append("@CreateSID )");
sb.Append("select @@identity;");
return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
}
