private void LL()
{
string sql = "select ProName from vgTaoCan_Info where ProSN=" + id;
d = new SqlDataSelect(sql);
if (d.Count < 1)
{
return;
}
string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;
sqlSelect = "select ev.Fraction,ev.FK_User,ev.Detail,ev.ReDetail,ev.AddDate,ui.UserName";
sqlFrom = " from TaoCan_Evaluate ev left join User_Info ui on ev.FK_User=ui.UserSN";
sqlWhere = " where Purview=1 and FK_Pro=" + id;
sqlOrder = " order by ev.AddDate desc";
pkName = "EvalSN";
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
pv.SQLRead = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
pv.SQL = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;
Paging pg = new Paging(pv, new PagingUrlVar(30));
pg.load();
DataTable dt = pg.GetDataTable();
cou = dt.Rows.Count.ToString();
Bind.BGRepeater(dt, this.rpList);
this.ucPS1.f = pg;
}
private void LL()
{
string sql;
DataTable dt;
sql = "select Title,Detail,Source,EditDate,Vote from News_Info where NewsSN=" + id;
d = new SqlDataSelect(sql);
//导航栏
curPath.Text += d.Eval("Title");
//投票
sql = "select ClassName,Str,PicS from Vote_Class where PClassSN=(select ClassSN from Vote_Class where Str='news') order by Taxis asc";
dt = DbHelp.GetDataTable(sql);
Bind.BGRepeater(dt, rpVoteList, false);
//hit +1
sql = "update News_Info set Hit=Hit+1 where NewsSN=" + id;
DbHelp.Update(sql);
//健康食品推荐
sql = "select top 10 ProSN,ProName,PicS,Price from vgPro_Info where JoinType=0 and Item&128=128 and Item&2=2 order by EditDate desc";
dt = DbHelp.GetDataTable(sql);
this.rpList.dt = dt;
this.rpList.listEvent = new CycleEvent(ProLay.d_list3);
List();
}
//订单详细信息
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()
{
string sSQL = "select FK_Pro_Class,FK_Join,ProName,Number,PicS,PicB,UnitNum,Unit,StockN,SellN,SellN1,hit,Detail1,Detail2,AddDate,EditDate,ProIsHas,Item from vgCaiPu_Info where ProSN=" + id;
d = new SqlDataSelect(sSQL);
if (d.Count > 0)
{
int FK_Pro_Class = Convert.ToInt32(d.Eval("FK_Pro_Class"));
CurPath(FK_Pro_Class); //位置
ShowAttr(); //显示属性
GetClassAttr(); //分类属性
Relate(); //相关食谱
GetGZ(); //关注
PicList(); //商品多张图片
MsgList();
SameClass(FK_Pro_Class);
//this.ucHistory.ProID = id;
FnData.SetHistory("caiPuHistory", id, 5);
GetFraction();
HitAdd();
GetChild();
}
}
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 sql;
if (id > 0)
{
sql = "select Name,Address,FixTel,Tel,FK_Area from User_Contact where ConSN=" + id + " and FK_User="******"Name").ToString();
this.cAddress.Text = d.Eval("Address").ToString();
this.cFixTel.Text = d.Eval("FixTel").ToString();
this.cTel.Text = d.Eval("Tel").ToString();
this.cArea.Text = d.Eval("FK_Area").ToString();
cp.Exe(d.Eval("FK_Area"));
//this.cSelectSpanHidden.Text = acp.GetPath;
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
}
private void LL()
{
string sSQL = "select FK_Pro_Class,JoinType,ProName,Number,PicS,PicB,Price,Price1,PriceMarket,PriceCost,UnitNum,Unit,SellN,SellN1,hit,Detail1,Detail2,AddDate,ProIsHas,Item,MS_StartTime,MS_EndTime from vgPro_Info where ProSN=" + id;
d = new SqlDataSelect(sSQL);
if (d.Count > 0)
{
item = int.Parse(d.Eval("Item").ToString());
int FK_Pro_Class = Convert.ToInt32(d.Eval("FK_Pro_Class"));
CurPath(FK_Pro_Class);//位置
//ShowAttr();//菜篮子 无公害
GetItemValue(); //显示属性
GetMS(); //秒杀
Relate(); //相关食谱,套餐
GetGZ(); //关注
PicList(); //商品多张图片
EvaluateList(); //评价列表
ProSameClass(FK_Pro_Class);
//this.ucHistory.ProID = id;
FnData.SetHistory("proHistory", id, 5);
GetFraction();
HitAdd();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string furl = "login.aspx?furl=" + Request.Url.ToString();
if (LoginInfo.IsLogin())
{
Response.Redirect(furl);
return;
}
id = Req.GetID();
string sql = "update User_Letter set IsRead=1 where LetSN=" + id + " and FK_User_To=" + LoginInfo.UserID
+ ";select FK_User_From,Title,Detail,AddDate,(select UserName from User_Info where UserSN=User_Letter.FK_User_From) as fromUserName from User_Letter where LetSN=" + id + " and FK_User_To=" + LoginInfo.UserID;
d = new SqlDataSelect(sql);
}
private void LL()
{
string sql = "select ProName from vgPro_Info where ProSN=" + id;
d = new SqlDataSelect(sql);
if (d.Count < 1)
{
return;
}
//ajax 分类
int cur_pageIndex = Fn.IsInt(Req.GetForm("ajax_page"), 1);
string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;
sqlSelect = "select ev.Fraction,ev.Detail,ev.ReDetail,ev.AddDate,ui.UserName";
sqlFrom = " from Pro_Evaluate ev left join User_Info ui on ev.FK_User=ui.UserSN";
sqlWhere = " where Purview=1 and FK_Pro=" + id;
sqlOrder = " order by ev.AddDate desc";
pkName = "EvalSN";
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
pv.SQLRead = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
pv.SQL = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;
Paging pg = new Paging(pv, new PagingUrlVar(30, cur_pageIndex));
pg.load();
DataTable dt = pg.GetDataTable();
cou = pg.um.page_count.ToString();
Bind.BGRepeater(dt, this.rpList);
this.ucPS1.f = pg;
this.ucPS1.cs = "javascript:ajaxPage('ajax_page_eval',{0});";
}
protected void LL()
{
string sql = "select ge.ExIntegral,ge.Num,ge.ExTotalIntegral,gi.Detail,gi.PicB,ge.GiftName from Gift_ExchangeLog as ge left join Gift_Info as gi on ge.FK_Gift=gi.GiftSN where ge.ExSN=" + id;
d = new SqlDataSelect(sql);
}
protected void LL()
{
string sql = "select GiftSN,GiftName,Integral,PicB,Detail,StockN from Gift_Info where GiftSN=" + id;
d = new SqlDataSelect(sql);
}
private void LL()
{
if (banH.IsBan())
{
msgAjax.Error("ban");
return;
}
string sql = "select Vote from News_Info where NewsSN=" + id;
SqlDataSelect d = new SqlDataSelect(sql);
if (d.Count > 0)
{
}
else
{
msgAjax.Error("不存在此新闻");
return;
}
string vote = d.Eval("Vote").ToString();
JavaScriptObject jsoVote = null;
try
{
jsoVote = (JavaScriptObject)JavaScriptConvert.DeserializeObject(vote);
}
catch
{
jsoVote = new JavaScriptObject();
}
finally
{
if (jsoVote == null)
{
jsoVote = new JavaScriptObject();
}
}
sql = "select top 1 1 from Vote_Class where PClassSN in(select ClassSN from Vote_Class where Str='news') and Str=@Str";
IDataParameter[] dp =
{
DbHelp.Def.AddParam("@Str", s),
};
if (DbHelp.First(sql, dp, "0") == "1")
{
object val;
if (jsoVote.TryGetValue(s, out val))
{
jsoVote[s] = Fn.IsInt(val.ToString(), 0) + 1;
}
else
{
jsoVote.Add(s, "1");
}
}
else
{
msgAjax.Error("不存在此投票项");
return;
}
if (jsoVote.Count > 0)
{
sql = "update News_Info set Vote=@Vote where NewsSN=" + id;
IDataParameter[] dp1 =
{
DbHelp.Def.AddParam("@Vote", JavaScriptConvert.SerializeObject(jsoVote)),
};
DbHelp.Update(sql, dp1);
banH.Add();
msgAjax.Success("1");
}
else
{
msgAjax.Error("投票失败");
}
}
