protected void Page_Load(object sender, EventArgs e)
{
var q = Request["q"];
var size = Request["size"];
if (string.IsNullOrEmpty(size))
{
size = "10";
}
var dmId = Request["DM_ID"];
var gia = Request["Gia"];
var url = string.Format("?q={0}&size={1}&DM_ID={2}&Gia={3}", q, size, dmId, gia) + "{1}={0}";
using (var con = DAL.con())
{
var pg =
HangHoaDal.KhoVay(con, url, false, null, q, Convert.ToInt32(size), dmId, gia);
List.List = pg.List;
paging = pg.Paging;
var nhomHangHoa = DanhMucDal.SelectByLDMMa(con, "HangHoa");
DM_ID.List = nhomHangHoa;
}
}
public static TuVanTinhTrang getFromReader(IDataReader rd)
{
var Item = new TuVanTinhTrang();
if (rd.FieldExists("TTDV_ID"))
{
Item.ID = (Guid)(rd["TTDV_ID"]);
}
if (rd.FieldExists("TTDV_TV_ID"))
{
Item.TV_ID = (Guid)(rd["TTDV_TV_ID"]);
}
if (rd.FieldExists("TTDV_TT_ID"))
{
Item.TT_ID = (Guid)(rd["TTDV_TT_ID"]);
}
if (rd.FieldExists("TTDV_ThuTu"))
{
Item.ThuTu = (Int32)(rd["TTDV_ThuTu"]);
}
if (rd.FieldExists("TTDV_NgayTao"))
{
Item.NgayTao = (DateTime)(rd["TTDV_NgayTao"]);
}
Item._DanhMuc = DanhMucDal.getFromReader(rd);
return(Item);
}
protected void Page_Load(object sender, EventArgs e)
{
var loggedIn = Security.IsAuthenticated();
var Id = Request["Id"];
var LDM = Request["LDM"];
var q = Request["q"];
switch (subAct)
{
case "search":
#region search
var list = !string.IsNullOrEmpty(q) ? DanhMucDal.SelectByLDMMa(LDM).Where(x => x.Ten.ToLower().Contains(q) || x.Ma.ToLower().Contains(q)).ToList() : DanhMucDal.SelectByLDMMa(LDM);
rendertext(JavaScriptConvert.SerializeObject(list), "text/javascript");
break;
#endregion
default:
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
var khId = Request["KH_ID"];
SuKien Item;
using (var con = DAL.con())
{
if (string.IsNullOrEmpty(id))
{
Item = new SuKien();
if (!string.IsNullOrEmpty(khId))
{
if (khId.Length > 36)
{
khId = khId.Substring(khId.LastIndexOf(',') + 1);
}
var kh = KhachHangDal.SelectById(new Guid(khId), con);
Item.KH_Ten = kh.Ten;
Item.KH_ID = kh.ID;
}
Add1.Item = Item;
}
else
{
Item = SuKienDal.SelectById(new Guid(id));
Item.KH_Ten = maHoa.DecryptString(Item.KH_Ten, Item.KH_ID.ToString());
Add1.Item = Item;
}
var listLoai = DanhMucDal.SelectByLDMMa(con, "NHOM-SK");
Add1.ListLoai = listLoai;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var q = Request["q"];
var size = Request["size"];
if (string.IsNullOrEmpty(size))
{
size = "10";
}
var khuVucId = Request["KhuVuc_Id"];
var nguonGocId = Request["NguonGoc_Id"];
var linhVucId = Request["LinhVuc_Id"];
var tuNgay = Request["TuNgay"];
var denNgay = Request["DenNgay"];
using (var con = DAL.con())
{
var pg =
KhachHangDal.pagerAll(con,
string.Format("?q={0}&size={1}&KhuVuc_Id={2}&NguonGoc_Id={3}&LinhVuc_Id={4}&TuNgay={5}&DenNgay={6}&", q, size, khuVucId,
nguonGocId, linhVucId, tuNgay, denNgay) + "{1}={0}", false, null, q, Convert.ToInt32(size), khuVucId,
nguonGocId, linhVucId, "0", tuNgay, denNgay);
DanhSachAll1.List = pg.List;
paging = pg.Paging;
var nguonGocList = DanhMucDal.SelectByLDMMa(con, "NGUON-KH");
var khuVucList = DanhMucDal.SelectByLDMMa(con, "KHUVUC");
var linhVucList = DanhMucDal.SelectByLDMMa(con, "LINHVUC-KH");
LinhVuc.List = linhVucList;
NguonGoc.List = nguonGocList;
KhuVuc.List = khuVucList;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
var khId = Request["KH_ID"];
var list = new List <PhieuXuatNhapSanPhamChiTiet>();
using (var con = DAL.con())
{
if (string.IsNullOrEmpty(id))
{
Item = ChoThueVayDal.SelectDraff(con);
Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1;
Item.ID = Guid.NewGuid();
if (!string.IsNullOrEmpty(khId))
{
var kh = KhachHangDal.SelectById(new Guid(khId), con);
Item.KH_ID = kh.ID;
Item.KH_Ten = kh.Ten;
}
}
else
{
Item = ChoThueVayDal.SelectById(con, new Guid(id));
list = PhieuXuatNhapSanPhamChiTietDal.SelectByPxnSpId(con, id);
}
var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description;
Add.LogoStr = logoStr;
Add.List = list;
Add.Item = Item;;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
var khId = Request["KH_ID"];
var pdvId = Request["PDV_ID"];
using (var con = DAL.con())
{
if (string.IsNullOrEmpty(id))
{
Item = ThuChiDal.SelectByDraff(con, false);
if (khId != null && khId.Length > 36)
{
khId = khId.Substring(khId.LastIndexOf(',') + 1);
var kh = KhachHangDal.SelectById(new Guid(khId), con);
Item.P_Ten = kh.Ten;
Item.P_ID = kh.ID;
}
}
else
{
Item = ThuChiDal.SelectById(con, new Guid(id));
}
var listLoai = DanhMucDal.SelectByLDMMa(con, "NDTC-CHI");
AddChi.ListLoai = listLoai;
AddChi.Item = Item;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var loggedIn = Security.IsAuthenticated();
var Id = Request["Id"];
var LDM = Request["LDM"];
var q = Request["q"];
switch (subAct)
{
case "search":
#region search
var pgResult = DanhMucDal.SelectByLDMMa(LDM);
rendertext(JavaScriptConvert.SerializeObject(pgResult), "text/javascript");
break;
#endregion
default:
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var q = Request["q"];
var size = Request["size"];
var tt_id = Request["TT_ID"];
var giaoHang = Request["GiaoHang"];
var TuNgay = Request["TuNgay"];
var DenNgay = Request["DenNgay"];
var dNow = DateTime.Now;
var dauThang = new DateTime(dNow.Year, 1, 1).ToString("yyyy-MM-dd");
var cuoiThang = new DateTime(dNow.Year, dNow.Month, 1).AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd");
TuNgay = string.IsNullOrEmpty(TuNgay) ? dauThang : Convert.ToDateTime(TuNgay, new CultureInfo("vi-Vn")).ToString("yyyy-MM-dd");
DenNgay = string.IsNullOrEmpty(DenNgay) ? cuoiThang : Convert.ToDateTime(DenNgay, new CultureInfo("vi-Vn")).ToString("yyyy-MM-dd");
if (string.IsNullOrEmpty(size))
{
size = "30";
}
using (var con = DAL.con())
{
var listLoai = DanhMucDal.SelectByLDMMa(con, "NDTC-CHI");
DM_ID.List = listLoai;
var pg = ThuChiReportDal.SelectTuNgayDenNgay(TuNgay, DenNgay);
List.List = pg;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
var listDuyetAnh = new List <DuyetAnh>();
var listBaiHat = new List <BaiHat>();
using (var con = DAL.con())
{
if (string.IsNullOrEmpty(id))
{
Item = PhieuDichVuDal.SelectDraff(con);
Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1;
Item.ID = Guid.NewGuid();
}
else
{
Item = PhieuDichVuDal.SelectById(con, new Guid(id));
listDuyetAnh = DuyetAnhDal.SelectByPdvId(con, id);
listBaiHat = BaiHatDal.SelectByPdvId(con, id);
var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description;
Add.LogoStr = logoStr;
}
Add.ListDuyetAnh = listDuyetAnh;
Add.ListBaiHat = listBaiHat;
Add.Item = Item;;
}
}
protected override void Render(HtmlTextWriter writer)
{
StringBuilder sb = new StringBuilder();
bool login_fe = Security.IsAuthenticated();
string subAct = Request["subAct"];
ClientScriptManager cs = this.Page.ClientScript;
if (subAct != "dangky_home" && subAct != "Ho_tro_khach_hang")
{
sb.AppendFormat("jQuery.getScript('{0}',"
, cs.GetWebResourceUrl(typeof(Class1), "docsoft.hethong.DangNhap.JScript1.js"));
sb.Append("function(){");
}
string Ma = Request["Ma"];
if (!Security.IsAuthenticated())
{
switch (subAct)
{
case "lite":
#region thu nhỏ
if (login_fe)
{
sb.AppendFormat("DangNhap.setup('{0}');", Security.Username);
}
else
{
sb.AppendFormat("DangNhap.login_fe('{0}');", Ma);
}
break;
#endregion
case "dangky_home":
{
sb.Append("(" + JavaScriptConvert.SerializeObject(DanhMucDal.SelectByMa(Ma)) + ")");
break;
}
default:
if (login_fe && !Security.IsAuthenticated())
{
sb.AppendFormat("DangNhap.setup('{0}');", Security.Username);
}
else
{
sb.AppendFormat("DangNhap.login_fe('{0}');", Ma);
}
break;
}
}
if (subAct != "dangky_home" && subAct != "Ho_tro_khach_hang")
{
sb.Append("});");
}
writer.Write(sb.ToString());
base.Render(writer);
}
protected void Page_Load(object sender, EventArgs e)
{
var q = Request["q"];
var khId = Request["KH_ID"];
var ndtcId = Request["NDTC_ID"];
var size = Request["size"];
if (string.IsNullOrEmpty(size))
{
size = "10";
}
var url = string.Format("?q={0}&size={1}&NDTC_ID={2}&", q, size, ndtcId) + "{1}={0}";
var tuNgay = Request["TuNgay"];
var denNgay = Request["DenNgay"];
if (!string.IsNullOrEmpty(tuNgay))
{
if (string.IsNullOrEmpty(denNgay))
{
tuNgay = Server.UrlDecode(tuNgay);
var d = Convert.ToDateTime(tuNgay, new CultureInfo("Vi-vn"));
tuNgay = d.AddDays(-1).ToString("yyyy-MM-dd");
denNgay = d.AddDays(1).ToString("yyyy-MM-dd");
}
else
{
tuNgay = Server.UrlDecode(tuNgay);
var d = Convert.ToDateTime(tuNgay, new CultureInfo("Vi-vn"));
tuNgay = d.ToString("yyyy-MM-dd");
denNgay = Server.UrlDecode(denNgay);
var d1 = Convert.ToDateTime(denNgay, new CultureInfo("Vi-vn"));
denNgay = d1.ToString("yyyy-MM-dd");
}
}
using (var con = DAL.con())
{
var listLoai = DanhMucDal.SelectByLDMMa(con, "NDTC-THU");
DM_ID.List = listLoai;
var pg =
ThuChiDal.pagerNormal(con, url, false, "TC_SoPhieu desc", q, Convert.ToInt32(size), true, ndtcId, tuNgay,
denNgay);
List.List = pg.List;
paging = pg.Paging;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
using (var con = DAL.con())
{
if (!string.IsNullOrEmpty(id))
{
Item = ChoThueVayDal.SelectById(con, new Guid(id));
ThanhLyIn.Item = Item;;
ThanhLyIn.Khach = KhachHangDal.SelectById(Item.KH_ID, con);
var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description;
ThanhLyIn.LogoStr = logoStr;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
using (var con = DAL.con())
{
Item = PhieuXuatNhapSanPhamDal.SelectById(con, new Guid(id));
var phieuDichVuItem = PhieuDichVuDal.SelectById(con, Item.PDV_ID);
var khachHangItem = KhachHangDal.SelectById(phieuDichVuItem.KH_ID, con);
Print.Item = Item;
Print.Khach = khachHangItem;
var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description;
Print.LogoStr = logoStr;
}
}
public override void KhoiTao(SqlConnection con)
{
var sb = new StringBuilder();
var listDm = GetTree(DanhMucDal.SelectByLDMMa(con, "MENU"));
var list1 = from p in listDm
where p.Level == 1
orderby p.ThuTu ascending
select p;
sb.AppendFormat(@"
<div class=""bodyGlobal top-navi"">
<div class=""boxGlobal"">
<div class=""box1Global"">");
// var itemDm = DanhMucDal.SelectByMa("HETHONG-LOGO", con);
// sb.AppendFormat(@"
//<div class=""top"">
// <div class=""logo-pnl"">
// {0}
// </div>
//</div>", String.IsNullOrEmpty(itemDm.Description) ? string.Format(@"<a href="""" class=""logo""></a>") : itemDm.Description);
sb.Append(@"<div class=""navi-top""><ul>");
foreach (DanhMuc item in list1)
{
sb.AppendFormat(@"<li class=""menu-li""><a title=""{1}"" class=""navi-top-item"" href=""{0}"">{1}</a>"
, string.Format(item.GiaTri, domain)
, item.Ten);
sb.Append(GetSub(listDm, item));
sb.Append("</li>");
}
sb.Append("</ul></div>");
sb.AppendFormat(@"</div>
</div>
</div>");
Html = sb.ToString();
base.KhoiTao(con);
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
using (var con = DAL.con())
{
if (string.IsNullOrEmpty(id))
{
Item = PhieuDichVuDal.SelectDraff(con);
Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1;
Item.ID = Guid.NewGuid();
}
else
{
Item = PhieuDichVuDal.SelectById(con, new Guid(id));
Item._KhachHang = KhachHangDal.SelectById(Item.KH_ID, con);
}
var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description;
Add.LogoStr = logoStr;
Add.Item = Item;;
}
}
public override void KhoiTao(SqlConnection con)
{
var sb = new StringBuilder();
#region header
sb.AppendFormat(@"
<div class=""{0}"">
<div class=""box-header"">
<a href=""{2}"" class=""box-header-label"">{1}</a>
</div>
<div class=""box-body"">", Css, Ten, Header_Url);
#endregion
var itemDm = DanhMucDal.SelectByMa(Ma, con);
sb.Append(itemDm.Description);
#region footer
sb.AppendFormat(@"
</div>
</div>");
#endregion
Html = sb.ToString();
base.KhoiTao(con);
}
protected void Page_Load(object sender, EventArgs e)
{
var q = Request["q"];
var dm_id = Request["DM_ID"];
var khId = Request["KH_ID"];
var NHANVIEN_ID = Request["NHANVIEN_ID"];
var size = Request["size"];
if (string.IsNullOrEmpty(size))
{
size = "10";
}
Ngay = Request["Ngay"];
using (var con = DAL.con())
{
var ListLoai = DanhMucDal.SelectByLDMMa(con, "NHOM-SK");
DM_ID.List = ListLoai;
var tuNgay = "";
var denNgay = "";
if (!string.IsNullOrEmpty(Ngay))
{
Ngay = Server.UrlDecode(Ngay);
var d = Convert.ToDateTime(Ngay, new CultureInfo("Vi-vn"));
tuNgay = new DateTime(d.Year, d.Month, d.Day).ToString("yyyy-MM-dd");
denNgay = new DateTime(d.Year, d.Month, d.Day).AddDays(1).ToString("yyyy-MM-dd");
}
var pg =
SuKienDal.pagerNormal(
string.Format("?q={0}&size={1}&DM_ID={2}&KH_ID={3}&NHANVIEN_ID={4}&", q, size, dm_id, khId, NHANVIEN_ID) + "{1}={0}"
, false, "SK_NgayBatDau desc", q, Convert.ToInt32(size)
, dm_id, khId, NHANVIEN_ID, null, null, tuNgay, denNgay);
paging = pg.Paging;
DanhSach1.List = pg.List;
}
}
public override void KhoiTao(SqlConnection con)
{
var sb = new StringBuilder();
var listDm = GetTree(DanhMucDal.SelectByLDMMa(con, "MENU"));
var list1 = from p in listDm
where p.Level == 1
orderby p.ThuTu ascending
select p;
sb.AppendFormat(@"
<div class=""bodyGlobal footer"">
<div class=""boxGlobal"">
<div class=""box1Global"">");
var itemDm = DanhMucDal.SelectByMa("HETHONG-FOOTER", con);
sb.Append(itemDm.Description);
sb.AppendFormat(@"</div>
</div>
</div>");
Html = sb.ToString();
base.KhoiTao(con);
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
using (var con = DAL.con())
{
if (string.IsNullOrEmpty(id))
{
Add1.Item = new KhachHang();;
}
else
{
Add1.Item = KhachHangDal.SelectById(new Guid(id));
}
var nguonGocList = DanhMucDal.SelectByLDMMa(con, "NGUON-KH");
var khuVucList = DanhMucDal.SelectByLDMMa(con, "KHUVUC");
var linhVucList = DanhMucDal.SelectByLDMMa(con, "LINHVUC-KH");
Add1.NguonGoc = nguonGocList;
Add1.KhuVuc = khuVucList;
Add1.LinhVuc = linhVucList;
}
}
protected override void Render(HtmlTextWriter writer)
{
var sb = new StringBuilder();
var cs = this.Page.ClientScript;
#region Tham số
HttpContext c = HttpContext.Current;
var TuNgay = c.Request["TuNgay"];
var DenNgay = c.Request["DenNgay"];
var dNow = DateTime.Now;
var dauThang = new DateTime(dNow.Year, 1, 1).ToString("yyyy-MM-dd");
var cuoiThang = new DateTime(dNow.Year, dNow.Month, 1).AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd");
TuNgay = string.IsNullOrEmpty(TuNgay) ? dauThang : Convert.ToDateTime(TuNgay, new CultureInfo("vi-Vn")).ToString("yyyy-MM-dd");
DenNgay = string.IsNullOrEmpty(DenNgay) ? cuoiThang : Convert.ToDateTime(DenNgay, new CultureInfo("vi-Vn")).ToString("yyyy-MM-dd");
var _q = c.Request["q"];
List <jgridRow> ListRow = new List <jgridRow>();
var danhMucKyHieuChi = DanhMucDal.SelectByMa("TC-CHI");
var danhMucKyHieuThu = DanhMucDal.SelectByMa("TC-THU");
#endregion
switch (subAct)
{
case "get":
#region lấy dữ liệu cho grid
var pagerGet = ThuChiReportDal.SelectTuNgayDenNgay(TuNgay, DenNgay);
var prefixMaChi = danhMucKyHieuChi.KyHieu;
var prefixMaThu = danhMucKyHieuThu.KyHieu;
foreach (var item in pagerGet)
{
ListRow.Add(new jgridRow(item.ma.ToString(), new string[]
{
item.ma.ToString()
,
item.sophieu == "0" ? "" : string.Format("{0}{1}",
(item.isthu
? prefixMaThu
: prefixMaChi),
item.sophieu)
, item.diengiai
, Lib.TienVietNam(item.thu_tk)
, Lib.TienVietNam(item.thu_tm)
, Lib.TienVietNam(item.thu_t)
, Lib.TienVietNam(item.chi_tk)
, Lib.TienVietNam(item.chi_tm)
, Lib.TienVietNam(item.chi_t)
, Lib.TienVietNam(item.tt_tk)
, Lib.TienVietNam(item.tt_tm)
, Lib.TienVietNam(item.tt_t)
, Lib.TienVietNam(item.sodu_tk)
, Lib.TienVietNam(item.sodu_tm)
, Lib.TienVietNam(item.sodu_t)
, item.loaiquy.ToString()
, item.isthu.ToString()
, item.isCandoi.ToString()
, item.ngay
, item.NguoiTao
}));
}
jgrid gridSPAdm = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage
, "1"
, pagerGet.Count.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.baoCaoThuChi.JScript1.js"));
//sb.AppendFormat(@"{0}"
// , cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.thuChiMgr.baoCaoThuChi.Publish.js"));
break;
#endregion
default:
#region nạp
var listFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId);
sb.Append(Lib.GetResource(Assembly.GetExecutingAssembly(), "baoCaoThuChi.mdl.htm"));
sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>"
, cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.thuChiMgr.baoCaoThuChi.JScript1.js")
, "{baoCaoThuChiFn.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);
}
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 void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
var khId = Request["KH_ID"];
var pdvId = Request["PDV_ID"];
var ctvId = Request["CTV_ID"];
var pgvId = Request["PGV_ID"];
var pbhId = Request["PBH_ID"];
using (var con = DAL.con())
{
if (string.IsNullOrEmpty(id))
{
Item = ThuChiDal.SelectByDraff(con, true);
if (khId != null && khId.Length >= 36)
{
khId = khId.Substring(khId.LastIndexOf(',') + 1);
var kh = KhachHangDal.SelectById(new Guid(khId), con);
Item.P_Ten = kh.Ten;
Item.P_ID = kh.ID;
}
if (pdvId != null && pdvId.Length >= 36)
{
pdvId = pdvId.Substring(pdvId.LastIndexOf(',') + 1);
var pdv = PhieuDichVuDal.SelectById(con, new Guid(pdvId));
Item.PDV_ID = pdv.ID;
Item.PDV_Ma = pdv.Ma;
var kh = KhachHangDal.SelectById(pdv.KH_ID, con);
Item.P_Ten = kh.Ten;
Item.P_ID = kh.ID;
}
if (ctvId != null && ctvId.Length >= 36)
{
ctvId = ctvId.Substring(ctvId.LastIndexOf(',') + 1);
var ctv = ChoThueVayDal.SelectById(con, new Guid(ctvId));
Item.CTV_ID = ctv.ID;
Item.CTV_Ma = ctv.Ma;
var kh = KhachHangDal.SelectById(ctv.KH_ID, con);
Item.P_Ten = kh.Ten;
Item.P_ID = kh.ID;
}
if (pgvId != null && pgvId.Length >= 36)
{
pgvId = pgvId.Substring(pgvId.LastIndexOf(',') + 1);
var pgv = PhieuGiatVayDal.SelectById(con, new Guid(pgvId));
Item.PGV_ID = pgv.ID;
Item.PGV_Ma = pgv.Ma;
}
if (pbhId != null && pbhId.Length >= 36)
{
pbhId = pbhId.Substring(pgvId.LastIndexOf(',') + 1);
var pbh = PhieuBaoHongDal.SelectById(con, new Guid(pbhId));
Item.PBH_ID = pbh.ID;
Item.PBH_Ma = pbh.Ma;
}
}
else
{
Item = ThuChiDal.SelectById(con, new Guid(id));
}
var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description;
InPhieuChi.LogoStr = logoStr;
var listLoai = DanhMucDal.SelectByLDMMa(con, "NDTC-CHI");
InPhieuChi.ListLoai = listLoai;
InPhieuChi.Item = Item;
}
}
protected override void Render(HtmlTextWriter writer)
{
StringBuilder sb = new StringBuilder();
ClientScriptManager cs = this.Page.ClientScript;
#region Tham số
string _ID = Request["ID"];
string _PID = Request["PID"];
string _LDMID = Request["LDMID"];
string _Lang = Request["Lang"];
string _Ten = Request["Ten"];
string _Alias = Request["Alias"];
string _Ma = Request["Ma"];
string _KyHieu = Request["KyHieu"];
string _GiaTri = Request["GiaTri"];
string _KeyWords = Request["KeyWords"];
string _Description = Request["Description"];
string _LangBased_ID = Request["LangBased_ID"];
string _ThuTu = Request["ThuTu"];
string _Anh = Request["Anh"];
string _LangBased = Request["LangBased"];
string _q = Request["q"];
string _LDM_Ma = Request["LDM_Ma"];
if (_PID == "0")
{
_PID = string.Empty;
}
DanhMuc Item;
List <DanhMuc> List = new List <DanhMuc>();
#endregion
switch (subAct)
{
case "get":
#region lấy dữ liệu cho grid
List = getTree(DanhMucDal.SelectByLDMID(_LDMID));
var listRow = List.Select(dm => new jgridRow(dm.ID.ToString(), new string[]
{
dm.ID.ToString(), dm.LangBased.ToString(), dm.ID.ToString(), dm.Lang, dm.ThuTu.ToString(), dm.LDM_Ten, dm.Ma, dm.KyHieu, dm.GiaTri, string.Format("<img class=\"adm-fn-icon\" src=\"../up/i/{0}?ref=\" />", string.IsNullOrEmpty(dm.Anh) ? "fn-icon.jpg" : dm.Anh, Guid.NewGuid().ToString().Replace("-", "")), dm.Ten, string.Format("{0:dd/MM/yy}", dm.NgayCapNhat), dm.NguoiTao + "/" + dm.NguoiSua, dm.Level.ToString(), dm.PID.ToString(), "true", "true"
})).ToList();
var grid = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage, List.Count.ToString(), List.Count.ToString(), listRow);
sb.Append(JavaScriptConvert.SerializeObject(grid));
break;
#endregion
case "getByMa":
#region lấy dữ liệu cho grid
List = getTree(DanhMucDal.SelectByLDMMa(_LDM_Ma));
var listRowByMa = List.Select(dm => new jgridRow(dm.ID.ToString(), new string[]
{
dm.ID.ToString(), dm.LangBased.ToString(), dm.ID.ToString(), dm.Lang, dm.ThuTu.ToString(), dm.LDM_Ten, dm.Ma, dm.KyHieu, dm.GiaTri, string.Format("<img class=\"adm-fn-icon\" src=\"../up/i/{0}?ref=\" />", string.IsNullOrEmpty(dm.Anh) ? "fn-icon.jpg" : dm.Anh, Guid.NewGuid().ToString().Replace("-", "")), dm.Ten, string.Format("{0:dd/MM/yy}", dm.NgayCapNhat), dm.NguoiTao + "/" + dm.NguoiSua, dm.Level.ToString(), dm.PID.ToString(), "true", "true"
})).ToList();
var gridByMa = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage, List.Count.ToString(), List.Count.ToString(), listRowByMa);
sb.Append(JavaScriptConvert.SerializeObject(gridByMa));
break;
#endregion
case "del":
#region xóa
if (!string.IsNullOrEmpty(_ID))
{
DanhMucDal.DeleteById(new Guid(_ID));
}
break;
#endregion
case "autoCompleteLangBased":
#region xóa
sb.Append(JavaScriptConvert.SerializeObject(getTree(DanhMucDal.SelectByLDMMa(_LDM_Ma))));
break;
#endregion
case "autoCompleteLdmMa":
#region xóa
sb.Append(JavaScriptConvert.SerializeObject(getTree(DanhMucDal.SelectByLDMMa(_LDM_Ma))));
break;
#endregion
case "edit":
#region chỉnh sửa
if (!string.IsNullOrEmpty(_ID))
{
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(DanhMucDal.SelectById(new Guid(_ID))));
}
break;
#endregion
case "save":
#region lưu
if (!string.IsNullOrEmpty(_ID))
{
Item = DanhMucDal.SelectById(new Guid(_ID));
}
else
{
Item = new DanhMuc();
}
Item.Ten = _Ten;
Item.Ma = _Ma;
Item.LDM_ID = new Guid(_LDMID);
Item.KyHieu = _KyHieu;
Item.NgayCapNhat = DateTime.Now;
Item.NguoiTao = Security.Username;
Item.GiaTri = _GiaTri;
Item.ThuTu = Convert.ToInt32(_ThuTu);
Item.NguoiSua = Security.Username;
Item.KeyWords = _KeyWords;
Item.Description = _Description;
Item.Alias = _Alias;
Item.Lang = _Lang;
Item.Anh = _Anh;
Item.LangBased = Convert.ToBoolean(_LangBased);
if (!string.IsNullOrEmpty(_LangBased_ID))
{
Item.LangBased_ID = new Guid(_LangBased_ID);
}
if (!string.IsNullOrEmpty(_PID))
{
Item.PID = new Guid(_PID);
}
if (!string.IsNullOrEmpty(_ID))
{
Item = DanhMucDal.Update(Item);
}
else
{
Item.NgayTao = DateTime.Now;
Item.RowId = Guid.NewGuid();
Item.ID = Guid.NewGuid();
if (!string.IsNullOrEmpty(_LangBased_ID))
{
Item.LangBased_ID = Item.ID;
}
Item = DanhMucDal.Insert(Item);
}
sb.Append("1");
break;
#endregion
case "scpt":
#region Nạp js
sb.AppendFormat(@"{0}"
, cs.GetWebResourceUrl(typeof(Class1), "docsoft.plugin.danhmuc.JScript1.js"));
break;
#endregion
default:
#region nạp
FunctionCollection ListFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId);
sb.Append(Lib.GetResource(Assembly.GetExecutingAssembly(), "mdl.htm"));
sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>"
, cs.GetWebResourceUrl(typeof(Class1), "docsoft.plugin.danhmuc.JScript1.js")
, "{danhmuc.loadgrid();}");
sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(ListFn));
break;
#endregion
}
writer.Write(sb.ToString());
base.Render(writer);
}
