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