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 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 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 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; } }
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 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 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; } }
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 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) { 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); }
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; } }