protected void Page_Load(object sender, EventArgs e)
{
comid = Request["comid"].ConvertTo <int>(0);
md5info = Request["md5info"].ConvertTo <string>("");
string companyName = new B2bCompanyData().GetCompanyNameById(comid);
string Returnmd5 = EncryptionHelper.ToMD5(comid.ToString() + "lixh1210", "UTF-8");
if (Returnmd5 == md5info)//验证MD5
{
//ExcelRender.RenderToExcel(
// ExcelSqlHelper.ExecuteDataTable(CommandType.Text, "select idcard [会员卡号], name [姓名],phone [手机],email [邮件],imprest [预付款],Integral [积分],regidate [注册时间] from b2b_crm where com_id=" + comid),
// Context, companyName + "会员信息" + ".xls");
DataTable crmdt = ExcelSqlHelper.ExecuteDataTable(CommandType.Text, "select idcard [会员卡号], name [姓名],phone [手机],email [邮件],imprest [预付款],Integral [积分],regidate [注册时间] from b2b_crm where com_id=" + comid);
DataTable dt = new DataTable();
dt.Columns.Add("会员卡号");
dt.Columns.Add("姓名");
dt.Columns.Add("手机");
dt.Columns.Add("邮件");
dt.Columns.Add("预付款");
dt.Columns.Add("积分");
dt.Columns.Add("注册时间");
dt.Columns.Add("渠道单位");
dt.Columns.Add("推荐人");
DataRow dr = dt.NewRow();
foreach (DataRow rr in crmdt.Rows)
{
dr = dt.NewRow();
dr["会员卡号"] = rr["会员卡号"].ToString();
dr["姓名"] = rr["姓名"].ToString();
dr["手机"] = rr["手机"].ToString();
dr["邮件"] = rr["邮件"].ToString();
dr["预付款"] = rr["预付款"].ToString();
dr["积分"] = rr["积分"].ToString();
dr["注册时间"] = rr["注册时间"].ToString();
dr["渠道单位"] = new MemberChannelcompanyData().UpCompanyById(rr["会员卡号"].ToString());
dr["推荐人"] = MemberChannelData.SearchNamestring(rr["会员卡号"].ToString());
dt.Rows.Add(dr);
}
ExcelRender.RenderToExcel(dt, Context, companyName + "会员信息" + ".xls");
}
}
public static string SearchPageList(int userid, string comid, int pageindex, int pagesize, string key, string isactivate = "1", string iswxfocus = "0,1", string ishasweixin = "0,1", string ishasphone = "0,1")
{
var totalcount = 0;
try
{
var list = new List <B2b_crm>();
#region
Sys_Group group = new Sys_GroupData().GetGroupByUserId(userid);
//判断会员是否要求精确到渠道人
bool crmIsAccurateToPerson = group.CrmIsAccurateToPerson;
Member_Channel_company channelcom = new MemberChannelcompanyData().GetChannelCompanyByUserId(userid);
if (channelcom == null)//总公司账户
{
list = new B2bCrmData().SearchPageList(comid, pageindex, pagesize, key, out totalcount, isactivate, iswxfocus, ishasweixin, ishasphone);
}
else
{
string channelcompanytype = "0"; //渠道类型：0内部门店；1合作公司
if (channelcom.Issuetype == 0) //内部门市
{
list = new B2bCrmData().SearchPageList1(comid, pageindex, pagesize, key, channelcom.Id, out totalcount, isactivate, iswxfocus, ishasweixin, channelcompanytype, crmIsAccurateToPerson, userid, ishasphone);
}
else //合作公司
{
channelcompanytype = "1";
list = new B2bCrmData().SearchPageList1(comid, pageindex, pagesize, key, channelcom.Id, out totalcount, isactivate, iswxfocus, ishasweixin, channelcompanytype, crmIsAccurateToPerson, userid, ishasphone);
}
}
IEnumerable result = "";
if (list != null)
{
result = from pro in list
select new
{
id = pro.Id,
comid = pro.Com_id,
phone = pro.Phone,
registerdate = pro.Regidate,
customername = pro.Name,
imprest = pro.Imprest,
integral = pro.Integral,
idcard = pro.Idcard,
email = pro.Email,
serverid = pro.Servercard,
isfocuswinxin = pro.Weixin == "" ? "" : pro.Whetherwxfocus == false ? "已取消" : "已关注",
weixin = pro.Weixin,
channel = new MemberChannelcompanyData().UpCompanyById(pro.Idcard.ToString()),
referrer = MemberChannelData.SearchNamestring(pro.Idcard.ToString()),
WxHeadimgurl = pro.WxHeadimgurl,
WxNickname = pro.WxNickname.Replace("?", ""),
WxProvince = pro.WxProvince,
WxCity = pro.WxCity,
WxSex = pro.WxSex == 0 ? "未知" : pro.WxSex == 1 ? "男" : "女",
GroupId = pro.Groupid,
GroupName = new B2b_groupData().GetB2bgroupName(pro.Groupid),
IsCanReplyWx = IsIn48h(pro.Wxlastinteracttime),
whetherwxfocus = pro.Whetherwxfocus
}
}
;
return(JsonConvert.SerializeObject(new { type = 100, totalCount = totalcount, msg = result }));
#endregion
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message }));
throw;
}
}
