public ThongKe_TrucTiep(ViewModelSearchKT_SANLUONG_TRUCTIEP t) { this.t = t; _lstDMNhomNghe = db.DM_NHOMNGHE.ToList(); _lstDMNhomTau = db.DNHOM_TAU.ToList(); }
public List <KT_SANLUONG_TRUC_TIEP> Lay_Danh_Sach_San_Luong(ViewModelSearchKT_SANLUONG_TRUCTIEP t) { // danh sach phang var tk = db.KT_SANLUONG. Join(db.KT_SANLUONG_DETAIL, sl_ID => sl_ID.ID, detail_ID => detail_ID.ID_KHAITHAC_SANLUONG, (sl_ID, detail_ID) => new { THANG = sl_ID.THANG , NAM = sl_ID.NAM , MA_TINHTP = sl_ID.MA_TINHTP , ID_KHAITHAC_NHOM_DOITUONG = detail_ID.ID_KHAITHAC_NHOM_DOITUONG , ID_KHAITHAC_NHOM_NGHE = detail_ID.ID_KHAITHAC_NHOM_NGHE , ID_KHAITHAC_NHOM_CONGSUAT = detail_ID.ID_KHAITHAC_NHOM_CONGSUAT , SAN_LUONG = detail_ID.SAN_LUONG } ). Where(o => (((string.IsNullOrEmpty(t.TinhTP) && t.TinhTP_User.StartsWith("Z")) || (string.IsNullOrEmpty(t.TinhTP) && o.MA_TINHTP == t.TinhTP_User) || (o.MA_TINHTP == t.TinhTP)) && (t.Thang == null || o.THANG == t.Thang) && (t.Nam == null || o.NAM == t.Nam) )); // dua vao list List <KT_SANLUONG_TRUC_TIEP> lstSL = new List <KT_SANLUONG_TRUC_TIEP>(); foreach (var sl in tk) { lstSL.Add(new KT_SANLUONG_TRUC_TIEP() { THANG = sl.THANG, NAM = sl.NAM, MA_TINHTP = sl.MA_TINHTP, ID_KHAITHAC_NHOM_DOITUONG = sl.ID_KHAITHAC_NHOM_DOITUONG, ID_KHAITHAC_NHOM_NGHE = sl.ID_KHAITHAC_NHOM_NGHE, ID_KHAITHAC_NHOM_CONGSUAT = sl.ID_KHAITHAC_NHOM_CONGSUAT, SAN_LUONG = sl.SAN_LUONG }); } return(lstSL); }
public Dictionary <string, float> ThongKe_SanLuong_TheonhomLoai(ViewModelSearchKT_SANLUONG_TRUCTIEP t) { Dictionary <string, float> dictSumSL = new Dictionary <string, float>(); // tinh san luong foreach (var nghe in _lstDMNhomNghe) { float iSum = 0; //foreach (var nhomloai in FDB.Common.CategoryCommon.lstDMDoiTuongCPUE) foreach (var nhomloai in db.DM_NHOMDOITUONG_KT.ToList()) { iSum += SanLuong_TheoLoai[t.TinhTP + "#" + t.Thang.ToString() + "#" + t.Nam.ToString() + "#" + nhomloai.ID.ToString() + "#" + nghe.DM_NhomNgheID.ToString()]; } dictSumSL.Add(t.TinhTP + "#" + t.Thang.ToString() + "#" + t.Nam.ToString() + "#" + nghe.DM_NhomNgheID.ToString(), iSum); } return(dictSumSL); }
public Dictionary <string, float> ThongKe_SanLuong_TheonhomNghe(ViewModelSearchKT_SANLUONG_TRUCTIEP t) { Dictionary <string, float> dictSumSL = new Dictionary <string, float>(); if (this.SanLuong_TheoNghe != null && this.SanLuong_TheoNghe.Count > 0) { foreach (var nghe in _lstDMNhomNghe) { float iSum = 0; foreach (var nhomtau in _lstDMNhomTau) { iSum += SanLuong_TheoNghe[t.TinhTP + "#" + t.Thang.ToString() + "#" + t.Nam.ToString() + "#" + nhomtau.ID.ToString() + "#" + nghe.DM_NhomNgheID.ToString()]; } dictSumSL.Add(t.TinhTP + "#" + t.Thang.ToString() + "#" + t.Nam.ToString() + "#" + nghe.DM_NhomNgheID.ToString(), iSum); } } return(dictSumSL); }
public ActionResult Search(ViewModelSearchKT_SANLUONG_TRUCTIEP search) { string strTitle = ""; ApplicationUser curUser = this.getCurrentUser(); initialCategorySearchAction(); if (search.Thang == null) { search.Thang = DateTime.Today.Month; } if (search.Nam == null) { search.Nam = DateTime.Today.Year; } search.TinhTP_User = curUser.MA_TINHTP; if (search.LoaiThongKe == 0) { search.LoaiThongKe = 1; } ThongKe_TrucTiep tk = new ThongKe_TrucTiep(search); search.San_Luong_Theo_Nghe = tk.SanLuong_TheoNghe; search.San_Luong_Theo_Nhom_Nghe = tk.SanLuong_TheoNhomNghe; search.San_Luong_Thang = tk.SanLuong_Thang; search.San_Luong_Theo_Loai = tk.SanLuong_TheoLoai; search.San_Luong_Theo_Nhom_Loai = tk.SanLuong_TheoNhomLoai; search.San_Luong_Loai_Thang = tk.SanLuong_Loai_Thang; strTitle = "Kết quả thống kê sản lượng thu thập trực tiếp Tháng " + (search.Thang < 10 ? "0" + search.Thang.ToString() : search.Thang.ToString()) + "/" + search.Nam.ToString() + " của " + (!string.IsNullOrEmpty(search.TinhTP) ? _context.DTINHTP.FirstOrDefault(a => a.MA_TINHTP == search.TinhTP).TEN_TINHTP : "toàn quốc"); ViewBag.strTitle = strTitle; return(View(search)); }
public Dictionary <string, float> ThongKe_SanLuong_TheoLoai(ViewModelSearchKT_SANLUONG_TRUCTIEP t) { Dictionary <string, float> dictSL = new Dictionary <string, float>(); // lay danh sach san luong List <KT_SANLUONG_TRUC_TIEP> lstSL = Lay_Danh_Sach_San_Luong(t); // tinh san luong foreach (var nghe in _lstDMNhomNghe) { // foreach (var nhomloai in FDB.Common.CategoryCommon.lstDMDoiTuongCPUE) foreach (var nhomloai in db.DM_NHOMDOITUONG_KT.ToList()) { var key = t.TinhTP + "#" + t.Thang.ToString() + "#" + t.Nam.ToString() + "#" + nhomloai.ID.ToString() + "#" + nghe.DM_NhomNgheID.ToString(); var sl = lstSL.Where(o => o.ID_KHAITHAC_NHOM_DOITUONG == nhomloai.ID && o.ID_KHAITHAC_NHOM_NGHE == nghe.DM_NhomNgheID).Sum(s => s.SAN_LUONG); dictSL.Add(key, sl ?? 0); } } return(dictSL); }
public Dictionary <string, float> ThongKe_SanLuong_TheoNghe(ViewModelSearchKT_SANLUONG_TRUCTIEP t) { Dictionary <string, float> dictSL = new Dictionary <string, float>(); // lay danh sach san luong List <KT_SANLUONG_TRUC_TIEP> lstSL = Lay_Danh_Sach_San_Luong(t); // tinh san luong foreach (var nghe in _lstDMNhomNghe) { foreach (var nhomtau in _lstDMNhomTau) { var key = t.TinhTP + "#" + t.Thang.ToString() + "#" + t.Nam.ToString() + "#" + nhomtau.ID.ToString() + "#" + nghe.DM_NhomNgheID.ToString(); var sl = lstSL.Where(o => o.ID_KHAITHAC_NHOM_CONGSUAT == nhomtau.ID && o.ID_KHAITHAC_NHOM_NGHE == nghe.DM_NhomNgheID).Sum(s => s.SAN_LUONG); dictSL.Add(key, sl ?? 0); } } return(dictSL); }