public List <V_RETURNFBI> GenerateCompanyRecord(string companyID, string year, string month) { List <V_RETURNFBI> lvr = new List <V_RETURNFBI>(); DepartmentBLL bll = new DepartmentBLL(); List <T_HR_DEPARTMENT> emplist = bll.GetDepartmentByCompanyId(companyID); var ents = from a in dal.GetObjects <T_HR_COMPANY>() where a.COMPANYID == companyID select a; foreach (var emp in emplist) { V_RETURNFBI vr = new V_RETURNFBI(); T_HR_DEPARTMENT dep = new T_HR_DEPARTMENT(); dep = bll.GetDepartmentById(emp.DEPARTMENTID); vr.COMPANYID = companyID; vr.COMPANYNAME = ents.FirstOrDefault().CNAME; vr.DEPARTMENTID = emp.DEPARTMENTID; vr.DEPARTMENTNAME = dep.T_HR_DEPARTMENTDICTIONARY.DEPARTMENTNAME; vr.SALARYSUM = GenerateDepartmentRecord(emp.DEPARTMENTID, year, month); lvr.Add(vr); } return(lvr); }
public List <V_RETURNFBI> CustomGuerdonRecord(int objectType, string objectID, int year, int month, bool markType) { var ents1 = from c in dal.GetObjects <T_HR_DEPARTMENT>().Include("T_HR_DEPARTMENTDICTIONARY").Include("T_HR_COMPANY") where c.DEPARTMENTID == objectID select new { COMPANYID = c.T_HR_COMPANY.COMPANYID, COMPANYNAME = c.T_HR_COMPANY.CNAME, DEPARTMENTID = c.DEPARTMENTID, DEPARTMENTNAME = c.T_HR_DEPARTMENTDICTIONARY.DEPARTMENTNAME }; var ents2 = from b in dal.GetObjects <T_HR_POST>().Include("T_HR_DEPARTMENT").Include("T_HR_DEPARTMENTDICTIONARY").Include("T_HR_COMPANY") where b.POSTID == objectID select new { COMPANYID = b.T_HR_DEPARTMENT.T_HR_COMPANY.COMPANYID, COMPANYNAME = b.T_HR_DEPARTMENT.T_HR_COMPANY.CNAME, DEPARTMENTID = b.T_HR_DEPARTMENT.DEPARTMENTID, DEPARTMENTNAME = b.T_HR_DEPARTMENT.T_HR_DEPARTMENTDICTIONARY.DEPARTMENTNAME }; var ents3 = from a in dal.GetObjects <T_HR_EMPLOYEEPOST>().Include("T_HR_POST").Include("T_HR_DEPARTMENT").Include("T_HR_DEPARTMENTDICTIONARY").Include("T_HR_COMPANY") where a.T_HR_EMPLOYEE.EMPLOYEEID == objectID select new { COMPANYID = a.T_HR_POST.T_HR_DEPARTMENT.T_HR_COMPANY.COMPANYID, COMPANYNAME = a.T_HR_POST.T_HR_DEPARTMENT.T_HR_COMPANY.CNAME, DEPARTMENTID = a.T_HR_POST.T_HR_DEPARTMENT.DEPARTMENTID, DEPARTMENTNAME = a.T_HR_POST.T_HR_DEPARTMENT.T_HR_DEPARTMENTDICTIONARY.DEPARTMENTNAME }; List <V_RETURNFBI> vfb = new List <V_RETURNFBI>(); if (!markType) { IsComputer = true; switch (objectType) { case 0: GenerateCompanyRecord(objectID, year.ToString(), month.ToString()); break; case 1: GenerateDepartmentRecord(objectID, year.ToString(), month.ToString()); break; case 2: GeneratePostRecord(objectID, year.ToString(), month.ToString()); break; case 3: GenerateEmployeeRecord(objectID, year.ToString(), month.ToString()); break; } } else { switch (objectType) { case 0: vfb = GenerateCompanyRecord(objectID, year.ToString(), month.ToString()); break; case 1: if (ents1.Count() > 0) { V_RETURNFBI vr1 = new V_RETURNFBI(); var en = ents1.FirstOrDefault(); vr1.COMPANYID = en.COMPANYID; vr1.COMPANYNAME = en.COMPANYNAME; vr1.DEPARTMENTID = en.DEPARTMENTID; vr1.DEPARTMENTNAME = en.DEPARTMENTNAME; vr1.SALARYSUM = GenerateDepartmentRecord(objectID, year.ToString(), month.ToString()); vfb.Add(vr1); } break; case 2: if (ents2.Count() > 0) { V_RETURNFBI vr2 = new V_RETURNFBI(); var en = ents2.FirstOrDefault(); vr2.COMPANYID = en.COMPANYID; vr2.COMPANYNAME = en.COMPANYNAME; vr2.DEPARTMENTID = en.DEPARTMENTID; vr2.DEPARTMENTNAME = en.DEPARTMENTNAME; vr2.SALARYSUM = GeneratePostRecord(objectID, year.ToString(), month.ToString()); vfb.Add(vr2); } break; case 3: if (ents3.Count() > 0) { V_RETURNFBI vr3 = new V_RETURNFBI(); var en = ents3.FirstOrDefault(); vr3.COMPANYID = en.COMPANYID; vr3.COMPANYNAME = en.COMPANYNAME; vr3.DEPARTMENTID = en.DEPARTMENTID; vr3.DEPARTMENTNAME = en.DEPARTMENTNAME; vr3.SALARYSUM = GenerateEmployeeRecord(objectID, year.ToString(), month.ToString()); vfb.Add(vr3); } break; } } return(vfb); }