protected void btnSearch_Click(object sender, EventArgs e)
{
string sSearch = txtSearch.Text;
DBLL.clsProduct clspdc = new DBLL.clsProduct();
DataTable dtpdc = new DataTable();
if (ddlProductCateTreelist1.nSelectProductCategoryID > 0)
{
dtpdc = clspdc.Select_tb_ProductBynParentCategoryID(ddlProductCateTreelist1.nSelectProductCategoryID);
}
else dtpdc = clspdc.sp_selectNormalTableOfAllByProduct(false);
if (dtpdc != null && dtpdc.Rows.Count > 0)
{
Model.dsProduct.tb_ProductDataTable dtSearchpdc = new Model.dsProduct.tb_ProductDataTable();
string cmd = "sProductNameCN like '%" + sSearch + "%' ";
cmd += " or ";
cmd += "sProductNameEN like '%" + sSearch + "%' ";
cmd += " or ";
cmd += "sSummaryCN like '%" + sSearch + "%' ";
cmd += " or ";
cmd += "sSummaryEN like '%" + sSearch + "%' ";
DataRow[] rows = dtpdc.Select(cmd);
foreach (DataRow row in rows)
{
Model.dsProduct.tb_ProductRow Searchrow = dtSearchpdc.Newtb_ProductRow();
foreach (DataColumn col in dtpdc.Columns)
{
Searchrow[col.ColumnName] = row[col.ColumnName];
}
dtSearchpdc.Rows.Add(Searchrow);
}
ProductList = new Model.dsProduct.tb_ProductDataTable();
ProductList.Merge(dtSearchpdc);
lvProductList.DataSource = dtSearchpdc;
lvProductList.DataBind();
}
//////old
//DBLL.clsProduct clspdc = new DBLL.clsProduct();
//DataTable dtpdc = new DataTable();
//if (ddlProductCateTreelist1.nSelectProductCategoryID > 0)
//{
// dtpdc = clspdc.Select_tb_ProductBynProductCategoryID(ddlProductCateTreelist1.nSelectProductCategoryID);
// if (dtpdc != null)
// {
// ProductList.Clear();
// ProductList.Merge(dtpdc);
// lvProductList.DataSource = ProductList;
// lvProductList.DataBind();
// }
// else
// {
// lvProductList.DataSource = null;
// lvProductList.DataBind();
// }
//}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string sSearch = txtSearch.Text;
DBLL.clsProduct clspdc = new DBLL.clsProduct();
DBLL.DBcommon DBc = new DBLL.DBcommon();
DataTable dtpdc = new DataTable();
if (ddlProductCateTreelist21.nSelectProductCategoryID > 0)
{
dtpdc = clspdc.Select_tb_ProductBynParentCategoryID(ddlProductCateTreelist21.nSelectProductCategoryID);
}
else
{
dtpdc = DBc.selectNormalTableofAll(false, "tb_Product");
}
if (dtpdc != null && dtpdc.Rows.Count > 0)
{
DataTable dtSearchpdc = new DataTable();
string cmd = "sProductNameCN like '%" + sSearch + "%' ";
cmd += " or ";
cmd += "sProductNameEN like '%" + sSearch + "%' ";
//cmd += "sSummaryCN like '%" + sSearch + "%' ";
//cmd += " or ";
//cmd += "sSummaryEN like '%" + sSearch + "%' ";
DataRow[] rows = dtpdc.Select(cmd);
foreach (DataColumn col in dtpdc.Columns)
{
dtSearchpdc.Columns.Add(col.ColumnName.ToString());
}
foreach (DataRow row in rows)
{
dtSearchpdc.Rows.Add(row.ItemArray);
}
//ProductList = new Model.dsProduct.tb_ProductDataTable();
//ProductList.Merge(dtSearchpdc);
lvProduct.DataSource = dtSearchpdc;
lvProduct.DataBind();
}
//else
//{
//dtpdc = DBc.selectNormalTableofAll(false, "tb_Product");
//if (dtpdc != null && dtpdc.Rows.Count > 0)
//{
//lvProduct.DataSource = null;
//lvProduct.DataBind();
//}
//}
}
protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
{
//for (int i = 0; i < this.TreeView1.Nodes.Count; i++)
//{//跌迭根节点
// if (this.TreeView1.SelectedNode.Parent == null)
// {
// if (this.TreeView1.SelectedValue == this.TreeView1.Nodes[i].Value)
// {//如果选中的是根节点,就展开
// this.TreeView1.SelectedNode.Expanded = true;
// }
// else
// {//如果选中的不是根节点
// this.TreeView1.Nodes[i].NavigateUrl = "";
// this.TreeView1.Nodes[i].Expanded = false;
// }
// }
//}
int _nProID = 0;
if (int.TryParse(this.TreeView1.SelectedValue, out _nProID) && _nProID > 0)
{
Panel1.Visible = true;
Panel2.Visible = false;
DBLL.clsProduct pro = new DBLL.clsProduct();
DataTable dtProduct = pro.Select_tb_ProductBynParentCategoryID(_nProID);
if (dtProduct != null)
{
DataTableProduct = dtProduct;
}
else
{
DataTableProduct = new DataTable();
}
BindProductData(DataTableProduct);
}
// TreeView1.SelectedNode.NavigateUrl = "Product.aspx?nSelelctProductCateID=" + TreeView1.SelectedNode.Value;
}