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