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 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 updateuser_master() { string json = string.Empty; BonusMasterQuery bmq = new BonusMasterQuery(); try { _uslmpgr = new UsersListMgr(mySqlConnectionString); bmq.master_id = Convert.ToUInt32(Request.Params["master_id"]); bmq.user_id = Convert.ToUInt32(Request.Params["user_id"]); bmq.master_total = Convert.ToUInt32(Request.Params["master_total"]); bmq.master_note = Convert.ToString(Request.Params["master_note"]); int already_use_bonus = 0; if (!string.IsNullOrEmpty(Request.Params["already_use_bonus"])) { already_use_bonus = int.Parse(Request.Params["already_use_bonus"]); } bmq.master_balance = int.Parse(bmq.master_total.ToString()) - already_use_bonus; bmq.master_end = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Params["smaster_end"])); bmq.master_start = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Params["smaster_start"])); _uslmpgr.updateuser_master(bmq); 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,msg:0}"; } this.Response.Clear(); this.Response.Write(json.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase sendemail() { 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;//郵箱登陸密碼 string json = string.Empty;//返回json數據 int id = Convert.ToInt32(Request.Params["id"]); _uslmpgr = new UsersListMgr(mySqlConnectionString); BLL.gigade.Model.Custom.Users stores = new BLL.gigade.Model.Custom.Users(); try { BLL.gigade.Model.Custom.Users query = new BLL.gigade.Model.Custom.Users(); query.user_id = Convert.ToUInt32(id); stores = _uslmpgr.getModel(id); if (stores.user_actkey == "") { stores.user_actkey = CommonFunction.Generate_Rand_String(8); } else { stores.user_actkey = stores.user_actkey; } _uslmpgr.UpdateUser(stores); //更新user數據庫 BLL.gigade.Model.Custom.Users urs = new BLL.gigade.Model.Custom.Users(); urs = _uslmpgr.getModel(id); //發送郵件 DateTime dt = DateTime.Now;//寄送時間 // stores.user_id;會員編號 //store.user_name;會員姓名 //store.user_email;寄送地址 //store.actkey 認證編號 // bool state = sendemail("*****@*****.**", "12345", "Gigade郵件", "www.gigade100.com/member_join_ok.php?uid=" + stores.user_id + "&act_key=" + stores.user_actkey, urs.user_email); FileStream fs = new FileStream(Server.MapPath("../ImportUserIOExcel/MemberValidate.html"), FileMode.OpenOrCreate, FileAccess.Read); StreamReader sr = new StreamReader(fs, Encoding.UTF8); string strTemp = sr.ReadToEnd(); sr.Close(); fs.Close(); strTemp = strTemp.Replace("{{$content$}}", "<a " + "href=" + "\"" + "www.gigade100.com/member_join_ok.php?uid=" + stores.user_id + "&act_key=" + stores.user_actkey + "\"" + ">" + "www.gigade100.com/member_join_ok.php?uid=" + stores.user_id + "&act_key=" + stores.user_actkey + "</a>"); bool state = sendmail(EmailFrom, FromName, urs.user_email, urs.user_name, EmailTile, strTemp, "", SmtpHost, Convert.ToInt32(SmtpPort), EmailUserName, EmailPassWord); string time = CommonFunction.DateTimeToString(DateTime.Now); if (state == true) { json = "{success:true,sendtime:'" + time + "',userid:'" + stores.user_id + "',username:'******',sendto:'" + stores.user_email + "',authenid:'" + stores.user_actkey + "'}"; } else { json = "{success:false,sendtime:'" + time + "',userid:'" + stores.user_id + "',username:'******',sendto:'" + stores.user_email + "',authenid:'" + stores.user_actkey + "'}"; } } 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); } this.Response.Clear(); this.Response.Write(json.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase BonusSearchList() { List<BonusMasterQuery> stores = new List<BonusMasterQuery>(); string json = string.Empty; try { BonusMasterQuery query = new BonusMasterQuery(); UInt32 uint32 = 0; query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "20");//用於分頁的變量 if (UInt32.TryParse(Request.Params["uid"], out uint32)) { query.user_id = uint32; } bool status = true; if (!string.IsNullOrEmpty(Request.Params["relation_id"]))//待回覆 { query.master_id = Convert.ToUInt32(Request.Params["relation_id"]); } if (bool.TryParse(Request.Params["use"], out status)) { query.use = status; } if (bool.TryParse(Request.Params["using"], out status)) { query.useing = status; } if (bool.TryParse(Request.Params["used"], out status)) { query.used = status; } if (bool.TryParse(Request.Params["usings"], out status)) { query.useings = status; } if (bool.TryParse(Request.Params["useds"], out status)) { query.useds = status; } if (!string.IsNullOrEmpty(Request.Params["userNameMail"])) { query.user_name = Request.Params["userNameMail"]; query.user_email = query.user_name; } DateTime dt; if (DateTime.TryParse(Request.Params["timestart"], out dt)) { query.smaster_start = Convert.ToDateTime(dt.ToString("yyyy-MM-dd HH:mm:ss")); } if (DateTime.TryParse(Request.Params["timeend"], out dt)) { query.smaster_end = Convert.ToDateTime(dt.ToString("yyyy-MM-dd HH:mm:ss")); ; } if (UInt32.TryParse(Request.Params["bonus_type"], out uint32)) { query.bonus_type = uint32; } if (UInt32.TryParse(Request.Params["type_id"], out uint32)) { query.type_id = uint32; } _uslmpgr = new UsersListMgr(mySqlConnectionString); int totalCount = 0; stores = _uslmpgr.bQuery(query, out totalCount); foreach (var item in stores) { //獲取時間 item.smaster_start = CommonFunction.GetNetTime(item.master_start); item.smaster_end = CommonFunction.GetNetTime(item.master_end); item.smaster_createtime = CommonFunction.GetNetTime(item.master_createdate); item.now_time = Convert.ToInt32(CommonFunction.GetPHPTime()); 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] + "@***"; } } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; //listUser是准备转换的对象 json = "{success:true,totalCount:" + totalCount + ",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; }
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; }