public void Edit(int id, string field, string oldvalue, string newvalue, object BangSD)
{
Newtonsoft.Json.Linq.JObject node = JSON.Deserialize <Newtonsoft.Json.Linq.JObject>(BangSD.ToString());
if (field.Substring(0, 2) == "dk")
{
daDuKienChiTra dDKCT = new daDuKienChiTra();
dDKCT.DKCTra.MaKeToanNgay = node.Property("MaKeToanNgay").Value.ToString();
dDKCT.DKCTra.MaBuuCuc = node.Property("MaBuuCuc").Value.ToString();
dDKCT.DKCTra.Ngay = DateTime.Parse(node.Property("Ngay").Value.ToString());
try
{
dDKCT.DKCTra.TCBCTapTrung = decimal.Parse(node.Property("dkTCBCTapTrung").Value.ToString());
}
catch { dDKCT.DKCTra.TCBCTapTrung = 0; }
try
{
dDKCT.DKCTra.TCBCThanhToanTaiDonVi = decimal.Parse(node.Property("dkTCBCThanhToanTaiDonVi").Value.ToString());
}
catch { dDKCT.DKCTra.TCBCThanhToanTaiDonVi = 0; }
try
{
dDKCT.DKCTra.TKBD = decimal.Parse(node.Property("dkTKBD").Value.ToString());
}
catch { dDKCT.DKCTra.TKBD = 0; }
try
{
dDKCT.DKCTra.KinhDoanh = decimal.Parse(node.Property("dkKinhDoanh").Value.ToString());
}
catch { dDKCT.DKCTra.KinhDoanh = 0; }
try
{
dDKCT.DKCTra.Cong = decimal.Parse(node.Property("dkCong").Value.ToString());
}
catch { dDKCT.DKCTra.Cong = 0; }
dDKCT.ThemSua();
}
else
{
daDuCuoiTienMat dDC = new daDuCuoiTienMat();
dDC.TM.MaKeToanNgay = node.Property("MaKeToanNgay").Value.ToString();
dDC.TM.MaBuuCuc = node.Property("MaBuuCuc").Value.ToString();
dDC.TM.Ngay = DateTime.Parse(node.Property("Ngay").Value.ToString());
try
{
dDC.TM.TCBCTapTrung = decimal.Parse(node.Property("TCBCTapTrung").Value.ToString());
}
catch { dDC.TM.TCBCTapTrung = 0; }
try
{
dDC.TM.TCBCThanhToanTaiDonVi = decimal.Parse(node.Property("TCBCThanhToanTaiDonVi").Value.ToString());
}
catch { dDC.TM.TCBCThanhToanTaiDonVi = 0; }
try
{
dDC.TM.TKBD = decimal.Parse(node.Property("TKBD").Value.ToString());
}
catch { dDC.TM.TKBD = 0; }
try
{
dDC.TM.KinhDoanh = decimal.Parse(node.Property("KinhDoanh").Value.ToString());
}
catch { dDC.TM.KinhDoanh = 0; }
try
{
dDC.TM.Cong = decimal.Parse(node.Property("Cong").Value.ToString());
}
catch { dDC.TM.Cong = 0; }
dDC.ThemSua();
}
grdSoDuTMCuoiNgay.GetStore().GetById(id).Commit();
}
protected void InAn_Click(object sender, DirectEventArgs e)
{
string json = e.ExtraParams["ValuesDCN"];
if (json == "")
{
return;
}
daDuCuoiTienMat dDCTM = new daDuCuoiTienMat();
daDuKienChiTra dDK = new daDuKienChiTra();
sp_tblGiayDeNghiTiepQuy_DanhSachResult pt = new sp_tblGiayDeNghiTiepQuy_DanhSachResult();
pt.TongSoDuTien = 0;
pt.SoDuTienMat = 0;
pt.SoDuTienMatTaiBuuCuc = 0;
pt.SoDuTienMatTaiBDH = 0;
pt.SoDuTienDangChuyen = 0;
pt.dkctBangTienMat = 0;
pt.DuKienChiTra = 0;
pt.SoTienQuyKhacVay = 0;
pt.SoTienVayQuyKhac = 0;
dDCTM.TM.MaKeToanNgay = json;
if (dDCTM.ThongTin() != null)
{
pt.TongSoDuTien = dDCTM.TM.Cong;
pt.SoDuTienMat = dDCTM.TM.TCBCTapTrung;
pt.SoDuTienMatTaiBuuCuc = dDCTM.TM.TCBCThanhToanTaiDonVi;
pt.SoDuTienMatTaiBDH = dDCTM.TM.TKBD;
pt.SoDuTienDangChuyen = dDCTM.TM.KinhDoanh;
}
dDK.DKCTra.MaKeToanNgay = json;
if (dDK.ThongTin() != null)
{
pt.dkctBangTienMat = dDK.DKCTra.Cong;
pt.DuKienChiTra = dDK.DKCTra.Cong;
}
pt.SoTienDeNghi = pt.DuKienChiTra - pt.TongSoDuTien;
if (pt.SoTienDeNghi < 0)
{
pt.SoTienDeNghi = 0;
}
pt.SoTienDeNghi = Math.Round((pt.SoTienDeNghi.Value) / 1000000, 0) * 1000000;
DocSo.DocSo ds = new DocSo.DocSo();
pt.BangChu = ds.DocSoDayDu(pt.SoTienDeNghi.ToString()) + " đồng";
pt.Ngay = DateTime.Parse(json.Substring(10, 2) + "/" + json.Substring(12, 2) + "/" + json.Substring(6, 4));
pt.NoiDung = "V/v đề nghị tiếp quỹ TCBC Ngày " + pt.Ngay.Value.AddDays(1).ToString("dd/MM/yyyy");
pt.NoiLuuVB = "Bưu cục";
daSoDuCuoiNgay dSDCK = new daSoDuCuoiNgay();
if (dSDCK.ThongTinBuuCuc(UIHelper.daPhien.MaDonVi) != null)
{
pt.TrinhDonVi = "Giám đốc " + dSDCK.BuuCuc.DonVi;
}
List <sp_tblGiayDeNghiTiepQuy_DanhSachResult> lstBC = new List <sp_tblGiayDeNghiTiepQuy_DanhSachResult>();
lstBC.Add(pt);
crGiayDeNghiTiepQuyBuuCuc rptGDN = new crGiayDeNghiTiepQuyBuuCuc();
rptGDN.SetDataSource(daTienIch.ToDataTable(lstBC));
rptGDN.SetParameterValue(0, dSDCK.BuuCuc.DonVi);
rptGDN.SetParameterValue(1, dSDCK.BuuCuc.BuuCuc);
rptGDN.SetParameterValue(2, dSDCK.BuuCuc.TenTat);
string _tf;
_tf = UIHelper.daPhien.TenFileInBaoCao("GiayDeNghiTiepQuy");
rptGDN.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Server.MapPath("~") + _tf);
string _url = UIHelper.daPhien.LayDiaChiURL(_tf);
string script = "window.open('" + _url + "', '')";
this.btnThangSau.AddScript(script);
/*crBieuNhapBaoCaoNhanhDonVi rptBCN = new crBieuNhapBaoCaoNhanhDonVi();
* rptBCN.SetDataSource(dBCN.DanhSachNhapBCN());
*
* rptBCN.SetParameterValue(0, "BƯU ĐIỆN THÀNH PHỐ HÀ NỘI");
* rptBCN.SetParameterValue(1, UIHelper.daPhien.ThongTinDN.TenDonVi);
* rptBCN.SetParameterValue(2, "BÁO CÁO NHANH TÌNH HÌNH SẢN XUẤT KINH DOANH CỦA ĐƠN VỊ");
* rptBCN.SetParameterValue(3, "Tháng " + Thang.ToString() + " Năm " + Nam.ToString());
* rptBCN.SetParameterValue(4, UIHelper.daPhien.TenNguoiSuDung);
*
* string _tf;
* _tf = UIHelper.daPhien.TenFileInBaoCao("SoLieu");
* rptBCN.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Server.MapPath("..") + _tf);
* //string _url = UIHelper.daPhien.LayDiaChiURL("/BaoCao/frmHienThiBaoCao.aspx") + "?TenFilePDF=" + _tf;
* string _url = UIHelper.daPhien.LayDiaChiURL(_tf);
*
* string script = "window.open('" + _url + "', '')";
* this.btnIn.AddScript(script);*/
}
