protected override void Render(HtmlTextWriter writer)
{
var sb = new StringBuilder();
var cs = this.Page.ClientScript;
#region Tham số
HttpContext c = HttpContext.Current;
var ID = c.Request["ID"];
var NDTC_ID = c.Request["NDTC_ID"];
var SoPhieu = c.Request["SoPhieu"];
var SoTien = c.Request["SoTien"];
var Mota = c.Request["Mota"];
var NgayTao = c.Request["NgayTao"];
var NguoiTao = c.Request["NguoiTao"];
var NgaySua = c.Request["NgaySua"];
var NguoiSua = c.Request["NguoiSua"];
var LoaiQuy = c.Request["LoaiQuy"];
var LoaiCandoi = c.Request["LoaiCandoi"];
var isCandoi = c.Request["isCandoi"];
var Thu = c.Request["Thu"];
var XN_ID = c.Request["XN_ID"];
var P_ID = c.Request["P_ID"];
var DV_ID = c.Request["DV_ID"];
var TuNgay = c.Request["TuNgay"];
var DenNgay = c.Request["DenNgay"];
var _q = c.Request["q"];
List <jgridRow> ListRow = new List <jgridRow>();
var danhMucKyHieu = DanhMucDal.SelectByMa("TC-THU");
var danhMucReportHeader = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI");
var danhMucReportFooter = DanhMucDal.SelectByMa("BAOCAO-FOOTER-THUCHI");
var draff = Request["draff"];
var isThu = true;
#endregion
switch (subAct)
{
case "get":
#region lấy dữ liệu cho grid
var pagerGet = ThuChiDal.pagerTuNgayDenNgay(jgrsidx + " " + jgrsord, _q, Convert.ToInt32(jgRows),
isThu, TuNgay, DenNgay, NDTC_ID, null, true);
string prefixMas = danhMucKyHieu.KyHieu;
foreach (var item in pagerGet.List)
{
ListRow.Add(new jgridRow(item.ID.ToString(), new string[] {
item.ID.ToString()
, item.NDTC_Ten
, prefixMas + item.SoPhieu
, item.P_Ten
, item.Mota
, item.NgayTao.ToString("dd-MM-yyyy")
, Lib.TienVietNam(item.SoTien)
, item.NguoiTao_Ten
, (item.NguoiTao == Security.Username).ToString()
, (item.XN_ID != Guid.Empty).ToString()
, (item.DV_ID != Guid.Empty).ToString()
}));
}
jgrid gridSPAdm = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage
, pagerGet.TotalPages.ToString()
, pagerGet.Total.ToString()
, ListRow);
sb.Append(JavaScriptConvert.SerializeObject(gridSPAdm));
break;
#endregion
case "del":
#region xóa
if (!string.IsNullOrEmpty(ID))
{
ThuChiDal.DeleteById(new Guid(ID));
}
break;
#endregion
case "edit":
#region chỉnh sửa
if (!string.IsNullOrEmpty(ID))
{
var item = ThuChiDal.SelectById(new Guid(ID));
string prefixMa = danhMucKyHieu.KyHieu;
item.SoPhieu = prefixMa + item.SoPhieu;
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(item));
}
break;
#endregion
case "draff":
#region draff
if (Security.IsAuthenticated())
{
var item = ThuChiDal.SelectByDraff(isThu);
string prefixMa = danhMucKyHieu.KyHieu;
item.SoPhieu = prefixMa + item.SoPhieu;
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(item));
}
break;
#endregion
case "save":
#region save
if (Security.IsAuthenticated())
{
var item = draff == "1" ? new ThuChi() : ThuChiDal.SelectById(new Guid(ID));
var prefixMa = danhMucKyHieu.KyHieu;
SoPhieu = SoPhieu.Replace(prefixMa, "");
item.SoPhieu = SoPhieu;
if (!string.IsNullOrEmpty(DV_ID))
{
item.DV_ID = new Guid(DV_ID);
}
item.LoaiCandoi = Convert.ToInt32(LoaiCandoi);
item.LoaiQuy = Convert.ToInt32(LoaiQuy);
item.Mota = Mota;
if (!string.IsNullOrEmpty(NDTC_ID))
{
item.NDTC_ID = new Guid(NDTC_ID);
}
item.NgaySua = DateTime.Now;
item.NguoiSua = Security.Username;
if (!string.IsNullOrEmpty(P_ID))
{
item.P_ID = new Guid(P_ID);
}
item.SoTien = Convert.ToDouble(SoTien);
item.Thu = isThu;
if (!string.IsNullOrEmpty(XN_ID))
{
item.XN_ID = new Guid(XN_ID);
}
item.isCandoi = true;
item.NgayTao = Convert.ToDateTime(NgayTao, new CultureInfo("vi-Vn"));
if (draff == "1")
{
item.ID = new Guid(ID);
item.NguoiTao = NguoiTao;
item = ThuChiDal.Insert(item);
}
else
{
item = ThuChiDal.Update(item);
}
// TODO: Tiếp tục phần thu chi
sb.Append("1");
}
break;
#endregion
case "reports":
#region bao cao
if (!string.IsNullOrEmpty(ID))
{
var itemIn = Lib.GetResource(Assembly.GetExecutingAssembly(), "quanLyThuDauKy.in-natural.htm");
var item = ThuChiDal.SelectById(new Guid(ID));
sb.AppendFormat(itemIn
, string.Format("Ngày {4}{0} tháng {3}{1} năm {2}", item.NgayTao.Day, item.NgayTao.Month, item.NgayTao.Year, item.NgayTao.Month < 10 ? "0" : "", item.NgayTao.Day < 10 ? "0" : "")
, item.NDTC_Ten
, string.Format("{0}{1}", danhMucKyHieu.KyHieu, item.SoPhieu)
, (item.LoaiQuy == 1 ? "Tài khoản" : "Tiền mặt")
, Lib.TienVietNam(item.SoTien)
, Lib.So_chu(item.SoTien)
, item.P_Ten
, item.NguoiTao_Ten
, item.Mota
, domain
, danhMucReportHeader.Description
, danhMucReportFooter.Description);
}
break;
#endregion
case "scpt":
#region Nạp js
sb.AppendFormat(@"{0}"
, cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.thuChiMgr.quanLyThuDauKy.JScript1.js"));
//sb.AppendFormat(@"{0}"
// , cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.thuChiMgr.quanLyThuDauKy.Publish.js"));
break;
#endregion
default:
#region nạp
var listFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId);
sb.Append(Lib.GetResource(Assembly.GetExecutingAssembly(), "quanLyThuDauKy.mdl.htm"));
sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>"
, cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.thuChiMgr.quanLyThuDauKy.JScript1.js")
, "{quanLyThuDauKyDauKyFn.loadgrid();}");
sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(listFn));
break;
#endregion
}
writer.Write(sb.ToString());
base.Render(writer);
}
protected override void Render(HtmlTextWriter writer)
{
var sb = new StringBuilder();
var cs = this.Page.ClientScript;
#region Tham số
var _ID = Request["ID"];
if (string.IsNullOrEmpty(_ID))
{
_ID = Guid.Empty.ToString();
}
var No = Request["No"];
HttpContext c = HttpContext.Current;
var listRow = new List <jgridRow>();
#endregion
switch (subAct)
{
case "get":
#region lấy dữ liệu cho grid
foreach (var item in KhachHangDal.SelectCongNo(No))
{
listRow.Add(new jgridRow(item.ID.ToString(), new string[]
{
item.ID.ToString()
, item.Ten
, Lib.TienVietNam(item.CongNoDauKy)
, Lib.TienVietNam(item.TongNhap)
, Lib.TienVietNam(item.TongXuat)
, Lib.TienVietNam(item.TongThu)
, Lib.TienVietNam(item.TongChi)
, Lib.TienVietNam(item.TongDichVu)
, Lib.TienVietNam(item.CongNo)
}));
}
var gridSpAdm = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage
, "1"
, "1000"
, listRow);
sb.Append(JavaScriptConvert.SerializeObject(gridSpAdm));
break;
#endregion
case "getSubXuat":
#region getSubXuat
if (!string.IsNullOrEmpty(_ID))
{
var danhMucLoaiXuatNhap = DanhMucDal.SelectByMa("LXN-X");
var pagerGet = XuatNhapDal.pagerXuatNhap(true.ToString(), false.ToString(), false.ToString(), false.ToString(), _ID,
jgrsidx + " " + jgrsord, string.Empty,
Convert.ToInt32(jgRows));
string prefixMas = danhMucLoaiXuatNhap.KyHieu;
foreach (var item in pagerGet.List)
{
listRow.Add(new jgridRow(item.ID.ToString(), new string[] {
item.ID.ToString()
, item.LOAI_Ten
, prefixMas + item.Ma
, item.KH_Ten
, item.NgayHoaDon.ToString("dd-MM-yyyy")
, Lib.TienVietNam(item.CongTienHang)
, Lib.TienVietNam(item.VAT)
, Lib.TienVietNam(item.ChietKhau)
, Lib.TienVietNam(item.CongTienHang + item.VAT - item.ChietKhau)
, Lib.TienVietNam(item.ThanhToan)
, Lib.TienVietNam(item.ConNo)
, string.Format("{0:dd/MM/yy}", item.NgayCapNhat)
}));
}
jgrid gridSPAdm = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage
, pagerGet.TotalPages.ToString()
, pagerGet.Total.ToString()
, listRow);
sb.Append(JavaScriptConvert.SerializeObject(gridSPAdm));
}
break;
#endregion
case "getSubNhap":
#region getSubNhap
if (!string.IsNullOrEmpty(_ID))
{
var danhMucLoaiXuatNhap = DanhMucDal.SelectByMa("LXN-N");
var pagerGet = XuatNhapDal.pagerXuatNhap(false.ToString(), false.ToString(), false.ToString(), false.ToString(), _ID,
jgrsidx + " " + jgrsord, string.Empty,
Convert.ToInt32(jgRows));
string prefixMas = danhMucLoaiXuatNhap.KyHieu;
foreach (var item in pagerGet.List)
{
listRow.Add(new jgridRow(item.ID.ToString(), new string[] {
item.ID.ToString()
, item.LOAI_Ten
, prefixMas + item.Ma
, item.KH_Ten
, item.NgayHoaDon.ToString("dd-MM-yyyy")
, Lib.TienVietNam(item.CongTienHang)
, Lib.TienVietNam(item.VAT)
, Lib.TienVietNam(item.ChietKhau)
, Lib.TienVietNam(item.CongTienHang + item.VAT - item.ChietKhau)
, Lib.TienVietNam(item.ThanhToan)
, Lib.TienVietNam(item.ConNo)
, string.Format("{0:dd/MM/yy}", item.NgayCapNhat)
}));
}
jgrid gridSPAdm = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage
, pagerGet.TotalPages.ToString()
, pagerGet.Total.ToString()
, listRow);
sb.Append(JavaScriptConvert.SerializeObject(gridSPAdm));
}
break;
#endregion
case "getSubThu":
#region getSubThu
if (!string.IsNullOrEmpty(_ID))
{
var pagerGet = ThuChiDal.pagerTuNgayDenNgay(jgrsidx + " " + jgrsord, null,
Convert.ToInt32(jgRows),
true, null, null, null, _ID);
var danhMucKyHieu = DanhMucDal.SelectByMa("TC-THU");
string prefixMas = danhMucKyHieu.KyHieu;
foreach (var item in pagerGet.List)
{
listRow.Add(new jgridRow(item.ID.ToString(), new string[] {
item.ID.ToString()
, item.NDTC_Ten
, prefixMas + item.SoPhieu
, item.P_Ten
, item.Mota
, item.NgayTao.ToString("dd-MM-yyyy")
, Lib.TienVietNam(item.SoTien)
, item.NguoiTao_Ten
, (item.NguoiTao == Security.Username).ToString()
, (item.XN_ID != Guid.Empty).ToString()
, (item.DV_ID != Guid.Empty).ToString()
}));
}
jgrid gridSPAdm = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage
, pagerGet.TotalPages.ToString()
, pagerGet.Total.ToString()
, listRow);
sb.Append(JavaScriptConvert.SerializeObject(gridSPAdm));
}
break;
#endregion
case "getSubChi":
#region lấy dữ liệu cho getSubThu
if (!string.IsNullOrEmpty(_ID))
{
var pagerGet = ThuChiDal.pagerTuNgayDenNgay(jgrsidx + " " + jgrsord, null,
Convert.ToInt32(jgRows),
false, null, null, null, _ID);
var danhMucKyHieu = DanhMucDal.SelectByMa("TC-CHI");
string prefixMas = danhMucKyHieu.KyHieu;
foreach (var item in pagerGet.List)
{
listRow.Add(new jgridRow(item.ID.ToString(), new string[] {
item.ID.ToString()
, item.NDTC_Ten
, prefixMas + item.SoPhieu
, item.P_Ten
, item.Mota
, item.NgayTao.ToString("dd-MM-yyyy")
, Lib.TienVietNam(item.SoTien)
, item.NguoiTao_Ten
, (item.NguoiTao == Security.Username).ToString()
, (item.XN_ID != Guid.Empty).ToString()
, (item.DV_ID != Guid.Empty).ToString()
}));
}
jgrid gridSPAdm = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage
, pagerGet.TotalPages.ToString()
, pagerGet.Total.ToString()
, listRow);
sb.Append(JavaScriptConvert.SerializeObject(gridSPAdm));
}
break;
#endregion
case "scpt":
#region Nạp js
sb.AppendFormat(@"{0}"
, cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.thuChiMgr.baoCaoNo.JScript1.js"));
//sb.AppendFormat(@"{0}"
// , cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.thuChiMgr.baoCaoNo.Publish.js"));
break;
#endregion
default:
#region nạp
var listFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId);
sb.Append(Lib.GetResource(Assembly.GetExecutingAssembly(), "baoCaoNo.mdl.htm"));
sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>"
, cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.thuChiMgr.baoCaoNo.JScript1.js")
, "{baoCaoNoFn.loadgrid();}");
sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(listFn));
break;
#endregion
}
writer.Write(sb.ToString());
base.Render(writer);
}