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("修改失败!")); } }