/// <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; }
/// <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 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 string QueryPm() { gcMgr = new GroupCallerMgr(connectionString); paraMgr = new ParameterMgr(connectionString); fgMgr = new FgroupMgr(connectionString); muMgr = new ManageUserMgr(connectionString); groupCaller gc = new groupCaller(); Fgroup fg = new Fgroup(); string json = string.Empty; try { List<Parametersrc> parstore = paraMgr.QueryUsed(new Parametersrc { ParameterType = "vendor_pm" }).ToList(); if (parstore.Count != 0) { fg.groupCode = parstore[0].ParameterCode; // fg.groupName = parstore[0].parameterName;//parameterName是可變的不可依此查詢 edit by shuangshuang0420j 2015.07.28 09:48 Fgroup pmfg = fgMgr.GetSingle(fg); if (pmfg != null) { gc.groupId = pmfg.rowid; string pm = gcMgr.QueryCallidById(gc); StringBuilder stb = new StringBuilder(""); stb.Append("{"); stb.Append("success:true,item:["); //stb.Append("{"); //stb.AppendFormat("\"userId\":\"{0}\",\"userName\":\"{1}\"", 0, "請選擇"); //stb.Append("}"); string nameStr = string.Empty; string[] pmar = pm.Split(',').ToArray(); foreach (var item in pmar) { int total = 0; ManageUserQuery mu = muMgr.GetManageUserList(new ManageUserQuery { user_email = item, search_status = "-1" }, out total).FirstOrDefault(); if (total == 1 && mu != null) { stb.Append("{"); stb.AppendFormat("\"userId\":\"{0}\",\"userName\":\"{1}\"", mu.user_id, mu.user_username); stb.Append("}"); } } stb.Append("]}"); json = stb.ToString().Replace("}{", "},{"); } //else //{ // json = "{success:false,error:1}"; //} } //else //{ // json = "{success:false,error:0}"; //} } 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 = "[]"; } return json; }
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 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; }
/// <summary> /// 對賬號解鎖重設 /// </summary> /// <returns>數據庫操作結果</returns> public JsonResult UnlockAndReset() { string jsonStr = string.Empty; try { sasMgr = new SecretAccountSetMgr(mySqlConnectionString); _muMgr = new ManageUserMgr(mySqlConnectionString); int id = Convert.ToInt32(Request.Params["id"]); int activeValue = Convert.ToInt32(Request.Params["active"]); SecretAccountSet sas = new SecretAccountSet(); sas.id = id; SecretAccountSet oldsas = sasMgr.Select(sas);//獲得用戶的密保信息 if (oldsas.secret_limit == oldsas.secret_count && oldsas.secret_limit != 0) { sas.status = 0; } else { sas.status = 1; } sas.pwd_status = oldsas.pwd_status; sas.user_login_attempts = 0; if (sasMgr.Update(sas) > 0) { return Json(new { success = "true" }); } else { return Json(new { 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); return Json(new { success = "false" }); } }
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 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; }