private Entities.TemplateInfo LoadSingleTemplateInfo(DataRow row) { Entities.TemplateInfo model = new Entities.TemplateInfo(); if (row["RecID"].ToString() != "") { model.RecID = int.Parse(row["RecID"].ToString()); } if (row["TCID"].ToString() != "") { model.TCID = int.Parse(row["TCID"].ToString()); } model.Title = row["Title"].ToString(); model.Content = row["Content"].ToString(); model.ReplaceTag = row["ReplaceTag"].ToString(); if (row["Status"].ToString() != "") { model.Status = int.Parse(row["Status"].ToString()); } if (row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } if (row["CreateUserID"].ToString() != "") { model.CreateUserID = int.Parse(row["CreateUserID"].ToString()); } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Insert(Entities.TemplateInfo model) { SqlParameter[] parameters = { new SqlParameter("@RecID", SqlDbType.Int, 4), new SqlParameter("@TCID", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 100), new SqlParameter("@Content", SqlDbType.NVarChar, 2000), new SqlParameter("@ReplaceTag", SqlDbType.NVarChar, 100), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUserID", SqlDbType.Int, 4) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.TCID; parameters[2].Value = model.Title; parameters[3].Value = model.Content; parameters[4].Value = model.ReplaceTag; parameters[5].Value = model.Status; parameters[6].Value = model.CreateTime; parameters[7].Value = model.CreateUserID; SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_TEMPLATEINFO_INSERT, parameters); return((int)parameters[0].Value); }
public void ProcessRequest(HttpContext context) { BitAuto.YanFa.SysRightManager.Common.UserInfo.Check(); context.Response.ContentType = "text/plain"; string type = HttpContext.Current.Request["Type"].ToString(); string userIDs = HttpContext.Current.Request["Persion"].ToString(); string tcID = HttpContext.Current.Request["TCID"].ToString(); string title = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["Title"].ToString()); string con = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["Con"].ToString()); string userName = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["PersionName"].ToString()); Entities.TemplateInfo template = new Entities.TemplateInfo(); template.TCID = Convert.ToInt32(tcID); template.Title = title; template.Content = con; template.CreateUserID = BLL.Util.GetLoginUserID(); template.CreateTime = DateTime.Now; template.ReplaceTag = "-"; template.Status = 0; //模板查重 if (BLL.TemplateInfo.Instance.IsExist((int)template.TCID, title)) { context.Response.Write("repeated"); } else { //模板写入 int templateID = BLL.TemplateInfo.Instance.Insert(template); //收件人写入 if (type == "2") { string[] userIDArr = userIDs.Split(','); string[] userNameArr = userName.Split(','); int length = userIDArr.Length; for (int i = 0; i < length; i++) { Entities.ConsultSolveUserMapping map = new Entities.ConsultSolveUserMapping(); map.CreateUserID = BLL.Util.GetLoginUserID();//创建者 map.SolveUserEID = Convert.ToInt32(userIDArr[i]); map.TemplateID = templateID; map.SolveUserEName = userNameArr[i]; BLL.ConsultSolveUserMapping.Instance.Insert(map); } } context.Response.Write("success"); BLL.Util.InsertUserLog("【添加】模板,模板名称:\"" + title + "\",模板内容:" + con + "。" + "操作人:" + BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(BLL.Util.GetLoginUserID())); } }
protected void Page_Load(object sender, EventArgs e) { int userID = BLL.Util.GetLoginUserID(); if (!BLL.Util.CheckRight(userID, "SYS024MOD5101")) { Response.Write(BLL.Util.GetNotAccessMsgPage("您没有访问该页面的权限")); Response.End(); } Template = BLL.TemplateInfo.Instance.GetTemplateInfo(Convert.ToInt32(Request.QueryString["TemplateID"])); DataTable db = new DataTable(); //Template.TCID; QueryTemplateCategory query = new QueryTemplateCategory(); query.RecID = Convert.ToInt32(Template.TCID); int totle; db = BLL.TemplateCategory.Instance.GetTemplateCategory(query, "RecID", 1, 1, out totle); recID = Template.RecID.ToString(); TcID = Template.TCID.ToString(); type = db.Rows[0]["Type"].ToString(); level = db.Rows[0]["Level"].ToString(); pID = db.Rows[0]["PID"].ToString(); DataTable db_EmailServers = BLL.TemplateInfo.Instance.getEmailServers(Template.RecID); if (db_EmailServers != null && db_EmailServers.Rows.Count > 0) { foreach (DataRow row in db_EmailServers.Rows) { ToUserIDs += row["UserID"].ToString() + ","; //根据UserID获取用户名称 ToUserNames += BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(Convert.ToInt32(row["UserID"])) + ","; } if (ToUserIDs.Length > 0) { ToUserIDs = "'" + ToUserIDs.Substring(0, ToUserIDs.Length - 1) + "'"; ToUserNames = "'" + ToUserNames.Substring(0, ToUserNames.Length - 1) + "'"; } } else { ToUserIDs = "''"; ToUserNames = "''"; } }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Entities.TemplateInfo model) { SqlParameter[] parameters = { new SqlParameter("@RecID", SqlDbType.Int, 4), new SqlParameter("@TCID", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 100), new SqlParameter("@Content", SqlDbType.NVarChar, 2000), new SqlParameter("@Status", SqlDbType.Int, 4) }; parameters[0].Value = model.RecID; parameters[1].Value = model.TCID; parameters[2].Value = model.Title; parameters[3].Value = model.Content; parameters[4].Value = model.Status; return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_TEMPLATEINFO_UPDATE, parameters)); }
protected void Bt_SubClick(object sender, EventArgs e) { Entities.TemplateInfo template = new Entities.TemplateInfo(); if (Request["hiddenFile"].ToString() == "0") { Response.Write("<script> alert('请选择模板分类!') </script>"); return; } else { template.TCID = Convert.ToInt32(Request["hiddenFile"]); } if (Request["TemplateTile"].ToString() == "") { Response.Write("<script> alert('请输入模板标题!') </script>"); return; } else { template.Title = Request["TemplateTile"].ToString(); } if (Request["TemplateCon"].ToString() == "") { Response.Write("<script> alert('请输入文本内容!') </script>"); return; } else { template.Content = Request["TemplateCon"].ToString(); } if (Request["type"].ToString() == "2") {//邮件 Response.Write("<script> alert('邮件!') </script>"); if (Request["PersonsGetEmailIN"].ToString() == "") { Response.Write("<script> alert('请填写邮件接收人!') </script>"); return; } } else if (Request["type"].ToString() == "1") {//短信 Response.Write("<script> alert('短信!') </script>"); } template.CreateUserID = 0; template.CreateTime = DateTime.Now; template.ReplaceTag = "-"; template.Status = 0; //模板写入 int templateID = BLL.TemplateInfo.Instance.Insert(template); //收件人写入 if (Request["type"].ToString() == "2") { string[] userIDArr = Request["PersonsGetEmailIN"].ToString().Split(','); foreach (string userID in userIDArr) { string sqlStr = "insert into ConsultSolveUserMapping TemplateID,SolveUserEID values(" + templateID.ToString() + "," + userID + ");"; Entities.ConsultSolveUserMapping map = new Entities.ConsultSolveUserMapping(); map.CreateUserID = 100;//创建者 map.SolveUserEID = Convert.ToInt32(userID); map.TemplateID = templateID; map.SolveUserEName = ""; BLL.ConsultSolveUserMapping.Instance.Insert(map); } } Response.Write("<script> alert('添加成功!'); </script>"); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Entities.TemplateInfo model) { return(Dal.TemplateInfo.Instance.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Insert(Entities.TemplateInfo model) { return(Dal.TemplateInfo.Instance.Insert(model)); }
public void ProcessRequest(HttpContext context) { BitAuto.YanFa.SysRightManager.Common.UserInfo.Check(); context.Response.ContentType = "text/plain"; string recID = HttpContext.Current.Request["RecID"].ToString(); string type = HttpContext.Current.Request["Type"].ToString(); string userIDs = HttpContext.Current.Request["Persion"].ToString(); string tcID = HttpContext.Current.Request["TCID"].ToString(); string title = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["Title"].ToString()); string con = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["Con"].ToString()); string userName = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["PersionName"].ToString()); Entities.TemplateInfo template = new Entities.TemplateInfo(); template.RecID = Convert.ToInt32(recID); template.TCID = Convert.ToInt32(tcID); template.Title = title; template.Content = con; template.CreateUserID = 100; template.CreateTime = DateTime.Now; template.ReplaceTag = "-"; template.Status = 0; if (BLL.TemplateInfo.Instance.IsExistNotThisRecID(int.Parse(recID), (int)template.TCID, template.Title)) { context.Response.Write("repeated"); } else { DataTable dt = new DataTable(); Entities.QueryTemplateInfo query = new Entities.QueryTemplateInfo(); query.TCID = template.TCID; int totle = 0; dt = BLL.TemplateInfo.Instance.GetTemplateInfo(query, "", 1, 10, out totle); Entities.TemplateInfo templateOri = BLL.TemplateInfo.Instance.GetTemplateInfo(template.RecID); #region 邮件接收人 DataTable dtEmailServersOri = BLL.TemplateInfo.Instance.getEmailServers(template.RecID); string strEmailServersOri = ""; if (dtEmailServersOri != null && dt.Rows.Count > 0) { int intVal = 0; foreach (DataRow drEmailServers in dtEmailServersOri.Rows) { if (int.TryParse(drEmailServers["UserID"].ToString(), out intVal)) { strEmailServersOri += BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(intVal) + ","; } } if (strEmailServersOri.ToString().Length > 0) { strEmailServersOri = strEmailServersOri.ToString().Substring(0, strEmailServersOri.ToString().Length - 1); } } #endregion //模板写入 int templateID = BLL.TemplateInfo.Instance.Update(template); //收件人写入 if (type == "2") { //清空原有 BLL.TemplateInfo.Instance.ClearUser(template.RecID); string[] userIDArr = userIDs.Split(','); string[] userNameArr = userName.Split(','); int length = userIDArr.Length; for (int i = 0; i < length; i++) { Entities.ConsultSolveUserMapping map = new Entities.ConsultSolveUserMapping(); map.CreateUserID = BLL.Util.GetLoginUserID();//创建者 map.SolveUserEID = Convert.ToInt32(userIDArr[i]); map.TemplateID = template.RecID; map.SolveUserEName = userNameArr[i]; BLL.ConsultSolveUserMapping.Instance.Insert(map); } } context.Response.Write("success"); string userLog = "【修改】模板。"; if (template.Title != templateOri.Title) { userLog += "模板标题“" + templateOri.Title + "”改为“" + template.Title + "”;"; } if (template.Content != templateOri.Content) { userLog += "模板内容“" + templateOri.Content + "”改为“" + template.Content + "”;"; } if (template.TCID != templateOri.TCID) { userLog += "模板分类“" + BLL.TemplateCategory.Instance.GetTemplateCategory(Convert.ToInt32(template.TCID)).Name + "”改为“" + BLL.TemplateCategory.Instance.GetTemplateCategory(Convert.ToInt32(templateOri.TCID)).Name + "”;"; } #region 邮件接收人 DataTable dtEmailServers = BLL.TemplateInfo.Instance.getEmailServers(template.RecID); string strEmailServers = ""; if (dtEmailServers != null && dt.Rows.Count > 0) { int intVal = 0; foreach (DataRow drEmailServers in dtEmailServers.Rows) { if (int.TryParse(drEmailServers["UserID"].ToString(), out intVal)) { strEmailServers += BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(intVal) + ","; } } if (strEmailServers.ToString().Length > 0) { strEmailServers += strEmailServers.ToString().Substring(0, strEmailServers.ToString().Length - 1); } } #endregion if (strEmailServers != strEmailServersOri) { userLog += "邮件接收人“" + strEmailServers + "”改为“" + strEmailServersOri + "”"; } BLL.Util.InsertUserLog("【修改】模板\"" + title + "\"(ID:" + template.RecID.ToString() + ")。修改者:" + BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(BLL.Util.GetLoginUserID())); } }