private void setControlText(int idCongTo) { var congto = db.DM_CongTos.SingleOrDefault(x => x.IDCongTo == idCongTo); if (congto != null) { lbMaCT.Text = congto.MaCongTo; lbTenCongTo.Text = congto.TenCongTo; lbChungLoai.Text = congto.ChungLoai; lbCDA.Text = congto.CapDienAp + ""; lbIDCongTO.Text = idCongTo + ""; lbDiemDo.Text = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == congto.IDDiemDo).TenDiemDo; lbDVGiao.Text = dm_dviSer.SelectDM_DVQLY((int)congto.IDDonViGiao).NAME_DVIQLY; lbDVNhan.Text = dm_dviSer.SelectDM_DVQLY((int)congto.IDDonViNhan).NAME_DVIQLY; lbHangSX.Text = congto.HangSanXuat; lbHSNhan.Text = congto.HeSoNhan + ""; lbHSQuyDoi.Text = congto.HeSoQuyDoi + ""; lbKenhNhan.Text = congto.KenhGiaoCongTo; lbKenhNhan.Text = congto.KenhNhanCongTo; lbMoTa.Text = congto.MoTa; lbNgayHieuLuc.Text = congto.NgayTreoThao + ""; lbNgaySua.Text = congto.NgayTao + ""; lbngayTao.Text = congto.NgayTao + ""; lbPhuongthuc.Text = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == congto.IDChiNhanh).TenChiNhanh; } }
protected void cmbCuoiNguon_SelectedIndexChanged(object sender, EventArgs e) { SYS_Session session = (SYS_Session)Session["SYS_Session"]; DM_DVQLYService dm_dviSer = new DM_DVQLYService(); var dvDN = dm_dviSer.SelectDM_DVQLY(int.Parse(session.User.ma_dviqly)); var dvChon = dm_dviSer.SelectDM_DVQLY(int.Parse(cmbCuoiNguon.Value + "")); txtMaDuongDat.Text = dvDN.MA_DVIQLY + "_" + dvChon.MA_DVIQLY; }
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 InTongHopKHDAThap() { 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 lst = db.TT_KhachHangDAThapTrongThang(int.Parse(session.User.ma_dviqly + ""), int.Parse("" + Request["Thang"]), int.Parse("" + Request["Nam"])).ToList(); DataTable dt = new DataTable(); dt.Columns.Add("STT"); dt.Columns.Add("TenDonVi"); dt.Columns.Add("SOKH"); dt.Columns.Add("KH160", typeof(decimal)); dt.Columns.Add("KH180", typeof(decimal)); dt.Columns.Add("KH200", typeof(decimal)); dt.Columns.Add("GiaiPhap"); dt.Columns.Add("TienDo"); int stt = 1; foreach (var chitiet in lst) { dt.Rows.Add(stt, chitiet.TEN_DVIQLY, chitiet.SoTBA, chitiet.KH160, chitiet.KH180, chitiet.KH200, chitiet.GiaiPhap, chitiet.TienDoThucHien); stt++; } MTCSYT.Report.KHDAThap report = new MTCSYT.Report.KHDAThap(dt, "" + Request["Thang"], "" + Request["Nam"], donvi.TEN_DVIQLY); ReportViewer1.Report = report; ReportToolbar1.ReportViewer = ReportViewer1; }
private void loadDanhMuc() { DM_DVQLYService dm_dviSer = new DM_DVQLYService(); DataTable lst_dmdv = new DataTable(); MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"]; int ma_dviqly = int.Parse(session.User.ma_dviqly + ""); var donvi = dm_dviSer.SelectDM_DVQLY(ma_dviqly); if (donvi.ParentId == 0 || donvi.ParentId == 61) { lst_dmdv = dm_dviSer.SelectAll_DVI_ByChild(ma_dviqly); cmbMaDonVi.DataSource = lst_dmdv; cmbMaDonVi.ValueField = "IDMA_DVIQLY"; cmbMaDonVi.TextField = "NAME_DVIQLY"; cmbMaDonVi.DataBind(); } else { List <Entity.DM_DVQLY> lst = new List <DM_DVQLY>(); lst.Add(donvi); cmbMaDonVi.DataSource = lst; cmbMaDonVi.ValueField = "IDMA_DVIQLY"; cmbMaDonVi.TextField = "NAME_DVIQLY"; cmbMaDonVi.DataBind(); } }
private void LoadDataDV() { MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"]; int a = int.Parse(session.User.ma_dviqly + ""); if (MaDienLuc.Value + "" != "") { if (a > 38) { DM_DVQLYService dm_dviSer = new DM_DVQLYService(); var donvi = dm_dviSer.SelectDM_DVQLY(a); List <DM_DS> List = new List <DM_DS>(); DM_DS Dvi = new DM_DS(); Dvi.MA_DVIQLY = session.User.ma_dviqlyDN + ""; Dvi.NAME_DVIQLY = donvi.NAME_DVIQLY.Split('-')[1].ToString().ToUpper(); List.Add(Dvi); cmMaDvi.DataSource = List; cmMaDvi.TextField = "NAME_DVIQLY"; cmMaDvi.ValueField = "MA_DVIQLY"; cmMaDvi.DataBind(); } else { DM_DVQLYService dm_dviSer = new DM_DVQLYService(); // DataTable lst_dmdv = new DataTable(); var lst_dmdv = dm_dviSer.SelectAll_DVI_ByChild(int.Parse(MaDienLuc.Value + "")); cmMaDvi.DataSource = lst_dmdv; cmMaDvi.ValueField = "MA_DVIQLY"; cmMaDvi.TextField = "NAME_DVIQLY"; cmMaDvi.DataBind(); } } }
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; }
protected void cmbDiemDo_SelectedIndexChanged(object sender, EventArgs e) { var lstDD = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == int.Parse(cmbDiemDo.Value + "")); List <Entity.DM_DVQLY> lst = new List <DM_DVQLY>(); var chinhanh = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == lstDD.IDChiNhanh); var DonVi = dm_dviSer.SelectDM_DVQLY(chinhanh.DiemDauNguon); lst.Add(DonVi); if (chinhanh.DiemDauNguon != chinhanh.DiemCuoiNguon) { var DonVi2 = dm_dviSer.SelectDM_DVQLY(chinhanh.DiemCuoiNguon); lst.Add(DonVi2); } }
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 dZ() { 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); DataTable dt = dbOR.Get_BCTT_LDD(Request["DonVi"] + "", int.Parse("" + Request["Thang"]), int.Parse("" + Request["Nam"]), Request["LanBC"] + "", int.Parse(Request["LuyKe"] + "")); MTCSYT.Report.InTrungAp report = new MTCSYT.Report.InTrungAp(dt, "" + Request["Thang"], "" + Request["Nam"], donvi.TEN_DVIQLY); ReportViewer1.Report = report; ReportToolbar1.ReportViewer = ReportViewer1; }
private void DN_TK_ChiTietThuongPham() { 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(int.Parse(Request["DonVi"] + "")); DataTable dt = Dienthuongpham(); MTCSYT.Report.InDN_ThuongPham report = new MTCSYT.Report.InDN_ThuongPham(dt, "" + Request["Thang"], "" + Request["Nam"], donvi.TEN_DVIQLY, int.Parse(Request["DonVi"] + "")); ReportViewer1.Report = report; ReportToolbar1.ReportViewer = ReportViewer1; }
protected void btnHuyNhan_Click(object sender, EventArgs e) { SYS_Session session = (SYS_Session)Session["SYS_Session"]; string strMadviqly = session.User.ma_dviqly; DM_DVQLYService isyOrganizationService = new DM_DVQLYService(); Entity.DM_DVQLY sysOrganization = new Entity.DM_DVQLY(); sysOrganization = isyOrganizationService.SelectDM_DVQLY(int.Parse(strMadviqly)); if (rdImportDuLieu.SelectedIndex == 0) { } else { var lstData = dbSQL.CMIS_DDoGCs.Where(x => x.MA_DVIQLY == sysOrganization.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "")); string tenfile = ""; foreach (var a in lstData) { tenfile = a.TENFILE; break; } Class.XuatXML_GCS class_xuatso = new Class.XuatXML_GCS(); DataSet ds = new DataSet(); CBDN.ConvertListToTable cv = new CBDN.ConvertListToTable(); DataTable dt = cv.ConvertToDataTable(lstData.ToList()); dt.Columns.Remove("TENFILE"); dt.Columns.Remove("TrangThaiDongBo"); ds.Tables.Add(dt); string strXML = class_xuatso.HTML_XuatFileCMIS(); string strXML1 = ds.GetXml(); //strXML1 = strXML1.Replace(",", "."); strXML1 = strXML1.Replace("<NewDataSet>", ""); strXML1 = strXML1.Replace("</NewDataSet>", ""); strXML1 = strXML1.Replace("<Table>", "<Table1>"); strXML1 = strXML1.Replace("</Table>", "</Table1>"); strXML += strXML1 + "</NewDataSet>"; string attachment = "attachment;filename=" + tenfile + ".XML"; Response.ClearContent(); Response.ContentType = "application/xml"; Response.AddHeader("content-disposition", attachment); Response.Write(strXML); Response.End(); } }
private void loadDLDongBo() { SYS_Session session = (SYS_Session)Session["SYS_Session"]; string strMadviqly = session.User.ma_dviqly; DM_DVQLYService isyOrganizationService = new DM_DVQLYService(); Entity.DM_DVQLY sysOrganization = new Entity.DM_DVQLY(); sysOrganization = isyOrganizationService.SelectDM_DVQLY(int.Parse(strMadviqly)); var lst = dbSQL.CMIS_DDoGCs.Where(x => x.MA_DVIQLY == sysOrganization.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.TrangThaiDongBo == 1); grdCN.DataSource = lst; grdCN.DataBind(); }
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; }
//private void loadDanhMuc() //{ // MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"]; // int ma_dviqly = int.Parse(session.User.ma_dviqly + ""); // tlDonVi.DataSource = db.db_ChiNhanhSelectXacNhan(ma_dviqly, int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + "")).ToList(); // tlDonVi.DataBind(); //} private void InTongHopDienNang() { if (cmbPhuongThuc.Value != null) { 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); bool kiemtra = false; // if (Request["XacNhan"] + "" == "1") kiemtra = true; //MTCSYT.Report.InBieuTong report = new MTCSYT.Report.InBieuTong(int.Parse(cmbPhuongThuc.Value + ""), ma_dviqly, int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), kiemtra, kiemtra, "", "", donvi.TEN_DVIQLY, 0,"","","",""); //ReportViewer1.Report = report; //ReportToolbar1.ReportViewer = ReportViewer1; } }
private void laodDVCapCha() { MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"]; int a = int.Parse(session.User.ma_dviqly + ""); if (a == 2) { DM_DVQLYService dm_dviSer = new DM_DVQLYService(); var lst_dmdv = dm_dviSer.SelectAllDM_DVQLY(); MaDienLuc.DataSource = lst_dmdv; MaDienLuc.ValueField = "IDMA_DVIQLY"; MaDienLuc.TextField = "TEN_DVIQLY"; MaDienLuc.DataBind(); } else if (a < 38) { DM_DVQLYService dm_dviSer = new DM_DVQLYService(); var donvi = dm_dviSer.SelectDM_DVQLY(int.Parse(session.User.ma_dviqly)); List <DM_DS> List = new List <DM_DS>(); DM_DS Dvi = new DM_DS(); Dvi.MA_DVIQLY = donvi.IDMA_DVIQLY + ""; Dvi.NAME_DVIQLY = donvi.NAME_DVIQLY.Split('-')[1].ToString().ToUpper();; List.Add(Dvi); MaDienLuc.DataSource = List; MaDienLuc.TextField = "NAME_DVIQLY"; MaDienLuc.ValueField = "MA_DVIQLY"; MaDienLuc.DataBind(); } else { DM_DVQLYService dm_dviSer = new DM_DVQLYService(); var lst_dmdv = dm_dviSer.Select_DVI_Cha_ByChild(a); MaDienLuc.DataSource = lst_dmdv; MaDienLuc.ValueField = "IDMA_DVIQLY"; MaDienLuc.TextField = "TEN_DVIQLY"; MaDienLuc.DataBind(); } }
private void DN_TK_ThuongPham_New() { 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(int.Parse(Request["DonVi"] + "")); int thangtr, namtr, thangN2, namN2; if (Request["Thang"] + "" == "1") { thangtr = 12; namtr = int.Parse(Request["Nam"] + "") - 1; thangN2 = 11; namN2 = int.Parse(Request["Nam"] + "") - 1; } else if (Request["Thang"] + "" == "2") { thangtr = 1; namtr = int.Parse(Request["Nam"] + ""); thangN2 = 12; namN2 = int.Parse(Request["Nam"] + "") - 1; } else { thangtr = int.Parse(Request["Thang"] + "") - 1; namtr = int.Parse(Request["Nam"] + ""); thangN2 = int.Parse(Request["Thang"] + "") - 2; namN2 = int.Parse(Request["Nam"] + ""); } //DataTable dt = dbOR.DN_TK_ThucTeTCT(int.Parse(Request["Thang"] + ""), int.Parse(Request["Nam"] + ""), thangtr, namtr, thangN2, namN2, int.Parse(Request["TuNgay"] + ""), int.Parse(Request["DenNgay"] + "")); CBDN.ConvertListToTable cv = new CBDN.ConvertListToTable(); var tk = db.DN_TK_ThucTeTCT(int.Parse(Request["Thang"] + ""), int.Parse(Request["Nam"] + ""), thangtr, namtr, thangN2, namN2, int.Parse(Request["TuNgay"] + ""), int.Parse(Request["DenNgay"] + "")); DataTable dt = cv.ConvertToDataTable(tk.ToList()); MTCSYT.Report.InDN_ThuongPhamTCT report = new MTCSYT.Report.InDN_ThuongPhamTCT(dt, "" + Request["Thang"], "" + Request["Nam"], donvi.TEN_DVIQLY, int.Parse(Request["DonVi"] + "")); ReportViewer1.Report = report; ReportToolbar1.ReportViewer = ReportViewer1; }
private void InTongHopDienNangSauChot() { 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); bool kiemtra = false; if (Request["XacNhan"] + "" == "1") { kiemtra = true; } //MTCSYT.Report.InBieuTong report = new MTCSYT.Report.InBieuTong(int.Parse(Request["ChinhNhanh"] + ""), ma_dviqly, int.Parse("" + Request["Thang"]), int.Parse("" + Request["Nam"]), kiemtra, kiemtra, "", "", donvi.TEN_DVIQLY, 1, "", "", "", ""); //ReportViewer1.Report = report; //ReportToolbar1.ReportViewer = ReportViewer1; }
private void DN_TK_ChiTiet() { 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(int.Parse(Request["DonVi"] + "")); //CBDN.ConvertListToTable cv = new CBDN.ConvertListToTable(); // var tk = db.DN_TK_ThucTeDonVi(int.Parse(Request["DonVi"] + ""), int.Parse("" + Request["Thang"]), int.Parse("" + Request["Nam"])); //DataTable dt = cv.ConvertToDataTable(tk.ToList()); DataTable dt = dbOR.DN_TK_ThucTeDonVi_ByThangNam(int.Parse(Request["DonVi"] + ""), int.Parse("" + Request["Thang"]), int.Parse("" + Request["Nam"])); MTCSYT.Report.InDN_ChiTiet report = new MTCSYT.Report.InDN_ChiTiet(dt, "" + Request["Thang"], "" + Request["Nam"], donvi.TEN_DVIQLY, int.Parse(Request["DonVi"] + "")); ReportViewer1.Report = report; ReportToolbar1.ReportViewer = ReportViewer1; }
private void DN_TK_KeHoach() { 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); //DataTable dt = dbOR.DN_TK_DNKeHoach(int.Parse(session.User.ma_dviqly), int.Parse("" + Request["Thang"]), int.Parse("" + Request["Nam"]), int.Parse(Request["Ngay"] + "")); CBDN.ConvertListToTable cv = new CBDN.ConvertListToTable(); var tk = db.DN_TK_DNKeHoach(int.Parse(session.User.ma_dviqly), int.Parse("" + Request["Thang"]), int.Parse("" + Request["Nam"]), int.Parse(Request["Ngay"] + "")); DataTable dt = cv.ConvertToDataTable(tk.ToList()); MTCSYT.Report.InDN_DuKien report = new MTCSYT.Report.InDN_DuKien(dt, "" + Request["Thang"], "" + Request["Nam"], Request["Ngay"], donvi.TEN_DVIQLY); ReportViewer1.Report = report; ReportToolbar1.ReportViewer = ReportViewer1; }
private void LoadData() { DM_DVQLYService isyOrganizationService = new DM_DVQLYService(); Entity.DM_DVQLY sysOrganization = new Entity.DM_DVQLY(); if (TreeListOrganization.FocusedNode != null) { var parentNode = TreeListOrganization.FocusedNode; //cmbChoseParent.SelectedIndex = IndexOfTreelist(parentNode.ParentNode.Key); int IDOrganization = int.Parse(TreeListOrganization.FocusedNode.Key.ToString()); sysOrganization = isyOrganizationService.SelectDM_DVQLY(int.Parse(TreeListOrganization.FocusedNode.Key)); txtNameOrganization.Text = sysOrganization.MA_DVIQLY; txtTenDV.Text = sysOrganization.TEN_DVIQLY; txtTenVietTat.Text = sysOrganization.TenVietTat; LoadCMBChooseParent(sysOrganization.ParentId); //cmbChoseParent.Value = sysOrganization.ParentId; Session["Organization"] = sysOrganization; } }
protected void btnXuat_Click(object sender, EventArgs e) { MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"]; int ma_dviqly = int.Parse(session.User.ma_dviqly + ""); var lst = db.BC_KhuVuc_ChiTiet(ma_dviqly, int.Parse("0" + cmbThang.Value), int.Parse("0" + cmbNam.Value)).ToList(); #region Chuẩn bị tệp excel mẫu để ghi dữ liệu string destFile = Server.MapPath("~/Tem/BC_KhuVuc.xls"); string sTemplate = (destFile); Workbook exBook = new Workbook(); exBook.Open(sTemplate, FileFormatType.Excel2003); _exSheet = exBook.Worksheets[0]; _range = _exSheet.Cells; #endregion // Xử lý replace các thông tin báo cáo tĩnh theo công ty //Report.ReplaceSpecificationField(_exSheet); int donghientai = 8; #region Ghi dữ liệu _exSheet.Replace("NGAYTHANG", "Ngày " + DateTime.Now.Day + " tháng " + DateTime.Now.Month + " năm " + DateTime.Now.Year); DM_DVQLYService dm_dviSer = new DM_DVQLYService(); var donvi = dm_dviSer.SelectDM_DVQLY(ma_dviqly); string tongdong = Session["tongdong"] + ""; if (donvi.Type < 3) { _exSheet.Replace("ntTieuDe", "BÁO CÁO SẢN LƯỢNG ĐIỆN NĂNG GIAO NHẬN VỚI CÁC CÔNG TY ĐIỆN LỰC"); } else { _exSheet.Replace("ntTieuDe", " BÁO CÁO ĐIỆN NĂNG GIAO NHẬN VỚI CÔNG TY " + donvi.TEN_DVIQLY); } if (lst.Count > 1) { _exSheet.Cells.InsertRows(donghientai + 1, (lst.Count() + int.Parse(tongdong)) * 5 - 3); } string macto = "", tenkhuvuc = ""; int vitri = 0; Style celicaStil = exBook.Styles[exBook.Styles.Add()]; celicaStil.VerticalAlignment = TextAlignmentType.Center; celicaStil.HorizontalAlignment = TextAlignmentType.Center; celicaStil.Pattern = BackgroundType.Solid; celicaStil.Font.IsBold = true; celicaStil.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin; StyleFlag flg = new StyleFlag(); flg.Font = true; int tongtram = 0; flg.CellShading = true; foreach (var ct in lst) { tongtram = tongtram + 1; celicaStil.VerticalAlignment = TextAlignmentType.Center; if (tenkhuvuc != ct.TEN_DVIQLY) { var countKV = lst.Where(x => x.TEN_DVIQLY == ct.TEN_DVIQLY).Count(); _range[donghientai + vitri, 0].PutValue(ct.TEN_DVIQLY); var categoryCounts = from p in lst group p by p.TenTram into g select new { TEN_DVIQLY = ct.TEN_DVIQLY, ProductCount = g.Count() }; _range.Merge(donghientai + vitri, 0, (categoryCounts.Count() + int.Parse(tongdong)) * 5, 1); _range[donghientai + vitri, 0].SetStyle(celicaStil); tenkhuvuc = ct.TEN_DVIQLY; } if (macto != ct.MaCongTo) { _range[donghientai + vitri, 1].PutValue(ct.TenTram); _range.Merge(donghientai + vitri, 1, 5, 1); _range[donghientai + vitri, 1].SetStyle(celicaStil); _range[donghientai + vitri, 2].PutValue(ct.TenDiemDo); _range.Merge(donghientai + vitri, 2, 5, 1); _range[donghientai + vitri, 2].SetStyle(celicaStil); _range[donghientai + vitri, 3].PutValue(ct.TU_TI); _range.Merge(donghientai + vitri, 3, 5, 1); _range[donghientai + vitri, 3].SetStyle(celicaStil); _range[donghientai + vitri, 4].PutValue(ct.TenCongTo); _range.Merge(donghientai + vitri, 4, 5, 1); _range[donghientai + vitri, 4].SetStyle(celicaStil); _range[donghientai + vitri, 5].PutValue(ct.HeSoNhan); _range.Merge(donghientai + vitri, 5, 5, 1); _range[donghientai + vitri, 5].SetStyle(celicaStil); macto = ct.MaCongTo; } for (int i = 0; i < 5; i++) { if (i == 0) { _range[donghientai + vitri + i, 6].PutValue("Tổng P"); _range[donghientai + vitri + i, 7].PutValue(ct.Giao_P_Dau); _range[donghientai + vitri + i, 8].PutValue(ct.Giao_P_Cuoi); _range[donghientai + vitri + i, 9].PutValue(ct.Giao_P_SanLuong); _range[donghientai + vitri + i, 10].PutValue(ct.CosGiao); _range[donghientai + vitri + i, 11].PutValue(ct.Nhan_P_Dau); _range[donghientai + vitri + i, 12].PutValue(ct.Nhan_P_Cuoi); _range[donghientai + vitri + i, 13].PutValue(ct.Nhan_P_SanLuong); _range[donghientai + vitri + i, 14].PutValue(ct.CosNhan); } else if (i == 1) { _range[donghientai + vitri + i, 6].PutValue("Tổng Q"); _range[donghientai + vitri + i, 7].PutValue(ct.Giao_Q_Dau); _range[donghientai + vitri + i, 8].PutValue(ct.Giao_Q_Cuoi); _range[donghientai + vitri + i, 9].PutValue(ct.Giao_Q_SanLuong); _range[donghientai + vitri + i, 10].PutValue(""); _range[donghientai + vitri + i, 11].PutValue(ct.Nhan_Q_Dau); _range[donghientai + vitri + i, 12].PutValue(ct.Nhan_Q_Cuoi); _range[donghientai + vitri + i, 13].PutValue(ct.Nhan_Q_SanLuong); _range[donghientai + vitri + i, 14].PutValue(""); } else if (i == 2) { _range[donghientai + vitri + i, 6].PutValue("Biểu 1"); _range[donghientai + vitri + i, 7].PutValue(ct.Giao_Bieu1_Dau); _range[donghientai + vitri + i, 8].PutValue(ct.Giao_Bieu1_Cuoi); _range[donghientai + vitri + i, 9].PutValue(ct.Giao_Bieu1_SanLuong); _range[donghientai + vitri + i, 10].PutValue(""); _range[donghientai + vitri + i, 11].PutValue(ct.Nhan_Bieu1_Dau); _range[donghientai + vitri + i, 12].PutValue(ct.Nhan_Bieu1_Cuoi); _range[donghientai + vitri + i, 13].PutValue(ct.Nhan_Bieu1_SanLuong); _range[donghientai + vitri + i, 14].PutValue(""); } else if (i == 3) { _range[donghientai + vitri + i, 6].PutValue("Biểu 2"); _range[donghientai + vitri + i, 7].PutValue(ct.Giao_Bieu2_Dau); _range[donghientai + vitri + i, 8].PutValue(ct.Giao_Bieu2_Cuoi); _range[donghientai + vitri + i, 9].PutValue(ct.Giao_Bieu1_SanLuong); _range[donghientai + vitri + i, 10].PutValue(""); _range[donghientai + vitri + i, 11].PutValue(ct.Nhan_Bieu2_Dau); _range[donghientai + vitri + i, 12].PutValue(ct.Nhan_Bieu2_Cuoi); _range[donghientai + vitri + i, 13].PutValue(ct.Nhan_Bieu2_SanLuong); _range[donghientai + vitri + i, 14].PutValue(""); } else if (i == 4) { _range[donghientai + vitri + i, 6].PutValue("Biểu 3"); _range[donghientai + vitri + i, 7].PutValue(ct.Giao_Bieu3_Dau); _range[donghientai + vitri + i, 8].PutValue(ct.Giao_Bieu3_Cuoi); _range[donghientai + vitri + i, 9].PutValue(ct.Giao_Bieu3_SanLuong); _range[donghientai + vitri + i, 10].PutValue(""); _range[donghientai + vitri + i, 11].PutValue(ct.Nhan_Bieu3_Dau); _range[donghientai + vitri + i, 12].PutValue(ct.Nhan_Bieu3_Cuoi); _range[donghientai + vitri + i, 13].PutValue(ct.Nhan_Bieu3_SanLuong); _range[donghientai + vitri + i, 14].PutValue(""); } } //in tổng _range[donghientai + vitri + 5, 1].PutValue(""); _range.Merge(donghientai + vitri + 5, 1, 5, 1); _range[donghientai + vitri + 5, 1].SetStyle(celicaStil); var lstTong = db.BC_GiaoNhan2Chieu_TongTram(ma_dviqly, int.Parse("0" + cmbThang.Value), int.Parse("0" + cmbNam.Value)).ToList(); var ctTong = lstTong.SingleOrDefault(x => x.TenTram == ct.TenTram); if (ctTong != null) { if (tongtram == ctTong.TongTram) { tongtram = 0; for (int i = 0; i < 5; i++) { celicaStil.VerticalAlignment = TextAlignmentType.Left; celicaStil.HorizontalAlignment = TextAlignmentType.Left; if (i == 0) { _range[donghientai + vitri + i + 5, 2].PutValue("Tổng P"); _range[donghientai + vitri + i + 5, 2].SetStyle(celicaStil); _range.Merge(donghientai + vitri + i + 5, 2, 1, 7); _range[donghientai + vitri + i + 5, 9].PutValue(ctTong.slPGiao); _range[donghientai + vitri + i + 5, 13].PutValue(ctTong.slPNhan); _range[donghientai + vitri + i + 5, 13].SetStyle(celicaStil); _range[donghientai + vitri + i + 5, 9].SetStyle(celicaStil); } else if (i == 1) { _range[donghientai + vitri + i + 5, 2].PutValue("Tổng Q"); _range[donghientai + vitri + i + 5, 2].SetStyle(celicaStil); _range.Merge(donghientai + vitri + i + 5, 2, 1, 7); _range[donghientai + vitri + i + 5, 9].PutValue(ctTong.slQGiao); _range[donghientai + vitri + i + 5, 13].PutValue(ctTong.slQNhan); _range[donghientai + vitri + i + 5, 13].SetStyle(celicaStil); _range[donghientai + vitri + i + 5, 9].SetStyle(celicaStil); } else if (i == 2) { _range[donghientai + vitri + i + 5, 2].PutValue("Tổng Biểu 1"); _range[donghientai + vitri + i + 5, 2].SetStyle(celicaStil); _range.Merge(donghientai + vitri + i + 5, 2, 1, 7); _range[donghientai + vitri + i + 5, 9].PutValue(ctTong.slb1Giao); _range[donghientai + vitri + i + 5, 13].PutValue(ctTong.slb1Nhan); _range[donghientai + vitri + i + 5, 13].SetStyle(celicaStil); _range[donghientai + vitri + i + 5, 9].SetStyle(celicaStil); } else if (i == 3) { _range[donghientai + vitri + i + 5, 2].PutValue("Tổng Biểu 2"); _range[donghientai + vitri + i + 5, 2].SetStyle(celicaStil); _range.Merge(donghientai + vitri + i + 5, 2, 1, 7); _range[donghientai + vitri + i + 5, 9].PutValue(ctTong.slb2Giao); _range[donghientai + vitri + i + 5, 13].PutValue(ctTong.slb2Nhan); _range[donghientai + vitri + i + 5, 13].SetStyle(celicaStil); _range[donghientai + vitri + i + 5, 9].SetStyle(celicaStil); } else if (i == 4) { _range[donghientai + vitri + i + 5, 2].PutValue("Tổng Biểu 3"); _range[donghientai + vitri + i + 5, 2].SetStyle(celicaStil); _range.Merge(donghientai + vitri + i + 5, 2, 1, 7); _range[donghientai + vitri + i + 5, 9].PutValue(ctTong.slb3Giao); _range[donghientai + vitri + i + 5, 13].PutValue(ctTong.slb3Nhan); _range[donghientai + vitri + i + 5, 13].SetStyle(celicaStil); _range[donghientai + vitri + i + 5, 9].SetStyle(celicaStil); } else if (i == 5) { _range[donghientai + vitri + i + 5, 2].PutValue("Tổng 3 Biểu"); _range[donghientai + vitri + i + 5, 2].SetStyle(celicaStil); _range.Merge(donghientai + vitri + i + 5, 2, 1, 7); _range[donghientai + vitri + i + 5, 9].PutValue(ctTong.tong3B_Giao); _range[donghientai + vitri + i + 5, 13].PutValue(ctTong.tong3B_Nhan); _range[donghientai + vitri + i + 5, 13].SetStyle(celicaStil); _range[donghientai + vitri + i + 5, 9].SetStyle(celicaStil); } } vitri = vitri + 5; } } vitri = vitri + 5; } #endregion exBook.Save("BC_KhuVuc.xls", SaveType.OpenInExcel, FileFormatType.Default, this.Response); //Response.Redirect("../BaoCao/Report.aspx?Loai=5&strSQL=" + strTruyVan); }
protected void btnXuatFile_Click(object sender, EventArgs e) { if (rdImportDuLieu.SelectedIndex == 0) { try { SYS_Session session = (SYS_Session)Session["SYS_Session"]; string strMadviqly = session.User.ma_dviqly; DataSet dsTem = new DataSet(); DataAccess.dbGCS dataA = new DataAccess.dbGCS(); //MemoryStream memStream = new MemoryStream(); //Stream file = Server.MapPath("~/") + "FileGCSCMIS\\" + UploadFile(); //using (Stream s = file.PostedFile.InputStream) //{ // s.CopyTo(memStream); //} dsTem.ReadXml(Server.MapPath("~/") + "FileGCSCMIS\\" + UploadFile(), XmlReadMode.InferSchema); for (int i = 0; i < dsTem.Tables[0].Rows.Count; i++) { CBDN.CMIS_DDoGC ddo = new CBDN.CMIS_DDoGC(); CBDN.CMIS_DDoGC kiemtraDDo = new CBDN.CMIS_DDoGC(); kiemtraDDo = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dsTem.Tables[0].Rows[i]["MA_DVIQLY"] + "" && x.MA_DDO == dsTem.Tables[0].Rows[i]["MA_DDO"] + "" && x.THANG == int.Parse(dsTem.Tables[0].Rows[i]["THANG"] + "") && x.NAM == int.Parse(dsTem.Tables[0].Rows[i]["NAM"] + "") && x.LOAI_BCS == dsTem.Tables[0].Rows[i]["LOAI_BCS"] + ""); if (kiemtraDDo == null) { ddo.MA_NVGCS = dsTem.Tables[0].Rows[i]["MA_NVGCS"] + ""; ddo.BOCSO_ID = dsTem.Tables[0].Rows[i]["BOCSO_ID"] + ""; ddo.CHUOI_GIA = dsTem.Tables[0].Rows[i]["CHUOI_GIA"] + ""; ddo.CS_CU = decimal.Parse(dsTem.Tables[0].Rows[i]["CS_CU"] + ""); ddo.CS_MOI = decimal.Parse(dsTem.Tables[0].Rows[i]["CS_MOI"] + ""); ddo.DIA_CHI = dsTem.Tables[0].Rows[i]["DIA_CHI"] + ""; ddo.HSN = decimal.Parse(dsTem.Tables[0].Rows[i]["HSN"] + ""); ddo.KIMUA_CSPK = decimal.Parse(dsTem.Tables[0].Rows[i]["KIMUA_CSPK"] + ""); ddo.KY = int.Parse(dsTem.Tables[0].Rows[i]["KY"] + ""); ddo.LOAI_BCS = dsTem.Tables[0].Rows[i]["LOAI_BCS"] + ""; ddo.LOAI_CS = dsTem.Tables[0].Rows[i]["LOAI_CS"] + ""; ddo.MA_CNANG = ""; ddo.MA_COT = dsTem.Tables[0].Rows[i]["MA_COT"] + ""; ddo.MA_CTO = dsTem.Tables[0].Rows[i]["MA_CTO"] + ""; ddo.MA_DDO = dsTem.Tables[0].Rows[i]["MA_DDO"] + ""; ddo.MA_DVIQLY = dsTem.Tables[0].Rows[i]["MA_DVIQLY"] + ""; ddo.MA_GC = dsTem.Tables[0].Rows[i]["MA_GC"] + ""; ddo.MA_KHANG = dsTem.Tables[0].Rows[i]["MA_KHANG"] + ""; ddo.MA_NVGCS = dsTem.Tables[0].Rows[i]["MA_NVGCS"] + ""; ddo.MA_NVIEN = ""; ddo.MA_SOGCS = dsTem.Tables[0].Rows[i]["MA_QUYEN"] + ""; ddo.MA_TRAM = dsTem.Tables[0].Rows[i]["MA_TRAM"] + ""; ddo.NAM = int.Parse(dsTem.Tables[0].Rows[i]["NAM"] + ""); ddo.NGAY_CU = DateTime.Parse(dsTem.Tables[0].Rows[i]["NGAY_CU"] + ""); ddo.NGAY_MOI = DateTime.Parse(dsTem.Tables[0].Rows[i]["NGAY_MOI"] + ""); ddo.NGAY_PMAX = DateTime.Parse(dsTem.Tables[0].Rows[i]["NGAY_PMAX"] + ""); ddo.NGUOI_GCS = dsTem.Tables[0].Rows[i]["NGUOI_GCS"] + ""; ddo.PMAX = decimal.Parse(dsTem.Tables[0].Rows[i]["PMAX"] + ""); ddo.SERY_CTO = dsTem.Tables[0].Rows[i]["SERY_CTO"] + ""; ddo.SL_MOI = decimal.Parse(dsTem.Tables[0].Rows[i]["SL_MOI"] + ""); ddo.SL_THAO = decimal.Parse(dsTem.Tables[0].Rows[i]["SL_THAO"] + ""); ddo.SL_TTIEP = decimal.Parse(dsTem.Tables[0].Rows[i]["SL_TTIEP"] + ""); ddo.SLUONG_1 = decimal.Parse(dsTem.Tables[0].Rows[i]["SLUONG_1"] + ""); ddo.SLUONG_2 = decimal.Parse(dsTem.Tables[0].Rows[i]["SLUONG_2"] + ""); ddo.SLUONG_3 = decimal.Parse(dsTem.Tables[0].Rows[i]["SLUONG_3"] + ""); ddo.SO_HO = Convert.ToInt32(Convert.ToDecimal(dsTem.Tables[0].Rows[i]["SO_HO"] + "")); ddo.SO_HOM = dsTem.Tables[0].Rows[i]["SO_HOM"] + ""; ddo.TEN_KHANG = dsTem.Tables[0].Rows[i]["TEN_KHANG"] + ""; ddo.THANG = int.Parse(dsTem.Tables[0].Rows[i]["THANG"] + ""); ddo.TTR_CU = dsTem.Tables[0].Rows[i]["TTR_MOI"] + ""; ddo.TENFILE = fileUp.FileName; dbSQL.CMIS_DDoGCs.InsertOnSubmit(ddo); dbSQL.SubmitChanges(); } } ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Nhận dữ liệu thành công');", true); } catch (Exception ex) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Lỗi nhận dữ liệu: " + ex.Message + "');", true); } } else { SYS_Session session = (SYS_Session)Session["SYS_Session"]; string strMadviqly = session.User.ma_dviqly; DM_DVQLYService _DM_DVQLY = new DM_DVQLYService(); var dv = _DM_DVQLY.SelectDM_DVQLY(int.Parse(strMadviqly)); var lst = dbSQL.CMIS_DDoGCs.Where(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "")); foreach (var ddo in lst) { var diemdo = dbSQL.DM_DiemDos.SingleOrDefault(x => x.MaDiemDo == ddo.MA_DDO && x.HoatDong == 1); if (diemdo == null) { continue; } var kiemtra = dbSQL.DM_CongTos.SingleOrDefault(x => x.IDDiemDo == diemdo.IDDiemDo + "" && x.TinhTrang == 1); if (kiemtra == null) { continue; } var hhddo = dbSQL.HD_GiaoNhanThangs.SingleOrDefault(x => x.IDCongTo == kiemtra.IDCongTo + "" && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + "")); if (hhddo == null) { continue; } if (ddo.LOAI_BCS == "BT") { var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "BT"); diemdocmis.CS_MOI = hhddo.Giao_Bieu1_Cuoi; diemdocmis.SL_MOI = hhddo.Giao_Bieu1_SanLuong; diemdocmis.TrangThaiDongBo = 1; dbSQL.SubmitChanges(); } else if (ddo.LOAI_BCS == "CD") { var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "CD"); diemdocmis.CS_MOI = hhddo.Giao_Bieu2_Cuoi; diemdocmis.SL_MOI = hhddo.Giao_Bieu2_SanLuong; diemdocmis.TrangThaiDongBo = 1; dbSQL.SubmitChanges(); } else if (ddo.LOAI_BCS == "TD") { var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "TD"); diemdocmis.CS_MOI = hhddo.Giao_Bieu3_Cuoi; diemdocmis.SL_MOI = hhddo.Giao_Bieu3_SanLuong; diemdocmis.TrangThaiDongBo = 1; dbSQL.SubmitChanges(); } else if (ddo.LOAI_BCS == "VC") { var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "VC"); diemdocmis.CS_MOI = hhddo.Giao_Q_Cuoi; diemdocmis.SL_MOI = hhddo.Giao_Q_SanLuong; diemdocmis.TrangThaiDongBo = 1; dbSQL.SubmitChanges(); } if (ddo.LOAI_BCS == "BN") { var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "BN"); diemdocmis.CS_MOI = hhddo.Nhan_Bieu1_Cuoi; diemdocmis.SL_MOI = hhddo.Nhan_Bieu1_SanLuong; diemdocmis.TrangThaiDongBo = 1; dbSQL.SubmitChanges(); } else if (ddo.LOAI_BCS == "CN") { var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "CN"); diemdocmis.CS_MOI = hhddo.Nhan_Bieu2_Cuoi; diemdocmis.SL_MOI = hhddo.Nhan_Bieu2_SanLuong; diemdocmis.TrangThaiDongBo = 1; dbSQL.SubmitChanges(); } else if (ddo.LOAI_BCS == "TN") { var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "TN"); diemdocmis.CS_MOI = hhddo.Nhan_Bieu3_Cuoi; diemdocmis.SL_MOI = hhddo.Nhan_Bieu3_SanLuong; diemdocmis.TrangThaiDongBo = 1; dbSQL.SubmitChanges(); } else if (ddo.LOAI_BCS == "VN") { var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "VN"); diemdocmis.CS_MOI = hhddo.Nhan_Q_Cuoi; diemdocmis.SL_MOI = hhddo.Nhan_Q_SanLuong; diemdocmis.TrangThaiDongBo = 1; dbSQL.SubmitChanges(); } } ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Đồng bộ số liệu thành công');", true); loadDLDongBo(); } }
protected void btnCapNhat_Click(object sender, EventArgs e) { DM_DVQLYService dm_dviSer = new DM_DVQLYService(); SYS_Session session = (SYS_Session)Session["SYS_Session"]; if (cmbCuoiNguon.Value == null) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Bạn chưa chọn đơn vị');", true); cmbCuoiNguon.Focus(); return; } if (txtSoTram.Text + "" == "") { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Bạn phải nhập số khách hàng đang có điện áp thấp');", true); txtSoTram.Focus(); return; } int testInt = 0; if (!int.TryParse(txtSoTram.Text + "", out testInt)) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Số khách hàng đang có điện áp thấp phải là kiểu số');", true); txtSoTram.Focus(); return; } if (!int.TryParse(txtSoKh160.Text + "", out testInt)) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Số khách hàng SH có điện áp thấp < 160kV');", true); txtSoKh160.Focus(); return; } if (!int.TryParse(txtSoKH180.Text + "", out testInt)) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Số khách hàng SH có điện áp thấp từ 160kV -180kv');", true); txtSoKH180.Focus(); return; } if (!int.TryParse(txtSoKH200.Text + "", out testInt)) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Số khách hàng SH có điện áp thấp trên 200kv');", true); txtSoKH200.Focus(); return; } string dvdaunguon = dm_dviSer.SelectDM_DVQLY(int.Parse(session.User.ma_dviqly)).MA_DVIQLY; string dvcuoinguon = dm_dviSer.SelectDM_DVQLY(int.Parse(cmbCuoiNguon.Value + "")).MA_DVIQLY; if (Session["Add"] + "" == "0") { CBDN.TT_KhachHangDAThapTrongThangResult qtCT = (CBDN.TT_KhachHangDAThapTrongThangResult)grdDVT.GetRow(grdDVT.FocusedRowIndex); CBDN.TT_KhachHangDAThap cn = db.TT_KhachHangDAThaps.SingleOrDefault(x => x.ID == qtCT.ID); cn.SoTBA = int.Parse(txtSoTram.Text); cn.KH160 = int.Parse(txtSoKh160.Value + ""); cn.KH180 = int.Parse(txtSoKH180.Value + ""); cn.KH200 = int.Parse(txtSoKH200.Value + ""); cn.Nam = int.Parse(cmbNam.Value + ""); cn.Thang = int.Parse(cmbThang.Value + ""); cn.TienDoThucHien = txtTienDo.Text; cn.GiaiPhap = txtGiaiPhap.Text; cn.IDMA_DVIQLY = int.Parse(cmbCuoiNguon.Value + ""); db.SubmitChanges(); //} } else { if (!CheckName(int.Parse(cmbCuoiNguon.Value + ""), int.Parse(cmbThang.Value + ""), int.Parse("" + cmbNam.Value))) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã phương thức giao nhận được trùng');", true); return; } CBDN.TT_KhachHangDAThap cv = new CBDN.TT_KhachHangDAThap(); cv.SoTBA = int.Parse(txtSoTram.Text); cv.KH160 = int.Parse(txtSoKh160.Value + ""); cv.KH180 = int.Parse(txtSoKH180.Value + ""); cv.KH200 = int.Parse(txtSoKH200.Value + ""); cv.Nam = int.Parse(cmbNam.Value + ""); cv.Thang = int.Parse(cmbThang.Value + ""); cv.TienDoThucHien = txtTienDo.Text; cv.GiaiPhap = txtGiaiPhap.Text; cv.IDMA_DVIQLY = int.Parse(cmbCuoiNguon.Value + ""); db.TT_KhachHangDAThaps.InsertOnSubmit(cv); db.SubmitChanges(); } pcAddRoles.ShowOnPageLoad = false; _DataBind(); }
protected void btnXuat_Click(object sender, EventArgs e) { MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"]; int ma_dviqly = int.Parse(session.User.ma_dviqly + ""); var lst = db.BC_TonThat_ChiTietCDA(ma_dviqly, int.Parse("0" + cmbThang.Value), int.Parse("0" + cmbNam.Value), cmbCapDienAp.Value + "").ToList(); var lsttONG = db.BC_TonThatCDA(ma_dviqly, int.Parse("0" + cmbThang.Value), int.Parse("0" + cmbNam.Value), cmbCapDienAp.Value + "").ToList(); #region Chuẩn bị tệp excel mẫu để ghi dữ liệu string destFile = Server.MapPath("~/Tem/BC_TonThat.xls"); string sTemplate = (destFile); Workbook exBook = new Workbook(); exBook.Open(sTemplate, FileFormatType.Excel2003); _exSheet = exBook.Worksheets[0]; _range = _exSheet.Cells; #endregion // Xử lý replace các thông tin báo cáo tĩnh theo công ty //Report.ReplaceSpecificationField(_exSheet); int donghientai = 7; #region Ghi dữ liệu _exSheet.Replace("ntNgayThang", "Ngày " + DateTime.Now.Day + " tháng " + DateTime.Now.Month + " năm " + DateTime.Now.Year); Style celicaStil = exBook.Styles[exBook.Styles.Add()]; celicaStil.Font.IsBold = true; DM_DVQLYService dm_dviSer = new DM_DVQLYService(); var donvi = dm_dviSer.SelectDM_DVQLY(ma_dviqly); _exSheet.Replace("ntDienLuc", donvi.NAME_DVIQLY.Split('-')[1].ToUpper()); _exSheet.Replace("ntTieuDe", "BÁO CÁO SẢN LƯỢNG ĐIỆN GIAO CỦA " + donvi.NAME_DVIQLY.Split('-')[1].ToString().ToUpper() + " TRONG THÁNG " + cmbThang.Value + " NĂM " + cmbNam.Value); if (lst.Count > 0) { _exSheet.Cells.InsertRows(donghientai + 1, lst.Count); } int stt = 1; string tenchinhan = ""; foreach (var chitiet in lst) { _range[donghientai + stt, 0].PutValue(stt); if (tenchinhan != chitiet.TenChiNhanh) { var soTCN = lst.Where(x => x.TenChiNhanh == chitiet.TenChiNhanh); _range[donghientai + stt, 1].PutValue(chitiet.TenChiNhanh); _range.Merge(donghientai + stt, 1, soTCN.Count(), 1); _range[donghientai + stt, 1].SetStyle(celicaStil); tenchinhan = chitiet.TenChiNhanh; } _range[donghientai + stt, 2].PutValue(chitiet.MaDiemDo + "-" + chitiet.TenDiemDo); _range[donghientai + stt, 3].PutValue(chitiet.Nhan_Bieu1_SanLuong); _range[donghientai + stt, 4].PutValue(chitiet.Giao_Bieu1_SanLuong); _range[donghientai + stt, 5].PutValue(chitiet.Nhan_Bieu2_SanLuong); _range[donghientai + stt, 6].PutValue(chitiet.Giao_Bieu2_SanLuong); _range[donghientai + stt, 7].PutValue(chitiet.Nhan_Bieu3_SanLuong); _range[donghientai + stt, 8].PutValue(chitiet.Giao_Bieu3_SanLuong); _range[donghientai + stt, 9].PutValue(chitiet.TongNhan3B); _range[donghientai + stt, 10].PutValue(chitiet.TongGiao3B); stt++; } foreach (var chitiet in lsttONG) { _range[donghientai + stt, 0].PutValue("Tổng"); _range.Merge(donghientai + stt, 0, 1, 3); _range[donghientai + stt, 3].PutValue(chitiet.NhanB1); _range[donghientai + stt, 4].PutValue(chitiet.GiaoB1); _range[donghientai + stt, 5].PutValue(chitiet.NhanB2); _range[donghientai + stt, 6].PutValue(chitiet.GiaoB2); _range[donghientai + stt, 7].PutValue(chitiet.NhanB3); _range[donghientai + stt, 8].PutValue(chitiet.GiaoB3); _range[donghientai + stt, 9].PutValue(chitiet.TongN3B); _range[donghientai + stt, 10].PutValue(chitiet.TongG3B); stt++; _range[donghientai + stt, 0].PutValue("Tổn hao"); _range.Merge(donghientai + stt, 0, 1, 3); _range[donghientai + stt, 3].PutValue(chitiet.TonHao1); _range.Merge(donghientai + stt, 3, 1, 2); _range[donghientai + stt, 5].PutValue(chitiet.TonHao2); _range.Merge(donghientai + stt, 5, 1, 2); _range[donghientai + stt, 7].PutValue(chitiet.TonHao3); _range.Merge(donghientai + stt, 7, 1, 2); _range[donghientai + stt, 9].PutValue(chitiet.TonHaoTong); _range.Merge(donghientai + stt, 9, 1, 2); stt++; _range[donghientai + stt, 0].PutValue("Tổng thất công ty"); _range.Merge(donghientai + stt, 0, 1, 3); _range[donghientai + stt, 3].PutValue(chitiet.TiLeTonThatB1); _range.Merge(donghientai + stt, 3, 1, 2); _range[donghientai + stt, 5].PutValue(chitiet.TiLeTonThatB2); _range.Merge(donghientai + stt, 5, 1, 2); _range[donghientai + stt, 7].PutValue(chitiet.TiLeTonThatb3); _range.Merge(donghientai + stt, 7, 1, 2); _range[donghientai + stt, 9].PutValue(chitiet.TiLeTonThat); _range.Merge(donghientai + stt, 9, 1, 2); break; } #endregion exBook.Save("bc_dienLuc.xls", SaveType.OpenInExcel, FileFormatType.Default, this.Response); //Response.Redirect("../BaoCao/Report.aspx?Loai=5&strSQL=" + strTruyVan); }
protected void btnCapNhat_Click(object sender, EventArgs e) { DM_DVQLYService dm_dviSer = new DM_DVQLYService(); SYS_Session session = (SYS_Session)Session["SYS_Session"]; string dvdaunguon = dm_dviSer.SelectDM_DVQLY(int.Parse(session.User.ma_dviqly)).MA_DVIQLY; if (Session["Add"] + "" == "0") { CBDN.DM_ChiNhanhSelectByIDDViResult cv = (CBDN.DM_ChiNhanhSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex); var lst = db.DM_ChiNhanhs.Where(x => x.MaChiNhanh == cv.MaChiNhanh); foreach (var qtCT in lst) { if (!CheckName(txtMaDuongDat.Text, cv.ID)) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã phương thức giao nhận được trùng');", true); return; } qtCT.TenChiNhanh = txtmoTa.Text; qtCT.MoTa = txtmoTa.Text; if (CkHoatDong.Checked) { qtCT.HoatDong = 1; } else { qtCT.HoatDong = 0; } db.SubmitChanges(); } } else { if (txtMaDuongDat.Text + "" == "") { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã chi nhánh không được để trống');", true); txtMaDuongDat.Focus(); return; } if (!CheckName(txtMaDuongDat.Text, 0)) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã chi nhánh không được trùng');", true); return; } CBDN.DM_ChiNhanh cv = new CBDN.DM_ChiNhanh(); cv.TenChiNhanh = txtmoTa.Text; cv.MaChiNhanh = txtMaDuongDat.Text; cv.IDMADVIQLY = int.Parse(session.User.ma_dviqly); cv.MoTa = txtmoTa.Text; cv.DiemDauNguon = int.Parse(session.User.ma_dviqly); cv.DiemCuoiNguon = int.Parse(session.User.ma_dviqly); if (CkHoatDong.Checked) { cv.HoatDong = 1; } else { cv.HoatDong = 0; } cv.ISNhaMay = true; cv.LoaiNhaMay = int.Parse(cmbloaiGiaoNhan.Value + ""); db.DM_ChiNhanhs.InsertOnSubmit(cv); db.SubmitChanges(); } pcAddRoles.ShowOnPageLoad = false; _DataBind(); }
protected void btnXuat_Click(object sender, EventArgs e) { MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"]; int ma_dviqly = int.Parse(session.User.ma_dviqly + ""); var lst = db.BC_ChiSoThang_ChuaChot(ma_dviqly, int.Parse("0" + cmbThang.Value), int.Parse("0" + cmbNam.Value)).ToList(); var lsttONG = db.BC_GiaoNhan2Chieu_TongTram(ma_dviqly, int.Parse("0" + cmbThang.Value), int.Parse("0" + cmbNam.Value)).ToList(); #region Chuẩn bị tệp excel mẫu để ghi dữ liệu string destFile = Server.MapPath("~/Tem/BC_BCDienLuc.xls"); string sTemplate = (destFile); Workbook exBook = new Workbook(); exBook.Open(sTemplate, FileFormatType.Excel2003); _exSheet = exBook.Worksheets[0]; _range = _exSheet.Cells; #endregion // Xử lý replace các thông tin báo cáo tĩnh theo công ty //Report.ReplaceSpecificationField(_exSheet); int donghientai = 7; #region Ghi dữ liệu _exSheet.Replace("NGAYTHANG", "Ngày " + DateTime.Now.Day + " tháng " + DateTime.Now.Month + " năm " + DateTime.Now.Year); Style celicaStil = exBook.Styles[exBook.Styles.Add()]; celicaStil.Font.IsBold = true; DM_DVQLYService dm_dviSer = new DM_DVQLYService(); var donvi = dm_dviSer.SelectDM_DVQLY(ma_dviqly); _exSheet.Replace("ntDienLuc", donvi.NAME_DVIQLY.Split('-')[1].ToUpper()); _exSheet.Replace("ntTieuDe", "BÁO CÁO SẢN LƯỢNG ĐIỆN GIAO CỦA " + donvi.NAME_DVIQLY.Split('-')[1].ToString().ToUpper() + " TRONG THÁNG " + cmbThang.Value + " NĂM " + cmbNam.Value); if (lst.Count > 0) { _exSheet.Cells.InsertRows(donghientai + 1, (lst.Count + lsttONG.Count * 2) - 3); } string idTram = "0"; int vitri = 0; int sttTong = 0, sttChiTiet = 0; foreach (var tongtram in lsttONG) { if (idTram != tongtram.IDTram + "") { var tram = db.DM_Trams.SingleOrDefault(x => x.IDTram == tongtram.IDTram); if (tram == null) { continue; } var phuongthuc = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(tram.IDChiNhanh)); if (phuongthuc == null) { continue; } _range[donghientai + vitri, 0].PutValue(phuongthuc.MoTa); _range.Merge(donghientai + vitri, 0, 1, 21); _range[donghientai + vitri, 0].SetStyle(celicaStil); vitri = vitri + 1; sttTong = sttTong + 1; _range[donghientai + vitri, 0].PutValue(sttTong); _range[donghientai + vitri, 0].SetStyle(celicaStil); _range[donghientai + vitri, 1].PutValue(tongtram.TenTram); _range[donghientai + vitri, 1].SetStyle(celicaStil); _range[donghientai + vitri, 7].PutValue(tongtram.slPGiao); _range[donghientai + vitri, 7].SetStyle(celicaStil); _range[donghientai + vitri, 11].PutValue(tongtram.slb1Giao); _range[donghientai + vitri, 11].SetStyle(celicaStil); _range[donghientai + vitri, 15].PutValue(tongtram.slb2Giao); _range[donghientai + vitri, 15].SetStyle(celicaStil); _range[donghientai + vitri, 19].PutValue(tongtram.slb3Giao); _range[donghientai + vitri, 19].SetStyle(celicaStil); vitri = vitri + 1; var lstByTram = lst.Where(x => x.IDTram == tongtram.IDTram).ToList(); sttChiTiet = sttChiTiet + 1; foreach (var chitiet in lstByTram) { _range[donghientai + vitri, 0].PutValue(sttTong + "." + sttChiTiet); _range[donghientai + vitri, 1].PutValue(chitiet.TenDiemDo); _range[donghientai + vitri, 2].PutValue(chitiet.CapDienAp); _range[donghientai + vitri, 3].PutValue(chitiet.HeSoNhan); _range[donghientai + vitri, 4].PutValue(chitiet.Giao_P_Dau); _range[donghientai + vitri, 5].PutValue(chitiet.Giao_P_Cuoi); _range[donghientai + vitri, 6].PutValue(chitiet.Giao_P_Cuoi - chitiet.Giao_P_Dau); _range[donghientai + vitri, 7].PutValue(chitiet.Giao_P_SanLuong); _range[donghientai + vitri, 8].PutValue(chitiet.Giao_Bieu1_Dau); _range[donghientai + vitri, 9].PutValue(chitiet.Giao_Bieu1_Cuoi); _range[donghientai + vitri, 10].PutValue(chitiet.Giao_Bieu1_Cuoi - chitiet.Giao_Bieu1_Dau); _range[donghientai + vitri, 11].PutValue(chitiet.Giao_Bieu1_SanLuong); _range[donghientai + vitri, 12].PutValue(chitiet.Giao_Bieu2_Dau); _range[donghientai + vitri, 13].PutValue(chitiet.Giao_Bieu2_Cuoi); _range[donghientai + vitri, 14].PutValue(chitiet.Giao_Bieu2_Cuoi - chitiet.Giao_Bieu2_Dau); _range[donghientai + vitri, 15].PutValue(chitiet.Giao_Bieu2_SanLuong); _range[donghientai + vitri, 16].PutValue(chitiet.Giao_Bieu3_Dau); _range[donghientai + vitri, 17].PutValue(chitiet.Giao_Bieu3_Cuoi); _range[donghientai + vitri, 18].PutValue(chitiet.Giao_Bieu3_Cuoi - chitiet.Giao_Bieu3_Dau); _range[donghientai + vitri, 19].PutValue(chitiet.Giao_Bieu3_SanLuong); vitri = vitri + 1; } idTram = tongtram.IDTram + ""; } } #endregion exBook.Save("bc_dienLuc.xls", SaveType.OpenInExcel, FileFormatType.Default, this.Response); //Response.Redirect("../BaoCao/Report.aspx?Loai=5&strSQL=" + strTruyVan); }
protected void btnCapNhat_Click(object sender, EventArgs e) { DM_DVQLYService dm_dviSer = new DM_DVQLYService(); SYS_Session session = (SYS_Session)Session["SYS_Session"]; string dvdaunguon = dm_dviSer.SelectDM_DVQLY(int.Parse(session.User.ma_dviqly)).MA_DVIQLY; string dvcuoinguon = dm_dviSer.SelectDM_DVQLY(int.Parse(cmbCuoiNguon.Value + "")).MA_DVIQLY; if (Session["Add"] + "" == "0") { CBDN.DM_ChiNhanhSelectByIDDViResult qtCT = (CBDN.DM_ChiNhanhSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex); //var lst = db.DM_ChiNhanhs.Where(x => x.MaChiNhanh == cv.MaChiNhanh); //foreach (var qtCT in lst) //{ CBDN.DM_ChiNhanh cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == qtCT.ID); if (!CheckName(txtMaDuongDat.Text, qtCT.ID)) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã phương thức giao nhận được trùng');", true); return; } cn.TenChiNhanh = txtmoTa.Text; cn.LoaiPhuongThuc = int.Parse(cmbLoaiPhuongThuc.Value + ""); cn.MoTa = txtmoTa.Text; if (CkHoatDong.Checked) { cn.HoatDong = 1; } else { cn.HoatDong = 0; } db.SubmitChanges(); //} } else { if (txtMaDuongDat.Text + "" == "") { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã chi nhánh không được để trống');", true); txtMaDuongDat.Focus(); return; } //if (txtTenDuongDay.Text == "") //{ // ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Tên chi nhánh không được để trống');", true); // txtTenDuongDay.Focus(); return; //} if (!CheckName(txtMaDuongDat.Text, 0)) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã chi nhánh không được trùng');", true); return; } CBDN.DM_ChiNhanh cv = new CBDN.DM_ChiNhanh(); cv.TenChiNhanh = txtmoTa.Text; cv.MaChiNhanh = dvdaunguon + "_" + dvcuoinguon; if (session.User.ma_dviqly != "" + cmbCuoiNguon.Value) { cv.IDMADVIQLY = "," + session.User.ma_dviqly + "," + cmbCuoiNguon.Value + ","; } else { cv.IDMADVIQLY = session.User.ma_dviqly; } cv.LoaiPhuongThuc = int.Parse(cmbLoaiPhuongThuc.Value + ""); cv.MoTa = txtmoTa.Text; cv.DiemDauNguon = int.Parse(session.User.ma_dviqly); cv.DiemCuoiNguon = int.Parse(cmbCuoiNguon.Value + ""); if (CkHoatDong.Checked) { cv.HoatDong = 1; } else { cv.HoatDong = 0; } db.DM_ChiNhanhs.InsertOnSubmit(cv); db.SubmitChanges(); //CBDN.DM_ChiNhanh cnGiaoNhan = new CBDN.DM_ChiNhanh(); //cnGiaoNhan.TenChiNhanh = txtmoTa.Text; //cnGiaoNhan.MaChiNhanh = dvdaunguon + "_" + dvcuoinguon; //cnGiaoNhan.IDMADVIQLY = int.Parse(cmbCuoiNguon.Value + ""); //cnGiaoNhan.MoTa = txtmoTa.Text; //cnGiaoNhan.DiemCuoiNguon = int.Parse(session.User.ma_dviqly); //cnGiaoNhan.DiemDauNguon = int.Parse(cmbCuoiNguon.Value + ""); //if (CkHoatDong.Checked) // cnGiaoNhan.HoatDong = 1; //else // cnGiaoNhan.HoatDong = 0; //db.DM_ChiNhanhs.InsertOnSubmit(cnGiaoNhan); //db.SubmitChanges(); //} } pcAddRoles.ShowOnPageLoad = false; _DataBind(); }