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; } }