public JsonResult Delete(WX_LK_RegMemberFans _t)
{
if (WMFactory.WXLKRegMemberFans.Delete(s => s.Id == _t.Id ))
return Json(ResultMsg.Success("删除成功！"));
else
return Json(ResultMsg.Failure("删除失败，请您重试！"));
}
public JsonResult VexSSOBind(string tel, string pwd, string code ,string amuser,string ampwd,bool reged)
{
if (!Regex.IsMatch(tel, @"^1[34578]\d{9}$", RegexOptions.IgnoreCase) && !Regex.IsMatch(tel, @"^6\d{8}$", RegexOptions.IgnoreCase))
{
return Json(ResultMsg.Failure("手机号格式错误！"));
}
DataTable dt = WMFactory.Wsrr.VexSSORegAndBindAM(tel, pwd, amuser, ampwd, code, reged);
if (dt.Rows[0][0].ToString().ToLower() == "true")
{
//绑定微信号，如果存在的话，绑定微信
if (!string.IsNullOrEmpty(Request["oid"]) && !string.IsNullOrEmpty(Request["sid"]))
{
//VexSSO绑定微信号
WMFactory.Wsrr.VexSSOBind(tel, pwd, "ITDCWeChat", Request["oid"], "");
//插入到关联表
WX_LK_RegMemberFans fan = new WX_LK_RegMemberFans();
fan.IsUsing = 0;
fan.AccountId = Guid.Parse(Request["sid"]);
fan.OpenId = Request["oid"];
fan.Telphone = tel;
fan.CreateUser = "******";
WMFactory.WXLKRegMemberFans.Insert(fan);
}
//更新C3AM的账号
WMFactory.Wsrr.UpdateC3AMUser(amuser, tel, pwd);
return Json(ResultMsg.Success("注册成功！"));
}
else
return Json(ResultMsg.Failure(dt.Rows[0][1].ToString()));
}
public JsonResult Post(WX_LK_RegMemberFans _t)
{
if (WMFactory.WXLKRegMemberFans.Insert(_t))
return Json(ResultMsg.Success("新增成功！"));
else
return Json(ResultMsg.Failure("新增失败，请您重试！"));
}
public JsonResult Put(WX_LK_RegMemberFans _t)
{
IWXLKRegMemberFansService service = WMFactory.WXLKRegMemberFans;
WX_LK_RegMemberFans entity = service.GetById(_t.Id.ToString());
entity = AutoMapper<WX_LK_RegMemberFans, WX_LK_RegMemberFans>.Convert(_t, entity);
if (service.Update(entity))
return Json(ResultMsg.Success("更新成功！"));
else
return Json(ResultMsg.Failure("更新失败，请您重试！"));
}
public JsonResult RegistMember(Guid sid,string oid, string tel, string pwd, string code)
{
if (!Regex.IsMatch(tel, @"^1[34578]\d{9}$", RegexOptions.IgnoreCase) && !Regex.IsMatch(tel, @"^6\d{8}$", RegexOptions.IgnoreCase))
{
return Json(ResultMsg.Failure("手机号格式错误！"));
}
//插入到关联表
WX_LK_RegMemberFans fan = new WX_LK_RegMemberFans();
fan.IsUsing = 0;
fan.AccountId = sid;
fan.OpenId = oid;
fan.Telphone = tel;
fan.CreateUser = "******";
try
{
DataTable dt = WMFactory.Wsrr.Register3S(tel, oid, pwd, code);
if (dt.Rows[0][0].ToString().ToLower() == "true")
{
WMFactory.WXLKRegMemberFans.Insert(fan);
return Json(ResultMsg.Success("注册成功！"));
}
else
return Json(ResultMsg.Failure(dt.Rows[0][1].ToString()));
}
catch (Exception error) {
if (error.Message.Contains("该手机号码已被注册！"))
{
//插入到关联表,已被注册的还是要插入到该表中
WMFactory.WXLKRegMemberFans.Insert(fan);
//单独绑定一次VEXSSO 微信号
WMFactory.Wsrr.VexSSOBind(tel, "", "3SWeChat", oid, "");
return Json(ResultMsg.Success("YZC"));
}
else
return Json(ResultMsg.Failure(error.Message));
}
}
public JsonResult DRPCheckPhone(Guid sid, string oid, string VipTel, string VipSex, string VipName)
{
//通过手机查询，积分，如果返回的表里面没有数据或者表不存在就直接判断会员号不存在。
DataTable dtpCentum = WMFactory.Wsrr.GetUserCentumInfo(VipTel);
if (dtpCentum.Rows[0]["mobtel"].ToString() == "")
{
//调取WSRR生成会员USER和会员VIP卡
DataTable dt = WMFactory.Wsrr.VipUserForC3(VipTel, VipSex, VipName);
if (dt.Rows[0][0].ToString().ToLower() == "true")
{
//插入到关联表
WX_LK_RegMemberFans fan = new WX_LK_RegMemberFans();
fan.IsUsing = 0;
fan.AccountId = sid;
fan.OpenId = oid;
fan.Telphone = VipTel;
fan.CreateUser = "******";
WMFactory.WXLKRegMemberFans.Insert(fan);
return Json(ResultMsg.Success("注册成功！"));
}
else
{
return Json(ResultMsg.Failure("注册失败"));
}
}
else
{
IEnumerable<WX_LK_RegMemberFans> fans = WMFactory.WXLKRegMemberFans.FindByConditions(null, f => f.Telphone == VipTel && f.OpenId == oid && f.IsUsing == 0);
if (fans == null || fans.Count() <= 0)
{
//查询如果这个手机号没有在绑定表里面绑定,那就直接绑定.
//插入到关联表
WX_LK_RegMemberFans fan = new WX_LK_RegMemberFans();
fan.IsUsing = 0;
fan.AccountId = sid;
fan.OpenId = oid;
fan.Telphone = VipTel;
fan.CreateUser = "******";
WMFactory.WXLKRegMemberFans.Insert(fan);
return Json(ResultMsg.Success("注册成功！"));
}
else
{
WX_LK_RegMemberFans fan = fans.First();
//查询如果这个手机号在绑定表里面绑定,那就直接按照这个手机号把微信号直接修改
//插入到关联表
fan.IsUsing = 0;
fan.AccountId = sid;
fan.OpenId = oid;
fan.Telphone = VipTel;
fan.ModifyUser = "******";
WMFactory.WXLKRegMemberFans.Update(fan);
return Json(ResultMsg.Success("注册成功！"));
}
}
}
public JsonResult DRPCheckPhone(Guid sid, string oid, string VipTel, string VipSex, string VipName, string VipBirthday)
{
if (WMFactory.Wsrr.GetCustomerInfoCommonInterface("3", "DL", "", "", VipTel, "", "").Rows[0]["phone"].ToString() == "")
{
DataTable dt = WMFactory.Wsrr.AddCustomerInfoCommonInterface("1", "DL", VipName, VipTel, oid, "", VipSex, "", VipBirthday, "", "", "", "", "", "");
if (dt.Rows[0][0].ToString().ToLower() == "true")
{
//插入到关联表
WX_LK_RegMemberFans fan = new WX_LK_RegMemberFans();
fan.IsUsing = 0;
fan.AccountId = sid;
fan.OpenId = oid;
fan.Telphone = VipTel;
fan.CreateUser = "******";
bool flag = WMFactory.WXLKRegMemberFans.Insert(fan);
if (flag.ToString().ToLower() == "true")
{
DataTable dtTicketAdd = WMFactory.Wsrr.AddCustomerTicketInfoCommonInterface("DL", "1", oid, "0", "1", "绑定有礼", "26", "1", "30", "", "", "");
return Json(ResultMsg.Success("注册成功！"));
}
else
{
return Json(ResultMsg.Failure("注册失败请重试！"));
}
}
else
{
return Json(ResultMsg.Failure(dt.Rows[0][1].ToString().ToLower()));
}
}
else
{
//WxFans wx = ElegantWM.WeiXin.Common.GetFanInfo(sid.ToString(), oid);
DataTable dt = WMFactory.Wsrr.UpdateCustomerInfoCommonInterface("3", "DL", VipName, VipTel, oid, "", VipSex, "", VipBirthday, "", "", "", "", "", "");
if (dt.Rows[0][0].ToString().ToLower() == "true")
{
#region C3
bool updateflag = false;
IEnumerable<WX_LK_RegMemberFans> fans = WMFactory.WXLKRegMemberFans.FindByConditions(null, f => f.Telphone == VipTel && f.AccountId == sid && f.OpenId == oid && f.IsUsing == 0);
if (fans == null || fans.Count() <= 0)
{
//查询如果这个手机号没有在绑定表里面绑定,那就直接绑定.
//插入到关联表
WX_LK_RegMemberFans fan = new WX_LK_RegMemberFans();
fan.IsUsing = 0;
fan.AccountId = sid;
fan.OpenId = oid;
fan.Telphone = VipTel;
fan.CreateUser = "******";
updateflag = WMFactory.WXLKRegMemberFans.Insert(fan);
}
else
{
WX_LK_RegMemberFans fan = fans.First();
//查询如果这个手机号在绑定表里面绑定,那就直接按照这个手机号把微信号直接修改
//插入到关联表
if (fan.Telphone != VipTel)
{
fan.IsUsing = 0;
fan.AccountId = sid;
fan.OpenId = oid;
fan.Telphone = VipTel;
fan.ModifyUser = "******";
updateflag = WMFactory.WXLKRegMemberFans.Update(fan);
}
else
{
updateflag = true;
}
}
#endregion
if (updateflag.ToString().ToLower() == "true")
{
DataTable dtTicketAdd = WMFactory.Wsrr.AddCustomerTicketInfoCommonInterface("DL", "1", oid, "0", "1", "绑定有礼", "26", "1", "30", "", "", "");
return Json(ResultMsg.Success("绑定成功！"));
}
else
{
return Json(ResultMsg.Failure("绑定失败，请重新尝试！"));
}
}
else
{
return Json(ResultMsg.Failure("绑定失败！这个手机号已经绑定微信号！"));
}
}
}
public JsonResult UpdateCustomerInfo(Guid sid, string oid, string VipTel, string VipSex, string VipName, string VipBirthday, string VipOccupation, string province, string city, string county, string VipAdd)
{
string issqflag = "修改成功";
//WxFans wx = ElegantWM.WeiXin.Common.GetFanInfo(sid.ToString(), oid);
DataTable dt = WMFactory.Wsrr.UpdateCustomerInfoCommonInterface("1", "DL", VipName, VipTel, oid, "", VipSex, "", VipBirthday, province, city, county, VipOccupation, "", VipAdd);
if (dt.Rows[0][0].ToString().ToLower() == "true")
{
#region C3
IEnumerable<WX_LK_RegMemberFans> fans = WMFactory.WXLKRegMemberFans.FindByConditions(null, f => f.Telphone == VipTel && f.AccountId == sid && f.OpenId == oid && f.IsUsing == 0);
if (fans == null || fans.Count() <= 0)
{
//查询如果这个手机号没有在绑定表里面绑定,那就直接绑定.
//插入到关联表
WX_LK_RegMemberFans fan = new WX_LK_RegMemberFans();
fan.IsUsing = 0;
fan.AccountId = sid;
fan.OpenId = oid;
fan.Telphone = VipTel;
fan.CreateUser = "******";
WMFactory.WXLKRegMemberFans.Insert(fan);
}
else
{
WX_LK_RegMemberFans fan = fans.First();
//查询如果这个手机号在绑定表里面绑定,那就直接按照这个手机号把微信号直接修改
//插入到关联表
if (fan.ModifyUser == "修改个人信息")
{
if (fan.Telphone != VipTel)
{
fan.IsUsing = 0;
fan.AccountId = sid;
fan.OpenId = oid;
fan.Telphone = VipTel;
fan.ModifyUser = "******";
WMFactory.WXLKRegMemberFans.Update(fan);
}
}
else
{
bool songquan = false;
if (fan.Telphone != VipTel)
{
fan.IsUsing = 0;
fan.AccountId = sid;
fan.OpenId = oid;
fan.Telphone = VipTel;
fan.ModifyUser = "******";
songquan = WMFactory.WXLKRegMemberFans.Update(fan);
}
else
{
fan.ModifyUser = "******";
songquan = WMFactory.WXLKRegMemberFans.Update(fan);
}
if (songquan.ToString().ToLower() == "true")
{
DataTable dtjlchange = WMFactory.Wsrr.CustomerJFchangeCommonInterface("DL", "1", oid, "add", "1000", "完善资料送积分");
issqflag = "提交成功，可至“我的积分”查询！";
}
}
}
#endregion
return Json(ResultMsg.Success(issqflag));
}
else
{
return Json(ResultMsg.Failure("修改失败！"));
}
}
