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();
}
}
private void GetItemValue()
{
const string fmat = "<li><img src=\"/images/item_detail/Label_{0}.gif\" alt=\"{1}\" /></li>";
StringBuilder sb = new StringBuilder();
if (d.Eval("JoinType").ToString() == "0")
{
sb.Append(string.Format(fmat, "01", "菜篮子"));
}
if ((item & 128) == 128)
{
sb.Append(string.Format(fmat, "02", "无公害"));
}
if ((item & 1) == 1)
{
sb.Append(string.Format(fmat, "03", "新品"));
}
if ((item & 2) == 2)
{
sb.Append(string.Format(fmat, "04", "推荐"));
}
if ((item & 8) == 8)
{
sb.Append(string.Format(fmat, "05", "热销"));
}
pageItem = sb.ToString();
}
private void ShowAttr()
{
int Item = Convert.ToInt32(d.Eval("Item"));
//int iItem1 = (int)PubEnum.CaiPuItem.菜蓝子;
int iItem2 = 128;//无公害;
//if ((Item & iItem1) == iItem1)
// this.liAttr1.Visible = true;
if ((Item & iItem2) == iItem2)
{
this.liAttr2.Visible = true;
}
}
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 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 ShowAttr()
{
int Item = Convert.ToInt32(d.Eval("Item"));
int iItem1 = (int)PubEnum.TaoCanItem.菜蓝子;
int iItem2 = (int)PubEnum.TaoCanItem.无公害;
if ((Item & iItem1) == iItem1)
{
this.liAttr1.Visible = true;
}
if ((Item & iItem2) == iItem2)
{
this.liAttr2.Visible = true;
}
}
//订单详细信息
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 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()
{
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("投票失败");
}
}
