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(); }