private void InTongHopDienNang()
{
if (cmbPhuongThuc.Value == null || cmbPhuongThuc.Value + "" == "0")
{
return;
}
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
int ma_dviqly = int.Parse(session.User.ma_dviqly);
DM_DVQLYService dm_dviSer = new DM_DVQLYService();
var donvi = dm_dviSer.SelectDM_DVQLY(ma_dviqly);
// if (Request["XacNhan"] + "" == "1") kiemtra = true;
var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(cmbPhuongThuc.Value + ""));
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);
}
MTCSYT.Report.InBieuTong report = new MTCSYT.Report.InBieuTong(int.Parse(cmbPhuongThuc.Value + ""), ma_dviqly, int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), "", "", donvi.TEN_DVIQLY, giao.TEN_DVIQLY, nhan.TEN_DVIQLY, 0, "", "", "", "");
ReportViewer1.Report = report;
ReportToolbar1.ReportViewer = ReportViewer1;
}
private void InTongHopDienNang()
{
if (cmbPhuongThuc.Value == null)
{
return;
}
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
int ma_dviqly = int.Parse(session.User.ma_dviqly);
DM_DVQLYService dm_dviSer = new DM_DVQLYService();
var donvi = dm_dviSer.SelectDM_DVQLY(ma_dviqly);
// if (Request["XacNhan"] + "" == "1") kiemtra = true;
string strGiao, strNhan; string strGDNhan = "", strGDGiao = "";
if (cmbPhuongThuc.Value + "" != "0")
{
var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(cmbPhuongThuc.Value + ""));
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);
}
strGiao = giao.TEN_DVIQLY;
strNhan = nhan.TEN_DVIQLY;
var imGDGiao = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == cn.DiemDauNguon && x.IDChinhNhanh == int.Parse(cmbPhuongThuc.Value + "") && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + "") && x.ChucVu == 3);
var imGDNhan = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == cn.DiemCuoiNguon && x.IDChinhNhanh == int.Parse(cmbPhuongThuc.Value + "") && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + "") && 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;
}
}
else
{
strGiao = "TỔNG CÔNG TY ĐIỆN LỰC MIỀM BẮC";
strNhan = donvi.TEN_DVIQLY;
}
MTCSYT.Report.InBieuTong report = new MTCSYT.Report.InBieuTong(int.Parse(cmbPhuongThuc.Value + ""), ma_dviqly, int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), "", "", donvi.TEN_DVIQLY, strGiao, strNhan, 0, "", "", strGDNhan, strGDGiao);
ReportViewer1.Report = report;
ReportToolbar1.ReportViewer = ReportViewer1;
}
private void loadTHDonVi()
{
if (cmbPhuongThucDV.Value == null || cmbPhuongThucDV.Value + "" == "")
{
return;
}
var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(cmbPhuongThucDV.Value + ""));
var giao = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == cn.DiemDauNguon);
var nhan = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == cn.DiemCuoiNguon);
string strTPGiao = "", strTPNhan = "", strGDNhan = "", strGDGiao = "";
var lstHDKy = db.HD_ThongTinKies.Where(x => x.IDChinhNhanh == int.Parse(cmbPhuongThucDV.Value + "") && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + "") && x.TrangThai == null);
foreach (var hdKy in lstHDKy)
{
if (hdKy.ChucVu == 2 && hdKy.IDMaDViQLy == giao.IDMA_DVIQLY)
{
strTPGiao = hdKy.Link;
}
if (hdKy.ChucVu == 2 && hdKy.IDMaDViQLy == nhan.IDMA_DVIQLY)
{
strTPNhan = hdKy.Link;
}
if (hdKy.ChucVu == 3 && hdKy.IDMaDViQLy == giao.IDMA_DVIQLY)
{
strGDGiao = hdKy.Link;
}
if (hdKy.ChucVu == 3 && hdKy.IDMaDViQLy == nhan.IDMA_DVIQLY)
{
strGDNhan = hdKy.Link;
}
}
//var imTPGiao = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == cn.DiemDauNguon && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + "") && x.ChucVu == 2);
//var imTPNhan = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == cn.DiemCuoiNguon && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + "") && x.ChucVu == 2);
//var imGDGiao = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == cn.DiemDauNguon && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + "") && x.ChucVu == 3);
//var imGDNhan = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == cn.DiemCuoiNguon && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + "") && x.ChucVu == 3);
//if (imTPGiao != null)
// if (imTPNhan != null)
// strTPNhan = imTPNhan.Link;
//if (imGDGiao != null)
// strGDGiao = imGDGiao.Link;
//if (imGDNhan != null)
// strGDNhan = imGDNhan.Link;
MTCSYT.Report.InBieuTong report = new MTCSYT.Report.InBieuTong(int.Parse(cmbPhuongThuc.Value + ""), giao.IDMA_DVIQLY, int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), "", "", giao.TEN_DVIQLY, giao.TEN_DVIQLY, nhan.TEN_DVIQLY, 0, strTPNhan, strTPGiao, strGDNhan, strGDGiao);
repViewDV.Report = report;
reToodDV.ReportViewer = ReportViewer1;
}
private void InTongHopDienNang()
{
if (cmbPhuongThuc.Value == null || cmbPhuongThuc.Value + "" == "0")
{
return;
}
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
int ma_dviqly = int.Parse(session.User.ma_dviqly);
DM_DVQLYService dm_dviSer = new DM_DVQLYService();
var donvi = dm_dviSer.SelectDM_DVQLY(ma_dviqly);
var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(cmbPhuongThuc.Value + ""));
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);
}
string strTPGiao = "", strTPNhan = "", strGDNhan = "", strGDGiao = "";
var lstHDKy = db.HD_ThongTinKies.Where(x => x.IDChinhNhanh == int.Parse(cmbPhuongThuc.Value + "") && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + ""));
foreach (var hdKy in lstHDKy)
{
if (hdKy.ChucVu == 2 && hdKy.IDMaDViQLy == giao.IDMA_DVIQLY)
{
strTPGiao = hdKy.Link;
}
if (hdKy.ChucVu == 2 && hdKy.IDMaDViQLy == nhan.IDMA_DVIQLY)
{
strTPNhan = hdKy.Link;
}
if (hdKy.ChucVu == 3 && hdKy.IDMaDViQLy == giao.IDMA_DVIQLY)
{
strGDGiao = hdKy.Link;
}
if (hdKy.ChucVu == 3 && hdKy.IDMaDViQLy == nhan.IDMA_DVIQLY)
{
strGDNhan = hdKy.Link;
}
}
MTCSYT.Report.InBieuTong report = new MTCSYT.Report.InBieuTong(int.Parse(cmbPhuongThuc.Value + ""), ma_dviqly, int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), "", "", donvi.TEN_DVIQLY, giao.TEN_DVIQLY, nhan.TEN_DVIQLY, 0, strTPNhan, strTPGiao, "", "");
ReportViewer1.Report = report;
ReportToolbar1.ReportViewer = ReportViewer1;
}
private void InTongHopDienNang()
{
if (cmbPhuongThuc.Value == null || cmbPhuongThuc.Value + "" == "")
{
return;
}
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
int ma_dviqly = int.Parse(session.User.ma_dviqly);
DM_DVQLYService dm_dviSer = new DM_DVQLYService();
var donvi = dm_dviSer.SelectDM_DVQLY(ma_dviqly);
// if (Request["XacNhan"] + "" == "1") kiemtra = true;
var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(cmbPhuongThuc.Value + ""));
var giao = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == cn.DiemDauNguon);
var nhan = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == cn.DiemCuoiNguon);
string strTPGiao = "", strTPNhan = "", strGDNhan = "", strGDGiao = "";
//var imTPGiao = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == cn.DiemDauNguon && x.IDChinhNhanh==int.Parse(cmbPhuongThuc.Value+"") && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + "") && x.ChucVu == 2);
//var imTPNhan = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == cn.DiemCuoiNguon && x.IDChinhNhanh == int.Parse(cmbPhuongThuc.Value + "") && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + "") && x.ChucVu == 2);
var imGDGiao = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == cn.DiemDauNguon && x.IDChinhNhanh == int.Parse(cmbPhuongThuc.Value + "") && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + "") && x.ChucVu == 3 && x.TrangThai == null);
var imGDNhan = db.HD_ThongTinKies.SingleOrDefault(x => x.IDMaDViQLy == cn.DiemCuoiNguon && x.IDChinhNhanh == int.Parse(cmbPhuongThuc.Value + "") && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + "") && x.ChucVu == 3 && x.TrangThai == null);
//if (imTPGiao != null)
// strTPGiao = imTPGiao.Link;
//if (imTPNhan != null)
// strTPNhan = imTPNhan.Link;
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;
}
MTCSYT.Report.InBieuTong report = new MTCSYT.Report.InBieuTong(int.Parse(cmbPhuongThuc.Value + ""), ma_dviqly, int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), "", "", donvi.TEN_DVIQLY, giao.TEN_DVIQLY, nhan.TEN_DVIQLY, 0, strTPNhan, strTPGiao, strGDNhan, strGDGiao);
ReportViewer1.Report = report;
ReportToolbar1.ReportViewer = ReportViewer1;
}
