/// <summary> /// 异步加载数据 /// </summary> /// <param name="getParam"></param> /// <returns></returns> public Common.ClientResult.DataResult GetByCompanyCity(int id, string city) { //int total = 0; CompanyInsurance_EditView model = new CompanyInsurance_EditView(); model = m_BLL.GetByCompanyCity(id, city); var data = new Common.ClientResult.DataResult { total = 1, rows = model }; return(data); }
/// <summary> /// 根据企业和缴纳地获取企业社保信息 /// </summary> /// <param name="companyID">企业ID</param> /// <returns></returns> public CompanyInsurance_EditView GetByCompanyCity(SysEntities db, int companyID, string cityID) { var Company_Insurance = db.CRM_Company_Insurance.Where(c => c.CRM_Company_ID == companyID && c.City == cityID).ToList() .Select(c => new CRM_Company_Insurance_View() { InsuranceKindId = c.InsuranceKind, Account = c.Account, ID = c.ID }).ToList(); var Company_PoliceInsurance = db.CRM_Company_PoliceInsurance.Where(c => c.CRM_Company_ID == companyID && c.City == cityID).ToList() .Select(c => new CRM_Company_PoliceInsurance_View() { InsuranceKind = c.InsuranceKind, PoliceInsuranceId = c.PoliceInsurance, ID = c.ID }).ToList(); CompanyInsurance_EditView model = new CompanyInsurance_EditView(); model.CRM_Company_ID = companyID; model.CityId = cityID; model.ListCI = Company_Insurance; model.ListCPI = Company_PoliceInsurance; return(model); }