protected void btnSubmit_Click(object sender, EventArgs e) { DbHelper.GetInstance().DeleteWorkflow_GroupLineFieldMap(DNTRequest.GetString("fmid"), DNTRequest.GetString("fdid")); for (int i = 0; i < GridView1.Rows.Count; i++) { string Prefix = "GridView1$ctl" + (i + 2).ToString().PadLeft(2, '0') + "$"; Workflow_GroupLineFieldMapEntity _GroupLineFieldMapEntity = new Workflow_GroupLineFieldMapEntity(); _GroupLineFieldMapEntity.FormID = DNTRequest.GetInt("fmid", 0); _GroupLineFieldMapEntity.FieldID = DNTRequest.GetInt("fdid", 0); _GroupLineFieldMapEntity.DataSetColumn = DNTRequest.GetString(Prefix + "DataSetColumn"); _GroupLineFieldMapEntity.TargetGroupField = GridView1.DataKeys[i][1].ToString(); DbHelper.GetInstance().AddWorkflow_GroupLineFieldMap(_GroupLineFieldMapEntity); } ScriptManager.RegisterStartupScript(btnSubmit, this.GetType(), "btnSubmit", "alert('设定成功');", true); BindGridView(); }
/// <summary> /// 新增信息 /// </summary> /// <param name="_Workflow_GroupLineFieldMapEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string AddWorkflow_GroupLineFieldMap(Workflow_GroupLineFieldMapEntity _Workflow_GroupLineFieldMapEntity) { DbParameter[] pramsInsert = { MakeInParam("@FormID",(DbType)SqlDbType.Int,4,_Workflow_GroupLineFieldMapEntity.FormID ), MakeInParam("@FieldID",(DbType)SqlDbType.Int,4,_Workflow_GroupLineFieldMapEntity.FieldID ), MakeInParam("@DataSetColumn",(DbType)SqlDbType.VarChar,50,_Workflow_GroupLineFieldMapEntity.DataSetColumn ), MakeInParam("@TargetGroupField",(DbType)SqlDbType.VarChar,50,_Workflow_GroupLineFieldMapEntity.TargetGroupField ), }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Workflow_GroupLineFieldMap]"); sb.Append("("); sb.Append(" [FormID]"); sb.Append(",[FieldID]"); sb.Append(",[DataSetColumn]"); sb.Append(",[TargetGroupField]"); sb.Append(") "); sb.Append(" VALUES ("); sb.Append("@FormID,"); sb.Append("@FieldID,"); sb.Append("@DataSetColumn,"); sb.Append("@TargetGroupField )"); sb.Append("select @@identity;"); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString(); }