private void InBienBanQuyetToan() { if (cmbPhuongThuc.Value == null || cmbPhuongThuc.Value + "" == "0") { return; } MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"]; int strMadviqly = int.Parse(session.User.ma_dviqly); DataTable dt = new DataTable(); CBDN.Class.InBienBanQT inBienBan = new CBDN.Class.InBienBanQT(); string strGiao = "", strNhan = "", strGDNhan = "", strGDGiao = ""; int donvi = strMadviqly; int phuongthuc = int.Parse(cmbPhuongThuc.Value + ""); if (strMadviqly == 2) { if (phuongthuc != 0) { donvi = int.Parse(db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(cmbPhuongThuc.Value + "")).IDMADVIQLY.Replace(",2,", "").Replace(",", "")); phuongthuc = 0; } } dt = inBienBan.InBienBanQuyetToan(phuongthuc, donvi, int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), ref strGiao, ref strNhan, ref strGDNhan, ref strGiao); MTCSYT.Report.InBienBanQT report = new MTCSYT.Report.InBienBanQT(dt, "" + cmbThang.Value, "" + cmbNam.Value, false, false, "", "", strGiao, strNhan, "", "", strGDNhan, strGDGiao); ReportViewer2.Report = report; ReportToolbar2.ReportViewer = ReportViewer2; }
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; }