public static string MasterpagelistByComId(string employstate, int pageindex, int pagesize, string comid, int userid, string key = "") { var totalcount = 0; var memberdata = new MemberChannelData(); MemberChannelcompanyData channel = new MemberChannelcompanyData(); try { var list = new B2bCompanyManagerUserData().Manageuserpagelist(employstate, comid, pageindex, pagesize, out totalcount, userid, key); IEnumerable result = ""; if (list != null) { result = from model in list select new { model.Id, Accounts = model.Accounts, PassWord = model.Passwords, MasterId = model.Id, MasterName = model.Employeename, CompanyName = channel.GetCompanyById(Int32.Parse(model.Channelcompanyid.ToString())) != null?channel.GetCompanyById(Int32.Parse(model.Channelcompanyid.ToString())).Companyname : "", Tel = model.Tel, GroupName = new Sys_MasterGroupData().GetGroupNameStrByMasterId(model.Id), Employstate = model.Employeestate, weixinstate = memberdata.GetChannelListByComidState(int.Parse(comid), model.Id), Peoplelistview = model.Peoplelistview, Workdays = model.Workdays, Isdefaultkf = model.Isdefaultkf, Channelid = new MemberChannelData().GetChannelid(model.Com_id, model.Tel), //渠道id rebatenum = new Member_channel_rebatelogData().Getrebatenum(model.Com_id, model.Tel), //返佣次数 rebateapplytotal = new Member_channel_rebateApplylogData().Getrebateapplytotal(model.Com_id, model.Tel), //返佣申请总额 rebatehastixian = new Member_channel_rebateApplylogData().Getrebatehastixian(model.Com_id, model.Tel), //返佣申请已提现金额 rebatenottixian = new Member_channel_rebateApplylogData().Getrebatenottixian(model.Com_id, model.Tel), //返佣申请尚未提现金额 restrebate = new MemberChannelData().Getrestrebate(model.Com_id, model.Tel), //剩余可申请返佣金额 } } ; return(JsonConvert.SerializeObject(new { type = 100, totalCount = totalcount, msg = result })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message })); throw; } }