protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int nID = 0;
if (Request.QueryString["nID"] != null && int.TryParse(Request.QueryString["nID"].ToString(), out nID) && nID > 0)
{
lblBigtitle.Text = "编辑数据";
BtnAdd.Visible = false;
btnUpdate.Visible = true;
DBLL.clsProductCategory clProductCategory = new DBLL.clsProductCategory();
DataTable dt = clProductCategory.Select_tb_ProductCategoryBynProductCategoryID(nID);
if (dt != null && dt.Rows.Count > 0)
{
hfID.Value = dt.Rows[0]["nProductCategoryID"].ToString();
txtsProductCategoryNameCN.Text = dt.Rows[0]["sProductCategoryNameCN"].ToString();
txtsProductCategoryNameEN.Text = dt.Rows[0]["sProductCategoryNameEN"].ToString();
txtnSorting.Text = dt.Rows[0]["nSorting"].ToString();
//绑定数据
}
}
else
{
lblBigtitle.Text = "添加数据";
btnUpdate.Visible = false;
BtnAdd.Visible = true;
}
}
}
protected void BtnAdd_Click(object sender, EventArgs e)
{
//判断session
if (Session["User"] == null || Session["User"].ToString().Length < 1)
{
Response.Redirect(Request.RawUrl);
}
if (ValiAdd())
{
DBLL.clsProductCategory ProductCategory = new DBLL.clsProductCategory();
DBLL.OptionSysDBLL option = new DBLL.OptionSysDBLL();
int _Result = ProductCategory.insert_tb_ProductCategory(ddlProductCateTreelist1.nSelectProductCategoryID, txtsProductCategoryNameCN.Text, txtsProductCategoryNameEN.Text, CKEditorControl1.Text, CKEditorControl2.Text, Session["User"].ToString(), DateTime.Now, Session["User"].ToString(), DateTime.Now, true, int.Parse(ddlnSorting.SelectedValue));
if (_Result > 0)
{
ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "InsertSuccess");
ShowMsg1.Show();
Clear();
}
else
{
ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "InsertFail");
ShowMsg1.Show();
}
}
else
{
ShowMsg1.Show();
}
}
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();
}
}
protected void lvProductList_ItemDataBound(object sender, ListViewItemEventArgs e)
{
try
{
DBLL.OptionSysDBLL option = new DBLL.OptionSysDBLL();
DBLL.clsProductCategory ProductCategory = new DBLL.clsProductCategory();
if (e.Item.ItemType == ListViewItemType.DataItem)
{
int nType = 0;
Label lblnProductCategoryID = (Label)e.Item.FindControl("lblnProductCategoryID");
if (int.TryParse(lblnProductCategoryID.Text, out nType))
{
nType = int.Parse(lblnProductCategoryID.Text);
string sTopicName = ProductCategory.Select_tb_ProductCategoryBynProductCategoryID(nType).Rows[0]["sProductCategoryNameCN"].ToString();
lblnProductCategoryID.Text = sTopicName;
}
}
ImageButton imgDelete = (ImageButton)e.Item.FindControl("imgDelete");
imgDelete.OnClientClick = "javascript:if (confirm('" + option.GetOptionValue("FormatSetting", "CommandControl", "bIsDelete") + "')){$('#EntryForm').block({ message: null });}else{return false;}";
}
catch (Exception)
{
}
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
//判断session
if (Session["User"] == null || Session["User"].ToString().Length < 1)
{
Response.Redirect(Request.RawUrl);
}
try
{
if (ValiEdit())
{
DBLL.clsProductCategory ProductCategory = new DBLL.clsProductCategory();
DBLL.OptionSysDBLL option = new DBLL.OptionSysDBLL();
bool _Result = ProductCategory.update_tb_ProductCategoryBynProductCategoryID(int.Parse(hfProductCategoryUpdateID.Value), ddlProductCateTreelist1.nSelectProductCategoryID, txtsProductCategoryNameCN.Text, txtsProductCategoryNameEN.Text, CKEditorControl1.Text, CKEditorControl2.Text, Session["User"].ToString(), DateTime.Now, true, int.Parse(ddlnSorting.SelectedValue));
if (_Result == true)
{
ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "InsertSuccess");
ShowMsg1.Show();
MultiView1.ActiveViewIndex = 0;
ReBindPageList();
}
else
{
ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "InsertFail");
ShowMsg1.Show();
}
}
}
catch (Exception)
{
throw;
}
}
protected bool ValiAdd()
{
bool bcheck = true;
ShowMsg1.InnerContent = "";
DBLL.clsProductCategory ProductCategory = new DBLL.clsProductCategory();
DataTable dt = new DataTable();
dt = ProductCategory.Select_tb_ProductCategoryBynParentCategoryID(ddlProductCateTreelist2.nSelectProductCategoryID);
if (dt != null)
{
ShowMsg1.InnerContent += "你选择的产品类型不是最尾级,请确认<br/>";
bcheck = false;
}
if (string.IsNullOrEmpty(txtsProductNameCN.Text))
{
ShowMsg1.InnerContent += "产品名称(中文)不能为空<br/>";
bcheck = false;
}
if (string.IsNullOrEmpty(txtsProductNameEN.Text))
{
ShowMsg1.InnerContent += "产品名称(英文)不能为空<br/>";
bcheck = false;
}
return(bcheck);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DBLL.clsProductCategory clspdc = new DBLL.clsProductCategory();
lvProCate.DataSource = TopicCateDataTable;
lvProCate.DataBind();
}
}
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 setnSelectID(int nSelectPCID)
{
nSelectProductCategoryID = nSelectPCID;
DBLL.clsProductCategory clspc = new DBLL.clsProductCategory();
DBLL.DBcommon DBc = new DBLL.DBcommon();
DataTable pcdt = new DataTable();
pcdt = DBc.selectNormalTableofAll(false, "tb_ProductCategory");
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.clsProductCategory ProductCategory = new DBLL.clsProductCategory();
DataTable dt = new DataTable();
dt = ProductCategory.sp_selectNormalTableOfAllByProductCategory(false);
if (dt != null)
{
ProductList.Merge(dt);
lvProductCategoryList.DataSource = ProductList;
lvProductCategoryList.DataBind();
}
else
{
lvProductCategoryList.DataSource = null;
lvProductCategoryList.DataBind();
}
}
public void Bind(int nProductID)
{
DBLL.clsProduct clspro = new DBLL.clsProduct();
DBLL.clsProductCategory clsprocate = new DBLL.clsProductCategory();
DataTable dtpro = clspro.Select_tb_ProductBynProductID(nProductID);
if (dtpro != null && dtpro.Rows.Count > 0)
{
Panel1.Visible = false;
Panel2.Visible = true;
DataRow dtprorow = dtpro.Rows[0];
DataTable dtprocate = clsprocate.Select_tb_ProductCategoryBynProductCategoryID(int.Parse(dtprorow["nProductCategoryID"].ToString()));
if (Session["languageGlobal"] == "en")
{
lblProductName.Text = dtprorow["sProductNameEN"].ToString();
lblProductCate.Text = dtprocate.Rows[0]["sProductCategoryNameEN"].ToString();
lblsBrandName.Text = dtprorow["sBrandNameEN"].ToString();
divProductInfo.InnerHtml = dtprorow["sIntroEN"].ToString();
divProductCate.InnerHtml = dtprorow["sSummaryEN"].ToString();
IMGbig.ImageUrl = dtprorow["sPImagePath"].ToString();
//lblSensitivity.Text = dtprorow["sEnsitivityCN"].ToString();
//lblchannelbalance.Text = dtprorow["sChannelBalanceCN"].ToString();
//lblimpedance.Text = dtprorow["sImpedanceCN"].ToString();
//lblfrequencyrange.Text = dtprorow["sFrequencyCN"].ToString();
//lblratedpower.Text = dtprorow["sRatedPowerCN"].ToString();
//lblmaximumpower.Text = dtprorow["sMaximumPowerCN"].ToString();
}
else
{
lblProductName.Text = dtprorow["sProductNameCN"].ToString();
lblProductCate.Text = dtprocate.Rows[0]["sProductCategoryNameCN"].ToString();
lblsBrandName.Text = dtprorow["sBrandNameCN"].ToString();
divProductInfo.InnerHtml = dtprorow["sIntroCN"].ToString();
divProductCate.InnerHtml = dtprorow["sSummaryCN"].ToString();
IMGbig.ImageUrl = dtprorow["sPImagePath"].ToString();
//lblSensitivity.Text = dtprorow["sEnsitivityEN"].ToString();
//lblchannelbalance.Text = dtprorow["sChannelBalanceEN"].ToString();
//lblimpedance.Text = dtprorow["sImpedanceEN"].ToString();
//lblfrequencyrange.Text = dtprorow["sFrequencyEN"].ToString();
//lblratedpower.Text = dtprorow["sRatedPowerEN"].ToString();
//lblmaximumpower.Text = dtprorow["sMaximumPowerEN"].ToString();
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
//判断session
if (Session["User"] == null || Session["User"].ToString().Length < 1)
{
Response.Redirect(Request.RawUrl);
}
try
{
int nID = 0;
if (int.TryParse(hfID.Value.ToString(), out nID) && nID > 0)
{
//更新
if (ValiEdit())
{
DBLL.clsProductCategory ProductCategory = new DBLL.clsProductCategory();
DBLL.OptionSysDBLL option = new DBLL.OptionSysDBLL();
bool _Result = ProductCategory.update_tb_ProductCategoryBynProductCategoryID(nID, 0, txtsProductCategoryNameCN.Text, txtsProductCategoryNameEN.Text, "", "", Session["user"].ToString(), DateTime.Now, true, int.Parse(txtnSorting.Text));
if (_Result == true)
{
ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "UpdateSuccess");
ShowMsg1.Show();
}
else
{
//失败就一条
ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "UpdateFail");
ShowMsg1.Show();
}
}
else
{
ShowMsg1.Show();
}
}
}
catch (Exception)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
OnSetLanguage();
if (!IsPostBack)
{
Panel1.Visible = true;
Panel2.Visible = false;
DBLL.clsProductCategory clspc = new DBLL.clsProductCategory();
DBLL.DBcommon dbcom = new DBLL.DBcommon();
DataTable dtProductCategory = dbcom.selectNormalTableofAll(false, "tb_ProductCategory");
DBLL.TreeViewFromTableBLL tvfbll = new DBLL.TreeViewFromTableBLL();
tvfbll.nRootParentID = 0;
tvfbll.FatherIDColumnName = dtProductCategory.Columns["nParentCategoryID"].ColumnName;
// tvfbll.NavigateUrlColumnName = "ProductList.aspx?nProductCategoryIDColumn=" + pcdt.nProductCategoryIDColumn.ColumnName;
tvfbll.NodeValueColumnName = dtProductCategory.Columns["nProductCategoryID"].ColumnName;
if (Session["languageGlobal"] == "en")
{
tvfbll.NodeTextColumnName = dtProductCategory.Columns["sProductCategoryNameEN"].ColumnName;
}
else
{
tvfbll.NodeTextColumnName = dtProductCategory.Columns["sProductCategoryNameCN"].ColumnName;
}
tvfbll.bIsClick = true;
TreeNode[] nodepages = tvfbll.GetTreeNodes(dtProductCategory);
TreeView1.Nodes.Clear();
if (nodepages != null && nodepages.Length > 0)
{
for (int i = 0; i < nodepages.Length; i++)
{
if (nodepages[i].Text.Length > 18)
{
nodepages[i].ToolTip = nodepages[i].Text;
nodepages[i].Text = nodepages[i].Text.Substring(0, 18) + "...";
}
TreeView1.Nodes.Add(nodepages[i]);
}
}
TreeView1.ExpandDepth = 1;
DataTable dtProduct = dbcom.selectNormalTableofAll(false, "tb_Product");
DataTableProduct = dtProduct;
BindProductData(dtProduct);
string sMenuname = "";
if (Session["languageGlobal"] == "en")
{
sMenuname = "sProductCategoryNameEN";
}
else
{
sMenuname = "sProductCategoryNameCN";
}
if (dtProductCategory != null && dtProductCategory.Rows.Count > 0)
{
foreach (DataRow row in dtProductCategory.Rows)
{
MenuItem menuitem1 = new MenuItem(row[sMenuname].ToString(), row["nProductCategoryID"].ToString(), "~/style/images/newsfront.gif");
Menu1.Items.Add(menuitem1);
}
}
int nProductID = 0;
if (Request.QueryString["nProductID"] != null && int.TryParse(Request.QueryString["nProductID"], out nProductID))
{
if (nProductID > 0)
{
Bind(nProductID);
}
}
}
}