protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
List <Model.ProductType> Typelist = new BLL.ProductType().GetList(0, "Lang='zh_cn' and IsPass=1 ", "Sort asc");
head1.Typelist = Typelist;
rptfootlist.DataSource = Typelist;
rptfootlist.DataBind();
string key = Server.UrlDecode(base.QueryString("key"));
head1.Key = key;
BLL.Product bll = new BLL.Product();
rptIsSearchProduct.DataSource = bll.GetList("IsDelete=0 and IsPass=1 and IsSearch=1 and ClassID in (Select ClassID from TB_ProductType where IsPass=1 and Lang='zh_cn')");
rptIsSearchProduct.DataBind();
List <Model.Product> list = bll.GetList(0, " IsDelete=0 and IsPass=1 and ProName like'%" + key + "%' or Contents like '%" + key + "%'", " Sort asc");
if (list != null && list.Count > 0)
{
lit_Menu.Text = "<div class=\"tab-box\"><p class=\"breadcrumb fullpage-inside\"><a href=\"/cn/\">首页</a>>><a href=\"javascript:void(0)\">全部结果</a>>><a class=\"bc-result\" href=\"javascript:void(0)\">" + key + "</a></p></div>";
BindSearchProduct(list);
}
else
{
lit_Search.Text = "<div class=\"search-no-shild\"><p class=\"search-no-tit\">抱歉, 没有搜索到与\"<span>" + key + "</span>\"相关的商品</p><p>请检查您的输入是否有误</p><p>您可以尝试以下搜索:<span><a href=\"/cn/Search/?key=" + Server.UrlEncode("通讯类") + "\">通讯类</a></span>|<span><a href=\"/cn/Search/?key=" + Server.UrlEncode("电力类") + "\">电力类</a></span>|<span><a href=\"/cn/Search/?key=" + Server.UrlEncode("家具类") + "\">家具类</a></span>|<span><a href=\"/cn/Search/?key=" + Server.UrlEncode("金融类") + "\">金融类</a></span>|<span><a href=\"/cn/Search/?key=" + Server.UrlEncode("精密机床") + "\">精密机床</a></span>|<span><a href=\"/cn/Search/?key=" + Server.UrlEncode("新能源类") + "\">新能源类</a></span>|<span><a href=\"/cn/Search/?key=" + Server.UrlEncode("精密加工") + "\">精密加工</a></span></p></div>";
}
}
}
protected void delByIds(int[] strArr)
{
bool result = new BLL.ProductType().Delete(strArr);
Response.Clear();
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", result ? "删除成功" : "删除失败"));
Response.End();
}
protected void delByIds(int[] strArr)
{
bool result = new BLL.ProductType().Delete(strArr);
Response.Clear();
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", result ? "删除成功" : "删除失败,请核查分类下是否有产品存在"));
Response.End();
}
private void rptlistBind()
{
if (Typelist == null || Typelist.Count == 0)
{
Typelist = new BLL.ProductType().GetList(0, "Lang='zh-cn' and IsPass=1 ", "Sort asc");
}
rptlist.DataSource = Typelist;
rptlist.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
classid = Common.WCommon.GetURLParamInt64("classid");
if (!IsPostBack)
{
List <Model.ProductType> Typelist = new BLL.ProductType().GetList(0, "Lang='zh_cn' and IsPass=1 ", "Sort asc");
head1.Typelist = foot1.Typelist = Typelist;
productTypeBind(Typelist);
rptlistBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
id = Common.WCommon.GetURLParamInt64("id");
if (!IsPostBack)
{
if (id < 1)
{
MessageBox.ShowRedirect("参数错误！", "/cn/product");
}
List <Model.ProductType> Typelist = new BLL.ProductType().GetList(0, "Lang='zh_cn' and IsPass=1 ", "Sort asc");
head1.Typelist = Typelist;
rptfootlist.DataSource = Typelist;
rptfootlist.DataBind();
productBind();
}
}
private string GetProductTypeCombotree()
{
DataTable dt = new BLL.ProductType().GetList("").Tables[0];
return(new DBUtility.JsonHelper().DataTable2Json_Tree(dt, "ID", "Name", "ParentID", 0, "", ""));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
Model.BaseUser bu = (Model.BaseUser)context.Session["login"];
if (bu == null)
{
context.Response.Write("登录超时，请重新登录。");
return;
}
string type = context.Request["type"];
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
DBUtility.JsonHelper jsHelper = new DBUtility.JsonHelper();
switch (type)
{
case "dept_comb":
dt = new BLL.BaseDepartment().GetList("1=1").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "role_comb":
dt = new BLL.BaseRole().GetList("1=1").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "dept_tree":
dt = new BLL.BaseDepartment().GetList("1=1 order by ParentDeptID").Tables[0];
sb.Append(jsHelper.DataTable2Json_Tree(dt, "DeptID", "DeptName", "ParentDeptID", 0, "closed", ""));
break;
case "dept_tree_open":
dt = new BLL.BaseDepartment().GetList("1=1 order by ParentDeptID").Tables[0];
sb.Append(jsHelper.DataTable2Json_Tree(dt, "DeptID", "DeptName", "ParentDeptID", 0, "open", ""));
break;
case "rft_comb":
dt = new BLL.request_form_type().GetList("1=1").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "nodeType_comb":
dt = new BLL.node_type().GetList("1=1").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "banding_comb":
dt = new BLL.approve_role().GetList("1=1 order by role_level asc").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "form_comb":
dt = new BLL.request_form().GetList("1=1").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "role_tree":
dt = new BLL.BaseMenu().GetList("1=1").Tables[0];
sb.Append(jsHelper.DataTable2Json_Tree(dt, "MenuID", "MenuName", "ParentMenuID", "0", "", ""));
break;
case "dept_users":
dt = new BLL.Common().GetList("select UserName,Name from baseuser where deptid in (select * from dbo.getTable(dbo.getdeptids_zxf('" + context.Request["deptid"] + "'),','))").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "get_users":
dt = new BLL.Common().GetList("select UserName,Name from baseuser where Permissions=1 order by name ").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "get_stage":
dt = new BLL.Common().GetList("select sid,stage_name from stage").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "product_Series":
dt = new BLL.Common().GetList("select ID,Name from ProductSeries ").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Josn(dt));
break;
case "product_ValuationMethods":
dt = new BLL.Common().GetList("select ID,Name from ProductPriceMethods ").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Josn(dt));
break;
case "product_Unit":
dt = new BLL.Common().GetList("select ID as ID,UnitName as Name from dbo.ProductUnit ").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Josn(dt));
break;
case "product_Manufacturer":
dt = new BLL.Common().GetList("select ID,FullName as Name from Supplier order by FullName ").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Josn(dt));
break;
case "productType":
dt = new BLL.ProductType().GetList("1=1").Tables[0];
sb.Append("[{\"id\":\"28\",\"text\":\"地毯\",\"state\":\"\",\"children\":[{\"id\":\"29\",\"text\":\"羊毛地毯\",\"state\":\"\",\"children\":[{\"id\":\"43\",\"text\":\"1\",\"state\":\"\"}]},{\"id\":\"30\",\"text\":\"麻质地毯\",\"state\":\"\"},{\"id\":\"31\",\"text\":\"棉地毯\",\"state\":\"\"},{\"id\":\"32\",\"text\":\"丝质地毯\",\"state\":\"\"}]},{\"id\":\"33\",\"text\":\"布艺成品\",\"state\":\"\",\"children\":[{\"id\":\"34\",\"text\":\"布帘\",\"state\":\"\"},{\"id\":\"35\",\"text\":\"香格里拉帘\",\"state\":\"\",\"children\":[{\"id\":\"36\",\"text\":\"透光香格里拉帘\",\"state\":\"\"},{\"id\":\"37\",\"text\":\"半透光香格里拉帘\",\"state\":\"\"},{\"id\":\"38\",\"text\":\"全遮光香格里拉帘\",\"state\":\"\"}]},{\"id\":\"39\",\"text\":\"风琴帘\",\"state\":\"\",\"children\":[{\"id\":\"40\",\"text\":\"透光风琴帘\",\"state\":\"\"},{\"id\":\"41\",\"text\":\"半透光风琴帘\",\"state\":\"\"},{\"id\":\"42\",\"text\":\"全遮光风琴帘\",\"state\":\"\"}]}]}]");
break;
case "work_users":
dt = new BLL.Common().GetList("select UserName,Name from baseuser where UserName in (select implementer_sid from project_work_implement where psi_sid in (select sid from project_specific_item where s_sid =" + context.Request["pssid"] + "))").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "getProject":
dt = new BLL.Common().GetList("select sid,project_name name from project").Tables[0];
DataRow dr = dt.NewRow();
dr[0] = "0";
dr[1] = "所有";
dt.Rows.InsertAt(dr, 0);
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "getSpace":
string psid = context.Request["pid"] == null ? "" : context.Request["pid"].Trim();
psid = psid == "" ? "0" : psid;
dt = new BLL.Common().GetList("select sid, name from project_Space where p_sid='" + psid + "' and ischild=0").Tables[0];
dr = dt.NewRow();
dr[0] = "0";
dr[1] = "所有";
dt.Rows.InsertAt(dr, 0);
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "getPlace":
psid = context.Request["pid"] == null ? "" : context.Request["pid"].Trim();
psid = psid == "undefined" ? "0" : psid;
dt = new BLL.Common().GetList("select sid, name from project_Space where parentID='" + psid + "' and ischild=1").Tables[0];
dr = dt.NewRow();
dr[0] = "0";
dr[1] = "所有";
dt.Rows.InsertAt(dr, 0);
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "getDic":
dt = new BLL.Common().GetList("select Value,Caption Text from BaseDictionaryDetail where CatgID='" + context.Request["catg"] + "'").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
default:
break;
}
context.Response.Write(sb.ToString());
}
private string ComboTree(HttpContext context)
{
DataTable dt = new BLL.ProductType().GetList("Level<>3").Tables[0];
return(new DBUtility.JsonHelper().DataTable2Json_Tree(dt, "ID", "CodeName", "ParentID", 0, "", ""));
}
private string QueryList(HttpContext context)
{
DataTable dt = new BLL.ProductType().GetList("").Tables[0];
return(DT2GTree(dt, "ParentID"));
}
