/// <summary> /// 增加一条数据 /// </summary> public int Insert(Entities.ConsultSolveUserMapping model) { SqlParameter[] parameters = { new SqlParameter("@RecID", SqlDbType.Int, 4), new SqlParameter("@TemplateID", SqlDbType.Int, 4), new SqlParameter("@SolveUserEID", SqlDbType.Int, 4), new SqlParameter("@SolveUserID", SqlDbType.Int, 4), new SqlParameter("@SolveUserEName", SqlDbType.VarChar), new SqlParameter("@CreateUserID", SqlDbType.Int, 4) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.TemplateID; parameters[2].Value = model.SolveUserEID; parameters[3].Value = model.SolveUserID; parameters[4].Value = model.SolveUserEName; parameters[5].Value = model.CreateUserID; SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_CONSULTSOLVEUSERMAPPING_INSERT, parameters); return((int)parameters[0].Value); }
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.ConsultSolveUserMapping model) { return(Dal.ConsultSolveUserMapping.Instance.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Insert(Entities.ConsultSolveUserMapping model) { return(Dal.ConsultSolveUserMapping.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())); } }