private void InBienBanQuyetToan()
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
//int strMadviqly = int.Parse(Request["ChiNhanh"] + "");
int strMadviqly = int.Parse(session.User.ma_dviqly);
DataTable dt = new DataTable();
dt.Columns.Add("STT");
dt.Columns.Add("TenDonVi");
dt.Columns.Add("Loai", typeof(int));
dt.Columns.Add("Nhan_Bieu1_SanLuong", typeof(decimal));
dt.Columns.Add("Nhan_Bieu2_SanLuong", typeof(decimal));
dt.Columns.Add("Nhan_Bieu3_SanLuong", typeof(decimal));
dt.Columns.Add("Nhan1Gia", typeof(decimal));
dt.Columns.Add("TongNhan3B", typeof(decimal));
dt.Columns.Add("Giao_Bieu1_SanLuong", typeof(decimal));
dt.Columns.Add("Giao_Bieu2_SanLuong", typeof(decimal));
dt.Columns.Add("Giao_Bieu3_SanLuong", typeof(decimal));
dt.Columns.Add("Giao1Gia", typeof(decimal));
dt.Columns.Add("TongGiao3B", typeof(decimal));
dt.Columns.Add("B1_TieuThu", typeof(decimal));
dt.Columns.Add("B2_TieuThu", typeof(decimal));
dt.Columns.Add("B3_TieuThu", typeof(decimal));
dt.Columns.Add("Tong1Gia", typeof(decimal));
dt.Columns.Add("Tong_TieuThu", typeof(decimal));
var lstquyettoanTT = db.BC_QuyetToanTruyenTai(strMadviqly, int.Parse(Request["Thang"]), int.Parse(Request["Nam"]));
int stt = 1;
dt.Rows.Add("A", "Từ hệ thống của EVN NPC", 0);
foreach (var chitiet in lstquyettoanTT)
{
dt.Rows.Add(stt, chitiet.khoitruyentai, 1, chitiet.Nhan_Bieu1_SanLuong, chitiet.Nhan_Bieu2_SanLuong, chitiet.Nhan_Bieu3_SanLuong, 0, chitiet.TongNhan3B, chitiet.Giao_Bieu1_SanLuong, chitiet.Giao_Bieu2_SanLuong, chitiet.Giao_Bieu3_SanLuong, 0, chitiet.TongGiao3B, chitiet.B1_TieuThu, chitiet.B2_TieuThu, chitiet.B3_TieuThu, 0, chitiet.Tong_TieuThu);
stt++;
}
var lstquyettoan = db.BC_QuyetToan(strMadviqly, int.Parse(Request["Thang"]), int.Parse(Request["Nam"]), int.Parse(Request["ParentId"]));
foreach (var chitiet in lstquyettoan)
{
dt.Rows.Add(stt, chitiet.TenCongTy, 2, chitiet.Nhan_Bieu1_SanLuong, chitiet.Nhan_Bieu2_SanLuong, chitiet.Nhan_Bieu3_SanLuong, 0, chitiet.TongNhan3B, chitiet.Giao_Bieu1_SanLuong, chitiet.Giao_Bieu2_SanLuong, chitiet.Giao_Bieu3_SanLuong, 0, chitiet.TongGiao3B, chitiet.B1_TieuThu, chitiet.B2_TieuThu, chitiet.B3_TieuThu, 0, chitiet.Tong_TieuThu);
stt++;
}
var lstquyettoanSX = db.BC_QuyetToanTuSX(strMadviqly, int.Parse(Request["Thang"]), int.Parse(Request["Nam"]));
stt = 1;
dt.Rows.Add("B", "Tự sản xuất", 0);
foreach (var chitiet in lstquyettoanSX)
{
dt.Rows.Add(stt, chitiet.khoitruyentai, 3, chitiet.Nhan_Bieu1_SanLuong, chitiet.Nhan_Bieu2_SanLuong, chitiet.Nhan_Bieu3_SanLuong, 0, chitiet.TongNhan3B, chitiet.Giao_Bieu1_SanLuong, chitiet.Giao_Bieu2_SanLuong, chitiet.Giao_Bieu3_SanLuong, 0, chitiet.TongGiao3B, chitiet.B1_TieuThu, chitiet.B2_TieuThu, chitiet.B3_TieuThu, 0, chitiet.Tong_TieuThu);
stt++;
}
var lstquyettoanMuaNgoai = db.BC_QuyetToanNgoaiNganh(strMadviqly, int.Parse(Request["Thang"]), int.Parse(Request["Nam"]));
stt = 1;
dt.Rows.Add("C", "Mua ngoài ngành", 0);
foreach (var chitiet in lstquyettoanMuaNgoai)
{
dt.Rows.Add(stt, chitiet.khoitruyentai, 4, chitiet.Nhan_Bieu1_SanLuong, chitiet.Nhan_Bieu2_SanLuong, chitiet.Nhan_Bieu3_SanLuong, 0, chitiet.TongNhan3B, chitiet.Giao_Bieu1_SanLuong, chitiet.Giao_Bieu2_SanLuong, chitiet.Giao_Bieu3_SanLuong, 0, chitiet.TongGiao3B, chitiet.B1_TieuThu, chitiet.B2_TieuThu, chitiet.B3_TieuThu, 0, chitiet.Tong_TieuThu);
stt++;
}
var lstMTAPM = db.BC_QuyetToanMTApMai(strMadviqly, int.Parse(Request["Thang"]), int.Parse(Request["Nam"]));
stt = 1;
foreach (var chitiet in lstMTAPM)
{
dt.Rows.Add("D", "Mặt trời áp mái", 5, chitiet.Nhan_Bieu1_SanLuong, chitiet.Nhan_Bieu2_SanLuong, chitiet.Nhan_Bieu3_SanLuong, chitiet.Nhan_1Gia, chitiet.TongNhan3B, chitiet.Giao_Bieu1_SanLuong, chitiet.Giao_Bieu2_SanLuong, chitiet.Giao_Bieu3_SanLuong, chitiet.Giao_1Gia, chitiet.TongGiao3B, chitiet.B1_TieuThu, chitiet.B2_TieuThu, chitiet.B3_TieuThu, chitiet.MGia_TieuThu, chitiet.Tong_TieuThu);
break;
}
//var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(Request["ChiNhanh"] + ""));
//var giao = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == cn.DiemDauNguon);
var nhan = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == int.Parse(session.User.ma_dviqly));
MTCSYT.Report.InBienBanQT report = new MTCSYT.Report.InBienBanQT(dt, "" + Request["Thang"], "" + Request["Nam"], false, false, "", "", "Tổng công ty điện lực miền bắc", nhan.TEN_DVIQLY, "", "", "", "");
ReportViewer1.Report = report;
ReportToolbar1.ReportViewer = ReportViewer1;
}
