public HttpResponseMessage Get(string org, string year, string dept, string soft_id, int CurrPage, int PageSize) { try { int totalrow; var datas = service.Get(year, org, dept, soft_id, CurrPage, PageSize, out totalrow).OrderByDescending(x => x.detail_id); int num = datas.OrderByDescending(x => x.detail_id).FirstOrDefault().detail_id; //int num = datas var Rvl = new { Total = totalrow, Data = datas }; return(Request.CreateResponse(HttpStatusCode.OK, Rvl)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message.ToString())); } }
public HttpResponseMessage Get(string org, string year, string dept, string soft_id) { try { var datas = service.Get(year, org, dept, soft_id); //var Rvl = new { Total = TotalRow, Data = datas }; //var datas = service.Get(); return(Request.CreateResponse(HttpStatusCode.OK, datas)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message.ToString())); } }
private List <SM01DirectoryViewModel> GetListDataByDept(string year, string org, string dept) { int c = 1; SM01Service SM01Ser = new SM01Service(); SM02Service SM02Ser = new SM02Service(); BD04Service BD04Ser = new BD04Service(); List <SM01DirectoryViewModel> result = new List <SM01DirectoryViewModel>(); List <SM01ViewModel> SM01 = SM01Ser.Get().Where(x => x.year == year && x.org == org && x.dept == dept).ToList(); foreach (SM01ViewModel s01 in SM01) { SM01DirectoryViewModel _result = new SM01DirectoryViewModel(); SM02ViewModel s02 = SM02Ser.Get(s01.year, s01.org, s01.dept, s01.soft_id).OrderBy(x => x.detail_id).FirstOrDefault(); if (s02 != null) { _result.directory_sn = c; _result.soft_id = s01.soft_id; _result.soft_type_name = BD04Ser.Get("SFTP").Where(x => x.bcc_id2 == int.Parse(s01.soft_type.Trim())).FirstOrDefault().bcc_name; _result.soft_name = s01.soft_name; _result.soft_ver = s02.soft_ver; _result.soft_sn = s01.soft_sn; _result.soft_max_user = s01.soft_max_user; _result.soft_work_on_name = BD04Ser.Get("WKON").Where(x => x.bcc_id2 == int.Parse(s01.soft_work_on.Trim())).FirstOrDefault().bcc_name; _result.soft_max_user = s01.soft_max_user; _result.soft_platform = s01.soft_platform; _result.soft_number = s01.soft_number; _result.soft_from_name = BD04Ser.Get("FROM").Where(x => x.bcc_id2 == int.Parse(s01.soft_from.Trim())).FirstOrDefault().bcc_name; _result.soft_from_unit = s01.soft_from_unit; _result.soft_keeper = s01.soft_keeper; _result.soft_doc = s01.soft_doc; _result.soft_cost = s01.soft_cost; _result.keep_org = s02.keep_org; _result.keep_man = s02.keep_man; _result.use_org = s02.use_org; _result.use_man = s02.use_man; _result.install_date = s01.install_date; _result.soft_for = s01.soft_for; _result.memo = s01.memo; result.Add(_result); c++; } } return(result); }