public int ManageUserUpd(ManageUserQuery q) { try { return _manageUserDao.ManageUserUpd(q); } catch (Exception ex) { throw new Exception("ManageUserMgr-->ManageUserUpd-->" + ex.Message, ex); } }
public List<ManageUserQuery> GetManageUserList(ManageUserQuery query, out int totalcount) { try { return _manageUserDao.GetManageUserList(query, out totalcount); } catch (Exception ex) { throw new Exception("ManageUserMgr-->GetManageUserList-->" + ex.Message, ex); } }
public List<ManageUserQuery> GetNameMail(ManageUserQuery query, out int totalcount) { StringBuilder sql = new StringBuilder(); StringBuilder sqlCondi = new StringBuilder(); try { sql.Append(@" select user_id, user_username as user_name,user_email "); sqlCondi.Append(" from manage_user "); sqlCondi.Append(" where 1=1 "); if (query.user_status != 0) { sqlCondi.AppendFormat(" and user_status='{0}' ", query.user_status); } if (!string.IsNullOrEmpty(query.user_username)) { sqlCondi.AppendFormat(" and user_username LIKE '%{0}%' ", query.user_username); } sqlCondi.Append(" order by user_id asc "); totalcount = 0; if (query.IsPage) { DataTable _dt = _access.getDataTable("select count(user_id) as totalCount " + sqlCondi.ToString()); if (_dt.Rows.Count > 0) { totalcount = int.Parse(_dt.Rows[0]["totalCount"].ToString()); } sqlCondi.AppendFormat(" limit {0},{1}", query.Start, query.Limit); } sql.Append(sqlCondi.ToString()); return _access.getDataTableForObj<ManageUserQuery>(sql.ToString()); } catch (Exception ex) { throw new Exception("ManageUserDao.GetNameMail-->" + ex.Message + sql.ToString(), ex); } }
public int ManageUserAdd(ManageUserQuery q) { StringBuilder sb = new StringBuilder(); StringBuilder sel_id = new StringBuilder(); DataTable dt = new DataTable(); try { sb.Append("SELECT * FROM serial where serial_id='1';"); dt = _access.getDataTable(sb.ToString()); if (dt.Rows.Count > 0) { q.user_id = uint.Parse(dt.Rows[0]["serial_value"].ToString()) + 1; sb.Clear(); sb.AppendFormat("insert into manage_user (user_id,user_username,user_email,user_status,user_lastvisit,user_last_login,manage,user_createdate,user_updatedate,erp_id,user_password) VALUE "); sb.AppendFormat("('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}') ;", q.user_id, q.user_username, q.user_email, q.user_status, q.user_lastvisit, q.user_last_login, q.manage, q.user_createdate, q.user_updatedate, q.erp_id, q.user_password); sb.AppendFormat("update serial set serial_value='{0}' where serial_id='1'; ", q.user_id); return _access.execCommand(sb.ToString()); } else { return 0; } } catch (Exception ex) { throw new Exception("ManageUserDao-->ManageUserAdd" + ex.Message + sb.ToString(), ex); } }
public HttpResponseBase GetManageUserList() { List<ManageUserQuery> store = new List<ManageUserQuery>(); string json = string.Empty; int totalCount = 0; try { _manageuserMgr = new ManageUserMgr(mySqlConnectionString); ManageUserQuery query = new ManageUserQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); if (!string.IsNullOrEmpty(Request.Params["limit"])) { query.Limit = Convert.ToInt32(Request.Params["limit"]); } if (!string.IsNullOrEmpty(Request.Params["search_status"])) { query.search_status = Request.Params["search_status"]; } if (!string.IsNullOrEmpty(Request.Params["s_mail"])) { query.user_email = Request.Params["s_mail"]; } if (!string.IsNullOrEmpty(Request.Params["s_name"])) { query.user_username = Request.Params["s_name"]; } if (!string.IsNullOrEmpty(Request.Params["login_sum"])) { query.login_sum = Request.Params["login_sum"]; } if (!string.IsNullOrEmpty(Request.Params["relation_id"]))//待回覆 { query.userid = Request.Params["relation_id"]; } store = _manageuserMgr.GetManageUserList(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; foreach (var item in store) { if (Convert.ToBoolean(Request.Params["isSecret"])) { item.user_email = item.user_email.Split('@')[0] + "@***"; } item.lastlogin = CommonFunction.GetNetTime(item.user_last_login); item.creattime = CommonFunction.GetNetTime(item.user_createdate); item.updtime = CommonFunction.GetNetTime(item.user_updatedate); } json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據 } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase UpdateStatus() { string json = string.Empty; try { _manageuserMgr = new ManageUserMgr(mySqlConnectionString); ManageUserQuery query = new ManageUserQuery(); if (!string.IsNullOrEmpty(Request.Params["id"])) { query.user_id = uint.Parse(Request.Params["id"]); } query.user_status = 1; query.user_updatedate = uint.Parse(CommonFunction.GetPHPTime(DateTime.Now.ToString()).ToString()); if (_manageuserMgr.UpdStatus(query) > 0) { json = "{success:true}"; } else { json = "{success:false}"; } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,msg:'操作失敗!'}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public int UpdStatus(ManageUserQuery query) { try { return _manageUserDao.UpdStatus(query); } catch (Exception ex) { throw new Exception("ManageUserMgr-->UpdStatus-->" + ex.Message, ex); } }
/// <summary> /// 用戶管理列表頁 /// </summary> /// <returns></returns> public HttpResponseBase MailUserList() { string jsonStr = string.Empty; try { List<MailUserQuery> MailUserStore = new List<MailUserQuery>(); MailUserQuery query = new MailUserQuery(); if (!string.IsNullOrEmpty(Request.Params["user_name"])) { query.user_name = Request.Params["user_name"]; } if (!string.IsNullOrEmpty(Request.Params["user_mail"])) { query.user_mail = Request.Params["user_mail"]; } if (!string.IsNullOrEmpty(Request.Params["relation_id"]))//待回覆 { query.row_id = Convert.ToInt32(Request.Params["relation_id"]); } List<ManageUserQuery> ManageUseStore = new List<ManageUserQuery>(); ManageUserQuery ManageUserQuery = new ManageUserQuery(); ManageUserQuery.IsPage = false; #region 查詢管理人員綁定到表中 DataTable _dtManageUser = new DataTable(); _dtManageUser.Columns.Add("user_id", typeof(String)); _dtManageUser.Columns.Add("user_name", typeof(String)); int total = 0; _IManageUserMgr = new ManageUserMgr(mySqlConnectionString); ManageUseStore = _IManageUserMgr.GetNameMail(ManageUserQuery, out total); foreach (var item in ManageUseStore) { DataRow dr = _dtManageUser.NewRow(); dr[0] = item.user_id; dr[1] = item.user_name; _dtManageUser.Rows.Add(dr); } #endregion if (!string.IsNullOrEmpty(Request.Params["pagers"])) { if (Convert.ToInt32(Request.Params["pagers"]) == 0) { query.IsPage = false; } } query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量 _IMailUserMgr = new MailUserMgr(mySqlConnectionString); int totalCount = 0; MailUserStore = _IMailUserMgr.GetMailUserStore(query, out totalCount);//查询出供應商出貨單 foreach (var item in MailUserStore) { item.nameemail = item.user_name + "(" + item.user_mail + ")"; DataRow[] rows = _dtManageUser.Select("user_id='" + item.create_user + "'"); foreach (DataRow row in rows)//篩選出的最多只有一條數據, { item.create_user_name = item.create_user.ToString(); if (!string.IsNullOrEmpty(row["user_id"].ToString())) { item.create_user_name = row["user_name"].ToString();//---創建人 } } rows = _dtManageUser.Select("user_id='" + item.update_user + "'"); foreach (DataRow row in rows)//篩選出的最多只有一條數據, { item.update_user_name = item.update_user.ToString(); if (!string.IsNullOrEmpty(row["user_id"].ToString())) { item.update_user_name = row["user_name"].ToString();//---修改人 } } if (Convert.ToBoolean(Request.Params["isSecret"])) { if (!string.IsNullOrEmpty(item.user_name)) { item.user_name = item.user_name.Substring(0, 1) + "**"; } item.user_mail = item.user_mail.Split('@')[0] + "@***"; if (item.nameemail.ToString().Length > 3) { item.nameemail = item.nameemail.Substring(0, 3) + "***"; } else { item.nameemail = item.nameemail + "***"; } } } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; jsonStr = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(MailUserStore, Formatting.Indented, timeConverter) + "}";//返回json數據 } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); jsonStr = "{success:false,msg:0}"; } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }
public List<ManageUserQuery> GetManageUserList(ManageUserQuery query, out int totalcount) { StringBuilder sql = new StringBuilder(); StringBuilder sqlCondi = new StringBuilder(); StringBuilder sqlFrom = new StringBuilder(); try { sql.Append(@" SELECT user_id,user_username,user_email,user_status,user_login_attempts,user_last_login,manage,user_createdate,user_updatedate,erp_id "); sqlFrom.Append(" FROM manage_user "); if (!string.IsNullOrEmpty(query.userid)) { sqlCondi.AppendFormat(" and user_id = '{0}' ", query.userid); } if (!string.IsNullOrEmpty(query.user_username)) { sqlCondi.AppendFormat(" and user_username like N'%{0}%' ", query.user_username); } if (!string.IsNullOrEmpty(query.user_email)) { sqlCondi.AppendFormat(" and user_email like N'%{0}%' ", query.user_email); } if (query.search_status != "-1") { sqlCondi.AppendFormat(" and user_status = '{0}' ", query.search_status); } if (!string.IsNullOrEmpty(query.login_sum)) { sqlCondi.AppendFormat(" and user_login_attempts >= '{0}' ", query.login_sum); } if (sqlCondi.Length > 0) { sqlFrom.Append(" where " + sqlCondi.ToString().TrimStart().Remove(0, 3)); } totalcount = 0; if (query.IsPage) { DataTable _dt = _access.getDataTable("select count(user_id) as totalCount " + sqlFrom.ToString()); if (_dt.Rows.Count > 0) { totalcount = int.Parse(_dt.Rows[0]["totalCount"].ToString()); } sqlFrom.Append(" order by user_id desc "); sqlFrom.AppendFormat(" limit {0},{1};", query.Start, query.Limit); } sql.Append(sqlFrom.ToString()); return _access.getDataTableForObj<ManageUserQuery>(sql.ToString()); } catch (Exception ex) { throw new Exception("ManageUserDao.GetNameMail-->" + ex.Message + sql.ToString(), ex); } }
public int CheckEmail(ManageUserQuery query) { StringBuilder sb = new StringBuilder(); try { if (!string.IsNullOrEmpty(query.user_email)) { sb.AppendFormat("SELECT user_username FROM manage_user WHERE user_email='{0}'; ", query.user_email); return _access.getDataTable(sb.ToString()).Rows.Count; } else { return 0; } } catch (Exception ex) { throw new Exception("ProductDao-->CheckEmail" + ex.Message + sb.ToString(), ex); } }
public DataTable GetUser(ManageUserQuery query) { StringBuilder sql = new StringBuilder(); try { sql.Append("SELECT user_id,user_username as config_name,user_email FROM manage_user where 1=1 "); if (query.user_id != 0) { sql.AppendFormat(" and user_id='{0}' ", query.user_id); } return _accessMySql.getDataTable(sql.ToString()); } catch (Exception ex) { throw new Exception(" ConfigDao-->GetUser-->" + ex.Message + sql.ToString(), ex); } }
public HttpResponseBase GetManagerUser() { string json = string.Empty; ManageUser mu = new ManageUser(); ManageUserQuery muq = new ManageUserQuery(); int totalCount = 0; List<ManageUser> store = new List<ManageUser>(); List<ManageUserQuery> storeq = new List<ManageUserQuery>(); try { _muMgr = new ManageUserMgr(mySqlConnectionString); //判斷輸入密碼是否和登入密碼一樣 if (!string.IsNullOrEmpty(Request.Params["user_id"])) { mu.user_id = uint.Parse(Request.Params["user_id"]); store = _muMgr.GetManageUser(mu); if (store.Count > 0) { if (!string.IsNullOrEmpty(Request.Params["secret_password"])) { HashEncrypt hmd5 = new HashEncrypt(); if (hmd5.SHA256Encrypt(Request.Params["secret_password"]) == store[0].user_password) { json = "{success:false}"; } else { json = "{success:true}"; } } } else { json = "{success:false}"; } } //獲取管理用戶下拉列表 else { muq.IsPage = false; muq.user_username = Request.Params["user_name"]; muq.user_status = 1; storeq = _muMgr.GetNameMail(muq, out totalCount); json = "{success:true,data:" + JsonConvert.SerializeObject(storeq, Formatting.Indented) + "}";//返回json數據 } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public int UpdPassword(ManageUserQuery q) { try { return _manageUserDao.UpdPassword(q); } catch (Exception ex) { throw new Exception("ManageUserMgr-->UpdPassword-->" + ex.Message, ex); } }
public int CheckEmail(ManageUserQuery query) { try { return _manageUserDao.CheckEmail(query); } catch (Exception ex) { throw new Exception("ManageUserMgr-->CheckEmail-->" + ex.Message, ex); } }
public int ManageUserUpd(ManageUserQuery query) { StringBuilder sb = new StringBuilder(); try { sb.AppendFormat("update manage_user set user_username='******' ", query.user_username); if (!string.IsNullOrEmpty(query.user_email)) { sb.AppendFormat(",user_email='{0}' ", query.user_email); } sb.AppendFormat(",erp_id='{0}',user_status='{1}',manage='{2}',user_updatedate='{3}' ", query.erp_id, query.user_status, query.manage, query.user_updatedate); if (!string.IsNullOrEmpty(query.user_delete_email)) { sb.AppendFormat(",user_delete_email='{0}' ", query.user_delete_email); } sb.AppendFormat(" where user_id ='{0}' ;", query.user_id); return _access.execCommand(sb.ToString()); } catch (Exception ex) { throw new Exception("ManageUserDao-->ManageUserUpd" + ex.Message + sb.ToString(), ex); } }
public DataTable GetDesign(ManageUserQuery query) { StringBuilder sb = new StringBuilder(); try { sb.Append(@"SELECT m.user_username,m.user_id from t_fgroup tf LEFT JOIN t_groupcaller tg ON tf.rowid=tg.groupId LEFT JOIN manage_user m ON tg.callid=m.user_email LEFT JOIN t_parametersrc t ON t.parameterCode=tf.rowid WHERE t.parameterType='design';"); return _accessMySql.getDataTable(sb.ToString()); } catch (Exception ex) { throw new Exception("DesignRequestDao.GetDesign-->" + ex.Message + sb.ToString(), ex); } }
public HttpResponseBase GetDesign() { string json = string.Empty; ManageUserQuery q = new ManageUserQuery(); DataTable store = new DataTable(); _DesignRequestMgr = new DesignRequestMgr(mySqlConnectionString); try { store = _DesignRequestMgr.GetDesign(q); json = "{success:true,data:" + JsonConvert.SerializeObject(store) + "}"; } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public int UpdStatus(ManageUserQuery query) { StringBuilder sb = new StringBuilder(); try { sb.AppendFormat("update manage_user set user_status='{0}',user_login_attempts=0,user_updatedate='{1}' ", query.user_status, query.user_updatedate); sb.AppendFormat(" where user_id ='{0}' ;", query.user_id); return _access.execCommand(sb.ToString()); } catch (Exception ex) { throw new Exception("ManageUserDao-->UpdStatus" + ex.Message + sb.ToString(), ex); } }
public System.Data.DataTable GetUser(ManageUserQuery query) { try { return _configDao.GetUser(query); } catch (Exception ex) { throw new Exception("ConfigMgr-->GetUser-->" + ex.Message, ex); } }
/// <summary> /// 用戶管理中,添加用戶時的下拉框綁定數據 /// </summary> /// <returns></returns> public HttpResponseBase ManageUser() { string jsonStr = string.Empty; try { List<ManageUserQuery> store = new List<ManageUserQuery>(); ManageUserQuery query = new ManageUserQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量 query.IsPage = false; query.user_status = 1; _IManageUserMgr = new ManageUserMgr(mySqlConnectionString); int totalCount = 0; store = _IManageUserMgr.GetNameMail(query, out totalCount);//查询出供應商出貨單 IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd"; jsonStr = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據 } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); jsonStr = "{success:false,msg:0}"; } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase SaveManageUser() { string json = string.Empty; DataTable dt = new DataTable(); bool isupdate = false; string password; try { #region 發送email設置 string path = Server.MapPath(xmlPath); SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path); SiteConfig Mail_From = _siteConfigMgr.GetConfigByName("Mail_From"); SiteConfig Mail_Host = _siteConfigMgr.GetConfigByName("Mail_Host"); SiteConfig Mail_Port = _siteConfigMgr.GetConfigByName("Mail_Port"); SiteConfig Mail_UserName = _siteConfigMgr.GetConfigByName("Mail_UserName"); SiteConfig Mail_UserPasswd = _siteConfigMgr.GetConfigByName("Mail_UserPasswd"); string EmailFrom = Mail_From.Value;//發件人郵箱 string SmtpHost = Mail_Host.Value;//smtp服务器 string SmtpPort = Mail_Port.Value;//smtp服务器端口 string EmailUserName = Mail_UserName.Value;//郵箱登陸名 string EmailPassWord = Mail_UserPasswd.Value;//郵箱登陸密碼 #endregion _manageuserMgr = new ManageUserMgr(mySqlConnectionString); ManageUserQuery store = new ManageUserQuery(); ManageUserQuery query = new ManageUserQuery(); if (!string.IsNullOrEmpty(Request.Params["user_id"])) {//如果是編輯獲取該id數據 int totalCount = 0; query.IsPage = false; query.user_id = uint.Parse(Request.Params["user_id"]); query.userid = Request.Params["user_id"]; query.search_status = "-1"; store = _manageuserMgr.GetManageUserList(query, out totalCount).FirstOrDefault(); isupdate = true; } if (!string.IsNullOrEmpty(Request.Params["user_username"])) { query.user_username = Request.Params["user_username"]; } if (!string.IsNullOrEmpty(Request.Params["user_email"])) { query.user_email = Request.Params["user_email"]; if (store != null) { if (store.user_email == query.user_email) {//如果編輯沒有變email就空值 query.user_email = string.Empty; } } } if (!string.IsNullOrEmpty(Request.Params["erp_id"])) { query.erp_id = Request.Params["erp_id"]; } if (!string.IsNullOrEmpty(Request.Params["user_status"])) { query.user_status = uint.Parse(Request.Params["user_status"]); } else { query.user_status = 0; } if (!string.IsNullOrEmpty(Request.Params["manage"])) { query.manage = uint.Parse(Request.Params["manage"]); } else { query.manage = 0; } Random rd = new Random(); password = CommonFunction.Getserials(8, rd); query.user_password = hmd5.SHA256Encrypt(password); query.user_lastvisit = uint.Parse(CommonFunction.GetPHPTime(DateTime.Now.ToString()).ToString()); query.user_last_login = query.user_lastvisit; query.user_createdate = query.user_lastvisit; query.user_updatedate = query.user_lastvisit; if (_manageuserMgr.CheckEmail(query) > 0 && !string.IsNullOrEmpty(query.user_email)) {//判斷新增編輯過得email數據庫是否有重複 json = "{success:true,msg:2}"; } else { if (isupdate) { #region 編輯 if (query.user_status == 3) { query.user_delete_email = query.user_email; Random re = new Random(); query.user_email = DateTime.Now.ToString("yyyyMMddhhmmss") + hmd5.SHA256Encrypt(CommonFunction.Getdeleteemail(32, re)); if (_manageuserMgr.ManageUserUpd(query) > 0) { json = "{success:true,msg:1}"; } else { json = "{success:false,msg:4}"; } } else { if (_manageuserMgr.ManageUserUpd(query) > 0) { json = "{success:true,msg:1}"; } else { json = "{success:false,msg:4}"; } } #endregion } else { #region 新增 if (_manageuserMgr.ManageUserAdd(query) > 0) { FileStream fs = new FileStream(Server.MapPath("../ImportUserIOExcel/901.html"), FileMode.OpenOrCreate, FileAccess.Read); StreamReader sr = new StreamReader(fs, Encoding.UTF8); string strTemp = sr.ReadToEnd(); sr.Close(); fs.Close(); _paraMgr = new ParameterMgr(mySqlConnectionString); string linkurl = string.Empty; Parametersrc paModel = _paraMgr.QueryUsed(new Parametersrc { ParameterType = "admin_link_url" }).FirstOrDefault(); if (paModel != null) { linkurl = paModel.ParameterCode; } strTemp = strTemp.Replace("{{$s_user_username$}}", query.user_username); strTemp = strTemp.Replace("{{$u_admin_url$}}", linkurl); strTemp = strTemp.Replace("{{$s_email$}}", query.user_email); strTemp = strTemp.Replace("{{$s_password$}}", password); if (CommonFunction.sendmail(EmailFrom, FromName, query.user_email, query.user_name, EmailTile, strTemp, "", SmtpHost, Convert.ToInt32(SmtpPort), EmailUserName, EmailPassWord)) { json = "{success:true,msg:1}"; } else { json = "{success:true,msg:3}"; } } else { json = "{success:false,msg:4}"; } #endregion } } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,msg:'操作失敗!'}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public DataTable GetDesign(ManageUserQuery query) { try { return _DesignRequestDao.GetDesign(query); } catch (Exception ex) { throw new Exception("DesignRequestMgr.GetDesign-->" + ex.Message, ex); } }
public HttpResponseBase GetVoteArticleList() { List<VoteArticleQuery> store = new List<VoteArticleQuery>(); string json = string.Empty; int totalCount = 0; try { _muMgr = new ManageUserMgr(mySqlConnectionString); ManageUserQuery muq = new ManageUserQuery(); muq.IsPage = false; List<ManageUserQuery> mustore = _muMgr.GetNameMail(muq, out totalCount); VoteArticleQuery query = new VoteArticleQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); if (!string.IsNullOrEmpty(Request.Params["limit"])) { query.Limit = Convert.ToInt32(Request.Params["limit"]); } if (!string.IsNullOrEmpty(Request.Params["ddlSel"])) { query.event_id = Convert.ToInt32(Request.Params["ddlSel"]); } if (!string.IsNullOrEmpty(Request.Params["selcontent"])) { query.article_title = Request.Params["selcontent"]; } if (!string.IsNullOrEmpty(Request.Params["date"])) { query.date = Convert.ToInt32(Request.Params["date"]); } if (!string.IsNullOrEmpty(Request.Params["time_start"])) { query.time_start = Convert.ToDateTime(Request.Params["time_start"]).ToString("yyyy-MM-dd HH:mm:ss"); } if (!string.IsNullOrEmpty(Request.Params["time_end"])) { query.time_end = Convert.ToDateTime(Request.Params["time_end"]).ToString("yyyy-MM-dd HH:mm:ss"); } _votearticle = new VoteArticleMgr(mySqlConnectionString); store = _votearticle.GetAll(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; foreach (var item in store) { item.kendo_editor = Server.HtmlDecode(Server.HtmlDecode(item.article_content)); if (item.article_banner != "") { item.article_banner = imgServerPath + PaperPath + item.article_banner; } int indexc = mustore.FindIndex((ManageUserQuery e) => e.user_id == uint.Parse(item.create_user.ToString())); if (indexc != -1) { item.creat_name = mustore[indexc].user_name; } else { item.creat_name = string.Empty; } int indexu = mustore.FindIndex((ManageUserQuery e) => e.user_id == uint.Parse(item.update_user.ToString())); if (indexu != -1) { item.upd_name = mustore[indexu].user_name; } else { item.upd_name = string.Empty; } } //listUser是准备转换的对象 json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據 } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }