/// <summary> /// 发送积分 /// </summary> /// <param name="mobile"></param> /// <returns></returns> public string SendPiod(string mobile, string piont) { dt_Dyn_ActCreateTel_req Actreq = new dt_Dyn_ActCreateTel_req(); // 数据源类型 Actreq.TYPE = "0002"; //处理标识 Actreq.OBJECT_ID = DateTime.Now.ToString("yyyyMMddHHmmss") + CommonHelp.GetRand(10);; //活动单据类型 Actreq.PROCESS_TYPE = "ZXY"; //外部会员卡号 "会员卡号(如已传输手机号,可不用填写会员卡号)" Actreq.ACCOUNT_ID = mobile; Actreq.POSTING_DATE = DateTime.Today.ToString(); //积分类型 Actreq.POINT_TYPE = "ZBCJF01"; //积分数 要改 Actreq.POINTS = decimal.Parse(piont); //单据全局活动ID Actreq.CAMPAIGN_HE_ID = "C-00001786"; Actreq.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 Actreq.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 Actreq.VGROUP = AppConfig.VGROUP; //销售组织 dt_Dyn_ActCreateTel_res Actres = WebApiHelp.ActCreateTel(Actreq); return(""); }
protected void Button1_Click(object sender, EventArgs e) { try { Random r = new Random(); int num = r.Next(100000, 999999); string message = string.Format("您的验证码为:" + num + "此验证码10分钟内有效,如非本人操作,请联系上海家化华美家微信后台。"); dt_SMSInsert_req req = new dt_SMSInsert_req { SMS_ITEM = new SMS_ITEM[] { new SMS_ITEM() { CONTENT = message, MESSAGEID = "0000001", MESSAGETYPE = "BC_WX_SMS", MOBILE = "13661450526", MSGFORMAT = "8", SRCNUMBER = "1069048560003" } } }; dt_SMSInsert_res res = WebApiHelp.SMSInsert(req, true); if (res != null && res.zstatus == "1") { this.TextBox1.Text = res.zstatus == "1" ? "成功" : "失败"; } } catch (Exception ex) { this.TextBox1.Text = ex.Message; } }
/// <summary> /// 发送短信 /// </summary> /// <returns></returns> public ActionResult SendMsg() { JsonSMsg msg = new JsonSMsg(); string mobile = Request["mobile"]; Random r = new Random(); int num = r.Next(100000, 999999); //string message = string.Format("本次微信平台获取的验证码是:" + num); string message = string.Format("本次微信平台获取的验证码是:" + num + "。如非本人操作,请致电400-821-6188"); dt_SMSInsert_req req = new dt_SMSInsert_req(); req.SMS_ITEM = new SMS_ITEM[] { new SMS_ITEM() { CONTENT = message, MESSAGEID = "0000001", MESSAGETYPE = "BC_WX_SMS", MOBILE = mobile, MSGFORMAT = "8", SRCNUMBER = "106900291033" } }; dt_SMSInsert_res res = WebApiHelp.OldSMSInsert(req); if (res.zstatus == "1") { msg.Data = num; msg.Status = 1; msg.Message = "发送成功"; return(Json(msg)); } msg.Data = 0; msg.Status = 0; msg.Message = "发送失败"; return(Json(msg)); }
public static int SendMessage(string message, string mobile, string TgId = null) { XYHCoupon2TGService xYHCoupon = new XYHCoupon2TGService(); dt_SMSInsert_req req = new dt_SMSInsert_req { // dt_SMSInsert_req req = new dt_SMSInsert_req(); //req.SMS_ITEM = new SMS_ITEM[] { new SMS_ITEM() { CONTENT = message, // MESSAGEID = "0000001", MESSAGETYPE = "BC_WX_SMS", // MOBILE = mobile, MSGFORMAT = "8", SRCNUMBER = "106900291033" } }; SMS_ITEM = new SMS_ITEM[] { new SMS_ITEM() { CONTENT = message, MESSAGEID = "0000001", MESSAGETYPE = "BC_WX_SMS", MOBILE = mobile, MSGFORMAT = "8", SRCNUMBER = "106900291033" // 1069048560003 -上海家化 } } }; dt_SMSInsert_res res = WebApiHelp.SMSInsert(req, true); if (res != null && res.zstatus == "1") { long ret = xYHCoupon.InsertMessageHis(new Entity.MessageHis() { Mobile = mobile, Content = message, TgId = (TgId == null ? 0 : int.Parse(TgId)), IsSend = 1, SendTime = DateTime.Now, Result = 1 }); return(1); } else { long ret = xYHCoupon.InsertMessageHis(new Entity.MessageHis() { Mobile = mobile, Content = message, TgId = (TgId == null ? 0 : int.Parse(TgId)), IsSend = 1, SendTime = DateTime.Now, Result = 0 }); return(0); } }
/// <summary> /// 激活 /// </summary> /// <param name="mobile"></param> public void ChageSatus(string mobile) { //如果是待激活状态那么就要激活 dt_Dyn_ChangeMemberStatus_req reqs = new dt_Dyn_ChangeMemberStatus_req(); reqs.DATA_SOURCE = "0002"; reqs.ZVTWEG = "102"; reqs.STATUS_OLD = "E0005"; reqs.STATUS_NEW = "E0001"; reqs.ACCOUNT_ID = mobile; reqs.FLAG = "I"; //激活 reqs.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 reqs.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 reqs.VGROUP = AppConfig.VGROUP; //销售组织 reqs.PASS_FLAG = "N"; reqs.REASON = "激活"; dt_Dyn_ChangeMemberStatus_res resok = WebApiHelp.ChangeMemberStatus(reqs); }
/// <summary> /// 显示历史记录 /// </summary> /// <param name="openid"></param> /// <returns></returns> public PointHistory GetPointHistory(string openid) { //查询会员主数据信息 CUST_MEMBER member = _repo.GetMemberByOpenId(openid); dt_Dyn_GetPointDetail_req req = new dt_Dyn_GetPointDetail_req(); req.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 req.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 req.VGROUP = AppConfig.VGROUP; //销售组织 req.DATA_SOURCE = "0002"; //得到一年之内的历史记录 req.ZSTART_DATE = DateTime.Now.AddYears(-1).ToString("yyyy-MM-dd"); req.ZEND_DATE = DateTime.Now.ToString("yyyy-MM-dd"); req.ACCOUNT_ID = member.MEMBERNO; ZCRMT402_Dyn[] lists = WebApiHelp.GetPointDetail(req).ZCRMT402; PointHistory datas = new PointHistory(); List <PointHisList> arry = new List <PointHisList>(); foreach (ZCRMT402_Dyn dyn in lists) { PointHisList his = new PointHisList() { CATEGORY = dyn.CATEGORY, CREATED_TIME = dyn.CREATED_TIME, EXPIRE_DATE = dyn.EXPIRE_DATE, ORDER_TYPE = Utility.GetDetailDis(dyn.ORDER_TYPE), POINTS = dyn.POINTS.ToString(), CREATED_TIME_EX = DateTime.Parse(dyn.CREATED_TIME), }; arry.Add(his); } datas.Hise = arry.OrderByDescending(a => a.CREATED_TIME_EX).ToList(); datas.Point = member.AVA_POINTS.ToString(); return(datas); }
/// <summary> /// 获取会员详细信息 /// </summary> /// <returns></returns> public MemberInfo GetMemberInfo(string openid, string isnew = "1") { //查询会员信息 CUST_MEMBER member = _repo.GetMemberByOpenId(openid); MemberInfo info = new MemberInfo(); string storeName = ""; if (isnew == "1") { dt_Dyn_DispMemQuick_req w2 = new dt_Dyn_DispMemQuick_req(); w2.DATA_SOURCE = "0002";//固定 w2.BP = member.PARTNER; w2.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 w2.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 w2.VGROUP = AppConfig.VGROUP; //销售组织 dt_Dyn_DispMemQuick_res dt2 = WebApiHelp.DispMemQuick(w2); storeName = dt2.I_ZCRMT316[0].DEPT_T; } info.AVA_POINTS = member.AVA_POINTS; info.MOBILE = member.MOBILE; info.SEX = member.GENDER == true ? 1 : 0; info.NAME = member.NAME; info.ADDRESS = member.ADDRESS; info.MEM_LEVEL = Utility.GetMemberLvl(member.MEM_LEVEL); info.BIRTHDAY = member.BIRTHDAY; info.STORE = member.STORE; info.PWD = member.LOGINPASSON; info.STORE_NAME = storeName; info.NAME_FIRST = member.NAME_FIRST; info.NAME_LAST = member.NAME_LAST; info.Member_Id = member.ID.ToString(); return(info); }
/// <summary> /// 得到时时的会员数据 /// </summary> /// <param name="bp"></param> /// <returns></returns> public ZCRMT302_Dyn GetMemberModelByBp(string bp) { //接口查询会员主数据 dt_Dyn_DispMember_req w = new dt_Dyn_DispMember_req(); w.DATA_SOURCE = "0002"; w.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 w.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 w.VGROUP = AppConfig.VGROUP; //销售组织 w.PARTNER = bp; //会员唯一标示 dt_Dyn_DispMember_res dt = WebApiHelp.DispMember(w); if (dt.ZCRMT316 == null || dt.ZCRMT316.Count() <= 0) { return(null); } if (dt.ZCRMT316.Count() > 1) { return(null); } return(dt.ZCRMT316[0]); }
/// <summary> /// 修改会员常规信息 /// </summary> /// <param name="name"></param> /// <param name="gender"></param> /// <param name="address"></param> /// <param name="opendID"></param> /// <returns></returns> public int UpdateMember(string NAME_LAST, string NAME_FIRST, string gender, string address, string opendID) { //查询会员主数据信息 CUST_MEMBER member = _repo.GetMemberByOpenId(opendID); dt_Dyn_UpdateMemberShip_req updates = new dt_Dyn_UpdateMemberShip_req(); ZCRMT322_Dyn z = new ZCRMT322_Dyn(); z.DATA_SOURCE = "0002"; z.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 z.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 z.VGROUP = AppConfig.VGROUP; //销售组织 z.NAME_LAST = NAME_LAST; z.NAME_FIRST = NAME_FIRST; z.NAME1_TEXT = NAME_LAST + NAME_FIRST; z.XSEX = gender == "0" ? "1" : "2"; //1女2男 z.PSTREET = address; //z.MOB_NUMBER = mobile; z.ACCOUNT_ID = member.MEMBERNO; z.PARTNER = member.PARTNER; updates.ZCRMT316 = new ZCRMT322_Dyn[] { z }; dt_Dyn_UpdateMemberShip_res ups = WebApiHelp.UpdateMemberShip(updates); if (ups.WV_RETURN == "Y") { return(1); } else { return(2); } }
public string SendMsg(string mobile) { WriteTxt("发送验证码:mobile=" + mobile); try { //得到请求参数 if (string.IsNullOrEmpty(mobile)) { response.Status = 0; response.Message = "手机号不能是空"; return(JsonHelper.ToJSON(response)); } Random r = new Random(); int num = r.Next(100000, 999999); //string message = string.Format("本次微信平台获取的验证码是:" + num); //【上海家化】您的验证码为:620384。 //此验证码10分钟内有效,如非本人操作,请联系Jahwa华美家微信后台。 string message = string.Format("您的验证码为:" + num + "此验证码10分钟内有效,如非本人操作,请联系华美家微信后台。"); dt_SMSInsert_req req = new dt_SMSInsert_req { //SMS_ITEM = new SMS_ITEM[] { new SMS_ITEM() { // CONTENT = message, // MESSAGEID = "0000001", // MESSAGETYPE = "BC_WX_SMS", // MOBILE = mobile, // MSGFORMAT = "8", // SRCNUMBER = "1069048560003" // } //} SMS_ITEM = new SMS_ITEM[] { new SMS_ITEM() { CONTENT = message, MESSAGEID = "0000001", MESSAGETYPE = "BC_WX_SMS", MOBILE = mobile, MSGFORMAT = "8", SRCNUMBER = "106900291033" // 1069048560003 -上海家化 } } }; dt_SMSInsert_res res = WebApiHelp.SMSInsert(req, true); if (res != null && res.zstatus == "1") { response.Status = 1; response.Message = "发送成功"; response.Data = num; return(JsonHelper.ToJSON(response)); } response.Status = 0; response.Message = "发送失败"; response.Data = num; return(JsonHelper.ToJSON(response)); } catch (Exception ex) { response.Status = 0; response.Message = "发送异常"; response.Data = ex.Message; return(JsonHelper.ToJSON(response)); } }
/// <summary> /// 获取优惠券 /// </summary> /// <param name="openid"></param> /// <returns></returns> public MEMBER_COUPON GetCoupon(string account_id) { MEMBER_COUPON coupon = new MEMBER_COUPON(); dt_Dyn_PosCpSearch_req reqs = new dt_Dyn_PosCpSearch_req(); reqs.ACCOUNT_ID = account_id; //会员账号和MOB_NUMBER至少输入一个 reqs.DATA_SOURCE = "0000"; //0002为 佰草集 reqs.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 reqs.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 reqs.VGROUP = AppConfig.VGROUP; //销售组织 dt_Dyn_PosCpSearch_res resok = WebApiHelp.PosCpSearch(reqs); //已使用 List <COUPONS> shiyong = new List <COUPONS>(); //未使用 List <COUPONS> meiyou = new List <COUPONS>(); //已过期 List <COUPONS> guoqi = new List <COUPONS>(); if (resok != null) { if (resok.ZTYPE != "Y") { return(null); } if (resok.ZPARTERN_CP2.Count() > 0) { foreach (ZPARTERN_CP2 item in resok.ZPARTERN_CP2) { //查询另外一个集合的数据 dt_Dyn_PosCpSearch_resITEM resout = resok.ZCPQ_RESULT.Where(a => a.ZCP_NUM == item.ZCP_NUM). ToList().FirstOrDefault(); string QrCode = resout.ZCP_PASSW + ".jpg"; GenerateCode(resout.ZCP_PASSW); //RULE = {"type":"DJQ","value":"100"} 这个就解析成100元代金券 //RULE = {"type":"ZKQ","value":"5"} 解析成 5者折扣券 string RULE = ""; if (!string.IsNullOrWhiteSpace(resout.RULE)) { CouponRule CouponRule = JsonHelper.DeserializeObject <CouponRule>(resout.RULE); if (CouponRule != null) { if (CouponRule.type == "DJQ") { RULE = CouponRule.value; } else if (CouponRule.type == "ZKQ") { RULE = CouponRule.value; } } } COUPONS one = new COUPONS() { BPEXT = item.BPEXT, ZCP_EDATE = resout.ZCP_EDATE, ZCP_EDATE_EX = resout.ZCP_EDATE, ZCP_JE = resout.ZCP_JE, ZCP_POINT = resout.ZCP_POINT, ZCP_PROD = resout.ZCP_PROD, ZCP_TYPE = item.ZCP_TYPE, ZCP_YHQDES = resout.ZCP_YHQDES, ZCP_ZK = resout.ZCP_ZK, ZCP_NUM = resout.ZCP_NUM, ZCP_YHQ = resout.ZCP_YHQ, ZCP_BDATE = resout.ZCP_BDATE, ZCP_PASSW = resout.ZCP_PASSW, IS_BOOK = 0, QrCode = AppConfig.HmjWebApi_https + "/QrCode/" + QrCode, CONTENT = resout.CONTENT, RULE = RULE, ZCP_USE_FLAG = item.ZCP_USE_FLAG }; one.ZCPUDATE = item.ZCPUDATE; //已使用 if (item.ZCP_USE_FLAG == "X") { shiyong.Add(one); } //未使用 if (string.IsNullOrEmpty(item.ZCP_USE_FLAG) || item.ZCP_USE_FLAG == "N") //item.ZCP_USE_FLAG="N" 未使用未激活 { DateTime endTime = one.ZCP_EDATE; if (endTime >= DateTime.Parse(DateTime.Now.ToShortDateString())) { //BCJ_BOOK_EX book = _book.GetBookByNo(one.ZCP_NUM); //if (book != null) //{ // if (book.STATUS == 1) // { // shiyong.Add(one); // } // else if (book.STATUS == 0) // { // one.IS_BOOK = 1; // meiyou.Add(one); // } //} //else //{ // meiyou.Add(one); //} meiyou.Add(one); } else { guoqi.Add(one); } } } } } coupon.ALREADY_USE = shiyong.OrderByDescending(a => a.ZCPUDATE).ToList(); coupon.NOT_USE = meiyou.OrderBy(a => a.ZCP_EDATE_EX).ToList(); coupon.OBSOLETE = guoqi.OrderByDescending(a => a.ZCP_EDATE_EX).ToList(); return(coupon); }
/// <summary> /// 插入门店 /// </summary> /// <returns></returns> public int InsertStore() { try { dt_GetMd_req req = new dt_GetMd_req(); TVKO[] ko = new TVKO[] { new TVKO() { VKORG = "C004" }, new TVKO() { VKORG = "C024" } }; req.ZTVKO = ko; dt_GetMd_res resStore = WebApiHelp.GetMd(req); JavaScriptSerializer js = new JavaScriptSerializer(); foreach (ZSAL_MD stroeModel in resStore.INFO_MD) { Thread.Sleep(100); //如果门店是激活状态 if (stroeModel.VTWEG != "28" && stroeModel.VTWEG != "11") { int id = _repo.CheckStore(stroeModel.ZMD_ID); if (id < 1) { TenAPI api = null; if (!string.IsNullOrEmpty(stroeModel.STRAS)) { string json = NetHelper.HttpRequest("http://apis.map.qq.com/ws/geocoder/v1/?key=MYVBZ-AO3R3-KVS3G-3OBPF-VNHE5-7VF7M&address=" + stroeModel.STRAS + "", "", "GET", 2000, Encoding.UTF8, "application/json"); if (!json.Contains("查询无结果")) { api = js.Deserialize <TenAPI>(json); if (api.status != 0) { api = null; } } } BCJ_STORES model = new BCJ_STORES() { ADDRESS = stroeModel.STRAS, CITY = stroeModel.CITY_CODE, CITY_CATE = stroeModel.ZCITY_TYPE, NAME = stroeModel.ZMD_MC, POS_CODE = stroeModel.ZMD_ID, KUNNR_SH = stroeModel.ZKUNNR_SH, TEL = stroeModel.TELF1, STORE_TYPE = stroeModel.ZMD_TYPE, LONGITUDE = api == null ? "无" : api.result.location.lng, LATITUDE = api == null ? "无" : api.result.location.lat, STATUS = string.IsNullOrEmpty(stroeModel.ZSTATUS) ? -1 : int.Parse(stroeModel.ZSTATUS) }; _repo.Insert(model); } //更新门店信息 else { BCJ_STORES model = new BCJ_STORES() { ID = id, ADDRESS = stroeModel.STRAS, CITY = stroeModel.CITY_CODE, CITY_CATE = stroeModel.ZCITY_TYPE, NAME = stroeModel.ZMD_MC, POS_CODE = stroeModel.ZMD_ID, KUNNR_SH = stroeModel.ZKUNNR_SH, TEL = stroeModel.TELF1, STATUS = string.IsNullOrEmpty(stroeModel.ZSTATUS) ? -1 : int.Parse(stroeModel.ZSTATUS) }; _repo.Update(model); } } } return(1); } catch (Exception ex) { throw; } }
/// <summary> /// 注册会员 /// </summary> /// <param name="mobile"></param> /// <param name="openid"></param> /// <param name="nameo"></param> /// <param name="namek"></param> /// <returns></returns> public string RegisterMember(string mobile, string openid, string nameo, string namek, string brithday, string nickname, string gender) { WXCUST_FANS fans = _repo.GetFans(openid); //没有该粉丝 if (fans == null) { return("-1"); } #region 调用接口通知crm创建会员 dt_Dyn_UploadMemberShip_req req = new dt_Dyn_UploadMemberShip_req(); ZCRMT316_Dyn meber = new ZCRMT316_Dyn(); meber.MOB_NUMBER = mobile; meber.OPENID = openid; meber.NAME1_TEXT = nameo + namek;//全名 meber.DATA_SOURCE = "0002"; meber.ACCOUNT_ID = mobile; meber.NAME_LAST = nameo; meber.NAME_FIRST = namek; meber.XSEX = gender == "1" ? "2" : "1"; meber.REGION = ""; meber.BIRTHDT = brithday; meber.NAMCOUNTRY = "CN"; meber.WECHATNAME = nickname; meber.WECHATFOLLOWSTATUS = "1"; //meber.LOGINPASS2 = "111111";//兑换密码默认123456 meber.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 meber.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 meber.VGROUP = AppConfig.VGROUP; //销售组织 //固定死 meber.EMPID = AppConfig.EMPID; meber.DEPTID = AppConfig.DEPTID; req.ZCRMT316 = new ZCRMT316_Dyn[] { meber }; //创建会员 dt_Dyn_UploadMemberShip_res res = WebApiHelp.CreateMemberShip(req); #endregion if (res.WV_RETURN == "N") { return(res.WV_MESSAGE); } //创建成功 if (res.WV_RETURN == "Y") { //创建本地会员 CUST_MEMBER member = new CUST_MEMBER() { BIRTHDAY = DateTime.Parse(brithday), FANS_ID = fans.ID, MEMBERNO = res.ACCOUNT_ID, MOBILE = mobile, NAME = nameo + namek, STATUS = 1, STORE = AppConfig.DEPTID, TYPE = 0, //LOGINPASSON = "111111", CREATE_DATE = DateTime.Now, AVA_POINTS = 0, PARTNER = res.PARTNER, GENDER = false //REMARK = remak }; double counts = _repo.Insert(member); if (counts <= 0) { return($"请关掉页面并用手机号:{mobile},绑定!"); } else { #region 注册送积分 //如果注册会员成功送积分 //si_Dyn_ActCreateTel_obService == si_ActCreateTel_obService dt_Dyn_ActCreateTel_req Actreq = new dt_Dyn_ActCreateTel_req { // 数据源类型 TYPE = "0002", //处理标识 OBJECT_ID = DateTime.Now.ToString("yyyyMMddHHmmss") + CommonHelp.GetRand(10), //活动单据类型 PROCESS_TYPE = "ZXY", //外部会员卡号 "会员卡号(如已传输手机号,可不用填写会员卡号)" ACCOUNT_ID = res.ACCOUNT_ID, POSTING_DATE = DateTime.Today.ToString(), //积分类型 POINT_TYPE = "ZBCJF01", //积分数 要改 POINTS = decimal.Parse(AppConfig.POINTS), //单据全局活动ID CAMPAIGN_HE_ID = "C-00001786", LOYALTY_BRAND = AppConfig.LOYALTY_BRAND, //忠诚度品牌 SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM, //来源系统 VGROUP = AppConfig.VGROUP //销售组织 }; dt_Dyn_ActCreateTel_res Actres = WebApiHelp.ActCreateTel(Actreq); //if (Actres.I_ZCRMT047_dyn[0].CHECK_FLAG == "N") //{ // remak = "新注册会员送积分失败,原因:" + Actres.I_ZCRMT047_dyn[0].MESSAGE; //} #endregion #region 注册成功就要激活会员 ////如果是待激活状态那么就要激活 //dt_Dyn_ChangeMemberStatus_req reqs = new dt_Dyn_ChangeMemberStatus_req(); //reqs.DATA_SOURCE = "0002"; //reqs.ZVTWEG = "102"; ////req.STATUS_OLD = "E0000"; ////req.STATUS_NEW = "E0001"; //reqs.ACCOUNT_ID = meber.ACCOUNT_ID; //reqs.FLAG = "I";//激活 //reqs.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND;//忠诚度品牌 //reqs.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM;//来源系统 //reqs.VGROUP = AppConfig.VGROUP; //销售组织 //reqs.PASS_FLAG = "N"; //reqs.REASON = "激活"; //dt_Dyn_ChangeMemberStatus_res resok = WebApiHelp.ChangeMemberStatus(reqs); #endregion } } return("1"); }
/// <summary> /// 获取优惠券 /// </summary> /// <param name="openid"></param> /// <returns></returns> public MEMBER_COUPON GetCoupon(string openid) { MEMBER_COUPON coupon = new MEMBER_COUPON(); //查询会员主数据信息 CUST_MEMBER member = _repo.GetMemberByOpenId(openid); dt_Dyn_PosCpSearch_req reqs = new dt_Dyn_PosCpSearch_req(); reqs.ACCOUNT_ID = member.MEMBERNO;//会员账号和MOB_NUMBER至少输入一个 reqs.DATA_SOURCE = "0002"; reqs.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 reqs.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 reqs.VGROUP = AppConfig.VGROUP; //销售组织 dt_Dyn_PosCpSearch_res resok = WebApiHelp.PosCpSearch(reqs); if (resok.ZTYPE != "Y") { return(null); } //已使用 List <COUPONS> shiyong = new List <COUPONS>(); //未使用 List <COUPONS> meiyou = new List <COUPONS>(); //已过期 List <COUPONS> guoqi = new List <COUPONS>(); if (resok.ZPARTERN_CP2.Count() > 0) { foreach (ZPARTERN_CP2 item in resok.ZPARTERN_CP2) { //查询另外一个集合的数据 dt_Dyn_PosCpSearch_resITEM resout = resok.ZCPQ_RESULT.Where(a => a.ZCP_NUM == item.ZCP_NUM). ToList().FirstOrDefault(); COUPONS one = new COUPONS() { BPEXT = item.BPEXT, ZCP_EDATE = resout.ZCP_EDATE, ZCP_EDATE_EX = resout.ZCP_EDATE, ZCP_JE = resout.ZCP_JE, ZCP_POINT = resout.ZCP_POINT, ZCP_PROD = resout.ZCP_PROD, ZCP_TYPE = item.ZCP_TYPE, ZCP_YHQDES = resout.ZCP_YHQDES, ZCP_ZK = resout.ZCP_ZK, ZCP_NUM = resout.ZCP_NUM, ZCP_YHQ = resout.ZCP_YHQ, ZCP_BDATE = resout.ZCP_BDATE, ZCP_PASSW = resout.ZCP_PASSW, IS_BOOK = 0 }; one.ZCPUDATE = item.ZCPUDATE; //已使用 if (item.ZCP_USE_FLAG == "X") { shiyong.Add(one); } //未使用 if (string.IsNullOrEmpty(item.ZCP_USE_FLAG)) { DateTime endTime = one.ZCP_EDATE; if (endTime > DateTime.Now) { HMJ_BOOK_EX book = _book.GetBookByNo(one.ZCP_NUM); if (book != null) { if (book.STATUS == 1) { shiyong.Add(one); } else if (book.STATUS == 0) { one.IS_BOOK = 1; meiyou.Add(one); } } else { meiyou.Add(one); } } else { guoqi.Add(one); } } } } coupon.ALREADY_USE = shiyong.OrderByDescending(a => a.ZCPUDATE).ToList(); coupon.NOT_USE = meiyou.OrderBy(a => a.ZCP_EDATE_EX).ToList(); coupon.OBSOLETE = guoqi.OrderByDescending(a => a.ZCP_EDATE_EX).ToList(); return(coupon); }
/// <summary> /// 修改会员手机或兑礼密码, /// </summary> /// <param name="mobile">新手机号</param> /// <param name="oldmobile">旧的手机号</param> /// <param name="pwd">新密码</param> /// <param name="oldpwd">旧密码</param> /// <returns></returns> public int UpdateMobileOrPwd(string mobile, string oldmobile, string pwd, string oldpwd, string OpendID, ref string msg) { //查询会员主数据信息 CUST_MEMBER member = _repo.GetMemberByOpenId(OpendID); //修改手机号 if (!string.IsNullOrEmpty(mobile) && !string.IsNullOrEmpty(oldmobile)) { //修改手机号 dt_Dyn_UpdateMemberShip_req updates = new dt_Dyn_UpdateMemberShip_req(); ZCRMT322_Dyn z = new ZCRMT322_Dyn { DATA_SOURCE = AppConfig.DATA_SOURCE, LOYALTY_BRAND = AppConfig.LOYALTY_BRAND, //忠诚度品牌 SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM, //来源系统 VGROUP = AppConfig.VGROUP, //销售组织 MOB_NUMBER = mobile, ACCOUNT_ID = member.MEMBERNO, PARTNER = member.PARTNER }; updates.ZCRMT316 = new ZCRMT322_Dyn[] { z }; dt_Dyn_UpdateMemberShip_res ups = WebApiHelp.UpdateMemberShip(updates); if (ups.WV_RETURN == "Y") { return(1); } else { msg = ups.WV_MESSAGE; return(2); } } //修改密码 if (!string.IsNullOrEmpty(pwd) && !string.IsNullOrEmpty(oldpwd)) { dt_Dyn_ChangePassword_req piq = new dt_Dyn_ChangePassword_req { DATA_SOURCE = AppConfig.DATA_SOURCE, //SOURCE ZVTWEG = "102", ACCOUNT_ID = member.MEMBERNO, //EXTERNAL_CARD_NU EXCHANGEPASS = oldpwd, EXCHANGEPASS2 = pwd, PASS_TYPE = "2", REASON = "兑礼密码修改", INIT_FLAG = "", LOYALTY_BRAND = AppConfig.LOYALTY_BRAND, //忠诚度品牌 SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM, //来源系统 VGROUP = AppConfig.VGROUP //销售组织 }; //修改CRM端密码 dt_Dyn_ChangePassword_res res = WebApiHelp.ChangePassword(piq); if (res.ZRETURN == "Y") { //修改本地密码 CUST_MEMBER mebers = new CUST_MEMBER() { ID = member.ID, LOGINPASSON = pwd }; //更新本地会员信息 int count = _repo.UpdateMember(mebers); return(1); } else { return(2); } } return(0); }
/// <summary> /// 绑定会员 /// </summary> /// <param name="mobile"></param> /// <returns></returns> public string BindMember(string mobile, string openid, string Nickname) { using (TransScope scope = new TransScope()) { WXCUST_FANS fans = _repo.GetFans(openid); if (fans == null) { return("3"); } CUST_MEMBER member = _repo.GetMemberByMobile(mobile, fans.ID); if (member != null) { return("2"); } #region 记录会员 dt_Dyn_DispMember_req w = new dt_Dyn_DispMember_req(); w.DATA_SOURCE = "0002"; w.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 w.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 w.VGROUP = AppConfig.VGROUP; //销售组织 w.MOB_NUMBER = mobile; //2002652891 dt_Dyn_DispMember_res dt = WebApiHelp.DispMember(w); if (dt.ZCRMT316 == null || dt.ZCRMT316.Count() <= 0) { return("4"); } if (dt.ZCRMT316.Count() > 1) { return("5"); } ZCRMT302_Dyn meber = dt.ZCRMT316[0]; CUST_MEMBER mebers = new CUST_MEMBER() { ADDRESS = meber.PSTREET, AVA_POINTS = (int?)meber.ZCCUR_POINT, BIRTHDAY = string.IsNullOrEmpty(meber.BIRTHDT) ? null : (DateTime?)DateTime.Parse(meber.BIRTHDT), CITY = "", COUNTRY = "", CREATE_DATE = DateTime.Now, CREATE_USER = "******", EMAIL = meber.CSMTP_ADDR, FANS_ID = fans.ID, GENDER = meber.XSEX == "2" ? true : false, MEMBERNO = meber.ACCOUNT_ID, MEM_LEVEL = meber.ZTIER, MOBILE = mobile, STATUS = 1, STORE = meber.ZH003, NAME = meber.NAME1_TEXT, PARTNER = meber.PARTNER, TYPE = meber.DATA_SOURCE == "0001" ? 0 : 1 }; double counts = _repo.Insert(mebers); #endregion //如果绑定成功需要告诉crm已经绑定 if (counts > 0) { //绑定接口 dt_Dyn_UpdateMemberShip_req updates = new dt_Dyn_UpdateMemberShip_req(); ZCRMT322_Dyn z = new ZCRMT322_Dyn(); z.DATA_SOURCE = "0002"; z.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 z.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 z.VGROUP = AppConfig.VGROUP; //销售组织 z.WECHATNAME = Nickname; z.WECHATFOLLOWSTATUS = "1"; z.OPENID = openid; z.ACCOUNT_ID = dt.ZCRMT316[0].ACCOUNT_ID; z.PARTNER = dt.ZCRMT316[0].PARTNER; updates.ZCRMT316 = new ZCRMT322_Dyn[] { z }; dt_Dyn_UpdateMemberShip_res ups = WebApiHelp.UpdateMemberShip(updates); //如果是待激活状态那么就要激活 if (meber.ZZAFLD000004 == "E0005") { //激活 this.ChageSatus(meber.ACCOUNT_ID); } //绑定成功送三百积分 if (fans.IS_REGISTER == null || fans.IS_REGISTER == 0) { #region 注册送积分 //如果注册会员成功送积分 //si_Dyn_ActCreateTel_obService == si_ActCreateTel_obService dt_Dyn_ActCreateTel_req Actreq = new dt_Dyn_ActCreateTel_req(); // 数据源类型 Actreq.TYPE = "0002"; //处理标识 Actreq.OBJECT_ID = DateTime.Now.ToString("yyyyMMddHHmmss") + CommonHelp.GetRand(10); //活动单据类型 Actreq.PROCESS_TYPE = "ZXY"; //外部会员卡号 "会员卡号(如已传输手机号,可不用填写会员卡号)" Actreq.ACCOUNT_ID = meber.ACCOUNT_ID; Actreq.POSTING_DATE = DateTime.Today.ToString(); //积分类型 Actreq.POINT_TYPE = "ZBCJF01"; //积分数 要改 Actreq.POINTS = decimal.Parse(AppConfig.POINTS); //单据全局活动ID Actreq.CAMPAIGN_HE_ID = "CMP2820171023005"; Actreq.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 Actreq.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 Actreq.VGROUP = AppConfig.VGROUP; //销售组织 dt_Dyn_ActCreateTel_res Actres = WebApiHelp.ActCreateTel(Actreq); string remak = string.Empty; if (Actres.I_ZCRMT047_dyn[0].CHECK_FLAG == "N") { remak = "新注册会员送积分失败,原因:" + Actres.I_ZCRMT047_dyn[0].MESSAGE; } #endregion string str = _repo.UpdateIsRegion(fans.ID); } } scope.Commit(); return("1"); } }
public string IsMember(string mobile, string openid) { //会员快速查询 //先查找华美家会员 try { //判断是否已经参加过 WXCouponGiveInfo wxcardmodel = _xyhService.GetWXCouponGiveInfoByMobile(mobile, AppConfig.CardId, ActivityName); if (wxcardmodel != null) { if (wxcardmodel.GetCoupon == 1) { response.Status = 2; response.Message = "已经参加过活动"; return(JsonHelper.ToJSON(response)); } else { response.Status = 0; response.Message = "不满足条件"; return(JsonHelper.ToJSON(response)); } } dt_Dyn_DispMemQuick_req w = new dt_Dyn_DispMemQuick_req { DATA_SOURCE = "0000", LOYALTY_BRAND = "HM", //忠诚度品牌 SOURCE_SYSTEM = "0016", //来源系统 VGROUP = "C001", //销售组织 ACCOUNT_ID = mobile //2002652891 }; dt_Dyn_DispMemQuick_res dt = WebApiHelp.DispMemQuick(w); if (dt.I_ZCRMT316 == null || dt.I_ZCRMT316.Length <= 0) { //查找佰草集会员 dt_Dyn_DispMemQuick_req wbcj = new dt_Dyn_DispMemQuick_req { DATA_SOURCE = "0002", LOYALTY_BRAND = "28", //忠诚度品牌 SOURCE_SYSTEM = "0003", //来源系统 VGROUP = "C004", //销售组织 ACCOUNT_ID = mobile }; dt_Dyn_DispMemQuick_res dtbcj = WebApiHelp.DispMemQuick(w); if (dtbcj.I_ZCRMT316 == null || dtbcj.I_ZCRMT316.Length <= 0) { long ret = _xyhService.AddWXCouponGiveInfo(new WXCouponGiveInfo() { Openid = openid, Mobile = mobile, GetCoupon = 1, Status = 0, ActivityName = ActivityName, CardId = AppConfig.CardId, CreateDate = DateTime.Now }); CreateCrmCust(mobile, openid); response.Status = 1; response.Message = "不存在会员"; response.Data = ret; return(JsonHelper.ToJSON(response)); } else { long ret = _xyhService.AddWXCouponGiveInfo(new WXCouponGiveInfo() { Openid = openid, Mobile = mobile, GetCoupon = 0, Status = 0, ActivityName = ActivityName, CardId = "", CreateDate = DateTime.Now }); response.Status = 0; response.Message = "存在会员"; return(JsonHelper.ToJSON(response)); } } else { //存在会员 long ret = _xyhService.AddWXCouponGiveInfo(new WXCouponGiveInfo() { Openid = openid, Mobile = mobile, GetCoupon = 0, Status = 0, ActivityName = ActivityName, CardId = "", CreateDate = DateTime.Now }); response.Status = 0; response.Message = "存在会员"; return(JsonHelper.ToJSON(response)); } } catch (Exception ex) { WriteTxt("验证手机是否是新客:手机号=" + mobile + ",异常:" + ex.Message); response.Status = 0;// -1; response.Message = "系统错误"; return(JsonHelper.ToJSON(response)); } }
/// <summary> /// 减少或者增加积分 /// </summary> /// <param name="mobile"></param> /// <returns></returns> public string ReduceOrAddPiod(string mobile, string piont, string type) { string pont_type = "ZXY"; if (type == "reduce") { pont_type = "PRODUCT_REDEEM"; } if (type == "add") { pont_type = "ZXY"; } dt_Dyn_ActCreateTel_req Actreq = new dt_Dyn_ActCreateTel_req(); // 数据源类型 Actreq.TYPE = "0002"; //处理标识 Actreq.OBJECT_ID = DateTime.Now.ToString("yyyyMMddHHmmss") + CommonHelp.GetRand(10);; //活动单据类型 Actreq.PROCESS_TYPE = pont_type; //外部会员卡号 "会员卡号(如已传输手机号,可不用填写会员卡号)" Actreq.ACCOUNT_ID = mobile; Actreq.POSTING_DATE = DateTime.Today.ToString(); //积分类型 Actreq.POINT_TYPE = "ZBCJF01"; //积分数 要改 Actreq.POINTS = decimal.Parse(piont); //单据全局活动ID Actreq.CAMPAIGN_HE_ID = "C-00001786"; Actreq.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 Actreq.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 Actreq.VGROUP = AppConfig.VGROUP; //销售组织 dt_Dyn_ActCreateTel_res Actres = WebApiHelp.ActCreateTel(Actreq); #region 查询会员详情 dt_Dyn_DispMember_req w = new dt_Dyn_DispMember_req(); w.DATA_SOURCE = "0002"; w.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 w.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 w.VGROUP = AppConfig.VGROUP; //销售组织 w.MOB_NUMBER = mobile; //2002652891 dt_Dyn_DispMember_res dt = WebApiHelp.DispMember(w); if (dt.ZCRMT316 == null || dt.ZCRMT316.Count() <= 0) { return("未查询到该会员"); } if (dt.ZCRMT316.Count() > 1) { return("查到多条该信息,请联系开发"); } #endregion ZCRMT302_Dyn meber = dt.ZCRMT316[0]; return(meber.PARTNER); }
public void CreateCrmCust(string mobile, string openid) { ThreadPool.QueueUserWorkItem(a => { bool isSuccess = false; string msg = "失败"; try { //通知crm创建 dt_Dyn_CreateLead_req crreq = new dt_Dyn_CreateLead_req(); ZCRMT342_Dyn meber = new ZCRMT342_Dyn(); meber.WECHATFOLLOWSTATUS = "1"; meber.MOB_NUMBER = mobile; meber.WECHAT = openid; //meber.EMPID = "HMWX001"; //meber.DEPTID = AppConfig.DEPTID;//入会门店 meber.NAME1_TEXT = AppConfig.CUST_NAME; // "佰草集潜客";//全名 meber.DATA_SOURCE = AppConfig.DATA_SOURCE; // "0002";//数据来源 meber.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; // "28";//忠诚度品牌 meber.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; // "0003";//来源系统 meber.VGROUP = AppConfig.VGROUP; // "C004"; //销售组织 meber.CAMPAIGN_ID1 = AppConfig.CAMPAIGN_ID; crreq.INFO_QK = new ZCRMT342_Dyn[] { meber }; dt_Dyn_CreateLead_res qianke = WebApiHelp.CreateLead(crreq); if (qianke.WV_RETURN == "Y") { isSuccess = true; msg = "成功"; } else { msg = "失败:" + qianke.WV_MESSAGE; } } catch (Exception ex) { msg = "异常:" + ex.Message; } finally { WXCRMCustLog WXCRMCustLog = new WXCRMCustLog(); WXCRMCustLog.OpenId = openid; WXCRMCustLog.Mobile = mobile; WXCRMCustLog.NAME1_TEXT = AppConfig.CUST_NAME; WXCRMCustLog.DATA_SOURCE = AppConfig.DATA_SOURCE; WXCRMCustLog.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; WXCRMCustLog.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; WXCRMCustLog.VGROUP = AppConfig.VGROUP; WXCRMCustLog.Result = isSuccess ? 1 : 0; WXCRMCustLog.ActivityName = ActivityName; WXCRMCustLog.CreateDate = DateTime.Now; if (msg.Length > 2000) { WXCRMCustLog.Remark = msg.Substring(0, 2000); } else { WXCRMCustLog.Remark = msg; } _xyhService.InsertWXCRMCustLog(WXCRMCustLog); } }); }
/// <summary> /// 获取并更新会员信息 /// </summary> /// <param name="openid"></param> /// <returns></returns> public MemberInfo GetLoadMember(string openid) { //查询会员主数据信息 CUST_MEMBER member = _repo.GetMemberByOpenId(openid); #region 得到最新会员信息 //接口查询会员主数据 dt_Dyn_DispMember_req w = new dt_Dyn_DispMember_req(); w.DATA_SOURCE = "0002"; w.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 w.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 w.VGROUP = AppConfig.VGROUP; //销售组织 w.PARTNER = member.PARTNER; //会员唯一标示 dt_Dyn_DispMember_res dt = WebApiHelp.DispMember(w); if (dt.ZCRMT316 == null || dt.ZCRMT316.Count() <= 0) { return(null); } if (dt.ZCRMT316.Count() > 1) { return(null); } ZCRMT302_Dyn newmeber = dt.ZCRMT316[0]; #region 接口查询兑礼密码 dt_Dyn_ChangeMemberStatus_req req = new dt_Dyn_ChangeMemberStatus_req(); req.DATA_SOURCE = AppConfig.DATA_SOURCE; req.ZVTWEG = "102"; //来源渠道 req.ACCOUNT_ID = newmeber.ACCOUNT_ID; req.FLAG = "Q"; //查询 req.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 req.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 req.VGROUP = AppConfig.VGROUP; //销售组织 req.PASS_FLAG = "Y"; req.REASON = "查询密码"; dt_Dyn_ChangeMemberStatus_res res = WebApiHelp.ChangeMemberStatus(req); #endregion CUST_MEMBER mebers = new CUST_MEMBER() { ID = member.ID, ADDRESS = newmeber.PSTREET, AVA_POINTS = (int?)newmeber.ZCCUR_POINT, BIRTHDAY = string.IsNullOrEmpty(newmeber.BIRTHDT) ? null : (DateTime?)DateTime.Parse(newmeber.BIRTHDT), GENDER = newmeber.XSEX == "2" ? true : false, MEMBERNO = newmeber.ACCOUNT_ID, MOBILE = newmeber.MOB_NUMBER, MEM_LEVEL = newmeber.ZTIER, NAME = newmeber.NAME1_TEXT, PARTNER = newmeber.PARTNER, STORE = newmeber.ZH003, LOGINPASSON = res.ZPASS, NAME_FIRST = newmeber.NAME_FIRST, NAME_LAST = newmeber.NAME_LAST, ZZAFLD000004 = newmeber.ZZAFLD000004 }; #endregion dt_Dyn_PosCpSearch_req reqs = new dt_Dyn_PosCpSearch_req(); reqs.ACCOUNT_ID = member.MEMBERNO;//会员账号和MOB_NUMBER至少输入一个 reqs.DATA_SOURCE = AppConfig.DATA_SOURCE; reqs.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌 reqs.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统 reqs.VGROUP = AppConfig.VGROUP; //销售组织 dt_Dyn_PosCpSearch_res resok = WebApiHelp.PosCpSearch(reqs); int allcount = 0; foreach (ZPARTERN_CP2 item in resok.ZPARTERN_CP2) { //未使用 if (string.IsNullOrEmpty(item.ZCP_USE_FLAG)) { //查询另外一个集合的数据 dt_Dyn_PosCpSearch_resITEM resout = resok.ZCPQ_RESULT.Where(a => a.ZCP_NUM == item.ZCP_NUM). ToList().FirstOrDefault(); DateTime endTime = resout.ZCP_EDATE;// DateTime.Parse(resout.ZCP_EDATE); if (endTime >= DateTime.Now) { allcount++; } } } //更新本地会员信息 int count = _repo.UpdateMember(mebers); return(new MemberInfo() { AVA_POINTS = (int?)newmeber.ZCCUR_POINT, MOBILE = newmeber.MOB_NUMBER, SEX = newmeber.XSEX == "2" ? 1 : 0, COUPON_COUNT = allcount.ToString(), MEM_LEVEL = Utility.GetMemberLvl(newmeber.ZTIER) }); }