private void GetClassAttr()
{
DataTable dtClassAttr = PubData.GetDataTable("caipu_classattr");
string sql = "select FK_Info_ClassAttr1,FK_Info_ClassAttr2 from CaiPu_ClassAttrInfo where FK_Info=" + id;
DataTable dt = DbHelp.GetDataTable(sql);
foreach (DataRow drw in dt.Rows)
{
string a1 = string.Empty;
string a2 = string.Empty;
foreach (DataRow drw1 in dtClassAttr.Rows)
{
if (drw["FK_Info_ClassAttr1"].ToString() == drw1["ClassSN"].ToString())
{
a1 = "<span>" + drw1["ClassName"].ToString() + "</span>";
}
if (drw["FK_Info_ClassAttr2"].ToString() == drw1["ClassSN"].ToString())
{
a2 = "<a href=\"/search/caiPu.aspx?s=------" + drw1["ClassSN"] + "\" target=\"_blank\" title=\"搜索与'" + drw1["ClassName"].ToString() + "'相关的食谱\">" + drw1["ClassName"].ToString() + "</a>";
}
}
if (a1.Length > 0)
{
pageClassAttr.Append("<li>");
pageClassAttr.Append(a1);
pageClassAttr.Append(a2);
pageClassAttr.Append("</li>");
}
}
}
private void LL()
{
string sql;
DataTable dt;
//一级分类
dtC = PubData.GetDataTable("TaoCan_Class");
DataRow[] dr = dtC.Select("ClassLevel=1", "Taxis asc");
dt = dtC.Clone();
Fn.DrwToDt(dr, dt);
Bind.BGRepeater(dt, rpClass1);
//推荐1
sql = "select top 2 ProSN,ProName,PicS from vgTaoCan_Info where Item&2=2 order by EditDate desc";
dt = DbHelp.GetDataTable(sql);
Bind.BGRepeater(dt, rpTJ1);
//推荐2
sql = "select top 4 ProSN,ProName,PicS from vgTaoCan_Info where Item&4=4 order by EditDate desc";
dt = DbHelp.GetDataTable(sql);
Bind.BGRepeater(dt, rpTJ2);
//精品
sql = "select top 12 ProSN,ProName,PicS from vgTaoCan_Info where Item&1=1 order by EditDate desc";
dt = DbHelp.GetDataTable(sql);
Bind.BGRepeater(dt, rpJP);
}
private void LL()
{
string sql;
DataTable dt;
//分类下 文章
sql = "select HelpSN,FK_Help_Class,Taxis,Title from Help_Info";
dtL = DbHelp.GetDataTable(sql);
//内容
if (id == 0)
{
sql = "select top 1 HelpSN,Title,Detail from Help_Info order by Taxis asc";
}
else
{
sql = "select HelpSN,Title,Detail from Help_Info where HelpSN=" + id;
}
d = new SqlDataSelect(sql);
//分类
dt = PubData.GetDataTable("help_class");
Bind.BGRepeater(dt, rpClass, false);
}
private void LL()
{
string sSQL = "select RealName,Sex,Area,Address,EMail,Tel from User_Info where UserSN=" + LoginInfo.UserID;
string sSex = "1";
string sArea = string.Empty;
using (IDataReader dr = DbHelp.Read(sSQL))
{
if (dr.Read())
{
this.cName.Text = dr["RealName"].ToString();
this.cEMail.Text = dr["EMail"].ToString();
this.cTel.Text = dr["Tel"].ToString();
this.cAddress.Text = dr["Address"].ToString();
sArea = dr["Area"].ToString();
this.cArea.Text = sArea;
sSex = dr["Sex"].ToString();
}
else
{
Message.Error("不存此用户");
}
}
this.cSex.Text = Bind.GetHtmlRadio(KeyPair.Sex, "cSex", sSex);
GetClassPath1 acp = new GetClassPath1();
ClassPath cp = new ClassPath(PubData.GetDataTable("Pub_Area"), acp);
cp.Exe(Fn.IsInt(sArea, 0));
this.cSelectSpanHidden.Text = acp.GetPath;
}
//private IMessage msgAjax = new MessageAjax();
protected void Page_Load(object sender, EventArgs e)
{
id = Req.GetID();
UserID = LoginInfo.UserID;
cp = new ClassPath(PubData.GetDataTable("pub_area"), acp);
string hid = Req.GetForm("hid");
if (hid == "1")
{
string cmd = Req.GetForm("cmd");
switch (cmd)
{
case "save":
cb_ok();
break;
case "del":
cb_delete();
break;
}
Response.Write(msgAjax.ReturnMessage);
Response.End();
}
if (!this.IsPostBack)
{
LL();
BGList();
}
}
//订单详细信息
private void GetOrdInfo()
{
//pageMod = new Ord_InfoM();
string sSQL = "select Ticket_1_Number,Ticket_1_Price,UserName,RealName,FixTel,Tel,Area,Address,OrdNumber,TotalPrice,AddDate,Caption,Remark,Status,StatusPay,ToMinTime,ToMaxTime,(select PayName from Pay_Info where PaySN=a.FK_Pay) as pn from Ord_Info a where OrdSN=" + id + " and FK_User="******"Remark").ToString().Length == 0)
// pageMod.Remark = "无";
ItemHandler kpOrd = new ItemHandler("OrderStatus");
pageStatusName = kpOrd.GetDircBit(int.Parse(d.Eval("Status").ToString()));
pagePayName = d.Eval("pn").ToString();
//区域
GetClassPath1 acp = new GetClassPath1();
ClassPath cp = new ClassPath(PubData.GetDataTable("pub_area"), acp);
cp.Exe(Convert.ToInt32(d.Eval("Area")));
pageAreaPath = acp.GetPath;
pageTicket_1_Number = d.Eval("Ticket_1_Number").ToString();
pageTicket_1_Price = double.Parse(d.Eval("Ticket_1_Price").ToString());
pageTotalPrice = double.Parse(d.Eval("TotalPrice").ToString());
}
else
{
msgG.Error("此订单不存在");
}
}
private void LL()
{
dtClass = PubData.GetDataTable("caipu_class");
DataTable dt;
string sql;
//推荐
sql = "select top 3 ProSN,ProName,PicS,Item from vgCaiPu_Info where Item&2=2 order by EditDate desc";
dt = cac.GetDataTable("caipulist_Item&2=2", sql);
this.rpTJ.dt = dt;
this.rpTJ.listEvent = CaiPuLay.d_dingo1;
//精品
sql = "select top 16 ProSN,ProName,PicS,Item from vgCaiPu_Info where Item&1=1 order by EditDate desc";
dt = cac.GetDataTable("caipulist_Item&1=1", sql);
this.rpJingPin.dt = dt;
this.rpJingPin.listEvent = CaiPuLay.d_dingo1;
//特价
sql = "select top 2 ProSN,ProName,PicS,Detail2,Item from vgCaiPu_Info where Item&4=4 order by EditDate desc";
dt = cac.GetDataTable("caipulist_Item&4=4", sql);
this.rpTeJja.dt = dt;
this.rpTeJja.listEvent = CaiPuLay.d_1;
//ListCaiPu("caiPu_JP", 9, PubEnum.CaiPuItem.精品食谱, this.rpJingPin);
//ListCaiPu("caiPu_TeiJia", 2, PubEnum.CaiPuItem.特价, this.rpTeJja);
PathList(); //分类列表
GetNewEval(); //最新评论产品
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = PubData.GetDataTable("pro_class");
DataRow drw = dt.Rows.Find(555);
Response.Write(drw == null);
}
protected void Page_Load(object sender, EventArgs e)
{
dt = PubData.GetDataTable("pub_area");
//LL1();
Response.Write("----------------------<br>");
LL2();
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = PubData.GetDataTable("help_class");
foreach (DataRow drw in dt.Rows)
{
Response.Write(drw["ClassName"] + "<br>");
}
}
private void CurPath(int pClassID)
{
DataTable dtCaiPuClass = PubData.GetDataTable("caipu_class");
GetClassPath gcp = new GetClassPath(GetURL.CaiPu.Class("{0}"));
ClassPath cp = new ClassPath(dtCaiPuClass, gcp);
cp.Exe(pClassID);
this.curPath.Text = " > <a href=\"" + GetURL.CaiPu.Default() + "\">烹饪课堂</a>" + gcp.GetPath;
}
private void CurPath(int pClassID)
{
DataTable dtProClass = PubData.GetDataTable("pro_class");
GetClassPath gcp = new GetClassPath(GetURL.Pro.Class("{0}"));
ClassPath cp = new ClassPath(dtProClass, gcp);
cp.Exe(pClassID);
this.curPath.Text = gcp.GetPath;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
dtHelpClass = PubData.GetDataTable("help_class");
string sql = "select * from Help_Info order by Taxis asc";
dtHelp = cac.GetDataTable("helplist_all", sql);
}
}
private void CurPath(int pClassID)
{
DataTable dtClass = PubData.GetDataTable("TaoCan_Class");
GetClassPath gcp = new GetClassPath(GetURL.TaoCan.Class("{0}"));
ClassPath cp = new ClassPath(dtClass, gcp);
cp.Exe(pClassID);
this.curPath.Text = " > <a href=\"" + GetURL.TaoCan.Default() + "\">营养套餐</a>" + gcp.GetPath;
}
private void LL()
{
dtClass = PubData.GetDataTable("TaoCan_Class");
ListTaoCan("taoCan_TJ", 3, PubEnum.TaoCanItem.推荐, this.rpTJ);
ListTaoCan("taoCan_JP", 9, PubEnum.TaoCanItem.精品食谱, this.rpJingPin);
ListTaoCan("taoCan_TeiJia", 2, PubEnum.TaoCanItem.特价, this.rpTeJja);
PathList();//分类列表
}
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
DataTable dt = PubData.GetDataTable("webinfo");
DataRow[] arrDrw = dt.Select("Str='" + str + "'");
if (arrDrw.Length > 0)
{
writer.Write("<div " + attr + ">");
writer.Write(arrDrw[0]["Detail"].ToString());
writer.Write("</div>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Cache["Key3"] = DateTime.Now.ToString();
DataTable dt = PubData.GetDataTable("join_info");
//Response.Write((int)SCWCache.CacheKey.Join_Info);
foreach (DataRow drw in dt.Rows)
{
Response.Write(drw[1].ToString() + "<br>");
}
}
public PubData GetPub(string pubName)
{
PubData selectedPub = null;
foreach (PubData currPub in pubs)
{
if (currPub.pubName.CompareTo(pubName) == 0)
{
selectedPub = currPub;
}
}
return(selectedPub);
}
private void LL()
{
dtClass = PubData.GetDataTable("caipu_class");
pageClassName = Fn.GetDataTableFind(dtClass, id, "ClassName").ToString();
PathList(); //分类列表
ListTJ(); //推荐
List(); //产品列表
GetClassPath gcp = new GetClassPath(GetURL.CaiPu.Class("{0}"));
ClassPath cp = new ClassPath(dtClass, gcp);
cp.Exe(id);
this.curPath.Text = " > <a href=\"" + GetURL.CaiPu.Default() + "\">烹饪课堂</a>" + gcp.GetPath;
}
protected void GetCaiPu()
{
DataTable dt = PubData.GetDataTable("caipu_classattr");
DataRow[] arrDrw = dt.Select("ClassLevel=1", "Taxis asc");
foreach (DataRow drw in arrDrw)
{
sbCaiPu.Append("<li>");
sbCaiPu.Append("<div class=\"left\">" + drw["ClassName"] + "：</div>");
sbCaiPu.Append("<div class=\"right\">");
DataRow[] arrDrw1 = dt.Select("PClassSN=" + drw["ClassSN"], "Taxis asc");
foreach (DataRow drw1 in arrDrw1)
{
sbCaiPu.Append(string.Format("<p><input id=\"attrCaiPu_{0}_{1}\" name=\"attrCaiPu_{0}\" type=\"radio\" value=\"{1}\" /><label for=\"attrCaiPu_{0}_{1}\">{2}</label></p>", drw["ClassSN"], drw1["ClassSN"], drw1["ClassName"]));
}
sbCaiPu.Append("</div>");
sbCaiPu.Append("</li>");
}
}
private void LL()
{
GetAttrClassName();
this.curPath.Text += " <span class=\"search-color\">";
if (keyword.Length > 0)
{
this.curPath.Text += keyword;
}
dtClass = PubData.GetDataTable("caipu_class");
if (item > 0)
{
IList <ItemInfo> l_Item = new List <ItemInfo>();
l_Item.Add(new ItemInfo()
{
id = "1", name = "精品食谱"
});
l_Item.Add(new ItemInfo()
{
id = "2", name = "推荐食谱"
});
ItemHandler ih_Item = new ItemHandler(l_Item);
this.curPath.Text += ih_Item.GetDircBit(item);
}
this.curPath.Text += "</span>";
//pageClassName = Fn.GetDataTableFind(dtClass, id, "ClassName").ToString();
//this.curPath.Text += pageClassName;
List();//产品列表
//GetClassPath gcp = new GetClassPath(GetURL.Pro.Class("{0}"));
//ClassPath cp = new ClassPath(dtClass, gcp);
//cp.Exe(id);
//foreach (int cid in gcp.PathListID)
// oneLevelClassID = cid;
//this.curPath.Text = gcp.GetPath;
PathList();//分类列表
}
private void LL()
{
dtClass = PubData.GetDataTable("Pro_Class");
pageClassName = Fn.GetDataTableFind(dtClass, id, "ClassName").ToString();
List();//产品列表
//GetClassPath gcp = new GetClassPath(GetURL.Pro.Class("{0}"));
//ClassPath cp = new ClassPath(dtClass, gcp);
//cp.Exe(id);
//foreach (int cid in gcp.PathListID)
// oneLevelClassID = cid;
//this.curPath.Text = gcp.GetPath;
PathList();//分类列表
}
private void LL()
{
dtClass = PubData.GetDataTable("pro_class");
PathList();
ListTJ();
GetNewSell();//最近出售
string sql;
//int iItem;
//iItem = (int)PubEnum.ProItem.推荐到菜篮子专栏栏目;
//推荐到专栏栏目 512 菜篮子
sql = "select top 14 ProSN,ProName,PicS,Price,PriceMarket from vgPro_Info where JoinType=0 and Item&512=512 order by EditDate desc";
dtCLZ = cac.GetDataTable("prolist_JoinType=0 and Item&512=512", sql);
//推荐到专栏栏目 512 商家
sql = "select top 14 ProSN,ProName,PicS,Price,PriceMarket from vgPro_Info where JoinType=1 and Item&512=512 order by EditDate desc";
dtSJ = cac.GetDataTable("prolist_JoinType=1 and Item&512=512", sql);
}
private void LL()
{
this.curPath.Text += " <span class=\"search-color\">" + keyword + "</span>";
dtClass = PubData.GetDataTable("pro_class");
//pageClassName = Fn.GetDataTableFind(dtClass, id, "ClassName").ToString();
List();//产品列表
//GetClassPath gcp = new GetClassPath(GetURL.Pro.Class("{0}"));
//ClassPath cp = new ClassPath(dtClass, gcp);
//cp.Exe(id);
//foreach (int cid in gcp.PathListID)
// oneLevelClassID = cid;
//this.curPath.Text = gcp.GetPath;
PathList();//分类列表
}
private void GetAttrClassName()
{
if (searchClassAttr.Length > 0)
{
string searchClassAttrName = string.Empty;
string ss = "," + searchClassAttr + ",";
DataTable dt = PubData.GetDataTable("caipu_classattr");
foreach (DataRow drw in dt.Rows)
{
if (ss.IndexOf("," + drw["ClassSN"].ToString() + ",") >= 0)
{
searchClassAttrName += drw["ClassName"].ToString() + ",";
}
}
if (searchClassAttrName.Length > 0)
{
curPath.Text += "> <strong>" + searchClassAttrName.TrimEnd(',') + "</strong>";
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
context.Response.CacheControl = "no-cache";
string tableName = string.Empty;
switch (Req.GetQueryString("t"))
{
//case "news":
// tableName = "News_Class";
// break;
case "pro":
tableName = "pro_class";
break;
case "help":
tableName = "help_class";
break;
//case "pack":
// tableName = "Pack_Class";
// break;
case "area":
tableName = "pub_area";
break;
default:
tableName = "pub_area";
break;
}
DataTable dt = PubData.GetDataTable(tableName);
WZ.Data.AjaxHandle.PubClass pc = new WZ.Data.AjaxHandle.PubClass(dt);
pc.Run();
}
private void LL()
{
dtProClass = PubData.GetDataTable("pro_class");
string sSQL = "select ClassSN,ClassName,PClassSN,Taxis from vgPro_Class where Item&1=1 order by Taxis desc";
dtProClassHome = cac.GetDataTable("pro_class_Item&1=1", sSQL);
//DataRow[] aDrw = dtProClassHome.Select("PClassSN=0", "Taxis asc");
//foreach (DataRow drw in aDrw)
//{
// DataRow[] aDrw1 = dtProClassHome.Select("PClassSN=" + drw["ClassSN"], "Taxis asc");
// int j = 0;
// foreach (DataRow drw1 in aDrw)
// {
// j++;
// if (j >= 3)
// break;
// }
//}
}
private void LL()
{
dtClass = PubData.GetDataTable("pro_class");
PathList();
}
