public int UserCancel(UsersListQuery u) { try { return _UserIplDao.UserCancel(u); } catch (Exception ex) { throw new Exception("UsersListMgr-->UserCancel-->" + ex.Message, ex); } }
public int UserCancel(UsersListQuery u) { StringBuilder sb = new StringBuilder(); StringBuilder sel = new StringBuilder(); string email = DateTime.Now.ToString("yyyyMMdd") + "_" + u.user_email; try { if (u.user_id > 0) { sb.Append("set sql_safe_updates = 0;"); sb.AppendFormat("Update users set user_status=2,user_email='{1}' where user_id='{0}';", u.user_id, email); sel.AppendFormat("SELECT * from edm_email where email_address='{0}' ;", u.user_email); if (_access.getDataTable(sel.ToString()).Rows.Count > 0) {//修改會員電子報信息 sb.AppendFormat("Update edm_email set email_updatedate='{2}' , email_address='{1}' where email_address='{0}';", u.user_email, email, CommonFunction.GetPHPTime(DateTime.Now.ToString())); } sel.Clear(); sel.AppendFormat("SELECT * from epaper_email where email_address='{0}'", u.user_email); if (_access.getDataTable(sel.ToString()).Rows.Count > 0) {//修改會員電子報信息 sb.AppendFormat("Update epaper_email set email_updatedate='{2}', email_address='{1}' where email_address='{0}';", u.user_email, email, CommonFunction.GetPHPTime(DateTime.Now.ToString())); } sb.Append("set sql_safe_updates = 1; "); //保存禁用會員的時間和操作人至會員生活表(user_life)edit by shuangshuang0420j 20150814 09:42 UserLifeDao _userLifeDao = new UserLifeDao(conn); sb.Append(_userLifeDao.UpdateDisableTime(u.user_id, (uint)CommonFunction.GetPHPTime(), u.update_user)); return _access.execCommand(sb.ToString()); } else { return 0; } } catch (Exception ex) { throw new Exception("UsersListDao-->UserCancel-->" + ex.Message + sb.ToString(), ex); } }
public HttpResponseBase GetUserInfo() { string json = string.Empty; UsersListQuery store = new UsersListQuery(); _orderMasterMgr = new OrderMasterMgr(mySqlConnectionString); try { uint user_id = Convert.ToUInt32(Request.Params["user_id"]); // uint user_id = 2341; store = _orderMasterMgr.GetUserInfo(user_id); store.suser_reg_date = CommonFunction.GetNetTime(store.user_reg_date); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; json = "{success:true,data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}"; } 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 string SaveUserList(UsersListQuery usr) { StringBuilder sb = new StringBuilder(); try { usr.Replace4MySQL(); sb.AppendFormat(@"update users set user_name='{0}',user_password='******',user_gender='{2}', user_birthday_year='{3}',user_birthday_month='{4}',user_birthday_day='{5}',user_zip='{6}', user_address='{7}',user_phone='{8}',user_mobile='{9}',send_sms_ad='{10}',adm_note='{11}' ,paper_invoice='{12}', user_mobile_bak='{13}' where user_id='{14}';", usr.user_name, usr.user_password, usr.user_gender, usr.user_birthday_year, usr.user_birthday_month, usr.user_birthday_day, usr.user_zip, usr.user_address, usr.user_phone, usr.user_mobile, Convert.ToInt32(usr.send_sms_ad), usr.adm_note, Convert.ToInt32(usr.paper_invoice), usr.user_mobile, usr.user_id); return sb.ToString(); } catch (Exception ex) { throw new Exception("UsersListDao-->SaveUserList-->" + ex.Message + sb.ToString(), ex); } }
public List<UsersListQuery> Export(UsersListQuery store) { StringBuilder sql = new StringBuilder(); StringBuilder sqlfrom = new StringBuilder(); try { sql.Append(@"SELECT users_login.login_ipfrom as master_ipfrom,redirect_name,group_name,users.user_id,users.user_name ,user_gender,user_reg_date, user_company_id,user_source ,concat(user_birthday_year,'/',user_birthday_month,'/',user_birthday_day) as birthday,ml_code, first_time,last_time,be4_last_time,bonus_master.master_total as master_total,bonus_master.master_balance as bonus_master"); sqlfrom.Append(" FROM users left join redirect on users.source_trace = redirect.redirect_id "); sqlfrom.Append(@" left join bonus_master on users.user_id =bonus_master.user_id "); sqlfrom.Append(@" LEFT JOIN users_login on users_login.user_id=bonus_master.user_id "); sqlfrom.Append(@" LEFT JOIN redirect_group on redirect_group.group_id=redirect.group_id WHERE 1=1 "); if (store.serchstart != DateTime.MinValue) { sqlfrom.AppendFormat(" and user_reg_date >= '{0}'", CommonFunction.GetPHPTime(store.serchstart.ToString())); } if (store.serchend.ToShortDateString() != DateTime.MinValue.ToShortDateString()) { sqlfrom.AppendFormat(" AND user_reg_date <= '{0}'", CommonFunction.GetPHPTime(store.serchend.ToString())); } if (!string.IsNullOrEmpty(store.serchtype)) { if (store.serchtype.ToString() == "0") { sqlfrom.Append(" "); } else if (store.serchtype.ToString() == "1") { sqlfrom.AppendFormat(" and user_email like '%{0}%' ", store.content.Trim()); } else if (store.serchtype.ToString() == "2") { sqlfrom.AppendFormat(" and user_name like '%{0}%' ", store.content.Trim()); } else if (store.serchtype.ToString() == "3") { store.content = EncryptComputer.EncryptDecryptTextByApi(store.content.Trim()); sqlfrom.AppendFormat(" and user_mobile like '%{0}%' ", store.content.Trim()); } else if (store.serchtype.ToString() == "4") { sqlfrom.AppendFormat(" and users.user_id like '%{0}%' ", store.content.Trim()); } else if (store.serchtype.ToString() == "5") { sqlfrom.AppendFormat(" and user_phone like '%{0}%' ", store.content.Trim()); } else if (store.serchtype.ToString() == "6") { sqlfrom.AppendFormat(" and user_address like '%{0}%' ", store.content.Trim()); } //Edit Start //Add by yuwei1015j 2015-12-02 else if (store.serchtype.ToString() == "7") { sqlfrom.AppendFormat(" and ml_code like '%{0}%' ", store.content.Trim()); } //Edit End } if (!string.IsNullOrEmpty(store.types.ToString())) { sqlfrom.AppendFormat(" and user_status='{0}' ", store.types); } if (store.checks.ToString() == "true") { sqlfrom.AppendFormat(" and (user_type=2 or adm_note LIKE '%更改為網路會員') "); } sqlfrom.AppendFormat(" GROUP BY users.user_id ORDER BY users.user_id DESC "); return _access.getDataTableForObj<UsersListQuery>(sql.ToString() + sqlfrom.ToString()); } catch (Exception ex) { throw new Exception("UsersListDao-->Query-->" + ex.Message + sql.ToString() + sqlfrom.ToString(), ex); } }
public string UnSecretMobile(UsersListQuery item) { if (!CommonFunction.isMobile(item.user_mobile)) { if (item.user_mobile.ToString().Length == 48) { item.user_mobile = EncryptComputer.EncryptDecryptTextByApi(item.user_mobile, false); if (!CommonFunction.isMobile(item.user_mobile)) { //異常記錄 Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("表名:{0},編號:{1},行動電話:{2},Message:{3}", "users", item.user_id, item.user_mobile, "行動電話解密后不滿足正則表達式"); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } } else { //異常記錄 Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("表名:{0},編號:{1},行動電話:{2},Message:{3}", "users", item.user_id, item.user_mobile, "行動電話錯誤"); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } } return item.user_mobile; }
public HttpResponseBase UserCancel() { string json = string.Empty; _uslmpgr = new UsersListMgr(mySqlConnectionString); UsersListQuery u = new UsersListQuery(); try { if (!string.IsNullOrEmpty(Request.Params["rowID"])) { u.user_id = uint.Parse(Request.Params["rowID"]); } if (!string.IsNullOrEmpty(Request.Params["email"])) { u.user_email = Request.Params["email"]; } u.update_user = (Session["caller"] as Caller).user_id; if (_uslmpgr.UserCancel(u) > 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}"; } this.Response.Clear(); this.Response.Write(json.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase UserslistExport() { List<UsersListQuery> stores = new List<UsersListQuery>(); UsersListQuery query = new UsersListQuery(); //todo:分页汇出会员信息,由于不能确定是按分页汇出还是汇出全部会员信息,暂且保留汇出全部会员信息 //query.Start = start;//用於分頁的變量 //query.Limit = limit;//用於分頁的變量 if (!string.IsNullOrEmpty(Request.Params["serchs"])) { query.serchtype = Request.Params["serchs"]; } if (!string.IsNullOrEmpty(Request.Params["timestart"])) { query.serchstart = Convert.ToDateTime(Request.Params["timestart"]); query.serchstart = Convert.ToDateTime(query.serchstart.ToString("yyyy-MM-dd HH:mm:ss")); } if (!string.IsNullOrEmpty(Request.Params["timestart"])) { query.serchend = Convert.ToDateTime(Request.Params["timeend"]); query.serchend = Convert.ToDateTime(query.serchend.ToString("yyyy-MM-dd HH:mm:ss")); } query.content = Request.Params["serchcontent"]; query.types = Request.Params["bonus_type"]; query.checks = Request.Params["checkbox1"]; string json = string.Empty; if (!System.IO.Directory.Exists(Server.MapPath(excelPath))) { System.IO.Directory.CreateDirectory(Server.MapPath(excelPath)); } DataTable dtHZ = new DataTable(); string newExcelName = string.Empty; dtHZ.Columns.Add("編號", typeof(String)); //dtHZ.Columns.Add("信箱", typeof(String)); dtHZ.Columns.Add("姓名", typeof(String)); dtHZ.Columns.Add("性別", typeof(String)); dtHZ.Columns.Add("生日", typeof(String)); dtHZ.Columns.Add("等級", typeof(String)); //dtHZ.Columns.Add("行動電話", typeof(String)); // dtHZ.Columns.Add("聯絡電話", typeof(String)); // dtHZ.Columns.Add("郵遞區號", typeof(String)); //dtHZ.Columns.Add("地址", typeof(String)); dtHZ.Columns.Add("註冊日期", typeof(String)); dtHZ.Columns.Add("來源", typeof(String)); dtHZ.Columns.Add("公司", typeof(String)); dtHZ.Columns.Add("站內連結群組", typeof(String)); dtHZ.Columns.Add("站內連結", typeof(String)); dtHZ.Columns.Add("購物金發放", typeof(String)); dtHZ.Columns.Add("購物金使用", typeof(String)); dtHZ.Columns.Add("首購時間", typeof(String)); dtHZ.Columns.Add("上次購買時間", typeof(String)); dtHZ.Columns.Add("上上次購買時間", typeof(String)); dtHZ.Columns.Add("初次登入IP", typeof(String)); try { _uslmpgr = new UsersListMgr(mySqlConnectionString); stores = _uslmpgr.Export(query); string userId = " ";/*获取会员的ID成为字符串,进入数据库查询*/ foreach (var item in stores) { userId += item.user_id + ","; //獲取時間 item.suser_reg_date = CommonFunction.GetNetTime(item.user_reg_date); item.sfirst_time = CommonFunction.GetNetTime(item.first_time); item.slast_time = CommonFunction.GetNetTime(item.last_time); item.sbe4_last_time = CommonFunction.GetNetTime(item.be4_last_time); } userId = userId.Remove(userId.Length - 1); DataTable dtBonusTotal = _uslmpgr.GetBonusTotal(query.serchstart, query.serchend, userId);/*购物金发放*/ DataTable dtRecordTotal = _uslmpgr.GetRecordTotal(query.serchstart, query.serchend, userId);/*购物金使用*/ DataTable dtZipCode = _uslmpgr.GetZipCode(); foreach (var item in stores) { DataRow dr = dtHZ.NewRow(); dr[0] = item.user_id; //dr[1] = item.user_email; dr[1] = ((char)9).ToString() + item.user_name.Replace(',', ','); if (item.user_gender == 0) { dr[2] = "小姐"; } else if (item.user_gender == 1) { dr[2] = "先生"; } dr[3] = item.birthday;//生日 dr[4] = item.ml_code; dr[5] = item.suser_reg_date; dr[6] = ((char)9).ToString() + item.user_source.Replace(',', ',');//來源 dr[7] = ((char)9).ToString() + item.user_company_id.Replace(',', ',');//外網來源 dr[8] = item.group_name;//站内链接群组 dr[9] = item.redirect_name;//站内链接群组 dr[10] = 0;//item.master_total;//购物金发放 dr[11] = 0;//item.master_balance;//购物金使用 #region 把购物金的信息导入dr表中; DataRow[] rBonusTotal = dtBonusTotal.Select("user_id='" + item.user_id + "'"); if (rBonusTotal.Length > 0) { dr[10] = rBonusTotal[0]["total_in"];//購物金發放 } DataRow[] rRecordTotal = dtRecordTotal.Select("user_id='" + item.user_id + "'"); if (rRecordTotal.Length > 0) { dr[11] = rRecordTotal[0]["total_out"];//購物金使用 } #endregion dr[12] = CommonFunction.DateTimeToString(item.sfirst_time) == "1970-01-01 08:00:00" ? "N/A" : CommonFunction.DateTimeToString(item.sfirst_time);//首購時間 dr[13] = CommonFunction.DateTimeToString(item.slast_time) == "1970-01-01 08:00:00" ? "N/A" : CommonFunction.DateTimeToString(item.slast_time);//上次購買時間 dr[14] = CommonFunction.DateTimeToString(item.sbe4_last_time) == "1970-01-01 08:00:00" ? "N/A" : CommonFunction.DateTimeToString(item.sbe4_last_time);//上上此購買時間 dr[15] = item.master_ipfrom;//初次登陸IP dtHZ.Rows.Add(dr); } string[] colname = new string[dtHZ.Columns.Count]; string filename = "user_list_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv"; newExcelName = Server.MapPath(excelPath) + filename; for (int i = 0; i < dtHZ.Columns.Count; i++) { colname[i] = dtHZ.Columns[i].ColumnName; } if (System.IO.File.Exists(newExcelName)) { System.IO.File.Delete(newExcelName); } CsvHelper.ExportDataTableToCsv(dtHZ, newExcelName, colname, true); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; json = "{success:true,fileName:\'" + filename + "\'}"; } 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 = "false"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase SaveUsersList() { string json = string.Empty; try { #region 獲取會員基本信息 //獲取會員基本信息 UsersListQuery user = new UsersListQuery(); if (!string.IsNullOrEmpty(Request.Params["user_id"])) { user.user_id = Convert.ToUInt32(Request.Params["user_id"]); } if (!string.IsNullOrEmpty(Request.Params["user_name"])) { user.user_name = Request.Params["user_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["user_gender"])) { user.user_gender = Convert.ToUInt32(Request.Params["user_gender"]); } //if (!string.IsNullOrEmpty(Request.Params["user_phone"])) //{ // user.user_phone = Request.Params["user_phone"].ToString(); //} if (!string.IsNullOrEmpty(Request.Params["user_mobile"])) { user.user_mobile = Request.Params["user_mobile"].ToString(); // user.user_mobile = EncryptComputer.EncryptDecryptTextByApi(Request.Params["user_mobile"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["my_birthday"])) { DateTime birth = Convert.ToDateTime(Request.Params["my_birthday"].ToString()); user.user_birthday_year = Convert.ToUInt32(birth.Year); user.user_birthday_month = Convert.ToUInt32(birth.Month); user.user_birthday_day = Convert.ToUInt32(birth.Day); } else { user.user_birthday_year = 1970; user.user_birthday_month = 0; user.user_birthday_day = 0; } if (user.user_id == 0 && !string.IsNullOrEmpty(Request.Params["user_password_add"])) { HashEncrypt hmd5 = new HashEncrypt(); user.user_password = hmd5.SHA256Encrypt(Request.Params["user_password_add"].Trim()); } else if (!string.IsNullOrEmpty(Request.Params["user_password_edit"])) { HashEncrypt hmd5 = new HashEncrypt(); user.user_password = hmd5.SHA256Encrypt(Request.Params["user_password_edit"].Trim()); } if (Request.Params["send_sms_ad"].ToString() == "on") { user.send_sms_ad = true; } else { user.send_sms_ad = false; } if (!string.IsNullOrEmpty(Request.Params["admNote"])) { user.adm_note = Request.Params["admNote"].ToString(); } user.user_zip = Convert.ToUInt32(Request.Params["user_zip"]); user.user_address = Request.Params["user_address"].ToString(); if (!string.IsNullOrEmpty(Request.Params["paper_invoice"])) { if (Request.Params["paper_invoice"].ToString() == "on") { user.paper_invoice = true; } else { user.paper_invoice = false; } } #endregion #region 獲取會員生活屬性 List<UserLife> userInfoList = new List<UserLife>(); UserLife uModel = new UserLife(); uModel.user_id = user.user_id; uModel.kdate = (uint)CommonFunction.GetPHPTime(); uModel.kuser = (Session["caller"] as Caller).user_id; user.update_user = uModel.kuser; if (Request.Params["user_marriage"] == "1") { UserLife model = new UserLife(); model.user_id = uModel.user_id; model.kdate = uModel.kdate; model.kuser = uModel.kuser; model.info_type = "user_marriage"; model.info_name = "是否結婚"; model.info_code = "1"; userInfoList.Add(model); } if (!string.IsNullOrEmpty(Request.Params["child_num"]) && Convert.ToInt32(Request.Params["child_num"]) != 0) { UserLife model = new UserLife(); model.user_id = uModel.user_id; model.kdate = uModel.kdate; model.kuser = uModel.kuser; model.info_type = "child_num"; model.info_name = "孩子個數"; model.info_code = Request.Params["child_num"]; userInfoList.Add(model); } if (!string.IsNullOrEmpty(Request.Params["vegetarian_type"]) && Convert.ToInt32(Request.Params["vegetarian_type"]) != 0) { UserLife model = new UserLife(); model.user_id = uModel.user_id; model.kdate = uModel.kdate; model.kuser = uModel.kuser; model.info_type = "vegetarian_type"; model.info_name = "是否吃素"; model.info_code = Request.Params["vegetarian_type"]; userInfoList.Add(model); } if (Request.Params["like_fivespice"] == "on") { UserLife model = new UserLife(); model.user_id = uModel.user_id; model.kdate = uModel.kdate; model.kuser = uModel.kuser; model.info_type = "like_fivespice"; model.info_name = "是否吃五辛"; model.info_code = "1"; userInfoList.Add(model); } string contact = string.Empty; if (Request.Params["contact1"] == "on") { contact += "1,"; } if (Request.Params["contact2"] == "on") { contact += "2,"; } if (Request.Params["contact3"] == "on") { contact += "3,"; } contact = contact.TrimEnd(','); if (!string.IsNullOrEmpty(contact)) { UserLife model = new UserLife(); model.user_id = uModel.user_id; model.kdate = uModel.kdate; model.kuser = uModel.kuser; model.info_type = "like_contact"; model.info_name = "方便聯繫方式"; model.info_code = contact; userInfoList.Add(model); } if (!string.IsNullOrEmpty(Request.Params["like_time"]) && Convert.ToInt32(Request.Params["like_time"]) != 0) { UserLife model = new UserLife(); model.user_id = uModel.user_id; model.kdate = uModel.kdate; model.kuser = uModel.kuser; model.info_type = "like_time"; model.info_name = "方便聯繫時間"; model.info_code = Request.Params["like_time"]; userInfoList.Add(model); } if (!string.IsNullOrEmpty(Request.Params["user_salary"]) && Convert.ToInt32(Request.Params["user_salary"]) != 0) { UserLife model = new UserLife(); model.user_id = uModel.user_id; model.kdate = uModel.kdate; model.kuser = uModel.kuser; model.info_type = "user_salary"; model.info_name = "年薪"; model.info_code = Request.Params["user_salary"]; userInfoList.Add(model); } if (!string.IsNullOrEmpty(Request.Params["work_type"]) && Convert.ToInt32(Request.Params["work_type"]) != 0) { UserLife model = new UserLife(); model.user_id = uModel.user_id; model.kdate = uModel.kdate; model.kuser = uModel.kuser; model.info_type = "work_type"; model.info_name = "職業"; model.info_code = Request.Params["work_type"]; userInfoList.Add(model); } if (!string.IsNullOrEmpty(Request.Params["user_educated"]) && Convert.ToInt32(Request.Params["user_educated"]) != 0) { UserLife model = new UserLife(); model.user_id = uModel.user_id; model.kdate = uModel.kdate; model.kuser = uModel.kuser; model.info_type = "user_educated"; model.info_name = "教育"; model.info_code = Request.Params["user_educated"]; userInfoList.Add(model); } if (!string.IsNullOrEmpty(Request.Params["user_religion"]) && Convert.ToInt32(Request.Params["user_religion"]) != 0) { UserLife model = new UserLife(); model.user_id = uModel.user_id; model.kdate = uModel.kdate; model.kuser = uModel.kuser; model.info_type = "user_religion"; model.info_name = "宗教信仰"; model.info_code = Request.Params["user_religion"]; userInfoList.Add(model); } if (!string.IsNullOrEmpty(Request.Params["user_constellation"]) && Convert.ToInt32(Request.Params["user_constellation"]) != 0) { UserLife model = new UserLife(); model.user_id = uModel.user_id; model.kdate = uModel.kdate; model.kuser = uModel.kuser; model.info_type = "user_constellation"; model.info_name = "星座"; model.info_code = Request.Params["user_constellation"]; userInfoList.Add(model); } #endregion _uslmpgr = new UsersListMgr(mySqlConnectionString); if (_uslmpgr.SaveUserList(user, userInfoList)) { json = "{success:true}";//返回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,error:\"" + BLL.gigade.Common.CommonFunction.MySqlException(ex) + "\"}"; } this.Response.Clear(); this.Response.Write(json.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase UsersList() { List<UsersListQuery> stores = new List<UsersListQuery>(); List<SiteConfig> configs = new List<SiteConfig>(); SiteConfig con = new SiteConfig(); string json = string.Empty; try { string path = Server.MapPath(xmlPath); if (System.IO.File.Exists(path)) { siteConfigMgr = new SiteConfigMgr(path); configs = siteConfigMgr.Query(); } foreach (SiteConfig site in configs) { if (site.Name == "DoMain_Name") { con = site; break; } } UsersListQuery query = new UsersListQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "20");//用於分頁的變量 //todo:分页汇出会员信息,由于不能确定是按分页汇出还是汇出全部会员信息,暂且保留汇出全部会员信息 //start = query.Start; //limit = query.Limit; if (!string.IsNullOrEmpty(Request.Params["serchs"])) { query.serchtype = Request.Params["serchs"]; } if (!string.IsNullOrEmpty(Request.Params["timestart"])) { query.serchstart = Convert.ToDateTime(Request.Params["timestart"]); query.serchstart = Convert.ToDateTime(query.serchstart.ToString("yyyy-MM-dd HH:mm:ss")); } if (!string.IsNullOrEmpty(Request.Params["timeend"])) { query.serchend = Convert.ToDateTime(Request.Params["timeend"]); query.serchend = Convert.ToDateTime(query.serchend.ToString("yyyy-MM-dd HH:mm:ss")); } query.content = Request.Params["serchcontent"]; query.types = Request.Params["bonus_type"]; query.checks = Request.Params["checkbox1"]; if (!string.IsNullOrEmpty(Request.Params["relation_id"]))//待回覆 { query.user_id = Convert.ToUInt32(Request.Params["relation_id"]); } _uslmpgr = new UsersListMgr(mySqlConnectionString); _paraMgr = new ParameterMgr(mySqlConnectionString); int totalCount = 0; stores = _uslmpgr.Query(query, out totalCount); Parametersrc pa = new Parametersrc(); foreach (var item in stores) { string[] url = con.Value.Split('/'); item.user_url = "http://" + url[0] + "/ecservice_jump.php";//?uid=" + item.user_id; if (Convert.ToBoolean(Request.Params["isSecret"])) { if (!string.IsNullOrEmpty(item.user_name)) { item.user_name = item.user_name.Substring(0, 1) + "**"; } item.user_email = item.user_email.Split('@')[0] + "@***"; //if (!string.IsNullOrEmpty(item.user_mobile)) //{ // if (item.user_phone.ToString().Length > 3) // { // item.user_phone = item.user_phone.Substring(0, 3) + "***"; // } // else // { // item.user_phone = item.user_phone + "***"; // } //} if (!string.IsNullOrEmpty(item.user_mobile)) { item.user_mobile = UnSecretMobile(item); if (item.user_mobile.ToString().Length > 3) { item.user_mobile = item.user_mobile.Substring(0, 3) + "***"; } else { item.user_mobile = item.user_mobile + "***"; } } if (item.user_address.ToString().Length > 3) { item.user_address = item.user_address.Substring(0, 3) + "***"; } else { item.user_address = item.user_address + "***"; } } else { if (item.user_mobile.Length == 48) { item.user_mobile = EncryptComputer.EncryptDecryptTextByApi(item.user_mobile, false); } } //獲取時間 item.reg_date = CommonFunction.GetNetTime(item.user_reg_date); item.sfirst_time = CommonFunction.GetNetTime(item.first_time); item.slast_time = CommonFunction.GetNetTime(item.last_time); item.sbe4_last_time = CommonFunction.GetNetTime(item.be4_last_time); pa = _paraMgr.QueryUsed(new Parametersrc { Used = 1, ParameterCode = item.user_level.ToString(), ParameterType = "UserLevel" }).FirstOrDefault(); if (pa != null) { item.userLevel = pa.parameterName; } #region 購物金欄位修改 add by yafeng0715j 20150924 BonusMasterMgr bmMgr = new BonusMasterMgr(mySqlConnectionString); BonusMasterQuery bmQuery = new BonusMasterQuery(); bmQuery.user_id = item.user_id; bmQuery.bonus_type = 1; DataTable table = bmMgr.GetBonusMasterList(bmQuery); uint master_total = 0; int master_balance = 0; if (table.Rows[0][0].ToString() != "") { master_total = Convert.ToUInt32(table.Rows[0][0]); master_balance = Convert.ToInt32(table.Rows[0][1]); } item.bonus_type = 1; item.bonus_typename = string.Format("購物金(剩餘{0}/總{1})", master_balance, master_total); master_total = 0; master_balance = 0; bmQuery.bonus_type = 2; table = bmMgr.GetBonusMasterList(bmQuery); if (table.Rows[0][0].ToString() != "") { master_total = Convert.ToUInt32(table.Rows[0][0]); master_balance = Convert.ToInt32(table.Rows[0][1]); } item.bonus_type1 = 2; item.bonus_typenamequan = string.Format("抵用券(剩餘{0}/總{1})", master_balance, master_total); #endregion } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; //listUser是准备转换的对象 json = "{success:true,'msg':'user',totalCount:" + totalCount + ",start:" + query.Start + ",limit:" + query.Limit + ",data:" + JsonConvert.SerializeObject(stores, 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:true,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }