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(); }