protected void btnSave_Click(object sender, EventArgs e) { //新增前先删除 int ReportID = Int32.Parse(txtReportID.Value); DbHelper.GetInstance().DeleteWorkflow_ReportDetail(ReportID); for (int i = 0; i < GridView1.Rows.Count; i++) { Workflow_ReportDetailEntity rd = new Workflow_ReportDetailEntity(); System.Web.UI.WebControls.CheckBox cbIsShow = (System.Web.UI.WebControls.CheckBox)GridView1.Rows[i].FindControl("cbIsShow"); if (cbIsShow.Checked) { System.Web.UI.WebControls.CheckBox cbIsStatistics = (System.Web.UI.WebControls.CheckBox)GridView1.Rows[i].FindControl("cbIsStatistics"); System.Web.UI.WebControls.CheckBox cbIsOrder = (System.Web.UI.WebControls.CheckBox)GridView1.Rows[i].FindControl("cbIsOrder"); System.Web.UI.WebControls.DropDownList ddlOrderPattern = (System.Web.UI.WebControls.DropDownList)GridView1.Rows[i].FindControl("ddlOrderPattern"); GPRP.GPRPControls.TextBox txtOrderIndex = (GPRP.GPRPControls.TextBox)GridView1.Rows[i].FindControl("txtOrderIndex"); GPRP.GPRPControls.TextBox txtDisplayOrder = (GPRP.GPRPControls.TextBox)GridView1.Rows[i].FindControl("txtDisplayOrder"); rd.ReportID = ReportID; rd.FieldID = Convert.ToInt32(GridView1.DataKeys[i][1].ToString()); rd.IsStatistics = Convert.ToByte(cbIsStatistics.Checked ? 1 : 0); rd.IsOrder = Convert.ToByte(cbIsOrder.Checked ? 1 : 0); if (cbIsOrder.Checked) { rd.OrderPattern = Convert.ToByte(ddlOrderPattern.SelectedValue == "" ? 1 : 2); rd.OrderIndex = txtOrderIndex.Text.Trim() == "" ? 0 : Int32.Parse(txtOrderIndex.Text); } if (txtDisplayOrder.Text.Trim() != "") rd.DisplayOrder = Int32.Parse(txtDisplayOrder.Text); DbHelper.GetInstance().AddWorkflow_ReportDetail(rd); } } System.Web.UI.ScriptManager.RegisterStartupScript(btnSave, this.GetType(), "ButtonHideScript", strButtonHideScript, false); }
/// <summary> /// 新增信息,插入前先删除 /// </summary> /// <param name="_Workflow_ReportDetailEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string AddWorkflow_ReportDetail(Workflow_ReportDetailEntity _Workflow_ReportDetailEntity) { DbParameter[] pramsInsert = { MakeInParam("@ReportID",(DbType)SqlDbType.Int,4,_Workflow_ReportDetailEntity.ReportID ), MakeInParam("@FieldID",(DbType)SqlDbType.Int,4,_Workflow_ReportDetailEntity.FieldID ), MakeInParam("@IsStatistics",(DbType)SqlDbType.TinyInt ,1,_Workflow_ReportDetailEntity.IsStatistics ), MakeInParam("@IsOrder",(DbType)SqlDbType.TinyInt,1,_Workflow_ReportDetailEntity.IsOrder ), MakeInParam("@OrderPattern",(DbType)SqlDbType.TinyInt,1,_Workflow_ReportDetailEntity.OrderPattern ), MakeInParam("@OrderIndex",(DbType)SqlDbType.Int,4,_Workflow_ReportDetailEntity.OrderIndex ), MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_ReportDetailEntity.DisplayOrder ) }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Workflow_ReportDetail]"); sb.Append("("); sb.Append("[ReportID]"); sb.Append(",[FieldID]"); sb.Append(",[IsStatistics]"); sb.Append(",[IsOrder]"); sb.Append(",[OrderPattern]"); sb.Append(",[OrderIndex]"); sb.Append(",[DisplayOrder]"); sb.Append(") "); sb.Append(" VALUES ("); sb.Append("@ReportID,"); sb.Append("@FieldID,"); sb.Append("@IsStatistics,"); sb.Append("@IsOrder,"); sb.Append("@OrderPattern,"); sb.Append("@OrderIndex,"); sb.Append("@DisplayOrder);"); sb.Append(" select @@rowcount;"); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString(); }