public List <ProGroupModel> TagsTbl() { var res = new List <ProGroupModel>(); PDBC db = new PDBC("PandaMarketCMS", true); db.Connect(); DataTable dt = db.Select("SELECT D.id_TE,B.PTname,A.MCName,C.SCName,D.TE_name FROM [tbl_Product_MainCategory] as A inner join [tbl_Product_Type] as B on A.id_PT=B.id_PT inner join [tbl_Product_SubCategory] as C on A.id_MC=C.id_MC inner join [tbl_Product_TagEnums] as D on C.id_SC=D.SubCatId"); db.DC(); for (int i = 0; i < dt.Rows.Count; i++) { var model = new ProGroupModel() { Num = i + 1, Id = Convert.ToInt32(dt.Rows[i]["id_TE"]), Type = dt.Rows[i]["PTname"].ToString(), Main = dt.Rows[i]["MCName"].ToString(), Sub = dt.Rows[i]["SCName"].ToString(), SubK = dt.Rows[i]["TE_name"].ToString(), }; res.Add(model); } return(res); }
public List <ProGroupModel> SubCatTbl() { var res = new List <ProGroupModel>(); PDBC db = new PDBC("PandaMarketCMS", true); db.Connect(); DataTable dt = db.Select("SELECT C.id_SC,B.PTname,A.MCName,C.ISDelete,C.ISDESABLED,C.SCName FROM [tbl_Product_MainCategory] as A inner join [tbl_Product_Type] as B on A.id_PT=B.id_PT inner join [tbl_Product_SubCategory] as C on A.id_MC=C.id_MC"); db.DC(); for (int i = 0; i < dt.Rows.Count; i++) { var model = new ProGroupModel() { Num = i + 1, Id = Convert.ToInt32(dt.Rows[i]["id_SC"]), IsDeleted = Convert.ToInt32(dt.Rows[i]["ISDelete"]), IsDisables = Convert.ToInt32(dt.Rows[i]["ISDESABLED"]), Type = dt.Rows[i]["PTname"].ToString(), Main = dt.Rows[i]["MCName"].ToString(), Sub = dt.Rows[i]["SCName"].ToString() }; res.Add(model); } return(res); }
public List <ProGroupModel> SubCatvValueTbl() { var res = new List <ProGroupModel>(); PDBC db = new PDBC("PandaMarketCMS", true); db.Connect(); DataTable dt = db.Select("SELECT E.id_SCOV,B.PTname,A.MCName,C.SCName,D.SCOKName,E.SCOVValueName FROM [tbl_Product_MainCategory] as A inner join [tbl_Product_Type] as B on A.id_PT=B.id_PT inner join [tbl_Product_SubCategory] as C on A.id_MC=C.id_MC inner join [tbl_Product_SubCategoryOptionKey] as D on C.id_SC=D.id_SC inner join [tbl_Product_SubCategoryOptionValue] as E on D.id_SCOK=E.id_SCOK"); db.DC(); for (int i = 0; i < dt.Rows.Count; i++) { var model = new ProGroupModel() { Num = i + 1, Id = Convert.ToInt32(dt.Rows[i]["id_SCOV"]), Type = dt.Rows[i]["PTname"].ToString(), Main = dt.Rows[i]["MCName"].ToString(), Sub = dt.Rows[i]["SCName"].ToString(), SubK = dt.Rows[i]["SCOKName"].ToString(), SubVal = dt.Rows[i]["SCOVValueName"].ToString() }; res.Add(model); } return(res); }
public List <ProGroupModel> TypeTbl() { var res = new List <ProGroupModel>(); PDBC db = new PDBC("PandaMarketCMS", true); db.Connect(); DataTable dt = db.Select("SELECT [id_PT],[PTname],[ISDESABLED],[ISDelete]FROM [tbl_Product_Type]"); db.DC(); for (int i = 0; i < dt.Rows.Count; i++) { var model = new ProGroupModel() { Num = i + 1, Id = Convert.ToInt32(dt.Rows[i]["id_PT"]), IsDeleted = Convert.ToInt32(dt.Rows[i]["ISDelete"]), IsDisables = Convert.ToInt32(dt.Rows[i]["ISDESABLED"]), Type = dt.Rows[i]["PTname"].ToString() }; res.Add(model); } return(res); }