public InDN_ChiTietThuongPham_DonVi(DataTable dt, string thang, string nam, string tenDonvi, int DonVi, string TCT)
{
CBDN.DB_CBDNDataContext db = new CBDN.DB_CBDNDataContext(new CBDN.ADOController().strcn());
InitializeComponent();
var khDN = db.DN_TongNhapDienNhans.SingleOrDefault(x => x.IDMA_DVIQLY == DonVi && x.Thang == int.Parse(thang) && x.Nam == int.Parse(nam));
if (khDN != null)
{
lbTongDN.Text = string.Format("Sản lượng thương phẩm phân bổ: {0:N0}", +khDN.DN_Thang);
if (khDN.NgayDCLan1 != null)
{
lbDieuChinh1.Text = string.Format("ĐC lần 1: {0:N0},", khDN.DN_DC_Lan1) + " Ngày ĐC: " + ((DateTime)khDN.NgayDCLan1).ToString("dd/MM/yyyy");
}
if (khDN.NgayDCLan2 != null)
{
lbDieuChinh2.Text = string.Format("ĐC lần 2: {0:N0},", khDN.DN_DC_Lan2) + " Ngày ĐC: " + ((DateTime)khDN.NgayDCLan2).ToString("dd/MM/yyyy");
}
if (khDN.NgayDCLan3 != null)
{
lbDieuChinh3.Text = string.Format("ĐC lần 3: {0:N0},", khDN.DN_DC_Lan3) + " Ngày ĐC: " + ((DateTime)khDN.NgayDCLan3).ToString("dd/MM/yyyy");
}
}
if (TCT == "TCT")
{
lbSanLuong.Text = "Sản lượng thương phẩm";
}
else
{
lbSanLuong.Text = "Thương phẩm theo các phần ghi chỉ số";
}
Detail.Report.DataSource = dt;
lbThangNam.Text = "Ngày: " + DateTime.Now.ToString("dd/MM/yyyy");
lbTenDVBC.Text = tenDonvi;
xlSTT.DataBindings.Add("Text", DataSource, "STT");
lbNgay.DataBindings.Add("Text", DataSource, "Ngay");
lnDNN2.DataBindings.Add("Text", DataSource, string.Format("{0:N0}", "DN2"));
lbDNN1.DataBindings.Add("Text", DataSource, string.Format("{0:N0}", "DN1"));
lbDNHT.DataBindings.Add("Text", DataSource, string.Format("{0:N0}", "DN"));
lbDNSS.DataBindings.Add("Text", DataSource, string.Format("{0:N0}", "SS_DN"));
lbSLgN1.DataBindings.Add("Text", DataSource, string.Format("{0:N0}", "SanLuongPB1"));
lbSLgPB.DataBindings.Add("Text", DataSource, string.Format("{0:N0}", "SanLuongKH"));
lbSLgThucHien.DataBindings.Add("Text", DataSource, string.Format("{0:N0}", "SanLuongPB"));
//xlSSNgay.DataBindings.Add("Text", DataSource, "SS_N1");
lbSSN1.DataBindings.Add("Text", DataSource, string.Format("{0:N0}", "SS_N1"));
lbGhiChu.DataBindings.Add("Text", DataSource, "GhiChu");
xrSoSanh.DataBindings.Add("Html", DataSource, "SS_N0");
xlSumDNN2.Text = string.Format("{0:N0}", dt.Compute("Sum(DN2)", "1=1").ToString());
xlSumDNN1.Text = string.Format("{0:N0}", dt.Compute("Sum(DN1)", "1=1").ToString());
xlSumHt.Text = string.Format("{0:N0}", dt.Compute("Sum(DN)", "1=1").ToString());
xlSumSSDN.Text = string.Format("{0:N0}", dt.Compute("Sum(SS_DN)", "1=1").ToString());
xlSumSlgN1.Text = string.Format("{0:N0}", dt.Compute("Sum(SanLuongPB1)", "1=1").ToString());
xlSumSlgPB.Text = string.Format("{0:N0}", dt.Compute("Sum(SanLuongKH)", "1=1").ToString());
xlSumSLgTH.Text = string.Format("{0:N0}", dt.Compute("Sum(SanLuongPB)", "1=1").ToString());
xlSumSlgKh.Text = string.Format("{0:N0}", dt.Compute("Sum(SS_N1)", "1=1").ToString());
xlSumSSSlgN1.Text = string.Format("{0:N0}", dt.Compute("Sum(SSKH_TH)", "1=1").ToString());
}
public InDN_ThuongPhamTCT(DataTable dt, string thang, string nam, string tenDonvi, int DonVi)
{
CBDN.DB_CBDNDataContext db = new CBDN.DB_CBDNDataContext(new CBDN.ADOController().strcn());
InitializeComponent();
return;
var khDN = db.DN_TK_SumALLKeHoach(int.Parse(thang), int.Parse("" + nam)).ToList();
if (khDN.Count() > 0)
{
foreach (var kh in khDN)
{
lbTongDN.Text = "Tổng điện nhận: " + kh.DN_Thang + "";
lbDieuChinh1.Text = "ĐC lần 1: " + kh.DN_DC_Lan1;
lbDieuChinh2.Text = " ĐC lần 2: " + kh.DN_DC_Lan2;
lbDieuChinh3.Text = " ĐC lần 3: " + kh.DN_DC_Lan3;
break;
}
}
Detail.Report.DataSource = dt;
lbThangNam.Text = "Ngày: " + DateTime.Now.ToString("dd/MM/yyyy");
xlSTT.DataBindings.Add("Text", DataSource, "STT");
lbNgay.DataBindings.Add("Text", DataSource, "TEN_DVIQLY");
lnDNN2.DataBindings.Add("Text", DataSource, "DN2");
lbDNN1.DataBindings.Add("Text", DataSource, "DN1");
lbDNHT.DataBindings.Add("Text", DataSource, "DN");
lbDNSS.DataBindings.Add("Text", DataSource, "SS_DN");
lbSLgN1.DataBindings.Add("Text", DataSource, "SanLuongPB1");
lbSLgPB.DataBindings.Add("Text", DataSource, "SanLuongKH");
lbSLgThucHien.DataBindings.Add("Text", DataSource, "SanLuongPB");
lbSSN1.DataBindings.Add("Text", DataSource, "SS_N1");
xlSumDNN2.Text = dt.Compute("Sum(DN2)", "1=1").ToString();
xlSumDNN1.Text = dt.Compute("Sum(DN1)", "1=1").ToString();
xlSumHt.Text = dt.Compute("Sum(DN)", "1=1").ToString();
xlSumSSDN.Text = dt.Compute("Sum(SS_DN)", "1=1").ToString();
xlSumSlgN1.Text = dt.Compute("Sum(SanLuongPB1)", "1=1").ToString();
xlSumSlgPB.Text = dt.Compute("Sum(SanLuongKH)", "1=1").ToString();
xlSumSLgTH.Text = dt.Compute("Sum(SanLuongPB)", "1=1").ToString();
xlSumSlgKh.Text = dt.Compute("Sum(SSKH_TH)", "1=1").ToString();
xlSumSSSlgN1.Text = dt.Compute("Sum(SS_N1)", "1=1").ToString();
xrTest.DataBindings.Add("Html", DataSource, "SS_N0");
}
public InDN_ChiTiet(DataTable dt, string thang, string nam, string tenDonvi, int DonVi)
{
CBDN.DB_CBDNDataContext db = new CBDN.DB_CBDNDataContext(new CBDN.ADOController().strcn());
InitializeComponent();
var khDN = db.DN_TongNhapDienNhans.SingleOrDefault(x => x.IDMA_DVIQLY == DonVi && x.Thang == int.Parse(thang) && x.Nam == int.Parse(nam));
if (khDN != null)
{
if (khDN.NgayDCLan1 != null)
{
lbDieuChinh1.Text = "ĐC lần 1: " + khDN.DN_DC_Lan1 + " Ngày ĐC: " + ((DateTime)khDN.NgayDCLan1).ToString("dd/MM/yyyy");
}
if (khDN.NgayDCLan2 != null)
{
lbDieuChinh2.Text = "ĐC lần 2: " + khDN.DN_DC_Lan2 + " Ngày ĐC: " + ((DateTime)khDN.NgayDCLan2).ToString("dd/MM/yyyy");
}
if (khDN.NgayDCLan3 != null)
{
lbDieuChinh3.Text = "ĐC lần 3: " + khDN.DN_DC_Lan3 + " Ngày ĐC: " + ((DateTime)khDN.NgayDCLan3).ToString("dd/MM/yyyy");
}
}
Detail.Report.DataSource = dt;
lbThangNam.Text = "Ngày: " + DateTime.Now.ToString("dd/MM/yyyy");
lbTenDVBC.Text = tenDonvi;
xlSTT.DataBindings.Add("Text", DataSource, "STT");
lbNgay.DataBindings.Add("Text", DataSource, "Ngay");
lbSLg.DataBindings.Add("Text", DataSource, "TH_PhanBoNgay");
lbLan1.DataBindings.Add("Text", DataSource, "DieuChinh");
lbLan2.DataBindings.Add("Text", DataSource, "DienNhan");
lbTongKH.DataBindings.Add("Text", DataSource, "TongKH");
lbLuyKeTH.DataBindings.Add("Text", DataSource, "LuyKeTH");
lbSoSanh.DataBindings.Add("Text", DataSource, "SoSanh");
lbTBNgayKh.DataBindings.Add("Text", DataSource, "TB_KH");
xlNgayTH.DataBindings.Add("Text", DataSource, "TB_TH");
xlSSNgay.DataBindings.Add("Text", DataSource, "TB_SS");
xlSumDC1.Text = dt.Compute("Sum(TH_PhanBoNgay)", "1=1").ToString();
xlSumDC3.Text = dt.Compute("Sum(DieuChinh)", "1=1").ToString();
xlSumDC3.Text = dt.Compute("Sum(DienNhan)", "1=1").ToString();
xlSumLuyKeTH.Text = dt.Compute("Sum(LuyKeTH)", "1=1").ToString();
xlSumSLPB.Text = dt.Compute("Sum(TH_PhanBoNgay)", "1=1").ToString();
xlSumSS.Text = dt.Compute("Sum(SoSanh)", "1=1").ToString();
xlSumSSNgay.Text = dt.Compute("Sum(TB_SS)", "1=1").ToString();
xlSumTBKH.Text = dt.Compute("Sum(TB_KH)", "1=1").ToString();
xlSumTBTH.Text = dt.Compute("Sum(TB_TH)", "1=1").ToString();
xlSumTongKH.Text = dt.Compute("Sum(TongKH)", "1=1").ToString();
}
public DataTable InBienBanGN(int PhuongThuc, int strMadviqly, int Thang, int Nam, ref string strTenDVGiao, ref string strTenDVnhan, ref string strGDNhan, ref string strGDGiao)
{
CBDN.DB_CBDNDataContext db = new CBDN.DB_CBDNDataContext(new CBDN.ADOController().strcn());
//if (PhuongThuc == null) return;
//MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
//int strMadviqly = int.Parse(session.User.ma_dviqly);
DataTable dt = new DataTable();
dt.Columns.Add("TenDonVi");
dt.Columns.Add("MaTram");
dt.Columns.Add("TenDiemDo");
dt.Columns.Add("Loai");
dt.Columns.Add("MaCongTo");
dt.Columns.Add("Bieu1_DoDem", typeof(decimal));
dt.Columns.Add("Bieu2_DoDem", typeof(decimal));
dt.Columns.Add("Bieu3_DoDem", typeof(decimal));
dt.Columns.Add("Tong_DoDem", typeof(decimal));
dt.Columns.Add("Gia1_DoDem", typeof(decimal));
dt.Columns.Add("TC_DoDem", typeof(decimal));
dt.Columns.Add("Bieu1_kDoDem", typeof(decimal));
dt.Columns.Add("Bieu2_kDoDem", typeof(decimal));
dt.Columns.Add("Bieu3_kDoDem", typeof(decimal));
dt.Columns.Add("Gia1_kDoDem", typeof(decimal));
dt.Columns.Add("Tong_kDoDem", typeof(decimal));
dt.Columns.Add("TC_kDoDem", typeof(decimal));
dt.Columns.Add("Bieu1", typeof(decimal));
dt.Columns.Add("Bieu2", typeof(decimal));
dt.Columns.Add("Bieu3", typeof(decimal));
dt.Columns.Add("Tong", typeof(decimal));
dt.Columns.Add("Gia1", typeof(decimal));
dt.Columns.Add("TC", typeof(decimal));
dt.Columns.Add("Bieu1_DoDem1");
dt.Columns.Add("Bieu2_DoDem1");
dt.Columns.Add("Bieu3_DoDem1");
dt.Columns.Add("Tong_DoDem1");
dt.Columns.Add("1Gia_DoDem1");
dt.Columns.Add("TC_DoDem1");
dt.Columns.Add("Bieu1_kDoDem1");
dt.Columns.Add("Bieu2_kDoDem1");
dt.Columns.Add("Bieu3_kDoDem1");
dt.Columns.Add("1Gia_kDoDem1");
dt.Columns.Add("Tong_kDoDem1");
dt.Columns.Add("TC_kDoDem1");
dt.Columns.Add("Bieu11");
dt.Columns.Add("Bieu21");
dt.Columns.Add("Bieu31");
dt.Columns.Add("Tong1");
dt.Columns.Add("1Gia1");
dt.Columns.Add("TC1");
var lst = db.BC_ChiSoThang_ChuaChot_BCC1(strMadviqly, Thang, Nam).ToList();
var lsttONG = db.BC_GiaoNhan2Chieu_TongTram_BCC1(strMadviqly, Thang, Nam).ToList();
DataTable ds = new DataTable();
ds.Columns.Add("Tram");
int b = 0;
foreach (var dstram in lsttONG)
{
int a = ds.Rows.Count;
var check2 = dstram.IDTram + "";
if (a > 0)
{
for (int i = 0; i < a; i++)
{
var check = ds.Rows[i]["Tram"] + "";
if (check2 == check)
{
b++;
}
}
}
if (b == 0)
{
ds.Rows.Add(dstram.IDTram);
}
b = 0;
}
int a1 = ds.Rows.Count;
if (a1 > 0)
{
for (int i = 0; i < a1; i++)
{
int ID = int.Parse(ds.Rows[i]["Tram"] + "");
var lstByTram = lst.Where(x => x.IDTram == ID).ToList();
string TEN_DVIQLY = "";
string MaTram = "";
string TenDiemDo = "";
string MaCongTo = "";
decimal Nhan_Bieu1_DoDem = 0;
decimal Nhan_Bieu2_DoDem = 0;
decimal Nhan_Bieu3_DoDem = 0;
decimal Nhan_Tong_DoDem = 0;
decimal Nhan1Gia_DoDem = 0;
decimal Tong_Nhan_DoDem = 0;
decimal Nhan_Bieu1_kDoDem = 0;
decimal Nhan_Bieu2_kDoDem = 0;
decimal Nhan_Bieu3_kDoDem = 0;
decimal Nhan_Tong_kDoDem = 0;
decimal Nhan1Gia_kDoDem = 0;
decimal Tong_Nhan_kDoDem = 0;
decimal Nhan_Bieu1 = 0;
decimal Nhan_Bieu2 = 0;
decimal Nhan_Bieu3 = 0;
decimal Nhan_Tong = 0;
decimal Nhan1Gia = 0;
decimal Tong_Nhan = 0;
decimal Giao_Bieu1_DoDem = 0;
decimal Giao_Bieu2_DoDem = 0;
decimal Giao_Bieu3_DoDem = 0;
decimal Giao_Tong_DoDem = 0;
decimal Giao1Gia_DoDem = 0;
decimal Tong_Giao_DoDem = 0;
decimal Giao_Bieu1_kDoDem = 0;
decimal Giao_Bieu2_kDoDem = 0;
decimal Giao_Bieu3_kDoDem = 0;
decimal Giao_Tong_kDoDem = 0;
decimal Giao1Gia_kDoDem = 0;
decimal Tong_Giao_kDoDem = 0;
decimal Giao_Bieu1 = 0;
decimal Giao_Bieu2 = 0;
decimal Giao_Bieu3 = 0;
decimal Giao_Tong = 0;
decimal Giao1Gia = 0;
decimal Tong_Giao = 0;
foreach (var chitiet in lstByTram)
{
var tram = db.DM_Trams.SingleOrDefault(x => x.IDTram == chitiet.IDTram);
if (tram == null)
{
continue;
}
var PTtram = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(tram.IDChiNhanh));
if (PTtram.ID == PhuongThuc)
{
if (chitiet.ISDoDem == 0)
{
if ((bool)chitiet.IsCToMotGia)
{
Nhan1Gia_DoDem = (decimal)chitiet.Nhan_Bieu1_SanLuong + (decimal)chitiet.Nhan_Bieu2_SanLuong + (decimal)chitiet.Nhan_Bieu3_SanLuong;
Giao1Gia_DoDem = (decimal)chitiet.Nhan_Bieu1_SanLuong + (decimal)chitiet.Nhan_Bieu2_SanLuong + (decimal)chitiet.Nhan_Bieu3_SanLuong;
}
else
{
Nhan_Bieu1_DoDem = (decimal)chitiet.Nhan_Bieu1_SanLuong;
Nhan_Bieu2_DoDem = (decimal)chitiet.Nhan_Bieu2_SanLuong;
Nhan_Bieu3_DoDem = (decimal)chitiet.Nhan_Bieu3_SanLuong;
Nhan_Tong_DoDem = Nhan_Bieu1_DoDem + Nhan_Bieu2_DoDem + Nhan_Bieu3_DoDem;
Tong_Nhan_DoDem = Nhan_Tong_DoDem + Nhan1Gia_DoDem;
Giao_Bieu1_DoDem = (decimal)chitiet.Giao_Bieu1_SanLuong;
Giao_Bieu2_DoDem = (decimal)chitiet.Giao_Bieu2_SanLuong;
Giao_Bieu3_DoDem = (decimal)chitiet.Giao_Bieu3_SanLuong;
Giao_Tong_DoDem = Giao_Bieu1_DoDem + Giao_Bieu2_DoDem + Giao_Bieu3_DoDem;
Tong_Giao_DoDem = Giao_Tong_DoDem + Giao1Gia_DoDem;
}
}
else
{
if ((bool)chitiet.IsCToMotGia)
{
Nhan1Gia_kDoDem = (decimal)chitiet.Nhan_Bieu1_SanLuong + (decimal)chitiet.Nhan_Bieu2_SanLuong + (decimal)chitiet.Nhan_Bieu3_SanLuong;
Giao1Gia_kDoDem = (decimal)chitiet.Nhan_Bieu1_SanLuong + (decimal)chitiet.Nhan_Bieu2_SanLuong + (decimal)chitiet.Nhan_Bieu3_SanLuong;
}
else
{
Nhan_Bieu1_kDoDem = (decimal)chitiet.Nhan_Bieu1_SanLuong;
Nhan_Bieu2_kDoDem = (decimal)chitiet.Nhan_Bieu2_SanLuong;
Nhan_Bieu3_kDoDem = (decimal)chitiet.Nhan_Bieu3_SanLuong;
Nhan_Tong_kDoDem = Nhan_Bieu1_kDoDem + Nhan_Bieu2_kDoDem + Nhan_Bieu3_kDoDem;
Tong_Nhan_kDoDem = Nhan_Tong_kDoDem + Nhan1Gia_kDoDem;
Giao_Bieu1_kDoDem = (decimal)chitiet.Giao_Bieu1_SanLuong;
Giao_Bieu2_kDoDem = (decimal)chitiet.Giao_Bieu2_SanLuong;
Giao_Bieu3_kDoDem = (decimal)chitiet.Giao_Bieu3_SanLuong;
Giao_Tong_kDoDem = Giao_Bieu1_kDoDem + Giao_Bieu2_kDoDem + Giao_Bieu3_kDoDem;
Tong_Giao_kDoDem = Giao_Tong_kDoDem + Giao1Gia_kDoDem;
}
}
TEN_DVIQLY = chitiet.TEN_DVIQLY + "";
MaTram = chitiet.MaTram + "";
TenDiemDo = chitiet.TenDiemDo + "";
MaCongTo = chitiet.MaCongTo + "";
Nhan_Bieu1 = Nhan_Bieu1_DoDem + Nhan_Bieu1_kDoDem;
Nhan_Bieu2 = Nhan_Bieu2_DoDem + Nhan_Bieu2_kDoDem;
Nhan_Bieu3 = Nhan_Bieu3_DoDem + Nhan_Bieu3_kDoDem;
Nhan_Tong = Nhan_Tong_DoDem + Nhan_Tong_kDoDem;
Nhan1Gia = Nhan1Gia_DoDem + Nhan1Gia_kDoDem;
Tong_Nhan = Tong_Nhan_DoDem + Tong_Nhan_kDoDem;
Giao_Bieu1 = Giao_Bieu1_DoDem + Giao_Bieu1_kDoDem;
Giao_Bieu2 = Giao_Bieu2_DoDem + Giao_Bieu2_kDoDem;
Giao_Bieu3 = Giao_Bieu3_DoDem + Giao_Bieu3_kDoDem;
Giao_Tong = Giao_Tong_DoDem + Giao_Tong_kDoDem;
Giao1Gia = Giao1Gia_DoDem + Giao1Gia_kDoDem;
Tong_Giao = Tong_Giao_DoDem + Tong_Giao_kDoDem;
}
}
if (Tong_Nhan > 0)
{
dt.Rows.Add(TEN_DVIQLY, MaTram, TenDiemDo, 1, MaCongTo,
string.Format("{0:N0} ", Nhan_Bieu1_DoDem),
string.Format("{0:N0} ", Nhan_Bieu2_DoDem), string.Format("{0:N0} ", Nhan_Bieu3_DoDem),
string.Format("{0:N0} ", Nhan_Tong_DoDem), string.Format("{0:N0} ", Nhan1Gia_DoDem),
string.Format("{0:N0} ", Tong_Nhan_DoDem),
string.Format("{0:N0} ", Nhan_Bieu1_kDoDem), string.Format("{0:N0} ", Nhan_Bieu2_kDoDem),
string.Format("{0:N0} ", Nhan_Bieu3_kDoDem), string.Format("{0:N0} ", Nhan1Gia_kDoDem),
string.Format("{0:N0} ", Nhan_Tong_kDoDem),
string.Format("{0:N0} ", Tong_Nhan_kDoDem), string.Format("{0:N0} ", Nhan_Bieu1),
string.Format("{0:N0} ", Nhan_Bieu2), string.Format("{0:N0} ", Nhan_Bieu3),
string.Format("{0:N0} ", Nhan_Tong), string.Format("{0:N0} ", Nhan1Gia),
string.Format("{0:N0} ", Tong_Nhan),
string.Format("{0:N0} ", Nhan_Bieu1_DoDem),
string.Format("{0:N0} ", Nhan_Bieu2_DoDem), string.Format("{0:N0} ", Nhan_Bieu3_DoDem),
string.Format("{0:N0} ", Nhan_Tong_DoDem), string.Format("{0:N0} ", Nhan1Gia_DoDem),
string.Format("{0:N0} ", Tong_Nhan_DoDem),
string.Format("{0:N0} ", Nhan_Bieu1_kDoDem), string.Format("{0:N0} ", Nhan_Bieu2_kDoDem),
string.Format("{0:N0} ", Nhan_Bieu3_kDoDem), string.Format("{0:N0} ", Nhan1Gia_kDoDem),
string.Format("{0:N0} ", Nhan_Tong_kDoDem),
string.Format("{0:N0} ", Tong_Nhan_kDoDem), string.Format("{0:N0} ", Nhan_Bieu1),
string.Format("{0:N0} ", Nhan_Bieu2), string.Format("{0:N0} ", Nhan_Bieu3),
string.Format("{0:N0} ", Nhan_Tong), string.Format("{0:N0} ", Nhan1Gia),
string.Format("{0:N0} ", Tong_Nhan));
}
if (Tong_Giao > 0)
{
dt.Rows.Add(TEN_DVIQLY, MaTram, TenDiemDo, 0, MaCongTo,
string.Format("{0:N0} ", Giao_Bieu1_DoDem), string.Format("{0:N0} ", Giao_Bieu2_DoDem),
string.Format("{0:N0} ", Giao_Bieu3_DoDem), string.Format("{0:N0} ", Giao_Tong_DoDem),
string.Format("{0:N0} ", Giao1Gia_DoDem), string.Format("{0:N0} ", Tong_Giao_DoDem),
string.Format("{0:N0} ", Giao_Bieu1_kDoDem), string.Format("{0:N0} ", Giao_Bieu2_kDoDem),
string.Format("{0:N0} ", Giao_Bieu3_kDoDem),
string.Format("{0:N0} ", Giao1Gia_kDoDem), string.Format("{0:N0} ", Giao_Tong_kDoDem),
string.Format("{0:N0} ", Tong_Giao_kDoDem), string.Format("{0:N0} ", Giao_Bieu1),
string.Format("{0:N0} ", Giao_Bieu2), string.Format("{0:N0} ", Giao_Bieu3),
string.Format("{0:N0} ", Giao_Tong), string.Format("{0:N0} ", Giao1Gia),
string.Format("{0:N0} ", Tong_Giao),
string.Format("{0:N0} ", Giao_Bieu1_DoDem), string.Format("{0:N0} ", Giao_Bieu2_DoDem),
string.Format("{0:N0} ", Giao_Bieu3_DoDem), string.Format("{0:N0} ", Giao_Tong_DoDem),
string.Format("{0:N0} ", Giao1Gia_DoDem), string.Format("{0:N0} ", Tong_Giao_DoDem),
string.Format("{0:N0} ", Giao_Bieu1_kDoDem), string.Format("{0:N0} ", Giao_Bieu2_kDoDem),
string.Format("{0:N0} ", Giao_Bieu3_kDoDem),
string.Format("{0:N0} ", Giao1Gia_kDoDem), string.Format("{0:N0} ", Giao_Tong_kDoDem),
string.Format("{0:N0} ", Tong_Giao_kDoDem), string.Format("{0:N0} ", Giao_Bieu1),
string.Format("{0:N0} ", Giao_Bieu2), string.Format("{0:N0} ", Giao_Bieu3),
string.Format("{0:N0} ", Giao_Tong), string.Format("{0:N0} ", Giao1Gia),
string.Format("{0:N0} ", Tong_Giao));
}
}
}
if (PhuongThuc + "" != "0")
{
var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == PhuongThuc);
CBDN.DM_DVQLY giao, nhan;
if (cn.IDMADVIQLY.Contains(",2,"))
{
giao = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == 2);
nhan = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == int.Parse(cn.IDMADVIQLY.Replace(",2,", "").Replace(",", "")));
}
else
{
giao = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == cn.DiemDauNguon);
nhan = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == cn.DiemCuoiNguon);
}
var imGDGiao = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == cn.DiemDauNguon && x.IDChinhNhanh == PhuongThuc && x.Thang == Thang && x.Nam == Nam && x.ChucVu == 3);
var imGDNhan = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == cn.DiemCuoiNguon && x.IDChinhNhanh == PhuongThuc && x.Thang == Thang && x.Nam == Nam && x.ChucVu == 3);
if (imGDGiao != null)
{
var ngGiao = db.DM_USERs.SingleOrDefault(x => x.IDUSER == imGDGiao.NguoiTao);
strGDGiao = ngGiao.HOTEN + "</br> Thời gian xác nhận: " + imGDGiao.NgayTao;
}
if (imGDNhan != null)
{
var ngNhan = db.DM_USERs.SingleOrDefault(x => x.IDUSER == imGDNhan.NguoiTao);
strGDNhan = ngNhan.HOTEN + "</br> Thời gian xác nhận: " + imGDNhan.NgayTao;
}
strTenDVGiao = giao.TEN_DVIQLY;
strTenDVnhan = nhan.TEN_DVIQLY;
}
else
{
strTenDVGiao = "TỔNG CÔNG TY ĐIỆN LỰC MIỀM BẮC";
strTenDVnhan = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == strMadviqly).TEN_DVIQLY;
}
return(dt);
}
public DataTable InBienBanQuyetToan(int PhuongThuc, int strMadviqly, int Thang, int Nam, ref string strTenDVGiao, ref string strTenDVnhan, ref string strGDNhan, ref string strGDGiao)
{
CBDN.DB_CBDNDataContext db = new CBDN.DB_CBDNDataContext(new CBDN.ADOController().strcn());
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));
dt.Columns.Add("Nhan_Bieu1_SanLuong1", typeof(string));
dt.Columns.Add("Nhan_Bieu2_SanLuong1", typeof(string));
dt.Columns.Add("Nhan_Bieu3_SanLuong1", typeof(string));
dt.Columns.Add("Nhan1Gia1", typeof(string));
dt.Columns.Add("TongNhan3B1", typeof(string));
dt.Columns.Add("Giao_Bieu1_SanLuong1", typeof(string));
dt.Columns.Add("Giao_Bieu2_SanLuong1", typeof(string));
dt.Columns.Add("Giao_Bieu3_SanLuong1", typeof(string));
dt.Columns.Add("Giao1Gia1", typeof(string));
dt.Columns.Add("TongGiao3B1", typeof(string));
dt.Columns.Add("B1_TieuThu1", typeof(string));
dt.Columns.Add("B2_TieuThu1", typeof(string));
dt.Columns.Add("B3_TieuThu1", typeof(string));
dt.Columns.Add("Tong1Gia1", typeof(string));
dt.Columns.Add("Tong_TieuThu1", typeof(string));
var lstquyettoanTT = db.BC_LS_QuyetToanTruyenTai(strMadviqly, Thang, Nam, PhuongThuc);
int stt = 1;
dt.Rows.Add("A", "Từ hệ thống của EVN NPC", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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
, string.Format("{0:N0} ", chitiet.Nhan_Bieu1_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Nhan_Bieu2_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Nhan_Bieu3_SanLuong).Replace(",", "."), 0,
string.Format("{0:N0} ", chitiet.TongNhan3B).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_Bieu1_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_Bieu2_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_Bieu3_SanLuong).Replace(",", "."),
0, string.Format("{0:N0} ", chitiet.TongGiao3B).Replace(",", "."),
string.Format("{0:N0} ", chitiet.B1_TieuThu).Replace(",", "."),
string.Format("{0:N0} ", chitiet.B2_TieuThu).Replace(",", "."),
string.Format("{0:N0} ", chitiet.B3_TieuThu).Replace(",", "."),
0, string.Format("{0:N0} ", chitiet.Tong_TieuThu).Replace(",", "."));
stt++;
}
var lstquyettoan = db.BC_LS_QuyetToan(strMadviqly, Thang, Nam, PhuongThuc);
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
, string.Format("{0:N0} ", chitiet.Nhan_Bieu1_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Nhan_Bieu2_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Nhan_Bieu3_SanLuong).Replace(",", "."), 0,
string.Format("{0:N0} ", chitiet.TongNhan3B).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_Bieu1_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_Bieu2_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_Bieu3_SanLuong).Replace(",", "."),
0, string.Format("{0:N0} ", chitiet.TongGiao3B).Replace(",", "."),
string.Format("{0:N0} ", chitiet.B1_TieuThu).Replace(",", "."),
string.Format("{0:N0} ", chitiet.B2_TieuThu).Replace(",", "."),
string.Format("{0:N0} ", chitiet.B3_TieuThu).Replace(",", "."),
0, string.Format("{0:N0} ", chitiet.Tong_TieuThu).Replace(",", "."));
stt++;
}
//tính tổng dòng A
DataRow[] drA = dt.Select("STT='A' AND Loai=0");
drA[0]["Nhan_Bieu1_SanLuong"] = 0;
drA[0]["Nhan_Bieu2_SanLuong"] = 0;
drA[0]["Nhan_Bieu3_SanLuong"] = 0;
drA[0]["Nhan1Gia"] = 0;
drA[0]["TongNhan3B"] = 0;
drA[0]["Giao_Bieu1_SanLuong"] = 0;
drA[0]["Giao_Bieu2_SanLuong"] = 0;
drA[0]["Giao_Bieu3_SanLuong"] = 0;
drA[0]["Giao1Gia"] = 0;
drA[0]["TongGiao3B"] = 0;
drA[0]["B1_TieuThu"] = 0;
drA[0]["B2_TieuThu"] = 0;
drA[0]["B3_TieuThu"] = 0;
drA[0]["Tong1Gia"] = 0;
drA[0]["Tong_TieuThu"] = 0;
drA[0]["Nhan_Bieu1_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Nhan_Bieu1_SanLuong)", "Loai<3")).Replace(",", ".");
drA[0]["Nhan_Bieu2_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Nhan_Bieu2_SanLuong)", "Loai<3")).Replace(",", ".");
drA[0]["Nhan_Bieu3_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Nhan_Bieu3_SanLuong)", "Loai<3")).Replace(",", ".");
drA[0]["Nhan1Gia1"] = string.Format("{0:N0} ", dt.Compute("sum(Nhan1Gia)", "Loai<3")).Replace(",", ".");
drA[0]["TongNhan3B1"] = string.Format("{0:N0} ", dt.Compute("sum(TongNhan3B)", "Loai<3")).Replace(",", ".");
drA[0]["Giao_Bieu1_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Giao_Bieu1_SanLuong)", "Loai<3")).Replace(",", ".");
drA[0]["Giao_Bieu2_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Giao_Bieu2_SanLuong)", "Loai<3")).Replace(",", ".");
drA[0]["Giao_Bieu3_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Giao_Bieu3_SanLuong)", "Loai<3")).Replace(",", ".");
drA[0]["Giao1Gia1"] = string.Format("{0:N0} ", dt.Compute("sum(Giao1Gia)", "Loai<3")).Replace(",", ".");
drA[0]["TongGiao3B1"] = string.Format("{0:N0} ", dt.Compute("sum(TongGiao3B)", "Loai<3")).Replace(",", ".");
drA[0]["B1_TieuThu1"] = string.Format("{0:N0} ", dt.Compute("sum(B1_TieuThu)", "Loai<3")).Replace(",", ".");
drA[0]["B2_TieuThu1"] = string.Format("{0:N0} ", dt.Compute("sum(B2_TieuThu)", "Loai<3")).Replace(",", ".");
drA[0]["B3_TieuThu1"] = string.Format("{0:N0} ", dt.Compute("sum(B3_TieuThu)", "Loai<3")).Replace(",", ".");
drA[0]["Tong1Gia1"] = string.Format("{0:N0} ", dt.Compute("sum(Tong1Gia)", "Loai<3")).Replace(",", ".");
drA[0]["Tong_TieuThu1"] = string.Format("{0:N0} ", dt.Compute("sum(Tong_TieuThu)", "Loai<3")).Replace(",", ".");
var lstquyettoanSX = db.BC_LS_QuyetToanTuSX(strMadviqly, Thang, Nam, PhuongThuc);
stt = 1;
dt.Rows.Add("B", "Tự sản xuất", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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
, string.Format("{0:N0} ", chitiet.Nhan_Bieu1_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Nhan_Bieu2_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Nhan_Bieu3_SanLuong).Replace(",", "."), 0,
string.Format("{0:N0} ", chitiet.TongNhan3B).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_Bieu1_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_Bieu2_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_Bieu3_SanLuong).Replace(",", "."),
0, string.Format("{0:N0} ", chitiet.TongGiao3B).Replace(",", "."),
string.Format("{0:N0} ", chitiet.B1_TieuThu).Replace(",", "."),
string.Format("{0:N0} ", chitiet.B2_TieuThu).Replace(",", "."),
string.Format("{0:N0} ", chitiet.B3_TieuThu).Replace(",", "."),
0, string.Format("{0:N0} ", chitiet.Tong_TieuThu).Replace(",", "."));
stt++;
}
//tính tổng dòng B
DataRow[] drB = dt.Select("STT='B' AND Loai=0");
drB[0]["Nhan_Bieu1_SanLuong"] = 0;
drB[0]["Nhan_Bieu2_SanLuong"] = 0;
drB[0]["Nhan_Bieu3_SanLuong"] = 0;
drB[0]["Nhan1Gia"] = 0;
drB[0]["TongNhan3B"] = 0;
drB[0]["Giao_Bieu1_SanLuong"] = 0;
drB[0]["Giao_Bieu2_SanLuong"] = 0;
drB[0]["Giao_Bieu3_SanLuong"] = 0;
drB[0]["Giao1Gia"] = 0;
drB[0]["TongGiao3B"] = 0;
drB[0]["B1_TieuThu"] = 0;
drB[0]["B2_TieuThu"] = 0;
drB[0]["B3_TieuThu"] = 0;
drB[0]["Tong1Gia"] = 0;
drB[0]["Tong_TieuThu"] = 0;
drB[0]["Nhan_Bieu1_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Nhan_Bieu1_SanLuong)", "Loai=3")).Replace(",", ".");
drB[0]["Nhan_Bieu2_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Nhan_Bieu2_SanLuong)", "Loai=3")).Replace(",", ".");
drB[0]["Nhan_Bieu3_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Nhan_Bieu3_SanLuong)", "Loai=3")).Replace(",", ".");
drB[0]["Nhan1Gia1"] = string.Format("{0:N0} ", dt.Compute("sum(Nhan1Gia)", "Loai=3")).Replace(",", ".");
drB[0]["TongNhan3B1"] = string.Format("{0:N0} ", dt.Compute("sum(TongNhan3B)", "Loai=3")).Replace(",", ".");
drB[0]["Giao_Bieu1_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Giao_Bieu1_SanLuong)", "Loai=3")).Replace(",", ".");
drB[0]["Giao_Bieu2_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Giao_Bieu2_SanLuong)", "Loai=3")).Replace(",", ".");
drB[0]["Giao_Bieu3_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Giao_Bieu3_SanLuong)", "Loai=3")).Replace(",", ".");
drB[0]["Giao1Gia1"] = string.Format("{0:N0} ", dt.Compute("sum(Giao1Gia)", "Loai=3")).Replace(",", ".");
drB[0]["TongGiao3B1"] = string.Format("{0:N0} ", dt.Compute("sum(TongGiao3B)", "Loai=3")).Replace(",", ".");
drB[0]["B1_TieuThu1"] = string.Format("{0:N0} ", dt.Compute("sum(B1_TieuThu)", "Loai=3")).Replace(",", ".");
drB[0]["B2_TieuThu1"] = string.Format("{0:N0} ", dt.Compute("sum(B2_TieuThu)", "Loai=3")).Replace(",", ".");
drB[0]["B3_TieuThu1"] = string.Format("{0:N0} ", dt.Compute("sum(B3_TieuThu)", "Loai=3")).Replace(",", ".");
drB[0]["Tong1Gia1"] = string.Format("{0:N0} ", dt.Compute("sum(Tong1Gia)", "Loai=3")).Replace(",", ".");
drB[0]["Tong_TieuThu1"] = string.Format("{0:N0} ", dt.Compute("sum(Tong_TieuThu)", "Loai=3")).Replace(",", ".");
var lstquyettoanMuaNgoai = db.BC_LS_QuyetToanNgoaiNganh(strMadviqly, Thang, Nam, PhuongThuc);
stt = 1;
dt.Rows.Add("C", "Mua ngoài ngành", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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,
string.Format("{0:N0} ", chitiet.Nhan_Bieu1_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Nhan_Bieu2_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Nhan_Bieu3_SanLuong).Replace(",", "."), 0,
string.Format("{0:N0} ", chitiet.TongNhan3B).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_Bieu1_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_Bieu2_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_Bieu3_SanLuong).Replace(",", "."),
0, string.Format("{0:N0} ", chitiet.TongGiao3B).Replace(",", ".")
, string.Format("{0:N0} ", chitiet.B1_TieuThu).Replace(",", "."),
string.Format("{0:N0} ", chitiet.B2_TieuThu).Replace(",", "."),
string.Format("{0:N0} ", chitiet.B3_TieuThu).Replace(",", "."),
0, string.Format("{0:N0} ", chitiet.Tong_TieuThu).Replace(",", "."));
stt++;
}
DataRow[] drC = dt.Select("STT='C' AND Loai=0");
drC[0]["Nhan_Bieu1_SanLuong"] = 0;
drC[0]["Nhan_Bieu2_SanLuong"] = 0;
drC[0]["Nhan_Bieu3_SanLuong"] = 0;
drC[0]["Nhan1Gia"] = 0;
drC[0]["TongNhan3B"] = 0;
drC[0]["Giao_Bieu1_SanLuong"] = 0;
drC[0]["Giao_Bieu2_SanLuong"] = 0;
drC[0]["Giao_Bieu3_SanLuong"] = 0;
drC[0]["Giao1Gia"] = 0;
drC[0]["TongGiao3B"] = 0;
drC[0]["B1_TieuThu"] = 0;
drC[0]["B2_TieuThu"] = 0;
drC[0]["B3_TieuThu"] = 0;
drC[0]["Tong1Gia"] = 0;
drC[0]["Tong_TieuThu"] = 0;
drC[0]["Nhan_Bieu1_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Nhan_Bieu1_SanLuong)", "Loai=4")).Replace(",", ".");
drC[0]["Nhan_Bieu2_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Nhan_Bieu2_SanLuong)", "Loai=4")).Replace(",", ".");
drC[0]["Nhan_Bieu3_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Nhan_Bieu3_SanLuong)", "Loai=4")).Replace(",", ".");
drC[0]["Nhan1Gia1"] = string.Format("{0:N0} ", dt.Compute("sum(Nhan1Gia)", "Loai=4")).Replace(",", ".");
drC[0]["TongNhan3B1"] = string.Format("{0:N0} ", dt.Compute("sum(TongNhan3B)", "Loai=4")).Replace(",", ".");
drC[0]["Giao_Bieu1_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Giao_Bieu1_SanLuong)", "Loai=4")).Replace(",", ".");
drC[0]["Giao_Bieu2_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Giao_Bieu2_SanLuong)", "Loai=4")).Replace(",", ".");
drC[0]["Giao_Bieu3_SanLuong1"] = string.Format("{0:N0} ", dt.Compute("sum(Giao_Bieu3_SanLuong)", "Loai=4")).Replace(",", ".");
drC[0]["Giao1Gia1"] = string.Format("{0:N0} ", dt.Compute("sum(Giao1Gia)", "Loai=4")).Replace(",", ".");
drC[0]["TongGiao3B1"] = string.Format("{0:N0} ", dt.Compute("sum(TongGiao3B)", "Loai=4")).Replace(",", ".");
drC[0]["B1_TieuThu1"] = string.Format("{0:N0} ", dt.Compute("sum(B1_TieuThu)", "Loai=4")).Replace(",", ".");
drC[0]["B2_TieuThu1"] = string.Format("{0:N0} ", dt.Compute("sum(B2_TieuThu)", "Loai=4")).Replace(",", ".");
drC[0]["B3_TieuThu1"] = string.Format("{0:N0} ", dt.Compute("sum(B3_TieuThu)", "Loai=4")).Replace(",", ".");
drC[0]["Tong1Gia1"] = string.Format("{0:N0} ", dt.Compute("sum(Tong1Gia)", "Loai=4")).Replace(",", ".");
drC[0]["Tong_TieuThu1"] = string.Format("{0:N0} ", dt.Compute("sum(Tong_TieuThu)", "Loai=4")).Replace(",", ".");
var lstMTAPM = db.BC_LS_QuyetToanMTApMai(strMadviqly, Thang, Nam, PhuongThuc);
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
, string.Format("{0:N0} ", chitiet.Nhan_Bieu1_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Nhan_Bieu2_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Nhan_Bieu3_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Nhan_1Gia).Replace(",", "."),
string.Format("{0:N0} ", chitiet.TongNhan3B).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_Bieu1_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_Bieu2_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_Bieu3_SanLuong).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Giao_1Gia).Replace(",", "."),
string.Format("{0:N0} ", chitiet.TongGiao3B).Replace(",", "."),
string.Format("{0:N0} ", chitiet.B1_TieuThu).Replace(",", "."),
string.Format("{0:N0} ", chitiet.B2_TieuThu).Replace(",", "."),
string.Format("{0:N0} ", chitiet.B3_TieuThu).Replace(",", "."),
string.Format("{0:N0} ", chitiet.MGia_TieuThu).Replace(",", "."),
string.Format("{0:N0} ", chitiet.Tong_TieuThu).Replace(",", "."));
break;
}
//DM_DVQLYService dm_dviSer = new DM_DVQLYService();
// var donvi = dm_dviSer.SelectDM_DVQLY(strMadviqly);
//DM_DVQLYService dm_dviSer = new DM_DVQLYService();
//var donvi = dm_dviSer.SelectDM_DVQLY(strMadviqly);
if (PhuongThuc + "" != "0")
{
var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == PhuongThuc);
CBDN.DM_DVQLY giao, nhan;
if (cn.IDMADVIQLY.Contains(",2,"))
{
giao = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == 2);
nhan = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == int.Parse(cn.IDMADVIQLY.Replace(",2,", "").Replace(",", "")));
}
else
{
giao = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == cn.DiemDauNguon);
nhan = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == cn.DiemCuoiNguon);
}
var imGDGiao = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == giao.IDMA_DVIQLY && x.IDChinhNhanh == PhuongThuc && x.Thang == Thang && x.Nam == Nam && x.ChucVu == 3 && x.TrangThai == null);
var imGDNhan = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == nhan.IDMA_DVIQLY && x.IDChinhNhanh == PhuongThuc && x.Thang == Thang && x.Nam == Nam && x.ChucVu == 3 && x.TrangThai == null);
if (imGDGiao != null)
{
var ngGiao = db.DM_USERs.SingleOrDefault(x => x.IDUSER == imGDGiao.NguoiTao);
if (ngGiao.CHUCDANH == null)
{
ngGiao.CHUCDANH = "Giám Đốc";
}
var chucdanh = ngGiao.CHUCDANH.ToUpper();
var TenCty = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == ngGiao.IDMA_DVIQLY);
var ten = TenCty.TEN_DVIQLY;
ten = ten.ToUpper();
strGDGiao = ngGiao.HOTEN + "</br> Đơn vị: " + chucdanh + " - " + ten + "</br> Thời gian xác nhận: " + String.Format("{0:dd-MM-yyyy HH:mm:ss}", imGDGiao.NgayTao);
}
if (imGDNhan != null)
{
var ngNhan = db.DM_USERs.SingleOrDefault(x => x.IDUSER == imGDNhan.NguoiTao);
if (ngNhan.CHUCDANH == null)
{
ngNhan.CHUCDANH = "Giám Đốc";
}
var chucdanh = ngNhan.CHUCDANH.ToUpper();
var TenCty = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == ngNhan.IDMA_DVIQLY);
var ten = TenCty.TEN_DVIQLY;
ten = ten.ToUpper();
strGDNhan = ngNhan.HOTEN + "</br> Đơn vị: " + chucdanh + " - " + ten + "</br> Thời gian xác nhận: " + String.Format("{0:dd-MM-yyyy HH:mm:ss}", imGDNhan.NgayTao);
}
strTenDVGiao = giao.TEN_DVIQLY;
strTenDVnhan = nhan.TEN_DVIQLY;
}
else
{
var lstPT = db.DM_ChiNhanhs.Where(x => x.DiemCuoiNguon == 2).Where(x => x.DiemDauNguon == strMadviqly).ToList();
if (lstPT.Count == 0)
{
lstPT = db.DM_ChiNhanhs.Where(x => x.DiemCuoiNguon == strMadviqly).Where(x => x.DiemDauNguon == 2).ToList();
}
if (lstPT.Count != 0)
{
foreach (var list in lstPT)
{
PhuongThuc = list.ID;
}
}
var imGDGiao = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == 2 && x.IDChinhNhanh == PhuongThuc && x.Thang == Thang && x.Nam == Nam && x.ChucVu == 3 && x.TrangThai == null);
var imGDNhan = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == strMadviqly && x.IDChinhNhanh == PhuongThuc && x.Thang == Thang && x.Nam == Nam && x.ChucVu == 3 && x.TrangThai == null);
if (imGDGiao != null)
{
var ngGiao = db.DM_USERs.SingleOrDefault(x => x.IDUSER == imGDGiao.NguoiTao);
if (ngGiao.CHUCDANH == null)
{
ngGiao.CHUCDANH = "Giám Đốc";
}
var chucdanh = ngGiao.CHUCDANH.ToUpper();
var TenCty = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == ngGiao.IDMA_DVIQLY);
var ten = TenCty.TEN_DVIQLY;
ten = ten.ToUpper();
strGDGiao = ngGiao.HOTEN + "</br> Đơn vị: " + chucdanh + " - " + ten + "</br> Thời gian xác nhận: " + String.Format("{0:dd-MM-yyyy HH:mm:ss}", imGDGiao.NgayTao);
}
if (imGDNhan != null)
{
var ngNhan = db.DM_USERs.SingleOrDefault(x => x.IDUSER == imGDNhan.NguoiTao);
if (ngNhan.CHUCDANH == null)
{
ngNhan.CHUCDANH = "Giám Đốc";
}
var chucdanh = ngNhan.CHUCDANH.ToUpper();
var TenCty = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == ngNhan.IDMA_DVIQLY);
var ten = TenCty.TEN_DVIQLY;
ten = ten.ToUpper();
strGDNhan = ngNhan.HOTEN + "</br> Đơn vị: " + chucdanh + " - " + ten + "</br> Thời gian xác nhận: " + String.Format("{0:dd-MM-yyyy HH:mm:ss}", imGDNhan.NgayTao);
}
strTenDVGiao = "TỔNG CÔNG TY ĐIỆN LỰC MIỀN BẮC";
strTenDVnhan = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == strMadviqly).TEN_DVIQLY;
}
return(dt);
}
public InDN_ThuongPham(DataTable dt, string thang, string nam, string tenDonvi, int DonVi)
{
CBDN.DB_CBDNDataContext db = new CBDN.DB_CBDNDataContext(new CBDN.ADOController().strcn());
InitializeComponent();
var khDN = db.DN_TongNhapDienNhans.SingleOrDefault(x => x.IDMA_DVIQLY == DonVi && x.Thang == int.Parse(thang) && x.Nam == int.Parse(nam));
if (khDN != null)
{
if (khDN.NgayDCLan1 != null)
{
lbDieuChinh1.Text = "ĐC lần 1: " + khDN.DN_DC_Lan1 + " Ngày ĐC: " + ((DateTime)khDN.NgayDCLan1).ToString("dd/MM/yyyy");
}
if (khDN.NgayDCLan2 != null)
{
lbDieuChinh2.Text = "ĐC lần 2: " + khDN.DN_DC_Lan2 + " Ngày ĐC: " + ((DateTime)khDN.NgayDCLan2).ToString("dd/MM/yyyy");
}
if (khDN.NgayDCLan3 != null)
{
lbDieuChinh3.Text = "ĐC lần 3: " + khDN.DN_DC_Lan3 + " Ngày ĐC: " + ((DateTime)khDN.NgayDCLan3).ToString("dd/MM/yyyy");
}
}
lbThangNam.Text = "Ngày: " + DateTime.Now.ToString("dd/MM/yyyy");
lbTenDVBC.Text = tenDonvi;
Detail.Report.DataSource = dt;
xlSTT.DataBindings.Add("Text", DataSource, "Ngay");
lb1.DataBindings.Add("Text", DataSource, "1");
lb2.DataBindings.Add("Text", DataSource, "2");
lb3.DataBindings.Add("Text", DataSource, "3");
lb4.DataBindings.Add("Text", DataSource, "4");
lb5.DataBindings.Add("Text", DataSource, "5");
lb6.DataBindings.Add("Text", DataSource, "6");
lb7.DataBindings.Add("Text", DataSource, "7");
lb8.DataBindings.Add("Text", DataSource, "8");
lb9.DataBindings.Add("Text", DataSource, "9");
lb10.DataBindings.Add("Text", DataSource, "10");
lb11.DataBindings.Add("Text", DataSource, "11");
lb12.DataBindings.Add("Text", DataSource, "12");
lb13.DataBindings.Add("Text", DataSource, "13");
lb14.DataBindings.Add("Text", DataSource, "14");
lb15.DataBindings.Add("Text", DataSource, "15");
lb16.DataBindings.Add("Text", DataSource, "16");
lb17.DataBindings.Add("Text", DataSource, "17");
lb18.DataBindings.Add("Text", DataSource, "18");
lb19.DataBindings.Add("Text", DataSource, "19");
lb20.DataBindings.Add("Text", DataSource, "20");
lb21.DataBindings.Add("Text", DataSource, "21");
lb22.DataBindings.Add("Text", DataSource, "22");
lb23.DataBindings.Add("Text", DataSource, "23");
lb24.DataBindings.Add("Text", DataSource, "24");
lb25.DataBindings.Add("Text", DataSource, "25");
lb26.DataBindings.Add("Text", DataSource, "26");
lb27.DataBindings.Add("Text", DataSource, "27");
lb28.DataBindings.Add("Text", DataSource, "28");
lb29.DataBindings.Add("Text", DataSource, "29");
lb30.DataBindings.Add("Text", DataSource, "30");
lb31.DataBindings.Add("Text", DataSource, "31");
}
