private void RptBind(string _strWhere, string _orderby) { // Model.wx_userweixin weixin = GetWeiXinCode(); //判断是否已经设置了微留言基本信息 BLL.wx_diancai_caipin_manage sbll = new BLL.wx_diancai_caipin_manage(); _strWhere = " and aa.shopid=" + shopid + " " + _strWhere;//and this.page = MXRequest.GetQueryInt("page", 1); txtKeywords.Text = this.keywords; DataSet ds = gbll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); // DataSet ds = gbll.GetList( _strWhere); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr; int count = ds.Tables[0].Rows.Count; for (int i = 0; i < count; i++) { dr = ds.Tables[0].Rows[i]; } ds.AcceptChanges(); } this.rptList.DataSource = ds; this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("caipin_manage.aspx", "keywords={0}&page={1}&shopid={2}", this.keywords, "__id__", shopid.ToString()); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
/// <summary> /// 绑定左边的分类信息 /// </summary> protected void BindLeftCate() { shopinfo = shopBll.GetModel(shopid); if (shopinfo == null) { return; } rename = shopinfo.dcRename; hotelName = shopinfo.hotelName; DataSet category1 = categorybll.GetList(shopid); if (category1 == null || category1.Tables.Count <= 0 || category1.Tables[0].Rows.Count <= 0) { return; } if (categoryid == 0) { if (category1 != null && category1.Tables.Count > 0 && category1.Tables[0].Rows.Count > 0) { categoryid = MyCommFun.Obj2Int(category1.Tables[0].Rows[0]["id"]); } } manageString = ""; cateString = ""; categories = "{"; if (category1.Tables[0].Rows.Count > 0) { for (int i = 0; i < category1.Tables[0].Rows.Count; i++) { if (categoryid == Convert.ToInt32(category1.Tables[0].Rows[i]["id"].ToString()))//选择的一条 { cateString += "<dd class=\"active\"><a style=\"width: 100%;\" href=\"index.aspx?categoryid=" + category1.Tables[0].Rows[i]["id"].ToString() + "&openid=" + openid + "&shopid=" + shopid + "\">" + category1.Tables[0].Rows[i]["categoryName"].ToString() + "</a></dd>"; } else { cateString += "<dd ><a style=\"width: 100%;\" href=\"index.aspx?categoryid=" + category1.Tables[0].Rows[i]["id"].ToString() + "&openid=" + openid + "&shopid=" + shopid + "\">" + category1.Tables[0].Rows[i]["categoryName"].ToString() + "</a></dd>"; } categories += "\"" + category1.Tables[0].Rows[i]["id"].ToString() + "\"" + ":" + "\"" + category1.Tables[0].Rows[i]["categoryName"].ToString() + "\"" + ","; } } categories = categories.Substring(0, categories.Length - 1); categories += "}"; //菜品 DataSet manage1 = managebll.GetList(categoryid);//分类id if (manage1.Tables[0].Rows.Count > 0) { for (int j = 0; j < manage1.Tables[0].Rows.Count; j++) { manageString += "<dd> "; manageString += " <div class=\"tupian\"><img src=" + manage1.Tables[0].Rows[j]["picUrl"].ToString() + " onClick=\"htmlit('" + manage1.Tables[0].Rows[j]["picUrl"].ToString() + "','" + manage1.Tables[0].Rows[j]["cpName"].ToString() + "'," + manage1.Tables[0].Rows[j]["id"].ToString() + ")\">"; manageString += "<a href=\"javascript:htmlit('" + manage1.Tables[0].Rows[j]["picUrl"].ToString() + "','" + manage1.Tables[0].Rows[j]["cpName"].ToString() + "'," + manage1.Tables[0].Rows[j]["id"].ToString() + ");\" class=\"add\" data-foodid=\"" + manage1.Tables[0].Rows[j]["id"].ToString() + "_1\">"; manageString += "<h3>" + manage1.Tables[0].Rows[j]["cpName"].ToString() + "</h3>"; manageString += " <em>" + manage1.Tables[0].Rows[j]["zkPrice"].ToString() + "元/件<del style='display: block;'>" + manage1.Tables[0].Rows[j]["cpPrice"].ToString() + "元/件</del></em>"; manageString += " <p class=\"dpNum\">" + manage1.Tables[0].Rows[j]["scan"].ToString() + "</p></a> "; manageString += "<div class='orderchange orderfood'>"; manageString += " <a href=\"javascript:addProduct('" + manage1.Tables[0].Rows[j]["id"].ToString() + "','1','" + manage1.Tables[0].Rows[j]["cpName"].ToString() + "','" + manage1.Tables[0].Rows[j]["zkPrice"].ToString() + "','" + categoryid + "',1);\" class=\"increase plus\" id=\"add_" + manage1.Tables[0].Rows[j]["id"].ToString() + "_1\"><b class=\"ico_increase\">加一份</b></a>"; manageString += "<span id=\"num_" + manage1.Tables[0].Rows[j]["id"].ToString() + "_1\" onClick=\"addProduct('" + manage1.Tables[0].Rows[j]["id"].ToString() + "','1','" + manage1.Tables[0].Rows[j]["cpName"].ToString() + "','" + manage1.Tables[0].Rows[j]["zkPrice"].ToString() + "','" + categoryid + "',1);\" class=\"count_zero\" >0</span>"; manageString += " <a href=\"javascript:reduceProduct('" + manage1.Tables[0].Rows[j]["id"].ToString() + "','1',1);\" class=\"minus reduce\" id=\"del_" + manage1.Tables[0].Rows[j]["id"].ToString() + "_1\" style=\"display:none;\"><b class=\"ico_reduce\">减一份</b></a>"; manageString += "</div>"; manageString += " </div></dd>"; } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { aid = MyCommFun.RequestInt("aid"); shopid = MyCommFun.RequestInt("shopid"); categoryid = MyCommFun.RequestInt("categoryid"); shopinfo = shopBll.GetModel(shopid); hotelName = shopinfo.hotelName; openid = MyCommFun.QueryString("openid"); if (categoryid != 0)//选择加载 { //分类 manageString = ""; cateString = ""; categories = "{"; DataSet category1 = categorybll.GetList(shopid); if (category1.Tables[0].Rows.Count > 0) { for (int i = 0; i < category1.Tables[0].Rows.Count; i++) { if (categoryid == Convert.ToInt32(category1.Tables[0].Rows[i]["id"].ToString()))//选择的一条 { cateString += "<dd class=\"active\"><a style=\"width: 100%;\" href=\"index.aspx?categoryid=" + category1.Tables[0].Rows[i]["id"].ToString() + "&openid=" + openid + "&shopid=" + shopid + "&aid=" + aid + "\">" + category1.Tables[0].Rows[i]["categoryName"].ToString() + "</a></dd>"; } else { cateString += "<dd ><a style=\"width: 100%;\" href=\"index.aspx?categoryid=" + category1.Tables[0].Rows[i]["id"].ToString() + "&openid=" + openid + "&shopid=" + shopid + "&aid=" + aid + "\">" + category1.Tables[0].Rows[i]["categoryName"].ToString() + "</a></dd>"; } categories += "\"" + category1.Tables[0].Rows[i]["id"].ToString() + "\"" + ":" + "\"" + category1.Tables[0].Rows[i]["categoryName"].ToString() + "\"" + ","; } } categories = categories.Substring(0, categories.Length - 1); categories += "}"; //菜品 DataSet manage1 = managebll.GetList(categoryid);//分类id if (manage1.Tables[0].Rows.Count > 0) { for (int j = 0; j < manage1.Tables[0].Rows.Count; j++) { manageString += "<dd> "; manageString += "<span class=\"count_zero\" id=\"num_" + manage1.Tables[0].Rows[j]["id"].ToString() + "_1\" onClick=\"addProduct('" + manage1.Tables[0].Rows[j]["id"].ToString() + "','1','" + manage1.Tables[0].Rows[j]["cpName"].ToString() + "','18.0','" + categoryid + "',1);\">0</span>"; manageString += " <div class=\"tupian\"><img src=" + manage1.Tables[0].Rows[j]["picUrl"].ToString() + " onClick=\"htmlit('http:','" + manage1.Tables[0].Rows[j]["cpName"].ToString() + "'," + manage1.Tables[0].Rows[j]["id"].ToString() + ")\">"; manageString += "<a href=\"javascript:addProduct('" + manage1.Tables[0].Rows[j]["id"].ToString() + "','1','" + manage1.Tables[0].Rows[j]["cpName"].ToString() + "','" + manage1.Tables[0].Rows[j]["zkPrice"].ToString() + "','" + categoryid + "',1);\" class=\"add\" data-foodid=\"" + manage1.Tables[0].Rows[j]["id"].ToString() + "_1\">"; manageString += "<h3>" + manage1.Tables[0].Rows[j]["cpName"].ToString() + "</h3>"; manageString += " <em>" + manage1.Tables[0].Rows[j]["zkPrice"].ToString() + "元/件<del>" + manage1.Tables[0].Rows[j]["cpPrice"].ToString() + "元/件</del></em>"; manageString += " <p class=\"dpNum\">" + manage1.Tables[0].Rows[j]["scan"].ToString() + "</p></a> "; manageString += " <a href=\"javascript:reduceProduct('" + manage1.Tables[0].Rows[j]["id"].ToString() + "','1',1);\" class=\"reduce\" id=\"del_" + manage1.Tables[0].Rows[j]["id"].ToString() + "_1\" style=\"display:none;\"><b class=\"ico_reduce\">减一份</b></a>"; manageString += " </div></dd>"; } } return; } //初始加载 DataSet category = categorybll.GetList(shopid); if (category.Tables[0].Rows.Count > 0)//分类 { manageString = ""; cateString = ""; categories = "{"; for (int i = 0; i < category.Tables[0].Rows.Count; i++) { if (i == 0) { cateString += "<dd class=\"active\"><a style=\"width: 100%;\" href=\"index.aspx?categoryid=" + category.Tables[0].Rows[i]["id"].ToString() + "&openid=" + openid + "&shopid=" + shopid + "&aid=" + aid + "\">" + category.Tables[0].Rows[i]["categoryName"].ToString() + "</a></dd>"; DataSet manage = managebll.GetList(Convert.ToInt32(category.Tables[0].Rows[i]["id"].ToString())); //分类id if (manage.Tables[0].Rows.Count > 0) //菜品 { for (int j = 0; j < manage.Tables[0].Rows.Count; j++) { manageString += "<dd> "; manageString += "<span class=\"count_zero\" id=\"num_" + manage.Tables[0].Rows[j]["id"].ToString() + "_1\" onClick=\"addProduct('" + manage.Tables[0].Rows[j]["id"].ToString() + "','1','" + manage.Tables[0].Rows[j]["cpName"].ToString() + "','18.0','" + category.Tables[0].Rows[i]["id"].ToString() + "',1);\">0</span>"; manageString += " <div class=\"tupian\"><img src=" + manage.Tables[0].Rows[j]["picUrl"].ToString() + " onClick=\"htmlit('http:','" + manage.Tables[0].Rows[j]["cpName"].ToString() + "'," + manage.Tables[0].Rows[j]["id"].ToString() + ")\">"; manageString += "<a href=\"javascript:addProduct('" + manage.Tables[0].Rows[j]["id"].ToString() + "','1','" + manage.Tables[0].Rows[j]["cpName"].ToString() + "','" + manage.Tables[0].Rows[j]["zkPrice"].ToString() + "','" + category.Tables[0].Rows[i]["id"].ToString() + "',1);\" class=\"add\" data-foodid=\"" + manage.Tables[0].Rows[j]["id"].ToString() + "_1\">"; manageString += "<h3>" + manage.Tables[0].Rows[j]["cpName"].ToString() + "</h3>"; manageString += " <em>" + manage.Tables[0].Rows[j]["zkPrice"].ToString() + "元/件<del>" + manage.Tables[0].Rows[j]["cpPrice"].ToString() + "元/件</del></em>"; manageString += " <p class=\"dpNum\">" + manage.Tables[0].Rows[j]["scan"].ToString() + "</p></a> "; manageString += " <a href=\"javascript:reduceProduct('" + manage.Tables[0].Rows[j]["id"].ToString() + "','1',1);\" class=\"reduce\" id=\"del_" + manage.Tables[0].Rows[j]["id"].ToString() + "_1\" style=\"display:none;\"><b class=\"ico_reduce\">减一份</b></a>"; manageString += " </div></dd>"; } } } else { cateString += "<dd ><a style=\"width: 100%;\" href=\"index.aspx?categoryid=" + category.Tables[0].Rows[i]["id"] + "&openid=" + openid + "&shopid=" + shopid + "&aid=" + aid + "\">" + category.Tables[0].Rows[i]["categoryName"] + "</a></dd>"; } categories += "\"" + category.Tables[0].Rows[i]["id"].ToString() + "\"" + ":" + "\"" + category.Tables[0].Rows[i]["categoryName"].ToString() + "\"" + ","; } categories = categories.Substring(0, categories.Length - 1); categories += "}"; } } }