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 = "获取微信关注者列表为空";
}
//}
}
}