Ejemplo n.º 1
0
        public static List <ExhibitCompany> Exhibit_Companies_Get(this Req_Exhibit_Dtl e)
        {
            var companies = DataAccess.Exhibit_Companies_Get(new DatabaseSearchModel().SetWhere($" ee_namemd = '{e.e_md}'").SetWhere(" len(ee_company) > 6").SetOrder(" ee_id ").SetPageIndex(e.pg_index).SetPageSize(e.pg_size));
            var model     = new DatabaseSearchModel().SetPageSize(e.pg_size).SetOrder(" oc_id ");

            foreach (var c in companies)
            {
                model.SetOrWhere($" oc_code='{c.oc_code}'");
            }

            var list = DataAccess.OrgCompanyList_Page_Select(model);

            foreach (var l in list)
            {
                for (int i = 0; i < companies.Count; i++)
                {
                    if (companies[i].oc_code == l.oc_code)
                    {
                        companies[i].oc_area = l.oc_area;
                        break;
                    }
                }
            }
            return(companies);
        }
Ejemplo n.º 2
0
 public static string Exhibit_Companies() => Compose(Req_Exhibit_Dtl.Default().ToJson());