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;
}
