protected void btnThem_Click(object sender, ImageClickEventArgs e) { if (txtTenDM.Text == "") { lbThongBao.Visible = true; lbThongBao.Text = "Error!!! : nhập tên Danh Mục"; txtTenDM.Focus(); } else { string ten = txtTenDM.Text; DataTable d = DataProvider.KiemTraInsertDanhMuc(ten); if(d.Rows.Count > 0) { lbThongBao.Visible = true; lbThongBao.Text = "Error...Tên danh mục đã tồn tại!!!"; return; } else { lbThongBao.Visible = true; lbThongBao.Text = "Error d**!!!"; DanhMuc dm = new DanhMuc(); string tendm = txtTenDM.Text; DataProvider.InsertDanhMuc(tendm); } Bind(); } }
protected void btnLuu_Click(object sender, EventArgs e) { DanhMuc dm = new DanhMuc() ; foreach (DataListItem li in DataList1.Items) { Label madm = (Label)li.FindControl("txtMaDM"); TextBox tendm = (TextBox)li.FindControl("txtTenDM"); if(madm.Text=="") { lbThongBao.Visible = true; lbThongBao.Text = "Error!!! nhập mã Danh Mục"; madm.Focus(); } else if (tendm.Text == "") { lbThongBao.Visible = true; lbThongBao.Text = "Error!!! nhập tên Danh Mục"; tendm.Focus(); } else { dm.ID = Convert.ToInt32( madm.Text); dm.TenDM = tendm.Text; DataProvider.UpdateDanhMuc(dm); Response.Redirect("DanhMuc.aspx"); } } }
public ActionResult ChiTietSanPham(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SanPham sp = _context.SanPham.Find(id); DanhMuc danhmuc = _context.DanhMuc.Find(id); if (sp == null) { return(HttpNotFound()); } return(View(sp)); return(View()); }
protected void Page_Load(object sender, EventArgs e) { if (Session["ACCOUNT"] == null) { Response.Redirect("../Login.aspx"); } DanhMuc objDanhMuc = new DanhMuc(); DataTable objTable = objDanhMuc.getListDanhMuc(); if (objTable.Rows.Count > 0) { dtlData.DataSource = objTable.DefaultView; dtlData.DataBind(); } }
public ActionResult Delete(int MaDM) { if (Session["Admin"] == null || Session["Admin"].ToString() == "") { return(RedirectToAction("Login", "Admin")); } //Lấy ra đối tượng sách theo mã DanhMuc dm = db.DanhMucs.SingleOrDefault(n => n.MaDM == MaDM); if (dm == null) { Response.StatusCode = 404; return(null); } return(View(dm)); }
public ActionResult Create(DanhMuc danhmuc) { if (ModelState.IsValid) { var dao = new DanhMucDao(); int id = dao.Insert(danhmuc); if (id > 0) { return(RedirectToAction("Index", "DanhMuc")); } else { ModelState.AddModelError("", "Thêm mới thành công"); } } return(View("Index")); }
public ActionResult Edit(DanhMuc danhmuc) { if (ModelState.IsValid) { var dao = new DanhMucDao(); var result = dao.Update(danhmuc); if (result) { return(RedirectToAction("Index", "DanhMuc")); } else { ModelState.AddModelError("", "Sửa thành công"); } } return(View("Index")); }
public ActionResult XuLyCreate(DanhMuc dm) { if (ModelState.IsValid) { try { csdl.ThemDanhMuc(dm.TenDM); SetAlert("Add Successful", "success"); return(RedirectToAction("Index", "DanhMuc")); } catch (Exception) { ModelState.AddModelError("", "Add Failded"); } } return(View("Create")); }
public ActionResult Edit([Bind(Include = "MaDM,TenDM")] DanhMuc danhMuc) { try { if (ModelState.IsValid) { db.Entry(danhMuc).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Index")); } catch (Exception ex) { ViewBag.Error = "Lỗi" + ex.Message; return(View(danhMuc)); } }
public ActionResult Update(DanhMuc dm) { if (ModelState.IsValid) { DanhMuc dmm = db.DanhMucs.SingleOrDefault(n => n.MaDM == dm.MaDM); dmm.TenDM = dm.TenDM; db.SaveChanges(); @ViewBag.Success = "Cập Nhập Thành Công Thành Công"; return(View()); } else { ViewBag.ThongBaoLoi = "Cập Nhập Thất Bại"; return(View()); } }
public ActionResult Update(DanhMuc model) { var selectedModel = _danhMucRepository.TableNoTracking.Where(a => a.Id == model.Id).FirstOrDefault(); if (selectedModel == null) { return(BadRequest("Danh mục không tồn tại !")); } selectedModel.IdParent = model.IdParent; selectedModel.Ten = model.Ten; _danhMucRepository.Update(model); _unitOfWork.SaveChange(); return(RedirectToAction("Index")); }
/// - Lấy danh mục theo mã nhóm và mã /// - Input: /// + maNhom: string - mã nhóm danh mục, lấy trong Constants.CodeSystem /// + ma: string - mã của danh mục trong nhóm /// - Output: /// + danhMuc: DanhMuc - Danh mục nếu tìm thấy, null nếu không tìm thấy public DanhMuc GetDanhMuc(string maNhom, string ma) { var param = new Dictionary <string, string>() { { "system", maNhom }, { "code", ma } }; string url = Constants.FHIR_URL + "/CodeSystem/$lookup"; var json = FhirClientUtils.get(url, param); if (json != null) { var obj = JsonValue.Parse(json); return(DanhMuc.FromParams(maNhom, obj["parameter"].AsJsonArray)); } return(null); }
//theo danh muc public ViewResult DemoDanhMuc(int MaDanhMuc = 0) { DanhMuc dm = db.DanhMucs.SingleOrDefault(n => n.MaDanhMuc == MaDanhMuc); if (dm == null) { Response.StatusCode = 404; return(null); } List <Demo> lstDemo = db.Demoes.Where(n => n.MaDanhMuc == MaDanhMuc).ToList(); if (lstDemo.Count == 0) { ViewBag.Demo = "Không có Demo nào"; } return(View(lstDemo)); }
public bool ThemDanhMuc(eDanhMuc edm) { DanhMuc dm = new DanhMuc(); //dm.IdDanhMuc = edm.IdDanhMuc; dm.TenDanhMuc = edm.TenDanhMuc; dm.PhiThue = edm.PhiThue; dm.PhiTreHan = edm.PhiTreHan; dm.TrangThaiXoa = false; if (!db.DanhMucs.Contains(dm)) { db.DanhMucs.InsertOnSubmit(dm); db.SubmitChanges(); return(true); } return(false); }
public ActionResult Delete(int madm) { if (kiemTraAdmin() == false) { ViewBag.ThongBaoCanDangNhap = "Cần Đăng Nhập để tiếp tục"; return(RedirectToAction("DangNhap", "UserAdmin")); } DanhMuc dmm = db.DanhMucs.SingleOrDefault(n => n.MaDM == madm); if (dmm == null) { Response.StatusCode = 404; return(null); } return(View(dmm)); }
public ActionResult Create(DanhMuc danhMucSanPham) { if (ModelState.IsValid) { var currentCulture = Session[CommonConstant.CurrentCulture]; var id = new DanhMucSanPhamDAO().Insert(danhMucSanPham); if (id > 0) { return(RedirectToAction("Index")); } else { ModelState.AddModelError("", StaticResources.Resources.InsertCategoryFailed); } } return(View(danhMucSanPham)); }
protected void Page_Load(object sender, EventArgs e) { using (SqlConnection con = DAL.con()) { if (Session["pop"] == null) { DanhMuc ItemDm = DanhMucDal.SelectByMa("SYSTEM-POP-UP", con); if (ItemDm.ID != 0 && ItemDm.KyHieu == "1") { pop = "</script><div style=\"display:none;\"class=\"pop-pnl-2\">" + ItemDm.Description + "</div><script>var l =$('.pop-pnl-2').html(); jQuery.facebox(l);"; } else { // pop = @" jQuery(function(){ //var l =' <div class=""pop-pnl""><a href=""javascript:;"" class=""close-pop""></a> <div style=""float:left; width:260px; height:308px; margin-top:100px;margin-left:26px; background: url(Dotphao.gif); background-repeat:no-repeat; background-position: -90px -20px;""></div> </div>'; //jQuery.facebox(l); //jQuery('.close-pop').click(function(){jQuery(document).trigger('close.facebox');}); //});"; } Session["pop"] = "oke"; } if (Request["pop"] != null) { Session["pop"] = null; } var sb = new StringBuilder(); #region sản phẩm //List<DanhMuc> ListDm = DanhMucDal.SelectLangBased("", "SP_NHOM"); //foreach (DanhMuc item in ListDm) //{ // sb.AppendFormat(@"<a href=""san-pham.aspx?dm_id={0}"" title=""{1}"" class=""navi-top-subItem"">{1}</a>" // ,item.ID,item.Ten); //} #endregion //List<SanPham> ListSanPhamMoi = SanPhamDal.SelectTop8SanPhamMoi(10); //foreach (SanPham item in ListSanPhamMoi) //{ // sb.AppendFormat(@"<a href=""san-pham.aspx?id={0}"" title=""{1}"" class=""navi-top-subItem"">{1}</a>" // , item.ID, item.Ten); //} //mnu = sb.ToString(); Item = DanhMucDal.SelectByMa("SYSTEM-FOOT"); } }
public ActionResult Create(DanhMuc model) { try { // TODO: Add insert logic here var result = new DanhMucFunction().Insert(model); if (result == 0) { return(View()); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create([Bind(Include = "MaDM,TenDM")] DanhMuc danhMuc) { try { if (ModelState.IsValid) { db.DanhMucs.Add(danhMuc); db.SaveChanges(); } return(RedirectToAction("Index")); } catch (Exception ex) { ViewBag.Error = "Lỗi" + ex.Message; return(View(danhMuc)); } }
public ActionResult Edit(DanhMuc dmcs) { if (ModelState.IsValid) { DanhMuc dm = db.DanhMuc.Find(dmcs.ma); dm.tendanhmuc = dmcs.tendanhmuc; db.SaveChanges(); return(RedirectToAction("Category")); } else { return(View(dmcs)); } }
public ActionResult Create(DanhMuc cate) { if (ModelState.IsValid) { var dao = new CategoryDao(); var res = dao.Insert(cate); if (res > 0) { return(RedirectToAction("Index", "Category")); } else { ModelState.AddModelError("", "Thêm thất bại"); } } return(View("Index")); }
/// - Lấy toàn bộ danh mục trong một nhóm /// - Input: /// + maNhom: string - mã nhóm danh mục, lấy trong Constants.CodeSystem /// /// - Output: /// + dsDanhMuc: List<DanhMuc> - Toàn bộ Danh Mục trong nhóm public List <DanhMuc> GetDanhMucByGroup(string maNhom) { string codeSytemId = GetCodeSystemId(maNhom); List <DanhMuc> dsDanhMuc = new List <DanhMuc>(); if (codeSytemId != null) { string url = Constants.FHIR_URL + "/CodeSystem/" + codeSytemId; var json = FhirClientUtils.get(url); var obj = JsonValue.Parse(json); var concepts = obj["concept"].AsJsonArray; foreach (var concept in concepts) { dsDanhMuc.Add(DanhMuc.FromConcept(maNhom, concept)); } } return(dsDanhMuc); }
public int Update(DanhMuc dmuc) { int i; using (SqlConnection con = new SqlConnection(cs)) { con.Open(); SqlCommand com = new SqlCommand("InsertUpdateDanhMuc", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@DanhMucID", dmuc.DanhMucID); com.Parameters.AddWithValue("@TenDanhMuc", dmuc.TenDanhMuc); com.Parameters.AddWithValue("@MetaKeyword", dmuc.MetaKeyword); com.Parameters.AddWithValue("@Status", dmuc.Status); com.Parameters.AddWithValue("@Action", "Update"); i = com.ExecuteNonQuery(); } return(i); }
public ActionResult Edit(int id, DanhMuc model) { try { // TODO: Add update logic here model.DanhmucID = id; var result = new DanhMucFunction().Update(model); //if (result == null) //{ // return View(); //} return(RedirectToAction("Index")); } catch { return(View()); } }
// Thuốc theo danh mục public ViewResult ThuocTheoDanhMuc(int MaDM = 0) { // Kiểm tra danh mục này tồn tại hay ko DanhMuc dm = db.DanhMucs.SingleOrDefault(n => n.MaDM == MaDM); if (dm == null) { Response.StatusCode = 404; return(null); } List <Thuoc> listthuoc = db.Thuocs.Where(n => n.MaDM == MaDM).OrderBy(n => n.GiaBan).ToList(); if (listthuoc.Count == 0) { ViewBag.Thuoc = "Không có thuốc nào thuộc danh mục này!"; } return(View(listthuoc)); }
public bool LuuDanhMuc(int maDM, string tenDM) { try { CSDLTestDataContext context = new CSDLTestDataContext(); DanhMuc dm = new DanhMuc(); dm.MaDM = maDM; dm.TenDM = tenDM; context.DanhMucs.InsertOnSubmit(dm); context.SubmitChanges(); return(true); } catch { } return(false); }
public bool SuaDanhMuc(int maDM, string tenDM) { try { CSDLTestDataContext context = new CSDLTestDataContext(); DanhMuc dm = context.DanhMucs.FirstOrDefault(x => x.MaDM == maDM); if (dm != null) { dm.TenDM = tenDM; context.SubmitChanges(); return(true); } } catch { } return(false); }
public string CapNhatDanhMuc(DanhMuc danhMuc) { try { int kq = dataProvider.ExecuteNonQuery("Proc_DanhMuc_Update", new object[] { danhMuc.MaDanhMuc, danhMuc.TenDanhMuc, danhMuc.TrangThaiHienThi, danhMuc.NgaySua }, new List <string>() { "@MaDanhMuc", "@TenDanhMuc", "@TrangThaiHienThi", "@NgaySua" }); return(kq.ToString()); } catch (Exception ex) { return(""); } }
protected void Page_Load(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); List<Tin> List = new List<Tin>(); string _DM_ID = Request["DM_ID"]; string _Pages = Request["Pages"]; using (SqlConnection con = DAL.con()) { Item = DanhMucDal.SelectById(Convert.ToInt32(_DM_ID)); List = TinDal.SelectByDanhMuc(con, Item.Ma, 2); int i = 0; foreach (Tin item in List) { i++; sb.Append(formatItem(item, i == List.Count - 1)); } } txt = sb.ToString(); }
public bool ThemDanhMuc(String TenDanhMuc) { if (TimTenTrung(TenDanhMuc) == 1) { DanhMuc dm = db.DanhMucs.FirstOrDefault(n => n.TenDM.Equals(TenDanhMuc)); dm.ISDELETE = false; db.SubmitChanges(); return(true); } else { DanhMuc dm = new DanhMuc(); dm.TenDM = TenDanhMuc; dm.ISDELETE = false; db.DanhMucs.InsertOnSubmit(dm); db.SubmitChanges(); return(true); } }
protected void Page_Load(object sender, EventArgs e) { var allModel = DanhMucDal.SelectByLdmMaFromCache("HANGXE"); var url = string.Empty; var ten = Request["Ten"]; using (var con = DAL.con()) { var item = DanhMucDal.SelectByTen(con, ten); if (item == null) return; item.Hang = DanhMucDal.SelectById(con, item.PID); Item = item; var pager = XeDal.PagerByHang(con, url, false, null, 50, null, null, item.ID.ToString(), Security.Username); ListByModelXe.Pager = pager; ListByModelXe.Item = item; } }
public string ThemDanhMuc(DanhMuc danhMuc) { try { string rs = ""; rs = dataProvider.ExecuteScalar("Proc_DanhMuc_Insert", new object[] { danhMuc.TenDanhMuc, danhMuc.TrangThaiHienThi, danhMuc.NgayTao }, new List <string>() { "@TenDanhMuc", "@TrangThaiHienThi", "@NgayTao" }); return(rs); } catch (Exception ex) { return(""); } }
public ViewResult GiayTheoDanhMuc(int madm = 0) { DanhMuc dm = db.DanhMucs.SingleOrDefault(n => n.MaDM == madm); if (dm == null) { ViewBag.hanghoa = "Không có sản phẩm nào"; return(null); } List <HangHoa> lstHangHoa = db.HangHoas.Where(n => n.MaDM == madm).OrderBy(n => n.TenHH).ToList(); if (lstHangHoa.Count == 0) { ViewBag.hanghoa = "Không tìm thấy sản phẩm"; } return(View(lstHangHoa)); }
public List <DanhMuc> DSDanhMuc() { conn.Open(); List <DanhMuc> listDM = new List <DanhMuc>(); String sql = "select * from DanhMuc"; cmd = new SqlCommand(sql, conn); dr = cmd.ExecuteReader(); while (dr.Read()) { DanhMuc dm = new DanhMuc(); dm.iddanhmuc = int.Parse(dr["iddanhmuc"].ToString()); dm.madanhmuc = dr["madanhmuc"].ToString(); dm.ten = dr["ten"].ToString(); listDM.Add(dm); } conn.Close(); return(listDM); }
public ActionResult Create(DanhMuc danhmuc) { if (ModelState.IsValid) { var dao = new DanhMucDao(); int id = dao.Insert(danhmuc); if (id > 0) { SetAlert("Thêm danh mục thành công", "success"); return(RedirectToAction("Index", "DanhMuc")); } else { ModelState.AddModelError("", "Thêm danh mục không thành công"); } SetViewBag(); } return(View("Index")); }
public string GetSub(List<DanhMuc> list, DanhMuc pitem) { var sb = new StringBuilder(); var list1 = from p in list where p.PID == pitem.ID orderby p.ThuTu ascending select p; if (list1.Count() > 0) { sb.Append(@"<div class=""menu-flyOut"">"); foreach (DanhMuc item in list1) { sb.AppendFormat(@"<a title=""{1}"" class=""navi-top-subItem"" href=""{0}"">{1}</a>" , string.Format(item.GiaTri, domain) , item.Ten); } sb.Append("</div>"); } return sb.ToString(); }
public string GetSub(List<DanhMuc> list, DanhMuc pitem) { var sb = new StringBuilder(); var list1 = from p in list where p.PID == pitem.ID orderby p.ThuTu ascending select p; if (list1.Any()) { sb.Append(@"<ul class=""sub"">"); foreach (var item in list1) { sb.AppendFormat(@"<li><a title=""{1}"" class=""navi-top-subItem"" href=""{0}"">{1}</a></li>" , item.GiaTri , item.Ten); } sb.Append("</ul>"); } return sb.ToString(); }
protected void Page_Load(object sender, EventArgs e) { var url = string.Empty; var ten = Request["Ten"]; using (var con = DAL.con()) { var item = DanhMucDal.SelectByTen(con, ten); if(item==null) return; Item = item; var allModel = DanhMucDal.SelectByLdmMaFromCache("HANGXE"); var filterModel = (from p in allModel where p.PID == item.ID select p).OrderBy(m => m.ThuTu).ToList(); filterModel.ForEach(x => x.Hang = Item); ListByHangXe.List = filterModel; var pager = XeDal.PagerByHang(con, url, false, null, 50, null, item.ID.ToString(), null, Security.Username); ListByHangXe.Pager = pager; ListByHangXe.Item = Item; } }
string getChild(List<DanhMuc> _List, DanhMuc PID) { j = 0; sb1 = new StringBuilder(); sb2 = new StringBuilder(); string srv = Request["kind"]; if (string.IsNullOrEmpty(srv)) srv = "San-pham"; StringBuilder sb = new StringBuilder(); var myList = from p in _List where p.PID == PID.ID select p; if (myList.Count() > 0) { foreach (DanhMuc item in myList) { sb.AppendFormat(@"<li class=""cate-home-li""><a href=""/{1}/{2}/{3}/"" class=""cate-item cate-item-sub"">{4}</a>" , domain, "Spa-khuyen-mai", item.Alias, item.ID, item.Ten); sb.Append(getChild(_List, item)); sb.Append("</li>"); } } return sb.ToString(); }
public static void UpdateDanhMuc(DanhMuc dm) { conn.Open(); SqlCommand cmd = new SqlCommand("Update DanhMuc Set TenDM = N'" + dm.TenDM + "' WHERE MaDM = " + dm.ID + "", conn); cmd.ExecuteNonQuery(); conn.Close(); }
public string GetSub(List<DanhMuc> list, DanhMuc pid) { j = 0; var sb1 = new StringBuilder(); var sb2 = new StringBuilder(); var sb = new StringBuilder(); var myList = from p in list where p.PID == pid.ID select p; if (myList.Any()) { sb.Append(@"<div class=""cate-flyOut"">"); int max = 0; int total = 0; foreach (DanhMuc muc in myList) total++; if (total % 2 == 0) { max = total / 2; } else { max = Convert.ToInt32(Math.Floor(Convert.ToDecimal(myList.Count() / 2))) + 1; } foreach (DanhMuc item in myList) { if (j < max) { sb1.AppendFormat(@"<a href=""{0}/Hang-hoa/{1}/"" title=""{2}"" Class=""cate-flyOut-subCate-item"">{2}</a>", domain, item.Ma, item.Ten); } else { sb2.AppendFormat(@"<a href=""{0}/Hang-hoa/{1}/"" title=""{2}"" Class=""cate-flyOut-subCate-item"">{2}</a>", domain, item.Ma, item.Ten); } j++; } if (!string.IsNullOrEmpty(sb1.ToString())) { sb.AppendFormat(@"<div class=""cate-flyOut-subCate-panel"">{0}</div>", sb1); } if (!string.IsNullOrEmpty(sb2.ToString())) { sb.AppendFormat(@"<div class=""cate-flyOut-subCate-panel"">{0}</div>", sb2); } sb.Append("</div>"); } return sb.ToString(); }
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 "autoCompleteLangBasedNoChild": #region xóa var list1 = DanhMucDal.SelectByLDMMa(_LDM_Ma); var list2 = from p in list1 where p.PID==Guid.Empty select p; sb.Append(JavaScriptConvert.SerializeObject(getTree(list2.ToList()))); break; #endregion case "autoCompleteByPid": #region xóa sb.Append(JavaScriptConvert.SerializeObject(DanhMucDal.SelectByPid(_ID))); break; #endregion case "autoCompleteLdmMa": #region xóa sb.Append(JavaScriptConvert.SerializeObject(getTree(DanhMucDal.SelectByLDMMa(_LDM_Ma)))); break; #endregion case "autoCompleteLangBasedByDM": #region xóa sb.Append(JavaScriptConvert.SerializeObject(getTree(DanhMucDal.SelectTreeByDmMa(DAL.con(), _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); }
public static ArrayList LayDanhMuc() { ArrayList list = new ArrayList(); string query = String.Format("SELECT * FROM DanhMuc WHERE Status = 1"); try { conn.Open(); command.CommandText = query; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int madm = reader.GetInt32(0); string tendm = reader.GetString(1); int status = reader.GetInt32(2); DanhMuc danhmuc = new DanhMuc(madm, tendm, status); list.Add(danhmuc); } } finally { conn.Close(); } return list; }
string getChild(List<DanhMuc> _List, DanhMuc PID) { j = 0; sb1 = new StringBuilder(); sb2 = new StringBuilder(); string srv = Request["kind"]; if (string.IsNullOrEmpty(srv)) srv = "San-pham"; StringBuilder sb = new StringBuilder(); var myList = from p in _List where p.PID == PID.ID select p; if (myList.Count() > 0) { sb.Append(@"<div class=""cate-flyOut"">"); int max = 0; int total = myList.Count(); if (total % 2 == 0) { max = total / 2; } else { max = Convert.ToInt32(Math.Floor(Convert.ToDecimal(myList.Count() / 2))) + 1; } foreach (DanhMuc item in myList) { if (j < max) { sb1.AppendFormat(@"<a href=""/Dich-vu-Spa/{1}/{2}/{3}/"" Class=""cate-flyOut-subCate-item"">{4}</a>", domain, PID.Alias, item.Alias, item.ID, item.Ten); } else { sb2.AppendFormat(@"<a href=""/Dich-vu-Spa/{1}/{2}/{3}/"" Class=""cate-flyOut-subCate-item"">{4}</a>", domain, PID.Alias, item.Alias, item.ID, item.Ten); } j++; } if(!string.IsNullOrEmpty(sb1.ToString())) { sb.AppendFormat(@"<div class=""cate-flyOut-subCate-panel"">{0}</div>", sb1); } if (!string.IsNullOrEmpty(sb2.ToString())) { sb.AppendFormat(@"<div class=""cate-flyOut-subCate-panel"">{0}</div>", sb2); } sb.AppendFormat(@"<div class=""cate-flyOut-featured""> <div class=""cate-flyOut-featured-header""> <div class=""cate-flyOut-featured-header-label""> Dịch vụ </div> <div class=""cate-flyOut-featured-header-line""> </div> </div> <div class=""cate-flyOut-featured-box"" _loaded=""0"" _DM_ID=""{0}""> </div> </div>", PID.ID); sb.Append("</div>"); } return sb.ToString(); }
protected void Page_Load(object sender, EventArgs e) { //var danhMuc = DanhMucDal.List; //using (var client = new RedisClient(CacheManager.RedisAddress)) //{ // var redis = client.As<Xe>(); // Response.Write("<hr/>"); // foreach (var key in redis.GetAllKeys()) // { // Response.Write(string.Format("{0}<br/>", key)); // } //} //return; var xe = new Person() { ID = new Guid("FF2573F3-368C-46B8-A0F4-49BB4747521C") , Ten = "BMW 325i thần thánh" }; var hangXe = new DanhMuc() { ID = new Guid("1a57008a-d21f-4c97-b714-61075421b80f") , Ten = "BMW" , PID = xe.ID }; var hangXe_1 = new DanhMuc() { ID = new Guid("4EBA0D5B-3530-4874-BEDA-139B20212450") , Ten = "Mercedes" , PID = xe.ID }; var hangXe_2 = new DanhMuc() { ID = new Guid("C6AA2CF9-9D44-4A3A-AF29-7878012F7CFA") , Ten = "Fyo" , PID = xe.ID }; var model = new DanhMuc() { ID = new Guid("26536587-bf03-4e98-a905-dac60d6e3669") , Ten = "325i" , PID = xe.ID }; using (var client = new RedisClient(CacheManager.RedisAddress)) { var redis = client.As<Person>(); var redisHang = client.As<DanhMuc>(); redisHang.Store(hangXe); redisHang.Store(hangXe_1); redisHang.Store(hangXe_2); redisHang.Store(model); redis.Store(xe); redis.StoreRelatedEntities(xe.ID, new List<DanhMuc>() { hangXe, hangXe_1, hangXe_2, model }); redis.StoreRelatedEntities(xe.Model, model); var hangs = redis.GetRelatedEntities<DanhMuc>(xe.ID); foreach (var item in hangs) { Response.Write("<hr/>" + item.Ten); } Response.Write("<hr/>"); foreach (var key in redis.GetAllKeys()) { Response.Write(string.Format("{0}<br/>", key)); } Response.Write("<hr/>Deleted"); //redis.DeleteRelatedEntities<DanhMuc>(xe.ID); Response.Write("<hr/>"); foreach (var key in redis.GetAllKeys()) { Response.Write(string.Format("{0}<br/>", key)); } } }
public string getSub(List<DanhMuc> list, DanhMuc pitem) { StringBuilder sb = new StringBuilder(); var List1 = from p in list where p.P_ID == pitem.ID orderby p.ThuTu ascending select p; if (List1.ToList().Count > 0) { sb.Append(@"<div class=""menu-flyOut"">"); foreach (docbao.entitites.DanhMuc item in List1) { sb.AppendFormat(@"<a title=""{5}"" class=""navi-top-subItem"" href=""{0}{1}/{3}/"">{5}</a>" , domain, pitem.Alias, pitem.ID, item.Alias,item.ID, item.Ten); } sb.Append("</div>"); } return sb.ToString(); }
public override void KhoiTao(SqlConnection con, Page page) { var sb = new StringBuilder(); var cs = page.ClientScript; var c = HttpContext.Current; #region bien var ID = Request["ID"]; var TT_ID = Request["TT_ID"]; var DV_ID = Request["DV_ID"]; var Ma = Request["Ma"]; var So = Request["So"]; var KH_ID = Request["KH_ID"]; var TuVanVien = Request["TuVanVien"]; var Ngay = Request["Ngay"]; var NgayTao = Request["NgayTao"]; var NguoiTao = Request["NguoiTao"]; var NgayCapNhat = Request["NgayCapNhat"]; var NguoiCapNhat = Request["NguoiCapNhat"]; var TinhTrangSucKhoe = Request["TinhTrangSucKhoe"]; var TinhTrangLanDa = Request["TinhTrangLanDa"]; var GhiChu = Request["GhiChu"]; var YKienKhachHang = Request["YKienKhachHang"]; var HieuQua = Request["HieuQua"]; var PDV_ID = Request["PDV_ID"]; var TuVanVienDanhGia = Request["TuVanVienDanhGia"]; var KhongTheoDoi = Request["KhongTheoDoi"]; var DichVuDieuTriKhac = Request["DichVuDieuTriKhac"]; var KH_NguoiGioiThieu = Request["KH_NguoiGioiThieu"]; var KH_Ma = Request["KH_Ma"]; var Anh = Request["Anh"]; var KH_Ten = Request["KH_Ten"]; var KH_GioiTinh = Request["KH_GioiTinh"]; var KH_NgaySinh = Request["KH_NgaySinh"]; var KH_DiaChi = Request["KH_DiaChi"]; var KH_KhuVuc_ID = Request["KH_KhuVuc_ID"]; var KH_Phone = Request["KH_Phone"]; var KH_Mobile = Request["KH_Mobile"]; var KH_Ym = Request["KH_Ym"]; var KH_CMND = Request["KH_CMND"]; var KH_Email = Request["KH_Email"]; var KH_NguonGoc_ID = Request["KH_NguonGoc_ID"]; var LinhVuc_ID = Request["LinhVuc_ID"]; #endregion switch (subAct) { case "draff": #region draff sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(KhachHangDal.SelectDraff(con))); break; #endregion case "draffTuVan": #region draffTuVan sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(TuVanDal.SelectDraff(con))); break; #endregion case "addTinhTrang": #region addTinhTrang if (!string.IsNullOrEmpty(ID)) { var itemTuVanTinhTrang = TuVanTinhTrangDal.Insert(new TuVanTinhTrang() { ID = Guid.NewGuid() , NgayTao = DateTime.Now , TT_ID = new Guid(TT_ID) , ThuTu = 0 , TV_ID = new Guid(ID) }); sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(itemTuVanTinhTrang)); } break; #endregion case "delTinhTrang": #region delTinhTrang TuVanTinhTrangDal.DeleteById(new Guid(TT_ID)); break; #endregion case "delDichVu": #region delDichVu RelationDal.DeleteByCidPid(DV_ID, ID); break; #endregion case "getAlbum": #region getAlbum var slideIndex = 0; var anhFsFormat = Lib.GetResource(Assembly.GetExecutingAssembly(), "AlbumMgr.anh-dich-vu-full.htm"); foreach (var anh in FilesDal.SelectByPRowId(new Guid(ID))) { sb.AppendFormat(anhFsFormat, slideIndex == 0 ? "block" : "none", domain, Lib.imgSize(anh.Path, "full"), anh.ThuMuc); slideIndex++; } break; #endregion case "save": #region save if(!string.IsNullOrEmpty(KH_Ten)) { var khItem = new KhachHang(); khItem.CMND = KH_CMND; khItem.DanhGia = 0; khItem.DiaChi = KH_DiaChi; khItem.Email = KH_Email; khItem.FacebookUid = string.Empty; khItem.GioiTinh = Convert.ToBoolean(KH_GioiTinh); if (!string.IsNullOrEmpty(KH_KhuVuc_ID)) { khItem.KhuVuc_ID = new Guid(KH_KhuVuc_ID); } khItem.ID = Guid.NewGuid(); khItem.Ma = KH_Ma; khItem.Mobile = KH_Mobile; khItem.NgayCapNhat = DateTime.Now; khItem.NgaySinh = Convert.ToDateTime(KH_NgaySinh, new CultureInfo("vi-Vn")); khItem.NguoiCapNhat = Security.Username; khItem.NguoiTao = Security.Username; if (!string.IsNullOrEmpty(LinhVuc_ID)) { khItem.LinhVuc_ID = new Guid(LinhVuc_ID); } khItem.TuVanVien = TuVanVien; if (!string.IsNullOrEmpty(KH_NguonGoc_ID)) { khItem.NguonGoc_ID = new Guid(KH_NguonGoc_ID); } if (!string.IsNullOrEmpty(KH_NguoiGioiThieu)) { khItem.NguoiGioiThieu = new Guid(KH_NguoiGioiThieu); } khItem.Phone = KH_Phone; khItem.Ten = KH_Ten; khItem.Ym = KH_Ym; khItem.NgayTao = DateTime.Now; khItem.Anh = Anh; khItem = KhachHangDal.Insert(khItem); sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(khItem)); } break; #endregion case "editTuVan": #region editTuVan var itemEditTuvan = TuVanDal.SelectById(new Guid(ID)); itemEditTuvan._TuVanTinhTrang = TuVanTinhTrangDal.SelectByTvId(ID); sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(itemEditTuvan)); break; #endregion case "saveTuVan": #region saveTuVan if (!string.IsNullOrEmpty(So)) { var tvItem = new TuVan(); tvItem.ID = new Guid(ID); tvItem.DichVuDieuTriKhac = DichVuDieuTriKhac; tvItem.GhiChu = GhiChu; tvItem.HieuQua = false; tvItem.KH_ID = new Guid(KH_ID); tvItem.Ma = Ma; tvItem.Ngay = Convert.ToDateTime(Ngay, new CultureInfo("vi-Vn")); tvItem.NgayCapNhat = DateTime.Now; tvItem.NgayTao = DateTime.Now; tvItem.NguoiCapNhat = Security.Username; tvItem.NguoiTao = Security.Username; tvItem.So = So; tvItem.TinhTrangLanDa = TinhTrangLanDa; tvItem.TinhTrangSucKhoe = TinhTrangSucKhoe; tvItem.TuVanVien = TuVanVien; tvItem.YKienKhachHang = YKienKhachHang; tvItem = TuVanDal.Insert(tvItem); sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(tvItem)); } break; #endregion case "reports": #region bao cao var itemTuVanRpt = new List<TuVan>(); itemTuVanRpt.Add(TuVanDal.SelectById(new Guid(ID))); var listKh = new List<KhachHang>(); listKh.Add(KhachHangDal.SelectById(itemTuVanRpt[0].KH_ID)); RenderReport(itemTuVanRpt, listKh, DanhMucDal.SelectByTvId(ID).ToList(), "WORD", "Báo cáo", DateTime.Now.ToString("dd-mm-yy")); break; #endregion case "scpt": #region Nạp js sb.AppendFormat(@"{0}" , cs.GetWebResourceUrl(typeof(DangKy), "appStore.pmSpa.desktop.controls.KHang.DangKy.js")); break; #endregion case "print": #region Nạp js if(!string.IsNullOrEmpty(ID)) { var tvItem = TuVanDal.SelectById(new Guid(ID)); var khItem = KhachHangDal.SelectById(tvItem.KH_ID); var memItem = MemberDal.SelectByUser(tvItem.TuVanVien); var printFormat = Lib.GetResource(Assembly.GetExecutingAssembly(), "KHang.TuVan-In.htm"); var ttFormat = Lib.GetResource(Assembly.GetExecutingAssembly(), "KHang.TuVan-In-TinhTrang-Item.htm"); var dvFormat = Lib.GetResource(Assembly.GetExecutingAssembly(), "KHang.TuVan-In-DichVu-Item.htm"); var sbTinhTrang = new StringBuilder(); var sbDichVu = new StringBuilder(); var tinhTrangItem = new DanhMuc(); var dichVuItem = new TinhTrangDichVu(); foreach (var rel in RelationDal.SelectByPid(tvItem.ID.ToString())) { tinhTrangItem = DanhMucDal.SelectById(rel.CID); sbDichVu=new StringBuilder(); foreach (var itemdv in TinhTrangDichVuDal.SelectDmId(rel.CID.ToString())) { sbDichVu.AppendFormat(dvFormat , itemdv.dvu.Ma , itemdv.dvu.Ten , itemdv.dvu.SoLan , itemdv.dvu.ThoiGian , string.Format(new CultureInfo("vi-Vn"), "{0:c}", itemdv.dvu.Gia).Replace(",00 ₫", "")); } sbTinhTrang.AppendFormat(ttFormat, tinhTrangItem.Ten, sbDichVu); } sb.AppendFormat(printFormat , cs.GetWebResourceUrl(typeof (DangKy),"appStore.pmSpa.desktop.controls.KHang.start-up.png") , khItem.Ma , string.Empty , tvItem.So , tvItem.NgayTao.ToString("dd/MM/yy") , memItem.Ten , khItem.Ten , khItem.GioiTinh ? "Nữ" : "Nam" , khItem.NgaySinh.ToString("dd/MM/yy") , khItem.DiaChi , khItem.KhuVuc_Ten , khItem.Phone , khItem.Mobile , khItem.Ym , khItem.CMND , khItem.Email , khItem.NguonGoc_Ten , tvItem.TinhTrangSucKhoe , tvItem.TinhTrangLanDa , tvItem.YKienKhachHang , sbTinhTrang , tvItem.DichVuDieuTriKhac , cs.GetWebResourceUrl(typeof(DangKy), "appStore.pmSpa.desktop.controls.KHang.Print.css")); } break; #endregion default: #region nạp var listFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId); sb.Append(Lib.GetResource(Assembly.GetExecutingAssembly(), "KHang.TuVan.htm")); sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>" , cs.GetWebResourceUrl(typeof(DangKy), "appStore.pmSpa.desktop.controls.KHang.DangKy.js") , "{danhMucDichVuMgr.loadgrid();}"); sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(listFn)); break; #endregion } Html = sb.ToString(); base.KhoiTao(con); }
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"]; DanhMuc Item; List<DanhMuc> List=new List<DanhMuc>(); #endregion switch (subAct) { case "get": #region lấy dữ liệu cho grid if (!string.IsNullOrEmpty(Request["s"])) { } List = getTree(DanhMucDal.SelectByDmLang(_LDMID, _Lang)); List<jgridRow> ListRow = new List<jgridRow>(); foreach (DanhMuc dm in List) { ListRow.Add(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" })); } jgrid grid = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage, List.Count.ToString(), List.Count.ToString(), ListRow); sb.Append(JavaScriptConvert.SerializeObject(grid)); break; #endregion case "new": break; case "del": #region xóa if (!string.IsNullOrEmpty(_ID)) { DanhMucDal.UpdateDeletedById(Convert.ToInt32(_ID), true); } break; #endregion case "edit": #region chỉnh sửa if (!string.IsNullOrEmpty(_ID)) { sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(DanhMucDal.SelectById(Convert.ToInt32(_ID)))); } break; #endregion case "save": #region lưu if (!string.IsNullOrEmpty(_ID)) { Item = DanhMucDal.SelectById(Convert.ToInt32(_ID)); } else { Item = new DanhMuc(); } Item.Ten = _Ten; Item.Ma = _Ma; Item.LDM_ID = Int32.Parse(_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 = Convert.ToInt32(_LangBased_ID); } if (!string.IsNullOrEmpty(_PID)) { Item.PID = Convert.ToInt32(_PID); } if (!string.IsNullOrEmpty(_ID)) { Item = DanhMucDal.Update(Item); } else { Item.NgayTao = DateTime.Now; Item.RowId = Guid.NewGuid(); Item = DanhMucDal.Insert(Item); } sb.Append("1"); break; #endregion case "quickSave": #region Lưu nhanh if (!string.IsNullOrEmpty(_Ten)) { DanhMuc _dmQS = DanhMucDal.QuickSave(_Ten, _KyHieu, _LDMID); sb.AppendFormat(@"({0})", JavaScriptConvert.SerializeObject(_dmQS)); } break; #endregion case "getPidByDm": #region Lấy danh sách danh mục if (string.IsNullOrEmpty(_Lang)) { _Lang = "Vi-vn"; } DanhMucCollection listgetPidByDm = DanhMucDal.SearchByLDM(_LDMID, _q, _Lang); sb.Append(JavaScriptConvert.SerializeObject(getTree(listgetPidByDm))); break; #endregion case "autoCompleteLangBased": #region Lấy danh sách danh mục Item = new DanhMuc(); //Item.ID = 0; //Item.Ten = "Chọn"; if (string.IsNullOrEmpty(_Lang)) { _Lang = "Vi-vn"; } List = getTree(DanhMucDal.SelectLangBased(_ID, _LDM_Ma)); //List.Insert(0, Item); sb.Append(JavaScriptConvert.SerializeObject(List)); break; #endregion case "autocompleteSelectPidByMa": #region Lấy danh sách danh mục Item = new DanhMuc(); if (string.IsNullOrEmpty(_Lang)) { _Lang = "Vi-vn"; } List = DanhMucDal.SelectPidByMa(_ID, _LDM_Ma); sb.Append(JavaScriptConvert.SerializeObject(List)); break; #endregion case "getPidByDmTop": #region Lấy danh sách danh mục if (string.IsNullOrEmpty(_Lang)) { _Lang = "Vi-vn"; } DanhMucCollection listgetPidByDmTop = DanhMucDal.SearchByLDM(_LDMID, _q, _Lang); sb.Append(JavaScriptConvert.SerializeObject(getTreeTop(listgetPidByDmTop))); break; #endregion case "autoCompleteByLoaiNguoiThao": #region Tìm người thảo sb.Append(JavaScriptConvert.SerializeObject(DanhMucDal.SearchNguoiThao("20", _q))); break; #endregion case "getByLdmAndPID": #region Lấy danh sách danh mục DanhMucCollection listByLdmAndPID = DanhMucDal.ByLdmAndPID(_LDMID, _PID); sb.Append(JavaScriptConvert.SerializeObject(listByLdmAndPID)); break; #endregion case "getNoiNhanList": #region nơi nhận if (!string.IsNullOrEmpty(_LDMID)) { DanhMucCollection listHead = DanhMucDal.NoiGuiListDmGiaTri(_LDMID); DanhMucCollection listDm = DanhMucDal.NoiGuiListDmbyPid(_LDMID,_PID); foreach (DanhMuc item in listHead) { sb.AppendFormat("<div class=\"adm-selectList-item-header\">"); sb.AppendFormat("<input dm=\"0\" type=\"checkbox\" /> {0}" , item.Ten); sb.AppendFormat("</div>"); var _dml = from _dm in listDm.ToList() where _dm.GiaTri == item.GiaTri select _dm; if (_dml.Count() > 0) { sb.AppendFormat("<div class=\"adm-selectList-box\">"); foreach (DanhMuc _item in _dml) { sb.AppendFormat("<span class=\"adm-selectList-item\"><input {0} _role=\"cid\" _value=\"{1}\" type=\"checkbox\" /> <span>{2}</span></span>" , _item.NguoiTao == "0" ? "" : " checked=\"checked\" " , _item.RowId , _item.Ten); } sb.AppendFormat("</div>"); } } } break; #endregion case "autoCompleteLangBasedByMaDanhMuc": #region Lấy danh sách danh mục // DanhMuc ItemDanhMuc = new DanhMuc(); // List<DanhMuc> ListDanhMuc = new List<DanhMuc>(); List = getTree(DanhMucDal.SelectLangBasedByMaDanhMuc(_Ma)); sb.Append(JavaScriptConvert.SerializeObject(List)); break; #endregion case "autoCompleteLangBasedByDM": #region Lấy danh sách danh mục Item = new DanhMuc(); //Item.ID = 0; //Item.Ten = "Chọn"; if (string.IsNullOrEmpty(_ID)) { _ID = ""; } if (string.IsNullOrEmpty(_Lang)) { _Lang = "Vi-vn"; } List = getTree(DanhMucDal.SelectLangBasedByMa(_ID, _Ma)); //List.Insert(0, Item); sb.Append(JavaScriptConvert.SerializeObject(List)); break; #endregion case "getTree": #region getTree: lấy sơ đồ cây sb.Append(JavaScriptConvert.SerializeObject(getTree(DanhMucDal.SelectByKyHieu("home")))); break; //if (!string.IsNullOrEmpty(_ID)) //{ // sb.Append("(" + JavaScriptConvert.SerializeObject(DanhMucDal.SelectById(Convert.ToInt32(_ID))) + ")"); //} #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(@"<div class=""mdl-head""> <span class=""mdl-head-searchPnl ui-state-default ui-corner-all""> <a href=""javascript:;"" class=""mdl-head-clearSearch""></a> <input type=""text"" class=""mdl-head-txt mdl-head-search mdl-head-search-danhmuc"" /> </span> <a class=""mdl-head-btn mdl-head-add"" id=""danhMucMdl-addBtn"" href=""javascript:"" onclick=""danhmuc.add('#danhmucmdl-List');"">Thêm</a> <a class=""mdl-head-btn mdl-head-add"" id=""danhMucMdl-addBtn"" href=""javascript:"" onclick=""danhmuc.addLang();"" >Thêm ngôn ngứ phụ</a> <a class=""mdl-head-btn mdl-head-edit"" id=""danhMucMdl-editBtn"" href=""javascript:"" onclick=""danhmuc.edit('#danhmucmdl-List');"">Sửa</a> <a class=""mdl-head-btn mdl-head-del"" id=""danhMucMdl-delBtn"" href=""javascript:"" onclick=""danhmuc.del('#danhmucmdl-List');"" >Xóa</a> <select class=""slt"" onchange=""danhmuc.search();"" id=""danhMucMdl-changeLangSlt""></select> <span class=""mdl-head-filterPnl ui-state-default ui-corner-all""> <a href=""javascript:;"" class=""mdl-head-clearSearch""></a> <input type=""text"" _value="""" class=""mdl-head-filter mdl-head-filterloaidanhmuc""/> </span> </div> <table id=""danhmucmdl-List"" class=""mdl-list""></table> <div id=""danhmucmdl-Pager""></div>"); 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) { StringBuilder sb = new StringBuilder(); DanhMuc ItemDm = new DanhMuc(); string _id = Request["ID"]; using (SqlConnection con = DAL.con()) { Item = TinDal.SelectById(Convert.ToInt64(_id)); ItemDm = DanhMucDal.SelectById(Item.ID); int i = 0; List<Tin> ListMoiHon = TinDal.lienQuanMoiHon(con, 10, _id); if (ListMoiHon.Count > 0) { foreach (Tin item in ListMoiHon) { i++; sb.Append(formatItem(item, i == (ListMoiHon.Count - 1))); } } else { } txtMoiHon = sb.ToString(); sb = new StringBuilder(); i = 0; List<Tin> ListCuHon = TinDal.lienQuanCuHon(con, 10, _id); if (ListCuHon.Count > 0) { foreach (Tin item in ListCuHon) { i++; sb.Append(formatItem(item, i == (ListCuHon.Count - 1))); } } else { } txtCuHon = sb.ToString(); sb = new StringBuilder(); DanhMucCollection ListDm = DanhMucDal.SelectTreeParentByDmId(con, Item.DM_ID.ToString()); sb.AppendFormat(@"<ul class=""tin-view-navi-menus"">"); sb.AppendFormat(@"<li> <a href=""/"" class=""tin-view-navi-menus-item home""> Trang chủ </a> </li>"); foreach (DanhMuc itemDm in ListDm) { if (itemDm.PID != 0) { sb.AppendFormat(@"<li><a class=""tin-view-navi-menus-item"" href=""/Tin-Tuc/{0}/{1}/"">{2}</a></li>" , itemDm.Ma, itemDm.ID, itemDm.Ten); } } sb.AppendFormat(@"</ul>"); HtmlMeta meta = new HtmlMeta(); meta.Name = "description"; meta.Content = Item.MoTa; this.Page.Header.Controls.Add(meta); this.Page.Header.Title = string.Format("{0}", Item.Ten); txtPath = sb.ToString(); sb = new StringBuilder(); CommentCollection ListCm = CommentDal.SelectActive(10, _id); foreach (Comment item in ListCm) { sb.Append(formatCom(item)); } txtBl = sb.ToString(); } txt = sb.ToString(); }
protected override void Render(HtmlTextWriter writer) { StringBuilder sb = new StringBuilder(); ClientScriptManager cs = this.Page.ClientScript; DanhMuc Item; List<DanhMuc> List = new List<DanhMuc>(); #region tham số string msg = Request["NoiDungLienHe"]; string msgtitle = Request["msgtitle"]; string MaDanhMuc = Request["MaDanhMuc"]; string _LDM_Ma = Request["LDM_Ma"]; sendEmailDele _dele = new sendEmailDele(sendmailThongbao); string _ID = Request["ID"]; string _Ten = Request["Ten"]; string _Anh = Request["Anh"]; string _Url = Request["Url"]; string _ThuTu = Request["ThuTu"]; string _ViTri = Request["ViTri"]; string _ViTri_Ten = Request["ViTri_Ten"]; string _TrangQuangCao = Request["TrangQuangCao"]; string _TrangQuangCao_Ten = Request["TrangQuangCao_Ten"]; string _Active = Request["Active"]; string _NgayHetHan = Request["NgayHetHan"]; string _NgayDangKy = Request["NgayDangKy"]; string _TenDonVi = Request["TenDonVi"]; string _DiaChiDonVi = Request["DiaChiDonVi"]; string _NguoiLienHe = Request["NguoiLienHe"]; string _Email = Request["Email"]; string _DienThoai = Request["DienThoai"]; string _SoTienThanhToan = Request["SoTienThanhToan"]; QuangCao ItemQC; #endregion //autoCompleteLangBasedDanhMuc switch (subAct) { case "SaveDKDVQC": #region Save Đăng ký dịch vụ quảng cáo if (!string.IsNullOrEmpty(_ID)) { ItemQC = QuangCaoDal.SelectByIdHoangDA(Convert.ToInt32(_ID)); } else { ItemQC = new QuangCao(); } ItemQC.Ten = _Ten; ItemQC.Anh = _Anh; ItemQC.Url = _Url; //ItemQC.ThuTu = int.Parse(_ThuTu); ItemQC.ViTri = int.Parse(_ViTri); ItemQC.ViTri_Ten = _ViTri_Ten; ItemQC.TrangQuangCao = int.Parse(_TrangQuangCao); ItemQC.TrangQuangCao_Ten = _TrangQuangCao_Ten; ItemQC.Active = Convert.ToBoolean(_Active); ItemQC.NgayHetHan = Convert.ToDateTime(_NgayHetHan, new CultureInfo("vi-vn")); ItemQC.NgayCapNhat = DateTime.Now; ItemQC.NgayDangKy = Convert.ToDateTime(_NgayDangKy, new CultureInfo("vi-vn")); ItemQC.TenDonVi = _TenDonVi; ItemQC.DiaChiDonVi = _DiaChiDonVi; ItemQC.NguoiLienHe = _NguoiLienHe; ItemQC.Email = _Email; ItemQC.DienThoai = _DienThoai; ItemQC.SoTienThanhToan = Double.Parse(_SoTienThanhToan); if (!string.IsNullOrEmpty(_ID)) { ItemQC = QuangCaoDal.UpdateHoangDA(ItemQC); } else { ItemQC.NgayTao = DateTime.Now; ItemQC.RowId = Guid.NewGuid(); ItemQC.NguoiTao = Security.Username; ItemQC = QuangCaoDal.InsertHoangDA(ItemQC); } sb.Append("1"); break; #endregion case "edit": #region chỉnh sửa if (!string.IsNullOrEmpty(_ID)) { sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(DanhMucDal.SelectById(Convert.ToInt32(_ID)))); } break; #endregion case "autoCompleteLangBasedByDanhMucId": #region Lấy danh sách danh mục DanhMuc ItemDanhMuc = new DanhMuc(); List<DanhMuc> ListDanhMuc = new List<DanhMuc>(); ListDanhMuc = DanhMucDal.SelectLangBasedByDanhMucId(_ID); sb.Append(JavaScriptConvert.SerializeObject(ListDanhMuc)); break; #endregion case "autoCompleteLangBased": #region Lấy danh sách danh mục Item = new DanhMuc(); List = getTree(DanhMucDal.SelectLangBasedFixHoangda(_ID, _LDM_Ma)); sb.Append(JavaScriptConvert.SerializeObject(List)); break; #endregion case "LoadHoTroDKDV": #region load hỗ trợ đăng ký dịch vụ sb.Append(JavaScriptConvert.SerializeObject(DanhMucDal.SelectLangBased("", MaDanhMuc))); break; #endregion case "lienHe": Member memberinfo = MemberDal.SelectByUser(Security.Username); #region lienhe _dele.BeginInvoke("" , string.Format(msgtitle) , string.Format(NoiDungLienHe, memberinfo.Username, memberinfo.Ten, memberinfo.DiaChi, memberinfo.Email, memberinfo.Mobile, msg) , null, null); break; #endregion case "get": #region lấy dữ liệu gian hàng sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(GianHangDal.SelectByUserCoQuan(Security.Username))); break; #endregion case "scpt": #region Nạp js sb.AppendFormat(@"{0}" , cs.GetWebResourceUrl(typeof(Class1), "cnn.plugin.DangKyDichVu.DangKyDVQuangCao.JScript1.js")); break; #endregion default: #region FunctionCollection ListFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId); sb.Append(@" <div id=""DangKyDVQuangCaoFn-Main""></div> "); sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>" , cs.GetWebResourceUrl(typeof(Class1), "cnn.plugin.DangKyDichVu.DangKyDVQuangCao.JScript1.js") , "{DangKyDVQuangCaoFn.LoadForm();}"); sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(ListFn)); break; #endregion } writer.Write(sb.ToString()); base.Render(writer); }