protected void btnSubmit_Click(object sender, EventArgs e)
{
int NodeID = DNTRequest.GetInt("id", 0);
int GroupID = DNTRequest.GetInt("gid", 0);
Workflow_NodeDetailFieldControlEntity _NodeDetailFieldControlEntity = new Workflow_NodeDetailFieldControlEntity();
_NodeDetailFieldControlEntity.NodeID = NodeID;
_NodeDetailFieldControlEntity.GroupID = GroupID;
_NodeDetailFieldControlEntity.IsView = chkIsView.Checked ? 1 : 0;
_NodeDetailFieldControlEntity.IsAdd = chkIsAdd.Checked ? 1 : 0;
_NodeDetailFieldControlEntity.IsEdit = chkIsEdit.Checked ? 1 : 0;
_NodeDetailFieldControlEntity.IsDelete = chkIsDelete.Checked ? 1 : 0;
DbHelper.GetInstance().UpdateWorkflow_NodeDetailFieldControl(_NodeDetailFieldControlEntity);
DbHelper.GetInstance().DeleteWorkflow_NodeDetailFieldControlDetail(DNTRequest.GetString("id"), DNTRequest.GetString("gid"));
Workflow_NodeDetailFieldControlDetailEntity _NodeDetailFieldControlDetailEntity = new Workflow_NodeDetailFieldControlDetailEntity();
_NodeDetailFieldControlDetailEntity.NodeID = DNTRequest.GetInt("id", 0);
_NodeDetailFieldControlDetailEntity.GroupID = DNTRequest.GetInt("gid", 0);
for (int i = 0; i < GridView1.Rows.Count; i++)
{
string Prefix = "GridView1$ctl" + (i + 2).ToString().PadLeft(2, '0') + "$";
_NodeDetailFieldControlDetailEntity.FieldID = Convert.ToInt32(GridView1.DataKeys[i][0]);
_NodeDetailFieldControlDetailEntity.IsView = DNTRequest.GetString(Prefix + "IsView") == "on" ? 1 : 0;
_NodeDetailFieldControlDetailEntity.IsEdit = DNTRequest.GetString(Prefix + "IsEdit") == "on" ? 1 : 0;
_NodeDetailFieldControlDetailEntity.IsMandatory = DNTRequest.GetString(Prefix + "IsMandatory") == "on" ? 1 : 0;
_NodeDetailFieldControlDetailEntity.BasicValidType = DNTRequest.GetInt("txtBasicValidTypeID" + (i + 2).ToString().PadLeft(2, '0'), 0);
_NodeDetailFieldControlDetailEntity.ValidTimeType = DNTRequest.GetInt(Prefix + "ValidTimeType", 0);
DbHelper.GetInstance().AddWorkflow_NodeDetailFieldControlDetail(_NodeDetailFieldControlDetailEntity);
}
ScriptManager.RegisterStartupScript(btnSubmit, this.GetType(), "btnSubmit", "alert('设定成功');", true);
BindGridView();
}
/// <summary>
/// 新增信息
/// </summary>
/// <param name="_Workflow_NodeDetailFieldControlDetailEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string AddWorkflow_NodeDetailFieldControlDetail(Workflow_NodeDetailFieldControlDetailEntity _Workflow_NodeDetailFieldControlDetailEntity)
{
DbParameter[] pramsInsert = {
MakeInParam("@NodeID",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlDetailEntity.NodeID ),
MakeInParam("@GroupID",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlDetailEntity.GroupID ),
MakeInParam("@FieldID",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlDetailEntity.FieldID ),
MakeInParam("@IsView",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlDetailEntity.IsView ),
MakeInParam("@IsEdit",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlDetailEntity.IsEdit ),
MakeInParam("@IsMandatory",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlDetailEntity.IsMandatory ),
MakeInParam("@BasicValidType",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlDetailEntity.BasicValidType ),
MakeInParam("@ValidTimeType",(DbType)SqlDbType.Int,4,_Workflow_NodeDetailFieldControlDetailEntity.ValidTimeType ),
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[Workflow_NodeDetailFieldControlDetail]");
sb.Append("(");
sb.Append(" [NodeID]");
sb.Append(",[GroupID]");
sb.Append(",[FieldID]");
sb.Append(",[IsView]");
sb.Append(",[IsEdit]");
sb.Append(",[IsMandatory]");
sb.Append(",[BasicValidType]");
sb.Append(",[ValidTimeType]");
sb.Append(") ");
sb.Append(" VALUES (");
sb.Append("@NodeID,");
sb.Append("@GroupID,");
sb.Append("@FieldID,");
sb.Append("@IsView,");
sb.Append("@IsEdit,");
sb.Append("@IsMandatory,");
sb.Append("@BasicValidType,");
sb.Append("@ValidTimeType )");
sb.Append("select @@identity;");
return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
}
