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);
}
