public int isrenzheng = 1;//1已认证;0未认证 protected void Page_Load(object sender, EventArgs e) { int userid = UserHelper.CurrentUserId(); IsParentCompanyUser = new B2bCompanyManagerUserData().IsParentCompanyUser(userid); ObtainGzListSplit lastSplit = new ObtainGzListSplitData().LastSplitNoByComid(comid);//最后一次拆分记录 if (lastSplit != null) { BindGrid2(comid, lastSplit.Splitno, lastSplit.Obtainno); } if (UserHelper.ValidateLogin()) { int comidd = UserHelper.CurrentCompany.ID; WeiXinBasic wxbasic = new WeiXinBasicData().GetWxBasicByComId(comidd); if (wxbasic != null) { if (wxbasic.Weixintype == 4) { isrenzheng = 1; } else { isrenzheng = 0; } } else { isrenzheng = 0; } } else { Response.Redirect("/Manage/index1.html"); } }
protected void Button3_Click(object sender, EventArgs e) { initJavascript(); string id = ((Button)sender).CommandArgument.ToString(); //Response.Write("<script>alert('" + id + "')</script>"); //根据id得到拆分的的记录 ObtainGzListSplit model = new ObtainGzListSplitData().GetObtainGzListSplit(int.Parse(id)); if (model != null) { //根据公司得到会员录入的次数 int MaxImportNum = new ExcelImportLogData().GetMaxImportNum(comid); int rowAffected = 0; //录入正确的条数 int rowerr = 0; //录入错误的条数 string dd = ""; //页面提示内容 string[] str = model.Splitopenid.Split(','); for (int i = 0; i < str.Length; i++) { if (str[i] != "") { int whetherwxfocus = 0; //微信关注状态标注为1(未关注) int whetheractivate = 0; //用户激活状态标注为0(未激活) string name = ""; //姓名 string phone = ""; //手机号 string email = ""; //email string weixin = str[i]; //微信号 if (weixin != "") { whetherwxfocus = 1; whetheractivate = 1; } int importstate = 1; //录入状态默认1:成功;0:出错 string ErrReason = ""; //录入错误原因 bool ishascrmphone = false; bool ishascrmweixin = false; //if (phone != "") //{ // ishascrmphone = new B2bCrmData().IsHasCrmPhone(comid, phone);//判断当前公司会员是否已经绑定当前手机 // if (ishascrmphone == true) // { // ErrReason = "当前公司已有会员绑定过手机" + phone; // } //} if (weixin != "") { ishascrmweixin = new B2bCrmData().IsHasCrmWeiXin(comid, weixin);//判断当前公司会员是否已经绑定当前微信 if (ishascrmweixin == true) { ErrReason = "当前公司已有会员绑定过微信" + weixin; } } if (ishascrmphone == false && ishascrmweixin == false) { if (phone == "" && weixin == "") { ErrReason = "导入会员的手机,微信必须至少有其中一项"; //会员通过excel录入日志 importstate = 0; int importnum = MaxImportNum + 1; string importtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); int insertlog = new ExcelImportLogData().InsExcelImportLog(importstate, 0, comid, "0", name, phone, weixin, whetherwxfocus, whetheractivate, importtime, importnum, email, ErrReason); rowerr++; } else { //创建卡号并插入活动 string cardcode = MemberCardData.CreateECard(2, comid); //插入会员表 decimal imprest = 0; //预付款 decimal integral = 0; //积分 string agegroup = ""; //年龄段 string crmlevel = "A"; //会员级别,默认网站注册 string country = ""; string province = ""; string city = ""; string address = ""; //插入会员表 int insb2bcrm = new B2bCrmData().ExcelInsB2bCrm(comid, cardcode, name, phone, weixin, whetherwxfocus, whetheractivate, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), email, imprest, integral, country, province, city, address, agegroup, crmlevel); //插入关注赠送优惠券 int jifen_temp = 0; var InputMoney = MemberCardData.AutoInputMoeny(insb2bcrm, 4, comid, out jifen_temp); //会员通过excel录入日志 int importnum = MaxImportNum + 1; string importtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); int insertlog = new ExcelImportLogData().InsExcelImportLog(importstate, insb2bcrm, comid, cardcode, name, phone, weixin, whetherwxfocus, whetheractivate, importtime, importnum, email, ErrReason); rowAffected++; } } else { //会员通过excel录入日志 importstate = 0; int importnum = MaxImportNum + 1; string importtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); int insertlog = new ExcelImportLogData().InsExcelImportLog(importstate, 0, comid, "0", name, phone, weixin, whetherwxfocus, whetheractivate, importtime, importnum, email, ErrReason); rowerr++; } } } UnloadJavascript(); dd += "成功导入数据共:" + rowAffected.ToString() + "条;"; if (rowerr > 0) { dd += "重复数据共:" + rowerr.ToString() + "条;"; } Response.Write("<script>alert('" + dd + "');</script>"); } else { UnloadJavascript(); Response.Write("<script>alert('拆分记录为空');</script>"); } }
protected void Button2_Click(object sender, EventArgs e) { initJavascript(); //获得以前总共抓取关注者列表的次数 int MaxOtainNo = new ObtainGzListLogData().GetMaxObtainNo(comid); if (MaxOtainNo == 0) { Literal2.Text = "还未获取过微信关注者列表"; } else { ////验证一下是否拆分过,拆分过不在拆分 //bool issplited = false; //if (issplited == true) //{ // Literal2.Text = "关注者列表已经拆分过无需再分"; // return; //} //else //{ //获得以前总共拆分过关注者列表的次数 int MaxSplitNo = new ObtainGzListSplitData().MaxSplitNo(comid, MaxOtainNo); IList <ObtainGzListLog> loglist = new ObtainGzListLogData().GetObtaingzlistlog(comid, MaxOtainNo); if (loglist != null) { string openidstr = ""; foreach (ObtainGzListLog log in loglist) { openidstr += log.Openid + ","; } openidstr = openidstr.Substring(0, openidstr.Length - 1); string[] str = openidstr.Split(','); //每20000个一组,判断可以拆分为几组 int splitnum = int.Parse(Math.Ceiling((double)(str.Length) / (double)20000).ToString()); if (splitnum == 1) { ObtainGzListSplit splitmodel = new ObtainGzListSplit { Id = 0, Comid = comid, Dealerid = dealuserid, Total = str.Length, Splitcount = str.Length, Splitno = MaxSplitNo + 1, Obtainno = MaxOtainNo, Splittime = DateTime.Now, Splitopenid = openidstr, Issuc = 1 }; new ObtainGzListSplitData().InsertsObtainGzListSplit(splitmodel); } else { //获取拆分的openid字符串 for (int i = 1; i <= splitnum; i++) { if (i == splitnum) { //录入最后不满20000的openid字符串 string splitopenid = ""; for (int j = 20000 * (splitnum - 1); j < str.Length; j++) { splitopenid += str[j] + ","; } splitopenid = splitopenid.Substring(0, splitopenid.Length - 1); ObtainGzListSplit splitmodel = new ObtainGzListSplit { Id = 0, Comid = comid, Dealerid = dealuserid, Total = str.Length, Splitcount = (str.Length) % 20000, Splitno = MaxSplitNo + 1, Obtainno = MaxOtainNo, Splittime = DateTime.Now, Splitopenid = splitopenid, Issuc = 1 }; new ObtainGzListSplitData().InsertsObtainGzListSplit(splitmodel); } else { string splitopenid = ""; for (int j = 20000 * (i - 1); j < 20000 * i; j++) { splitopenid += str[j] + ","; } splitopenid = splitopenid.Substring(0, splitopenid.Length - 1); ObtainGzListSplit splitmodel = new ObtainGzListSplit { Id = 0, Comid = comid, Dealerid = dealuserid, Total = str.Length, Splitcount = 20000, Splitno = MaxSplitNo + 1, Obtainno = MaxOtainNo, Splittime = DateTime.Now, Splitopenid = splitopenid, Issuc = 1 }; new ObtainGzListSplitData().InsertsObtainGzListSplit(splitmodel); } } } UnloadJavascript(); Literal2.Text = "微信关注者总数目:" + str.Length; BindGrid2(comid, MaxSplitNo + 1, MaxOtainNo); } else { UnloadJavascript(); Literal2.Text = "获取微信关注者列表为空"; } //} } }