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