public DataTable GetByParent(string pID)
{
string sql = "select * from DM_CoQuanHanhChinh where CoQuanQuanLy=" + pID;
DataTable dt = Sys_Common.getDataByQuery(sql);
return(dt);
}
public DataTable GetAll()
{
string sql = "select * from VitriMenu";
DataTable dt = Sys_Common.getDataByQuery(sql);
return(dt);
}
public DataTable GetByParent(string pID, int type)
{
string sql = "select DanhMucID,TenDanhMuc from DanhMucMedia where DanhMucCha=" + pID + " and TheLoai=" + type;
DataTable dt = Sys_Common.getDataByQuery(sql);
return(dt);
}
public DataTable GetByParent(string pID)
{
string sql = "select * from Document where DanhMuc=" + pID;
DataTable dt = Sys_Common.getDataByQuery(sql);
return(dt);
}
public DataTable GetByFrame(int frame)
{
string sql = "select * from Menu where Duyet=1 and FrameViewID=" + frame;
DataTable dt = Sys_Common.getDataByQuery(sql);
return(dt);
}
public DataTable GetByParent(string p, string vitri, string lang = "vi")
{
string sql = "select MenuID,TenMenu,dbo.getUrl(MenuID,'Menu',null) as url,ChucNangID from Menu where Duyet=1 and Vitri =" + vitri + " and ParentID=" + p + " and Lang='" + lang + "' order by Stt";
DataTable dt = Sys_Common.getDataByQuery(sql);
return(dt);
}
public DataTable GetByParent(string pID)
{
string sql = "select LoaiID,MaLoai,TenLoai,ParentID,Stt from DM_LoaiDiSan where ParentID=" + pID + " order by Stt";
DataTable dt = Sys_Common.getDataByQuery(sql);
return(dt);
}
public DataTable GetByPosition(string p, string lang = "vi")
{
string sql = "select * from Menu where Vitri=" + p + " and Lang='" + lang + "'";
DataTable dt = Sys_Common.getDataByQuery(sql);
return(dt);
}
public DataTable GetAll()
{
string sql = "select * from DanhHieuNgheNhan";
DataTable dt = Sys_Common.getDataByQuery(sql);
return(dt);
}
public DataTable GetAll()
{
string sql = "select * from FrameView where Duyet=1";
DataTable dt = Sys_Common.getDataByQuery(sql);
return(dt);
}
public DataTable GetAll(string lang = "vi")
{
string ten = lang == "vi" ? "TenDanhMuc" : "EngName";
string sql = "select DanhMucID," + ten + " as TenDanhMuc,EngName,(select TenAnh from Image i where i.ImageID=d.HinhAnh) as HinhAnh,dbo.getUrl(DanhMucID,'DM_DiSan',null) as url from DM_DiSan d";
DataTable dt = Sys_Common.getDataByQuery(sql);
return(dt);
}
public NV_Menu_ChiTiet GetByUrl(string url)
{
string sql = "select top 1 *,dbo.getUrl(MenuID,'Menu',null) as UrlFull from Menu where Duyet=1 and TenUrl='" + url + "'";
DataTable dt = Sys_Common.getDataByQuery(sql);
NV_Menu_ChiTiet menu = new NV_Menu_ChiTiet();
if (dt != null && dt.Rows.Count > 0)
{
menu = new NV_Menu_ChiTiet(dt);
}
return(menu);
}
public NV_BaiViet_AnPham_ChiTiet GetByUrl(string url)
{
string sql = "select top 1 *,(select TenAnh from Image i where i.ImageID=bv.HinhAnh) as AnhDaiDien from BaiViet_AnPham bv where Duyet=1 and Url='" + url + "'";
DataTable dt = Sys_Common.getDataByQuery(sql);
NV_BaiViet_AnPham_ChiTiet bv = new NV_BaiViet_AnPham_ChiTiet();
if (dt != null && dt.Rows.Count > 0)
{
bv = new NV_BaiViet_AnPham_ChiTiet(dt);
}
return(bv);
}
public NV_AnPham_ChiTiet GetByUrl(string url)
{
string sql = "select top 1 * from AnPham where Url='" + url + "'";
DataTable dt = Sys_Common.getDataByQuery(sql);
NV_AnPham_ChiTiet bv = new NV_AnPham_ChiTiet();
if (dt != null && dt.Rows.Count > 0)
{
bv = new NV_AnPham_ChiTiet(dt);
}
return(bv);
}
public NV_DanhMucAnPham_ChiTiet GetByUrl(string url)
{
string sql = "select top 1 *,dbo.getUrl(DanhMucID,'DanhMucAnPham',null) as UrlFull from DanhMucAnPham where Url='" + url + "'";
DataTable dt = Sys_Common.getDataByQuery(sql);
NV_DanhMucAnPham_ChiTiet menu = new NV_DanhMucAnPham_ChiTiet();
if (dt != null && dt.Rows.Count > 0)
{
menu = new NV_DanhMucAnPham_ChiTiet(dt);
}
return(menu);
}
public NV_DanhMucDuong_ChiTiet GetByUrl(string url)
{
string sql = "select top 1 * from DanhMucDuong where Url='" + url + "'";
DataTable dt = Sys_Common.getDataByQuery(sql);
NV_DanhMucDuong_ChiTiet menu = new NV_DanhMucDuong_ChiTiet();
if (dt != null && dt.Rows.Count > 0)
{
menu = new NV_DanhMucDuong_ChiTiet(dt);
}
return(menu);
}
public NV_DiSanVanHoa_ChiTiet GetByUrl(string url)
{
//string sql = "select top 1 *,(select TenAnh from Image where ImageID=AnhBanDo) as TenAnhBanDo from DiSanVanHoa where Url='" + url + "'";
string sql = "select top 1 *,'' as TenAnhBanDo from DiSanVanHoa where Url='" + url + "'";
DataTable dt = Sys_Common.getDataByQuery(sql);
NV_DiSanVanHoa_ChiTiet ds = new NV_DiSanVanHoa_ChiTiet();
if (dt != null && dt.Rows.Count > 0)
{
ds = new NV_DiSanVanHoa_ChiTiet(dt);
}
return(ds);
}
public string GetNotification()
{
DataTable myTable = Sys_Common.RunTableBySQL("SELECT TOP 10 * FROM " + TableName + " A LEFT JOIN HT_Nguoi_Dung B ON A.Ma_Nguoi_Dung = B.Ma_Nguoi_Dung WHERE Ma_Don = '" + Ma_Ho_So + "' ORDER BY Ngay_Ghi_Nhan");
string result = "<font face='Tahoma' size='2'>";
if (myTable != null)
{
for (int i = 0; i < myTable.Rows.Count; i++)
{
result += "<b>" + myTable.Rows[i]["Ho_Ten"].ToString() + " phản hồi lúc " + DateTime.Parse(myTable.Rows[i]["Ngay_Ghi_Nhan"].ToString()).ToString("dd/MM/yyyy hh:mm:ss") + "</b><br>" + myTable.Rows[i]["Noi_Dung_Phan_Hoi"].ToString() + "<br>";
}
}
result += "</font>";
return(result);
}
public NV_DM_DiSan_ChiTiet GetByUrl(string url)
{
string sql = "select DanhMucID,TenDanhMuc,EngName,(select TenAnh from Image i where i.ImageID=d.HinhAnh) as HinhAnh,dbo.getUrl(DanhMucID,'DM_DiSan',null) as url from DM_DiSan d where d.Url='" + url + "'";
DataTable dt = Sys_Common.getDataByQuery(sql);
NV_DM_DiSan_ChiTiet dm = new NV_DM_DiSan_ChiTiet();
if (dt != null && dt.Rows.Count > 0)
{
dm.DanhMucID = int.Parse(dt.Rows[0]["DanhMucID"].ToString());
dm.TenDanhMuc = dt.Rows[0]["TenDanhMuc"].ToString();
dm.EngName = dt.Rows[0]["EngName"].ToString();
dm.Url = dt.Rows[0]["url"].ToString();
dm.HinhAnh = dt.Rows[0]["HinhAnh"].ToString();
}
return(dm);
}
public bool checkRole(string Ma_Du_An, string MaND)
{
string sql = "select distinct Ma_Du_An from HT_Vai_Tro_Du_An where Ma_Vai_Tro in (SELECT Ma_Vai_Tro FROM HT_Nguoi_Dung_Vai_Tro NVT where NVT.Ma_Nguoi_Dung = " + MaND + ")";
DataTable dt = Sys_Common.RunTableBySQL(sql);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (dr["Ma_Du_An"].ToString().Equals(Ma_Du_An))
{
return(true);
}
}
}
return(false);
}
public int taoStt(int stt, int pID)
{
string sql = "select Stt from DM_LoaiDisan where ParentID=" + pID + " order by Stt";
DataTable dt = Sys_Common.getDataByQuery(sql);
if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows[0]["Stt"].ToString().Equals("1"))
{
dt.Rows[0]["Stt"] = "2";
for (int i = 0; i < dt.Rows.Count; i++)
{
//if(dt.Rows[""])
}
}
}
return(1);
}
public NV_DM_LoaiDiSan_ChiTiet GetByUrl(string url)
{
string sql = "select * from DM_LoaiDiSan where Url='" + url + "'";
DataTable dt = Sys_Common.getDataByQuery(sql);
NV_DM_LoaiDiSan_ChiTiet model = new NV_DM_LoaiDiSan_ChiTiet();
if (dt != null && dt.Rows.Count > 0)
{
model.LoaiID = int.Parse(dt.Rows[0]["LoaiID"].ToString());
model.MaLoai = dt.Rows[0]["MaLoai"].ToString();
model.TenLoai = dt.Rows[0]["TenLoai"].ToString();
model.EngName = dt.Rows[0]["EngName"].ToString();
try
{
model.ParentID = int.Parse(dt.Rows[0]["ParentID"].ToString());
}
catch { }
model.GhiChu = dt.Rows[0]["GhiChu"].ToString();
model.Stt = int.Parse(dt.Rows[0]["Stt"].ToString());
}
return(model);
}
