/// <summary> /// 得到一个对象实体 /// </summary> public CUSTOMRP.Model.REPORTGROUP DataRowToModel(DataRow row) { CUSTOMRP.Model.REPORTGROUP model = new CUSTOMRP.Model.REPORTGROUP(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = Int32.Parse(row["ID"].ToString()); } if (row["DATABASEID"] != null && row["DATABASEID"].ToString() != "") { model.DATABASEID = Int32.Parse(row["DATABASEID"].ToString()); } if (row["NAME"] != null) { model.NAME = row["NAME"].ToString(); } if (row["DESCRIPTION"] != null) { model.DESCRIPTION = row["DESCRIPTION"].ToString(); } if (row["AUDOTIME"] != null && row["AUDOTIME"].ToString() != "") { model.AUDOTIME = DateTime.Parse(row["AUDOTIME"].ToString()); } } return(model); }
protected void Button1_Click(object sender, EventArgs e) { string name = this.TextBox1.Text.Trim(); string description = this.TextBox2.Text.Trim(); if (isexist == false) { if (bllsensitivitylevel.GetList(me.ID, "NAME='" + name + "'").Tables[0].Rows.Count > 0) { //Common.JScript.Alert(AppNum.Commonexits); //Common.JScript.GoHistory(-1); Common.JScript.AlertAndRedirect(AppNum.ErrorMsg.Commonexits, "ReportGroup.aspx"); Response.End(); } CUSTOMRP.Model.REPORTGROUP mylevel = new CUSTOMRP.Model.REPORTGROUP(); mylevel.DATABASEID = me.DatabaseID; mylevel.DESCRIPTION = description; mylevel.NAME = name; bllsensitivitylevel.Add(me.ID, mylevel); } else { CUSTOMRP.Model.REPORTGROUP mylevel = bllsensitivitylevel.GetModel(me.ID, id); mylevel.DESCRIPTION = description; mylevel.NAME = name; bllsensitivitylevel.Update(me.ID, mylevel); } Common.JScript.AlertAndRedirect(AppNum.ErrorMsg.success, "ReportGroup.aspx"); Response.End(); }
protected void Page_Init(object sender, EventArgs e) { if (string.IsNullOrEmpty(Request.QueryString["id"])) { if (me.checkUserGroupRight(CUSTOMRP.Model.APPModuleID.usergroupright_reportgroup, "Add", me.LoginID) == false) { Common.JScript.AlertAndRedirect(AppNum.ErrorMsg.accesserror, "ReportGroup.aspx"); Response.End(); } isexist = false; id = 0; this.Button2.Visible = false; } else { if (me.checkUserGroupRight(CUSTOMRP.Model.APPModuleID.usergroupright_reportgroup, "Modify", me.LoginID) == false) { Common.JScript.AlertAndRedirect(AppNum.ErrorMsg.accesserror, "ReportGroup.aspx"); Response.End(); } isexist = true; id = Int32.Parse(Request.QueryString["id"]); myrpgroup = bllsensitivitylevel.GetModel(me.ID, id); if (myrpgroup == null) { Common.JScript.AlertAndRedirect(AppNum.ErrorMsg.parameter_error, "ReportGroup.aspx"); Response.End(); } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(int UserID, CUSTOMRP.Model.REPORTGROUP model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update REPORTGROUP set "); strSql.Append("DATABASEID=@DATABASEID,"); strSql.Append("NAME=@NAME,"); strSql.Append("DESCRIPTION=@DESCRIPTION,"); strSql.Append("AUDOTIME=@AUDOTIME"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@DATABASEID", SqlDbType.Int, 4), new SqlParameter("@NAME", SqlDbType.NVarChar, 50), new SqlParameter("@DESCRIPTION", SqlDbType.NVarChar, -1), new SqlParameter("@AUDOTIME", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.DATABASEID; parameters[1].Value = model.NAME; parameters[2].Value = model.DESCRIPTION; parameters[3].Value = model.AUDOTIME; parameters[4].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(UserID, strSql.ToString(), parameters); if (rows > 0) { Model.AUDITLOG auditobj = model.GetAuditLogObject(null); auditobj.UserID = UserID; auditobj.CreateDate = DateTime.Now; auditobj.MessageType = Model.AUDITLOG.Severity.Audit; auditobj.ModuleName = "DAL.REPORTGROUP.Update"; auditobj.Message = String.Format(AppNum.AuditMessage.ReportGroupUpdateSuccess, model.ID); AUDITLOG.Add(auditobj); return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(int UserID, CUSTOMRP.Model.REPORTGROUP model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into REPORTGROUP("); strSql.Append("DATABASEID,NAME,DESCRIPTION,AUDOTIME)"); strSql.Append(" values ("); strSql.Append("@DATABASEID,@NAME,@DESCRIPTION,@AUDOTIME)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@DATABASEID", SqlDbType.Int, 4), new SqlParameter("@NAME", SqlDbType.NVarChar, 50), new SqlParameter("@DESCRIPTION", SqlDbType.NVarChar, -1), new SqlParameter("@AUDOTIME", SqlDbType.DateTime) }; parameters[0].Value = model.DATABASEID; parameters[1].Value = model.NAME; parameters[2].Value = model.DESCRIPTION; parameters[3].Value = model.AUDOTIME; object obj = DbHelperSQL.GetSingle(UserID, strSql.ToString(), parameters); if (obj == null) { return(0); } else { model.ID = Convert.ToInt32(obj); Model.AUDITLOG auditobj = model.GetAuditLogObject(null); auditobj.UserID = UserID; auditobj.CreateDate = DateTime.Now; auditobj.MessageType = Model.AUDITLOG.Severity.Audit; auditobj.ModuleName = "DAL.REPORTGROUP.Add"; auditobj.Message = String.Format(AppNum.AuditMessage.ReportGroupInsertSuccess, model.ID); AUDITLOG.Add(auditobj); return(model.ID); } }
/// <summary> /// 批量删除数据 /// </summary> //public bool DeleteList(int UserID, string IDlist) //{ // StringBuilder strSql=new StringBuilder(); // strSql.Append("delete from REPORTGROUP "); // strSql.Append(" where ID in ("+IDlist + ") "); // int rows=DbHelperSQL.ExecuteSql(UserID, strSql.ToString()); // if (rows > 0) // { // return true; // } // else // { // return false; // } //} /// <summary> /// 得到一个对象实体 /// </summary> public CUSTOMRP.Model.REPORTGROUP GetModel(int UserID, int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,DATABASEID,NAME,DESCRIPTION,AUDOTIME from REPORTGROUP "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; CUSTOMRP.Model.REPORTGROUP model = new CUSTOMRP.Model.REPORTGROUP(); DataSet ds = DbHelperSQL.Query(UserID, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void btnNext_Click(object sender, EventArgs e) { if (!this.ValidateParameters()) { return; } CUSTOMRP.Model.REPORT myReport = null; List <CUSTOMRP.Model.ColumnInfo> columninfos = null; string path = g_Config["WordTemplatePath"]; string savedFileName = String.Empty; try { savedFileName = this.SaveTemplateFile(); } catch { this.lblJavascript.Text = String.Format("<script type=\"text/javascript\">alert(\"{0}\");</script>", AppNum.ErrorMsg.uploadFailed); return; } string strReportName = this.txtReportName.Text.Trim(); int svID = Convert.ToInt32(this.ddlQueryName.SelectedValue); #region Read CustomProps from file System.Collections.Specialized.NameValueCollection nvc = QueryReport.Code.MailMerge.ReadCustomPropsFromFile(path + savedFileName); if (String.IsNullOrWhiteSpace(strReportName)) { strReportName = nvc["RptName"]; if (strReportName != null) { strReportName = strReportName.Trim(); } } string strQueryName = nvc["QueryName"]; if (!String.IsNullOrWhiteSpace(strQueryName)) { CUSTOMRP.Model.SOURCEVIEW svFromFile = WebHelper.bllSOURCEVIEW.GetModelByQueryName(me.ID, strQueryName.Trim(), me.DatabaseID); svID = (svFromFile != null) ? svFromFile.ID : -1; } #endregion if (String.IsNullOrWhiteSpace(strReportName)) { this.lblJavascript.Text = String.Format("<script type=\"text/javascript\">alert(\"{0}\");</script>", String.Format(AppNum.ErrorMsg.fieldcannotbeempty, "Report Name")); return; } if (svID == -1) { this.lblJavascript.Text = String.Format("<script type=\"text/javascript\">alert(\"{0}\");</script>", String.Format(AppNum.ErrorMsg.pleaseselectvalidvaluefrom, "Query Name")); return; } CUSTOMRP.Model.RPCATEGORY rpcat = WebHelper.bllcategory.GetModelList(me.ID, "DATABASEID='" + me.DatabaseID + "'").FirstOrDefault(); CUSTOMRP.Model.REPORTGROUP rpgrp = WebHelper.bllrpGroup.GetModelList(me.ID, "DATABASEID='" + me.DatabaseID + "'").FirstOrDefault(); #region Save columninfos CUSTOMRP.Model.SOURCEVIEW sv = WebHelper.bllSOURCEVIEW.GetModel(me.ID, svID); List <CUSTOMRP.Model.SOURCEVIEWCOLUMN> svclist = WebHelper.bllSOURCEVIEWCOLUMN.GetModelsForSourceView(me.ID, sv.ID).OrderBy(x => x.DisplayName).ToList(); string[] colnames = svclist.Select(x => x.DisplayName).ToArray(); switch (sv.SourceType) { case CUSTOMRP.Model.SOURCEVIEW.SourceViewType.View: case CUSTOMRP.Model.SOURCEVIEW.SourceViewType.Table: { try { columninfos = CUSTOMRP.BLL.AppHelper.GetColumnInfoForTblView(me.ID, me.DatabaseNAME, sv.TBLVIEWNAME); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); columninfos = new List <CUSTOMRP.Model.ColumnInfo>(); this.lblJavascript.Text = String.Format("<script type=\"text/javascript\">alert('Error in retrieving columns for [{0}]. Please check view defination.');</script>", sv.TBLVIEWNAME); } if (colnames == null) { colnames = CUSTOMRP.BLL.AppHelper.GetColumnNamesForTblView(me.ID, me.DatabaseNAME, sv.TBLVIEWNAME); } } break; case CUSTOMRP.Model.SOURCEVIEW.SourceViewType.StoredProc: { try { columninfos = CUSTOMRP.BLL.AppHelper.GetColumnInfoForStoredProc(me.ID, me.DatabaseNAME, sv.ID); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); columninfos = new List <CUSTOMRP.Model.ColumnInfo>(); this.lblJavascript.Text = String.Format("<script type=\"text/javascript\">alert('Error in retrieving columns for [{0}]. Please check stored proc defination.');</script>", sv.TBLVIEWNAME); } if (colnames == null) { colnames = CUSTOMRP.BLL.AppHelper.GetColumnNamesForStoredProc(me.ID, me.DatabaseNAME, sv.TBLVIEWNAME); } } break; } // Filter result to only columns that is requested columninfos = columninfos.Where(x => colnames.Contains(x.ColName)).ToList(); #endregion Save columninfos #region myReport DateTime currTime = DateTime.Now; int UserID = me.ID; myReport = new CUSTOMRP.Model.REPORT(); myReport.REPORTNAME = strReportName; myReport.RPTITLE = myReport.REPORTNAME; myReport.DATABASEID = me.DatabaseID; myReport.SVID = svID; myReport.CATEGORY = rpcat != null ? rpcat.ID : -1; myReport.REPORTGROUPLIST = rpgrp != null ? rpgrp.ID : -1; myReport.DEFAULTFORMAT = 0; myReport.ADDUSER = UserID; myReport.AUDODATE = currTime; myReport.ADDUSER = UserID; myReport.ReportColumns = new List <CUSTOMRP.Model.REPORTCOLUMN>(); foreach (CUSTOMRP.Model.ColumnInfo c in columninfos) { CUSTOMRP.Model.SOURCEVIEWCOLUMN svc = svclist.Where(x => x.COLUMNNAME == c.ColName).First(); myReport.ReportColumns.Add(new CUSTOMRP.Model.REPORTCOLUMN() { COLUMNNAME = c.ColName, COLUMNFUNC = (int)CUSTOMRP.Model.REPORTCOLUMN.ColumnFuncs.Content, CRITERIA1 = String.Empty, CRITERIA2 = String.Empty, CRITERIA3 = String.Empty, CRITERIA4 = String.Empty, AUDODATE = currTime, SOURCEVIEWCOLUMNID = svc.ID, DISPLAYNAME = svc.DISPLAYNAME, COLUMNTYPE = (int)CUSTOMRP.Model.REPORTCOLUMN.ColumnTypes.Normal, COLUMNCOMMENT = String.Empty, HIDDEN = false, }); } myReport.WordFile = new CUSTOMRP.Model.WORDFILE(); myReport.WordFile.Description = String.Format("Word file for {0}", myReport.RPTITLE); myReport.WordFile.OrigFileName = Path.GetFileName(fUploadTemplate.PostedFile.FileName).Replace(' ', '_'); myReport.WordFile.WordFileName = savedFileName; myReport.WordFile.CreateDate = currTime; myReport.WordFile.CreateUser = UserID; myReport.WordFile.ModifyDate = currTime; myReport.WordFile.ModifyUser = UserID; #endregion myReport Session[rpexcel.strSessionKeyMyReport] = myReport; Session[rpexcel.strSessionKeyColumnInfo] = columninfos; Response.Redirect("rpworddetail.aspx"); }