private void SearchResult() { try { string keyword = CpanelUtils.ClearUnicode(txtKeyword.Value); var AllList = (from g in DB.ESHOP_NEWs where ("" == keyword || DB.fClearUnicode(g.NEWS_TITLE).Contains(keyword) || g.NEWS_DESC.Contains(keyword)) //&& g.NEWS_LANGUAGE == lang && (g.NEWS_TYPE != 1 && g.NEWS_TYPE != 2) orderby g.NEWS_ID descending select g); if (AllList.ToList().Count > 0) { Session["NewsList"] = DataUtil.LINQToDataTable(AllList); } GridItemList.DataSource = AllList; if (AllList.ToList().Count > GridItemList.PageSize) { GridItemList.AllowPaging = true; } else { GridItemList.AllowPaging = false; } GridItemList.DataBind(); } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void LoadCategoryParent() { try { var CatList = ( from t2 in DB.ESHOP_PROPERTies select new { PROP_ID = t2.PROP_NAME == "------- Root -------" ? 0 : t2.PROP_ID, PROP_NAME = t2.PROP_NAME, PROP_PARENT_ID = t2.PROP_PARENT_ID, PROP_RANK = t2.PROP_RANK } ); if (CatList.ToList().Count > 0) { DataRelation relCat; DataTable tbl = DataUtil.LINQToDataTable(CatList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["PROP_ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["PROP_ID"], ds.Tables[0].Columns["PROP_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; CpanelUtils.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null); ddlCategory.DataSource = dsCat.Tables[0]; ddlCategory.DataTextField = "PROP_NAME"; ddlCategory.DataValueField = "PROP_ID"; ddlCategory.DataBind(); } else { DataTable dt = new DataTable("Newtable"); dt.Columns.Add(new DataColumn("PROP_ID")); dt.Columns.Add(new DataColumn("PROP_NAME")); DataRow row = dt.NewRow(); row["PROP_ID"] = 0; row["PROP_NAME"] = "--------Root--------"; dt.Rows.Add(row); ddlCategory.DataTextField = "PROP_NAME"; ddlCategory.DataValueField = "PROP_ID"; ddlCategory.DataSource = dt; ddlCategory.DataBind(); } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void SearchResult() { try { string keyword = CpanelUtils.ClearUnicode(txtKeyword.Value); var AllList = (from g in DB.ESHOP_CATEGORies where ("" == keyword || (DB.fClearUnicode(g.CAT_NAME)).Contains(keyword)) && g.CAT_RANK > 0 select new { g.CAT_ID, g.CAT_PARENT_ID, CAT_NAME = (string.IsNullOrEmpty(g.CAT_CODE) ? g.CAT_NAME : g.CAT_NAME + "(" + g.CAT_CODE + ")"), g.CAT_POSITION, g.CAT_LANGUAGE, g.CAT_ORDER, g.CAT_PERIOD_ORDER, g.CAT_RANK, g.CAT_STATUS }); if (AllList.ToList().Count > 0) { DataRelation relCat; //Session["CatList"] = DataUtil.LINQToDataTable(AllList); //DataTable tbl = Session["CatList"] as DataTable; DataTable tbl = DataUtil.LINQToDataTable(AllList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["CAT_ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["CAT_ID"], ds.Tables[0].Columns["CAT_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; DataUtil.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null); if (IsPostBack) { Rplistcate.DataSource = AllList; Rplistcate.DataBind(); } else { Rplistcate.DataSource = dsCat.Tables[0]; Rplistcate.DataBind(); } } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void SearchResult() { try { string keyword = CpanelUtils.ClearUnicode(txtKeyword.Value); if (_gtype != 1) { var AllList = (from g in DB.ESHOP_SHOPs where ("" == keyword || (DB.fClearUnicode(g.NAME)).Contains(keyword)) && g.FIELD1 == _userId.ToString() select new { g.ID, g.NAME, g.EMAIL, g.ADDRESS, g.PHONE, g.FIELD1, g.WEBSITE, g.TYPE, g.SEO_URL }); Rplistcate.DataSource = AllList; Rplistcate.DataBind(); } else { var AllList = (from g in DB.ESHOP_SHOPs where ("" == keyword || (DB.fClearUnicode(g.NAME)).Contains(keyword)) select new { g.ID, g.NAME, g.EMAIL, g.ADDRESS, g.PHONE, g.FIELD1, g.WEBSITE, g.TYPE, g.SEO_URL }); Rplistcate.DataSource = AllList; Rplistcate.DataBind(); } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void SearchResult() { try { string keyword = txtKeyword.Value; int _limit = 20; int _skip = 0; if (_page != 0) { _skip = _page * _limit - _limit; } var AllList = (from g in DB.ESHOP_PROPERTies where ("" == keyword || (g.PROP_NAME).Contains(keyword)) && g.PROP_RANK > 0 select new { g.PROP_ID, g.PROP_PARENT_ID, g.PROP_NAME, g.PROP_RANK }); if (AllList.ToList().Count > 0) { DataRelation relCat; Session["PropList"] = DataUtil.LINQToDataTable(AllList); //DataTable tbl = Session["CatList"] as DataTable; DataTable tbl = DataUtil.LINQToDataTable(AllList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["PROP_ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["PROP_ID"], ds.Tables[0].Columns["PROP_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; CpanelUtils.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null); RplistArea.DataSource = dsCat.Tables[0]; RplistArea.DataBind(); //LitPage.Text = pagechange.changePage("customer_list.aspx", AllList.ToList().Count, _limit, _page); } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void SearchResult() { try { string keyword = txtKeyword.Value; var AllList = (from g in DB.ESHOP_PROPERTies where ("" == keyword || (g.PROP_NAME).Contains(keyword)) && g.PROP_RANK > 0 select new { g.PROP_ID, g.PROP_PARENT_ID, g.PROP_NAME, g.PROP_RANK }); if (AllList.ToList().Count > 0) { DataRelation relCat; Session["PropList"] = DataUtil.LINQToDataTable(AllList); //DataTable tbl = Session["CatList"] as DataTable; DataTable tbl = DataUtil.LINQToDataTable(AllList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["PROP_ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["PROP_ID"], ds.Tables[0].Columns["PROP_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; CpanelUtils.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null); GridItemList.DataSource = dsCat.Tables[0]; //if (CatTable.Rows.Count > GridItemList.PageSize) // GridItemList.AllowPaging = true; //else // GridItemList.AllowPaging = false; GridItemList.DataBind(); } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void SearchResult() { try { int _limit = 20; int _skip = 0; string keyword = CpanelUtils.ClearUnicode(txtKeyword.Value); int _catid = Utils.CIntDef(ddlCategory.SelectedValue); if (_catid != 0 || !String.IsNullOrEmpty(keyword)) { _limit = 200; } if (_page != 0) { _skip = _page * _limit - _limit; } var AllList = (from g in DB.ESHOP_NEWs join a in DB.ESHOP_NEWS_CATs on g.NEWS_ID equals a.NEWS_ID into t2_join from d in t2_join.DefaultIfEmpty() where ("" == keyword || SqlMethods.Like(g.NEWS_KEYWORD_ASCII, "%" + keyword + "%") || g.NEWS_CODE.Contains(keyword)) && (_gtype != 1 ? (getCatid().Contains(d.ESHOP_CATEGORy.CAT_ID.ToString()) || getCatid().Contains(d.ESHOP_CATEGORy.CAT_PARENT_ID.ToString())) : true) && (_type == 1 ? g.NEWS_TYPE == 1 : g.NEWS_TYPE != 1) && ((d.ESHOP_CATEGORy.CAT_ID == _catid || d.ESHOP_CATEGORy.CAT_PARENT_PATH.Contains(_catid.ToString())) || 0 == _catid) orderby g.NEWS_ID descending select g).GroupBy(n => n.NEWS_ID).Select(n => new { NEWS_ID = n.First().NEWS_ID, NEWS_TITLE = n.First().NEWS_TITLE, NEWS_TYPE = n.First().NEWS_TYPE, NEWS_SHOWTYPE = n.First().NEWS_SHOWTYPE, NEWS_ORDER = n.First().NEWS_ORDER, NEWS_PUBLISHDATE = n.First().NEWS_PUBLISHDATE, }).OrderByDescending(n => n.NEWS_ID).ToList(); RpItemList.DataSource = AllList.Skip(_skip).Take(_limit); RpItemList.DataBind(); LitPage.Text = pagechange.changePageNews("news_list.aspx", AllList.Count, _limit, _page, _type); } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void Loadinventory() { string keyword = CpanelUtils.ClearUnicode(txtKeyword.Value); var list = DB.ESHOP_NEWs.Where(n => n.NEWS_TYPE == 1 && (DB.fClearUnicode(n.NEWS_TITLE).Contains(keyword) || DB.fClearUnicode(n.NEWS_CODE).Contains(keyword) || "" == keyword)).OrderByDescending(n => n.NEWS_ID).ToList(); if (list.Count > 0) { ASPxGridView_inventory.DataSource = list; ASPxGridView_inventory.DataBind(); HttpContext.Current.Session["buy.listinvent"] = list; } else { HttpContext.Current.Session["buy.listinvent"] = null; ASPxGridView_inventory.DataSource = list; ASPxGridView_inventory.DataBind(); } }
public string getPosition(object obj_position) { List <string[]> l = CpanelUtils.listAds(); var list = from obj in l select new { Id = obj[0], Name = obj[1] }; foreach (var i in list) { if (Utils.CIntDef(obj_position) == Utils.CIntDef(i.Id)) { return(i.Name); } } return(""); }
private void SearchResult() { try { string keyword = txtKeyword.Value; int _limit = 20; int _skip = 0; if (_page != 0) { _skip = _page * _limit - _limit; } var AllList = (from g in DB.MENUs where "" == keyword || g.MENU_NAME.Contains(keyword) orderby g.ID descending select g); if (AllList.ToList().Count > 0) { DataRelation relCat; DataTable tbl = DataUtil.LINQToDataTable(AllList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["ID"], ds.Tables[0].Columns["MENU_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; CpanelUtils.TransformTableWithSpace2(ref CatTable, dsCat.Tables[0], relCat, null); RplistMenu.DataSource = dsCat.Tables[0]; RplistMenu.DataBind(); //LitPage.Text = pagechange.changePage("customer_list.aspx", AllList.ToList().Count, _limit, _page); } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void SearchResult() { try { int _limit = 20; int _skip = 0; string keyword = CpanelUtils.ClearUnicode(txtKeyword.Value); int _catid = Utils.CIntDef(ddlCategory.SelectedValue); if (_catid != 0 || !String.IsNullOrEmpty(keyword)) { _limit = 200; } if (_page != 0) { _skip = _page * _limit - _limit; } var AllList = (from g in DB.ESHOP_NEWs join a in DB.ESHOP_NEWS_CATs on g.NEWS_ID equals a.NEWS_ID join d in DB.ESHOP_CATEGORies on a.CAT_ID equals d.CAT_ID where ("" == keyword || (DB.fClearUnicode(g.NEWS_TITLE)).Contains(keyword) || g.NEWS_CODE.Contains(keyword)) && (g.NEWS_TYPE == 1) && g.UNIT_ID2 > 0 && ((d.CAT_ID == _catid || d.CAT_PARENT_PATH.Contains(_catid.ToString())) || 0 == _catid) orderby g.UNIT_ID2 descending select g).GroupBy(n => n.NEWS_ID).Select(n => new { UNIT_ID2 = n.First().UNIT_ID2, NEWS_ID = n.First().NEWS_ID, NEWS_TITLE = n.First().NEWS_TITLE, NEWS_TYPE = n.First().NEWS_TYPE, NEWS_SHOWTYPE = n.First().NEWS_SHOWTYPE, NEWS_ORDER = n.First().NEWS_ORDER, NEWS_PUBLISHDATE = n.First().NEWS_PUBLISHDATE, }).OrderByDescending(n => n.NEWS_ID).ToList(); RpItemList.DataSource = AllList.Skip(_skip).Take(_limit); RpItemList.DataBind(); LitPage.Text = pagechange.changePageNews(AllList.Count, _limit, "xulylinkdie.aspx", _page, _type, 10); } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void SearchResult() { try { int _limit = 40; int _skip = 0; string keyword = CpanelUtils.ClearUnicode(txtKeyword.Value); if (_page != 0) { _skip = _page * _limit - _limit; } var AllList = (from g in DB.ESHOP_NEWs where (g.NEWS_TYPE == 1 && ("" == keyword || (DB.fClearUnicode(g.NEWS_TITLE)).Contains(keyword))) select new { g.NEWS_ID, g.NEWS_TITLE, g.NEWS_PERIOD, g.NEWS_COUNT, g.NEWS_ORDER, g.NEWS_ORDER_PERIOD, g.NEWS_PUBLISHDATE, }).ToList(); if (_News_period == 1) { AllList = AllList.OrderByDescending(n => n.NEWS_ID).ToList(); } else { AllList = AllList.OrderByDescending(n => n.NEWS_COUNT).ToList(); } Rplist_news.DataSource = AllList.Skip(_skip).Take(_limit); Rplist_news.DataBind(); LitPage.Text = changePageNews(AllList.Count, _limit, "duyet_video_index.aspx", _page, 10); } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void LoadMenu() { try { var AllList = DB.MENUs.Where(n => n.MENU_ACTIVE == 1); if (AllList.ToList().Count > 0) { DataRelation relCat; DataTable tbl = DataUtil.LINQToDataTable(AllList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["ID"], ds.Tables[0].Columns["MENU_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; CpanelUtils.TransformTableWithSpace2(ref CatTable, dsCat.Tables[0], relCat, null); Rplistmenu.DataSource = dsCat.Tables[0]; Rplistmenu.DataBind(); } //var allCat=DB.GetTable<ESHOP_CATEGORy>(); //GridItemList.DataSource = allCat; //GridItemList.DataBind(); //Session["CatGroupList"] = allCat; } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void loadListInventory() { string keyword = CpanelUtils.ClearUnicode(txtKeyword.Value); string date = txtDate.Text; DateTime dt = DateTime.Now; if (!String.IsNullOrEmpty(date)) { dt = Utils.CDateDef(catngay(date), DateTime.Now); } //int khoid = Utils.CIntDef(Drkho.SelectedValue); //int nhacccid = Utils.CIntDef(Drnhacc.SelectedValue); var list = (from a in db.ESHOP_NEWs join b in db.INVENTORies on a.NEWS_ID equals b.NEWS_ID where b.INVENT_TYPE == type && (db.fClearUnicode(a.NEWS_TITLE).Contains(keyword) || db.fClearUnicode(a.NEWS_CODE).Contains(keyword) || "" == keyword) //&&(b.INVENT_KHO==khoid||0==khoid)&&(b.INVENT_NHACC==nhacccid||0==nhacccid) && (!String.IsNullOrEmpty(date) ? b.INVENT_DATE.Value.Date == dt : 0 == 0) select new { a.NEWS_TITLE, a.NEWS_CODE, b.INVENT_TYPE, b.ID, b.INVENT_DATE, b.INVENT_QUANTITY, b.USER_ID, b.INVENT_NHACC, b.INVENT_KHO, b.INVENT_PRICE, b.INVENT_NAMEKH, b.INVENT_ADDRESS, b.INVENT_CHIECKHAU, b.INVENT_NO, b.INVENT_NOTE }).OrderByDescending(n => n.ID).ToList(); RplistInvent.DataSource = list; RplistInvent.DataBind(); }
private void LoadMenu() { try { var AllList = DB.MENUs.Where(n => n.MENU_ACTIVE == 1); if (AllList.ToList().Count > 0) { DataRelation relCat; DataTable tbl = DataUtil.LINQToDataTable(AllList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["ID"], ds.Tables[0].Columns["MENU_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; CpanelUtils.TransformTableWithSpace2(ref CatTable, dsCat.Tables[0], relCat, null); Drchuyenmuc.DataValueField = "ID"; Drchuyenmuc.DataTextField = "MENU_NAME"; Drchuyenmuc.DataSource = dsCat.Tables[0]; Drchuyenmuc.DataBind(); } ListItem l = new ListItem("------- Root -------", "0"); l.Selected = true; Drchuyenmuc.Items.Insert(0, l); } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void SaveInfo() { try { //get image string Banner_File; if (trUpload.Visible == true) { if (fileImage1.PostedFile != null) { Banner_File = Path.GetFileName(fileImage1.PostedFile.FileName); } else { Banner_File = ""; } } else { Banner_File = hplFile.Text; } //get image string BG_File; if (trUploadBG.Visible == true) { if (fileImageBG.PostedFile != null) { BG_File = Path.GetFileName(fileImageBG.PostedFile.FileName); } else { BG_File = ""; } } else { BG_File = hplFileBG.Text; } var G_info = DB.GetTable <ESHOP_CONFIG>().OrderBy(c => c.CONFIG_ID).Take(1); if (G_info.ToList().Count > 0) { G_info.Single().CONFIG_TITLE = txtSeoTitle.Value; G_info.Single().CONFIG_DESCRIPTION = txtSeoDesc.Value; G_info.Single().CONFIG_KEYWORD = txtSeoKeyword.Value; G_info.Single().CONFIG_TITLE_EN = txtSeoTitleEn.Value; G_info.Single().CONFIG_DESCRIPTION_EN = txtSeoDescEn.Value; G_info.Single().CONFIG_KEYWORD_EN = txtSeoKeywordEn.Value; G_info.Single().CONFIG_FAVICON = Banner_File; G_info.Single().CONFIG_FIELD1 = BG_File; G_info.Single().CONFIG_FIELD2 = ColorPicker1.Color; DB.SubmitChanges(); } else { //insert ESHOP_CONFIG config_insert = new ESHOP_CONFIG(); config_insert.CONFIG_TITLE = txtSeoTitle.Value; config_insert.CONFIG_DESCRIPTION = txtSeoDesc.Value; config_insert.CONFIG_KEYWORD = txtSeoKeyword.Value; config_insert.CONFIG_TITLE_EN = txtSeoTitleEn.Value; config_insert.CONFIG_DESCRIPTION_EN = txtSeoDescEn.Value; config_insert.CONFIG_KEYWORD_EN = txtSeoKeywordEn.Value; config_insert.CONFIG_FAVICON = Banner_File; config_insert.CONFIG_FIELD1 = BG_File; config_insert.CONFIG_FIELD2 = ColorPicker1.Color; DB.ESHOP_CONFIGs.InsertOnSubmit(config_insert); DB.SubmitChanges(); } //update images if (trUpload.Visible) { if (!string.IsNullOrEmpty(fileImage1.PostedFile.FileName)) { string pathfile = Server.MapPath("/data/configs"); string fullpathfile = pathfile + "/" + Banner_File; if (!Directory.Exists(pathfile)) { Directory.CreateDirectory(pathfile); } fileImage1.PostedFile.SaveAs(fullpathfile); } } //update imagesBG if (trUploadBG.Visible) { //if (!string.IsNullOrEmpty(fileImageBG.PostedFile.FileName)) //{ // string pathfile = Server.MapPath("/data/configs"); // string fullpathfile = pathfile + "/" + BG_File; // if (!Directory.Exists(pathfile)) // { // Directory.CreateDirectory(pathfile); // } // fileImageBG.PostedFile.SaveAs(fullpathfile); //} CpanelUtils.ImageResize(Server.MapPath("/data/configs/"), fileImageBG.Value, 2560, fileImageBG.PostedFile.InputStream); } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } finally { getInfo(); } }
//private void LoadBrands() //{ // try // { // var units = DB.GetTable<ESHOP_BRAND>(); // ddlBrand.DataSource = units; // ddlBrand.DataTextField = "NAME"; // ddlBrand.DataValueField = "ID"; // ddlBrand.DataBind(); // ddlBrand.Items.Insert(0, new ListItem("--------Thương hiệu--------", "0")); // } // catch (Exception ex) // { // clsVproErrorHandler.HandlerError(ex); // } //} //private void LoadUnits() //{ // try // { // var units = DB.GetTable<ESHOP_UNIT>(); // ddlUnit1.DataSource = units; // ddlUnit1.DataTextField = "UNIT_NAME"; // ddlUnit1.DataValueField = "UNIT_ID"; // ddlUnit1.DataBind(); // ddlUnit2.DataSource = units; // ddlUnit2.DataTextField = "UNIT_NAME"; // ddlUnit2.DataValueField = "UNIT_ID"; // ddlUnit2.DataBind(); // } // catch (Exception ex) // { // clsVproErrorHandler.HandlerError(ex); // } //} private void getInfo() { try { //LoadUnits(); Components.CpanelUtils.createItemTarget(ref ddlTarget); var G_info = (from n in DB.ESHOP_NEWs join c in DB.ESHOP_NEWS_CATs on n.NEWS_ID equals c.NEWS_ID into t2_join from c in t2_join.DefaultIfEmpty() where n.NEWS_ID == m_news_id select new { n, c.CAT_ID } ); if (G_info.ToList().Count > 0) { if (G_info.ToList()[0].n.NEWS_TYPE == 0) { div_price.Visible = false; } else { div_price.Visible = true; } iCate.Visible = false; txtCode.Value = G_info.ToList()[0].n.NEWS_CODE; txtTitle.Value = G_info.ToList()[0].n.NEWS_TITLE; txtDesc.Value = G_info.ToList()[0].n.NEWS_DESC; txtUrl.Value = G_info.ToList()[0].n.NEWS_URL; ddlTarget.SelectedValue = G_info.ToList()[0].n.NEWS_TARGET; txtPrice.Value = CpanelUtils.FormatMoney(G_info.ToList()[0].n.NEWS_PRICE1); txtPriceNew.Value = CpanelUtils.FormatMoney(G_info.ToList()[0].n.NEWS_PRICE2); //TextBox1.Text = Utils.CStrDef(Utils.CIntDef(G_info.ToList()[0].n.NEWS_PRICE3)); ddlBrand.SelectedValue = Utils.CStrDef(G_info.ToList()[0].n.UNIT_ID1); rblNewsType.SelectedValue = Utils.CStrDef(G_info.ToList()[0].n.NEWS_TYPE); rblStatus.SelectedValue = Utils.CStrDef(G_info.ToList()[0].n.NEWS_SHOWTYPE); rblNewsPeriod.SelectedValue = Utils.CStrDef(G_info.ToList()[0].n.NEWS_PERIOD); //rblField1.SelectedValue = Utils.CStrDef(G_info.ToList()[0].n.NEWS_FIELD1); //txtWebsite.Value = Utils.CStrDef(G_info.ToList()[0].n.NEWS_FIELD2); rblFeefback.SelectedValue = Utils.CStrDef(G_info.ToList()[0].n.NEWS_FEEDBACKTYPE); txtOrder.Value = Utils.CStrDef(G_info.ToList()[0].n.NEWS_ORDER, "1"); txtOrderPeriod.Value = Utils.CStrDef(G_info.ToList()[0].n.NEWS_ORDER_PERIOD, "1"); txtCount.Value = Utils.CStrDef(G_info.ToList()[0].n.NEWS_COUNT); //lblCount.Text = string.IsNullOrEmpty(Utils.CStrDef(G_info.ToList()[0].n.NEWS_COUNT)) ? "0" : Utils.CStrDef(G_info.ToList()[0].n.NEWS_COUNT); //lblSendEmail.Text = G_info.ToList()[0].n.NEWS_SENDDATE == null ? "Chưa gửi" : "Gửi lần cuối vào " + string.Format("{0:dd/MM/yyyy HH:mm:ss}", G_info.ToList()[0].n.NEWS_SENDDATE); //seo txtSeoTitle.Value = Utils.CStrDef(G_info.ToList()[0].n.NEWS_SEO_TITLE); txtSeoKeyword.Value = Utils.CStrDef(G_info.ToList()[0].n.NEWS_SEO_KEYWORD); txtSeoDescription.Value = Utils.CStrDef(G_info.ToList()[0].n.NEWS_SEO_DESC); txtSeoUrl.Value = Utils.CStrDef(G_info.ToList()[0].n.NEWS_SEO_URL); //PRICE //ddlUnit2.SelectedValue = Utils.CStrDef(G_info.ToList()[0].n.UNIT_ID2); //Product Properties // txtStatus.Value = G_info.ToList()[0].n.NEWS_FIELD1; // txtWarranty.Value = G_info.ToList()[0].n.NEWS_FIELD2; // txtOrigin.Value = G_info.ToList()[0].n.NEWS_FIELD3; //txtManufacture.Value = G_info.ToList()[0].n.NEWS_FIELD4; // txtWeight.Value = G_info.ToList()[0].n.NEWS_FIELD5; //image //if (!string.IsNullOrEmpty(G_info.ToList()[0].n.NEWS_IMAGE1)) //{ // trUploadImage1.Visible = false; // trImage1.Visible = true; // Image1.Src = PathFiles.GetPathNews(m_news_id) + G_info.ToList()[0].n.NEWS_IMAGE1; // hplImage1.NavigateUrl = PathFiles.GetPathNews(m_news_id) + G_info.ToList()[0].n.NEWS_IMAGE1; // hplImage1.Text = G_info.ToList()[0].n.NEWS_IMAGE1; //} //else //{ // trUploadImage1.Visible = true; // trImage1.Visible = false; //} ////image2 //if (!string.IsNullOrEmpty(G_info.ToList()[0].n.NEWS_IMAGE2)) //{ // trUploadImage2.Visible = false; // trImage2.Visible = true; // Image2.Src = PathFiles.GetPathNews(m_news_id) + G_info.ToList()[0].n.NEWS_IMAGE2; // hplImage2.NavigateUrl = PathFiles.GetPathNews(m_news_id) + G_info.ToList()[0].n.NEWS_IMAGE2; // hplImage2.Text = G_info.ToList()[0].n.NEWS_IMAGE2; //} //else //{ // trUploadImage2.Visible = true; // trImage2.Visible = false; //} //image3 if (!string.IsNullOrEmpty(G_info.ToList()[0].n.NEWS_IMAGE3)) { trUploadImage3.Visible = false; trImage3.Visible = true; Image3.Src = PathFiles.GetPathNews(m_news_id) + G_info.ToList()[0].n.NEWS_IMAGE3; hplImage3.NavigateUrl = PathFiles.GetPathNews(m_news_id) + G_info.ToList()[0].n.NEWS_IMAGE3; hplImage3.Text = G_info.ToList()[0].n.NEWS_IMAGE3; } else { trUploadImage3.Visible = true; trImage3.Visible = false; } } else { //trUploadImage1.Visible = true; //trImage1.Visible = false; //trUploadImage2.Visible = true; //trImage2.Visible = false; trUploadImage3.Visible = true; trImage3.Visible = false; LoadCategoryParent(); //trCat.Visible = true; } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }