private void RptBind(string _strWhere, string _orderby)
{
// Model.wx_userweixin weixin = GetWeiXinCode();
//判断是否已经设置了微留言基本信息
BLL.wx_diancai_caipin_category sbll = new BLL.wx_diancai_caipin_category();
_strWhere = "shopid=" + shopid + " " + _strWhere;
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_category.aspx", "keywords={0}&page={1}&shopid={2}", this.keywords, "__id__", shopid.ToString());
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
openid = MyCommFun.QueryString("openid");
aid = MyCommFun.RequestInt("aid");
shopid = MyCommFun.RequestInt("shopid");
shopinfo = shopBll.GetModel(shopid);
hotelName = shopinfo.hotelName;
idf = MyCommFun.RequestInt("id");
if (idf != 0)
{
member = menberbll.GetModel(idf);
name = member.memberName;
phone = member.menberTel;
this.note.InnerText = member.memberAddress;
}
categories = "{";
DataSet category1 = categorybll.GetList(shopid);
if (category1.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < category1.Tables[0].Rows.Count; i++)
{
categories += "\"" + category1.Tables[0].Rows[i]["id"].ToString() + "\"" + ":" + "\"" + category1.Tables[0].Rows[i]["categoryName"].ToString() + "\"" + ",";
}
}
categories = categories.Substring(0, categories.Length - 1);
categories += "}";
}
}
protected void BindFormControl()
{
BLL.wx_diancai_caipin_category categorybll = new BLL.wx_diancai_caipin_category();
BLL.wx_diancai_member menberbll = new BLL.wx_diancai_member();
Model.wx_diancai_member member = new Model.wx_diancai_member();
BLL.wx_diancai_shopinfo shopBll = new BLL.wx_diancai_shopinfo();
Model.wx_diancai_shopinfo shopinfo = new Model.wx_diancai_shopinfo();
openid = MyCommFun.QueryString("openid");
shopid = MyCommFun.RequestInt("shopid");
wid = MyCommFun.QueryString("wid");
if (openid == "" || shopid == 0)
{
return;
}
shopinfo = shopBll.GetModel(shopid);
if (shopinfo == null)
{
return;
}
hotelName = shopinfo.hotelName;
idf = MyCommFun.RequestInt("id");
member = menberbll.GetModel(shopid, openid);
if (member != null)
{
name = member.memberName;
phone = member.menberTel;
}
categories = "{";
DataSet category1 = categorybll.GetList(shopid);
if (category1.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < category1.Tables[0].Rows.Count; i++)
{
categories += "\"" + category1.Tables[0].Rows[i]["id"].ToString() + "\"" + ":" + "\"" + category1.Tables[0].Rows[i]["categoryName"].ToString() + "\"" + ",";
}
}
categories = categories.Substring(0, categories.Length - 1);
categories += "}";
}
/// <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 += "}";
}
}
}
protected void BindFormControl()
{
BLL.wx_diancai_caipin_category categorybll = new BLL.wx_diancai_caipin_category();
BLL.wx_diancai_dingdan_caiping caipinbll = new BLL.wx_diancai_dingdan_caiping();
BLL.wx_diancai_member menberbll = new BLL.wx_diancai_member();
Model.wx_diancai_member member = new Model.wx_diancai_member();
BLL.wx_diancai_shopinfo shopBll = new BLL.wx_diancai_shopinfo();
Model.wx_diancai_shopinfo shopinfo = new Model.wx_diancai_shopinfo();
BLL.wx_diancai_form_control controlbll = new BLL.wx_diancai_form_control();
openid = MyCommFun.QueryString("openid");
shopid = MyCommFun.RequestInt("shopid");
zhuohao(shopid);
if (openid == "" || shopid == 0)
{
return;
}
shopinfo = shopBll.GetModel(shopid);
rename = shopinfo.dcRename;
hotelName = shopinfo.hotelName;
idf = MyCommFun.RequestInt("id");
member = menberbll.GetModel(shopid, openid);
if (member != null)
{
name = member.memberName;
phone = member.menberTel;
this.address.InnerText = member.memberAddress;
}
if (shopinfo.limiteOrder && (!isOpen(shopinfo)))
{
contact_info.Style.Add("display", "none");
showcard.Style.Add("display", "none");
// MessageBox.ResponseScript(this, "$(\"#showcard2\").show();");
showcard2.Style.Add("display", "");
// contact_info.InnerHtml = "";
}
//获取控件
DataSet ZH = controlbll.GetListZH(shopid);
if (ZH.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ZH.Tables[0].Rows.Count; i++)
{
if (ZH.Tables[0].Rows[i]["cType"].ToString() == "0")
{
kongjian += "<tr><td width=\"80px\"><label for=\"txt" + i + "\" class=\"ui-input-text\" >" + ZH.Tables[0].Rows[i]["cName"] + "：</label></td>";
kongjian += "<td><div class=\"ui-input-text\">";
kongjian += " <input type=\"text\" id=\"txt" + i + "\" name=\"txt" + i + "\" value=\"\" class=\"ui-input-text\" placeholder=\"" + ZH.Tables[0].Rows[i]["defaultValue"] + "\">";
kongjian += "</div></td></tr>";
javascriptStr += "control_" + ZH.Tables[0].Rows[i]["seq"] + ":$(\"#txt" + i + "\").val(),";
}
else if (ZH.Tables[0].Rows[i]["cType"].ToString() == "1")
{
kongjian += "<tr><td width=\"80px\"><label for=\"select" + i + "\" class=\"ui-input-text\" >" + ZH.Tables[0].Rows[i]["cName"] + "：</label></td>";
kongjian += "<td>";
kongjian += "<select name=\"select" + i + "\" class=\"selectstyle\" id=\"select" + i + "\" >";
if (ZH.Tables[0].Rows[i]["defaultValue"].ToString() != "")
{
string strzh = ZH.Tables[0].Rows[i]["defaultValue"].ToString().Replace("，", ",");
string[] sArray = strzh.Split(',');
for (int j = 0; j < sArray.Length; j++)
{
kongjian += "<option value=" + sArray[j] + ">" + sArray[j] + "</option>";
}
}
kongjian += "</select>";
kongjian += "</td></tr>";
javascriptStr += "control_" + ZH.Tables[0].Rows[i]["seq"] + ":$(\"#select" + i + "\").val(),";
}
}
}
categories = "{";
DataSet category1 = categorybll.GetList(shopid);
if (category1.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < category1.Tables[0].Rows.Count; i++)
{
categories += "\"" + category1.Tables[0].Rows[i]["id"].ToString() + "\"" + ":" + "\"" + category1.Tables[0].Rows[i]["categoryName"].ToString() + "\"" + ",";
}
}
categories = categories.Substring(0, categories.Length - 1);
categories += "}";
}
