protected void lvProductCategoryList_SelectedIndexChanging(object sender, ListViewSelectEventArgs e) { Label lblnID = (Label)lvProductCategoryList.Items[e.NewSelectedIndex].FindControl("lblnProductCategoryID"); int _nID = 0; DBLL.clsProductCategory ProductCategory = new DBLL.clsProductCategory(); if (int.TryParse(lblnID.Text.Trim(), out _nID) && _nID > 0) { DBLL.DBcommon dbcom = new DBLL.DBcommon(); Model.dsProduct.tb_ProductCategoryDataTable ProductList = new Model.dsProduct.tb_ProductCategoryDataTable(); ProductList.Merge(dbcom.selectNormalTableofAll(false, "tb_ProductCategory")); ddlProductCateTreelist1.ProductList = ProductList; ddlProductCateTreelist1.Fresh(); MultiView1.ActiveViewIndex = 1; DataTable dt = ProductCategory.Select_tb_ProductCategoryBynProductCategoryID(_nID); txtsProductCategoryNameCN.Text = dt.Rows[0]["sProductCategoryNameCN"].ToString(); txtsProductCategoryNameEN.Text = dt.Rows[0]["sProductCategoryNameEN"].ToString(); CKEditorControl1.Text = dt.Rows[0]["sContentCN"].ToString(); CKEditorControl2.Text = dt.Rows[0]["sContentEN"].ToString(); lblPCID.Text = dt.Rows[0]["nParentCategoryID"].ToString(); //ddlProductCateTreelist1.nSelectProductCategoryID = int.Parse(dt.Rows[0]["nParentCategoryID"].ToString()); ddlProductCateTreelist1.setnSelectID(int.Parse(dt.Rows[0]["nParentCategoryID"].ToString())); ddlnSorting.SelectedValue = dt.Rows[0]["nSorting"].ToString(); hfProductCategoryUpdateID.Value = _nID.ToString(); } }
public void Clear() { cbbHot.Checked = false; txtsProductNameCN.Text = ""; txtsProductNameEN.Text = ""; txtsSummaryCN.Text = ""; txtsSummaryEN.Text = ""; txtsPlaceoforiginCN.Text = ""; txtsPlaceoforiginEN.Text = ""; txtsModelNoCN.Text = ""; txtsModelNoEN.Text = ""; txtsPriceTermsCN.Text = ""; txtsPriceTermsEN.Text = ""; txtsPaymentTermsCN.Text = ""; txtsPaymentTermsEN.Text = ""; txtsPackageCN.Text = ""; txtsPackageEN.Text = ""; txtsMinimumOrderCN.Text = ""; txtsMinimumOrderEN.Text = ""; txtsDeliveryTimeCN.Text = ""; txtsDeliveryTimeEN.Text = ""; txtsBrandNameCN.Text = ""; txtsBrandNameEN.Text = ""; CKEditorControl1.Text = ""; CKEditorControl2.Text = ""; ddlnSorting.SelectedIndex = 0; DBLL.DBcommon dbcom = new DBLL.DBcommon(); Model.dsProduct.tb_ProductCategoryDataTable ProductList = new Model.dsProduct.tb_ProductCategoryDataTable(); ProductList.Merge(dbcom.selectNormalTableofAll(false, "tb_ProductCategory")); ddlProductCateTreelist2.ProductList = ProductList; ddlProductCateTreelist2.Fresh(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DBLL.DBcommon dbcom = new DBLL.DBcommon(); Model.dsProduct.tb_ProductCategoryDataTable ProductList = new Model.dsProduct.tb_ProductCategoryDataTable(); ProductList.Merge(dbcom.selectNormalTableofAll(false, "tb_ProductCategory")); ddlProductCateTreelist1.ProductList = ProductList; } }
public void setnSelectID(int nSelectPCID) { nSelectProductCategoryID = nSelectPCID; DBLL.clsProductCategory clspc = new DBLL.clsProductCategory(); Model.dsProduct.tb_ProductCategoryDataTable pcdt = new Model.dsProduct.tb_ProductCategoryDataTable(); if (pcdt != null && pcdt.Rows.Count > 0) { pcdt.Merge(clspc.Select_tb_ProductCategoryBynProductCategoryID(nSelectPCID)); txtProducCateID.Text = pcdt.Rows[0]["sProductCategoryNameCN"].ToString(); } else { txtProducCateID.Text = "没有上级产品类"; } }
public void ReBindPageList() { DBLL.clsProduct Product = new DBLL.clsProduct(); DataTable dt = new DataTable(); dt = Product.sp_selectNormalTableOfAllByProduct(false); if (dt != null) { ProductList.Merge(dt); lvProductList.DataSource = ProductList; lvProductList.DataBind(); } else { lvProductList.DataSource = null; lvProductList.DataBind(); } DBLL.DBcommon dbcom = new DBLL.DBcommon(); Model.dsProduct.tb_ProductCategoryDataTable ProductCategoryList = new Model.dsProduct.tb_ProductCategoryDataTable(); ProductCategoryList.Merge(dbcom.selectNormalTableofAll(false, "tb_ProductCategory")); ddlProductCateTreelist1.ProductList = ProductCategoryList; }
protected void lvProductList_SelectedIndexChanging(object sender, ListViewSelectEventArgs e) { Label lblnID = (Label)lvProductList.Items[e.NewSelectedIndex].FindControl("lblnProductID"); int _nID = 0; DBLL.clsProduct Product = new DBLL.clsProduct(); if (int.TryParse(lblnID.Text.Trim(), out _nID) && _nID > 0) { DBLL.DBcommon dbcom = new DBLL.DBcommon(); Model.dsProduct.tb_ProductCategoryDataTable ProductList = new Model.dsProduct.tb_ProductCategoryDataTable(); ProductList.Merge(dbcom.selectNormalTableofAll(false, "tb_ProductCategory")); ddlProductCateTreelist2.ProductList = ProductList; ddlProductCateTreelist2.Fresh(); MultiView1.ActiveViewIndex = 1; DataTable dt = Product.Select_tb_ProductBynProductID(_nID); cbbHot.Checked = bool.Parse(dt.Rows[0]["bHot"].ToString()); txtsProductNameCN.Text = dt.Rows[0]["sProductNameCN"].ToString(); txtsProductNameEN.Text = dt.Rows[0]["sProductNameEN"].ToString(); txtsSummaryCN.Text = dt.Rows[0]["sSummaryCN"].ToString(); txtsSummaryEN.Text = dt.Rows[0]["sSummaryEN"].ToString(); txtsPlaceoforiginCN.Text = dt.Rows[0]["sPlaceoforiginCN"].ToString(); txtsPlaceoforiginEN.Text = dt.Rows[0]["sPlaceoforiginEN"].ToString(); txtsModelNoCN.Text = dt.Rows[0]["sModelNoCN"].ToString(); txtsModelNoEN.Text = dt.Rows[0]["sModelNoEN"].ToString(); txtsPriceTermsCN.Text = dt.Rows[0]["sPriceTermsCN"].ToString(); txtsPriceTermsEN.Text = dt.Rows[0]["sPriceTermsEN"].ToString(); txtsPaymentTermsCN.Text = dt.Rows[0]["sPaymentTermsCN"].ToString(); txtsPaymentTermsEN.Text = dt.Rows[0]["sPaymentTermsEN"].ToString(); txtsPackageCN.Text = dt.Rows[0]["sPackageCN"].ToString(); txtsPackageEN.Text = dt.Rows[0]["sPackageEN"].ToString(); txtsMinimumOrderCN.Text = dt.Rows[0]["sMinimumOrderCN"].ToString(); txtsMinimumOrderEN.Text = dt.Rows[0]["sMinimumOrderEN"].ToString(); txtsDeliveryTimeCN.Text = dt.Rows[0]["sDeliveryTimeCN"].ToString(); txtsDeliveryTimeEN.Text = dt.Rows[0]["sDeliveryTimeEN"].ToString(); txtsBrandNameCN.Text = dt.Rows[0]["sBrandNameCN"].ToString(); txtsBrandNameEN.Text = dt.Rows[0]["sBrandNameEN"].ToString(); CKEditorControl1.Text = dt.Rows[0]["sIntroCN"].ToString(); CKEditorControl2.Text = dt.Rows[0]["sIntroEN"].ToString(); ddlnSorting.SelectedValue = dt.Rows[0]["nSorting"].ToString(); //ddlProductCateTreelist2.nSelectProductCategoryID = int.Parse(dt.Rows[0]["nProductCategoryID"].ToString()); ddlProductCateTreelist2.setnSelectID(int.Parse(dt.Rows[0]["nProductCategoryID"].ToString())); MutileUploaderUserControl1.Refresh(); DBLL.clsProductImage ProductImage = new DBLL.clsProductImage(); DataTable Imagedt = new DataTable(); Imagedt = ProductImage.Select_tb_ProductImageBynProductID(_nID); if (Imagedt != null) { ProductImageList.Clear(); ProductImageList.Merge(Imagedt); lvProductImageList.DataSource = ProductImageList; lvProductImageList.DataBind(); } else { ProductImageList.Clear(); lvProductImageList.DataSource = ProductImageList; lvProductImageList.DataBind(); } Button1.Text = "显示图片"; lvProductImageList.Visible = false; hfProductUpdateID.Value = _nID.ToString(); } }