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