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 url = string.Format("?q={0}&size={1}&DM_ID={2}&", q, size, dmId) + "{1}={0}"; using (var con = DAL.con()) { var pg = HangHoaDal.ByDm(con, url, false, null, q, Convert.ToInt32(size), dmId); List.List = pg.List; paging = pg.Paging; var nhomHangHoa = DanhMucDal.SelectByLDMMa(con, "HangHoa"); DM_ID.List = nhomHangHoa; } }
protected override void Render(HtmlTextWriter writer) { var sb = new StringBuilder(); var cs = this.Page.ClientScript; #region Tham số var ID = Request["ID"]; var DM_ID = Request["DM_ID"]; var GH_ID = Request["GH_ID"]; var Lang = Request["Lang"]; var LangBased_ID = Request["LangBased_ID"]; var LangBased = Request["LangBased"]; var Alias = Request["Alias"]; var Ten = Request["Ten"]; var Ma = Request["Ma"]; var Keywords = Request["Keywords"]; var Description = Request["Description"]; var MoTa = Request["MoTa"]; var NoiDung = Request["NoiDung"]; var GNY = Request["GNY"]; var GiaNhap = Request["GiaNhap"]; var DonVi_ID = Request["DonVi_ID"]; var SoLuong = Request["SoLuong"]; var RowId = Request["RowId"]; var NgayTao = Request["NgayTao"]; var NguoiTao = Request["NguoiTao"]; var NgayCapNhat = Request["NgayCapNhat"]; var NguoiCapNhat = Request["NguoiCapNhat"]; var Anh = Request["Anh"]; var Publish = Request["Publish"]; var Active = Request["Active"]; var Home = Request["Home"]; var Hot1 = Request["Hot1"]; var Hot2 = Request["Hot2"]; var Hot3 = Request["Hot3"]; var Hot4 = Request["Hot4"]; var HetHang = Request["HetHang"]; var TonDinhMuc = Request["TonDinhMuc"]; var Draff = Request["Draff"]; var _q = Request["q"]; var draff = Request["draff"]; var Loai = Request["Loai"]; var Rep_Ten = Request["Rep_Ten"]; var Rep_Ngay = Request["Rep_Ngay"]; var _F_ID = Request["F_ID"]; List <jgridRow> ListRow = new List <jgridRow>(); //List<DanhMuc> ListDanhMucBG = new List<DanhMuc>(); #endregion switch (subAct) { case "get": #region lấy dữ liệu cho grid var pagerGet = HangHoaDal.ByDm("", false, jgrsidx + " " + jgrsord, _q, Convert.ToInt32(jgRows), DM_ID); foreach (HangHoa item in pagerGet.List) { ListRow.Add(new jgridRow(item.ID.ToString(), new string[] { item.ID.ToString() , item.DM_Ten , item.Ma , item.Ten , Lib.TienVietNam(item.GiaNhap) , Lib.TienVietNam(item.GNY) , item.SoLuong.ToString() , item.DonVi_Ten , 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 "del": #region xóa if (!string.IsNullOrEmpty(ID)) { HangHoaDal.DeleteByMultiId(ID); } break; #endregion case "edit": #region chỉnh sửa if (!string.IsNullOrEmpty(ID)) { var hhitem = HangHoaDal.SelectById(new Guid(ID)); hhitem.ListFiles = FilesDal.SelectByPRowId(hhitem.ID); sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(hhitem)); } break; #endregion case "draff": #region draff sb.Append(Guid.NewGuid().ToString()); break; #endregion case "autoCompleteByQ": #region lấy dữ liệu cho grid var pagerByQ = HangHoaDal.ByDm("", false, "HH_NgayTao asc", _q, 10, string.Empty); sb.Append(JavaScriptConvert.SerializeObject(pagerByQ.List)); break; #endregion case "save": #region save if (Security.IsAuthenticated()) { var item = draff == "1" ? new HangHoa() : HangHoaDal.SelectById(new Guid(ID)); item.DM_ID = new Guid(DM_ID); item.Ten = Ten; item.Ma = Ma; item.Keywords = Keywords; item.MoTa = MoTa; item.NoiDung = NoiDung; item.GNY = Convert.ToDouble(GNY); item.GiaNhap = Convert.ToDouble(GiaNhap); item.DonVi_ID = new Guid(DonVi_ID); item.SoLuong = Convert.ToDouble(SoLuong); item.Anh = Anh; item.HetHang = Convert.ToBoolean(HetHang); item.TonDinhMuc = Convert.ToDouble(TonDinhMuc); item.NguoiCapNhat = Security.Username; item.NgayCapNhat = DateTime.Now; if (draff == "1") { item.ID = new Guid(ID); item.NgayTao = DateTime.Now; item.NguoiTao = Security.Username; item.RowId = Guid.NewGuid(); item = HangHoaDal.Insert(item); } else { item = HangHoaDal.Update(item); } sb.Append("1"); } break; #endregion case "DeleteDoc": #region Xóa tài liệu đính kèm if (!string.IsNullOrEmpty(_F_ID)) { Files item = FilesDal.SelectById(Convert.ToInt32(_F_ID)); string _files = Server.MapPath("~/lib/up/sanpham/") + item.ThuMuc + @"\"; string _file1 = _files + @"\" + item.Ten + item.MimeType; string _file2 = _files + @"\" + item.Ten + "400x400" + item.MimeType; if (Directory.Exists(_files)) { File.Delete(_file1); File.Delete(_file2); Directory.Delete(_files); } FilesDal.DeleteById(item.ID); } break; #endregion case "reports": #region bao cao var pagerGetReport = HangHoaDal.ByDm("", false, jgrsidx + " " + jgrsord, _q, Convert.ToInt32(jgRows), DM_ID); break; #endregion case "scpt": #region Nạp js sb.AppendFormat(@"{0}" , cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.hangHoaMgr.JScript1.js")); //sb.AppendFormat(@"{0}" // , cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.hangHoaMgr.Publish.js")); break; #endregion default: #region nạp var 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), "appStore.commonStore.hangHoaMgr.JScript1.js") , "{hangHoaMgrFn.loadgrid();}"); sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(listFn)); break; #endregion } writer.Write(sb.ToString()); base.Render(writer); }