protected void btn_save_Click(object sender, ImageClickEventArgs e) { ReportTableModel report = new ReportTableModel(); string tablestr = string.Empty; for (int i = 0; i < this.tablelist.Items.Count; i++) { if (tablelist.Items[i].Selected) { tablestr += "," + tablelist.Items[i].Value; } } report.Tablelist = tablestr.TrimStart(','); string id = "0"; if (Request.QueryString["getid"] != null) { id = Request.QueryString["getid"].ToString(); } else { id = HidControl.Value; } report.Menuname = this.txt_menu.Text; report.SqlStr = this.txt_sql.Text; report.timeFlag = Convert.ToInt32(this.ddl_timeflag.SelectedValue); report.Excelhead = ""; HidControl.Value = TableReportBus.InsertReport(report, UserInfo, id, hiduserid.Value).ToString(); }
/// <summary> /// /// </summary> /// <param name="report"></param> /// <param name="flag">判断是添加还是修改</param> /// <returns></returns> public static int InsertReport(ReportTableModel report,XBase.Common.UserInfoUtil userinfo,string ID,string useridlist) { int num = 0; StringBuilder strSql = new StringBuilder(); if (ID == "0") //添加 { strSql.Append("insert into defdba.ReportTable(Menuname,CompanyCD,sqlstr,timeFlag,tablelist,excelhead) values(@Menuname,@CompanyCD,@SqlStr,@timeFlag,@tablelist,@excelhead)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Menuname", SqlDbType.VarChar,200), new SqlParameter("@CompanyCD", SqlDbType.VarChar,200), new SqlParameter("@SqlStr", SqlDbType.Text), new SqlParameter("@timeFlag", SqlDbType.Int,4), new SqlParameter("@tablelist", SqlDbType.VarChar,100), new SqlParameter("@excelhead", SqlDbType.VarChar,100) }; parameters[0].Value = report.Menuname; parameters[1].Value = userinfo.CompanyCD; parameters[2].Value = report.SqlStr; parameters[3].Value = report.timeFlag; parameters[4].Value = report.Tablelist; parameters[5].Value = report.Excelhead; num = Convert.ToInt32(SqlHelper.ExecuteScalar(strSql.ToString(), parameters)); } else //修改 { strSql.Append("update defdba.ReportTable set Menuname=@menuname,timeFlag=@timeFlag,sqlstr=@SqlStr,tablelist=@tablelist,excelhead=@excelhead where ID=@id"); SqlParameter[] parameters = { new SqlParameter("@Menuname", SqlDbType.VarChar,200), new SqlParameter("@CompanyCD", SqlDbType.VarChar,200), new SqlParameter("@SqlStr", SqlDbType.Text), new SqlParameter("@timeFlag", SqlDbType.Int,4), new SqlParameter("@tablelist", SqlDbType.VarChar,100), new SqlParameter("@ID", SqlDbType.VarChar,100), new SqlParameter("@excelhead", SqlDbType.VarChar,500) }; parameters[0].Value = report.Menuname; parameters[1].Value = userinfo.CompanyCD; parameters[2].Value = report.SqlStr; parameters[3].Value = report.timeFlag; parameters[4].Value = report.Tablelist; parameters[5].Value = ID; parameters[6].Value = report.Excelhead; try { SqlHelper.ExecuteTransSql(strSql.ToString(),parameters); num = Convert.ToInt32(ID); } catch { return 0; } } //添加菜单 CreateMenu(report.Menuname, num.ToString(), userinfo, useridlist); return num; }
public static int InsertReport(ReportTableModel report, XBase.Common.UserInfoUtil userinfo, string ID,string useridlist) { return TableReportDBHelper.InsertReport(report, userinfo,ID,useridlist); }