private void MsgList()
{
int cur_pageIndex = Fn.IsInt(Req.GetForm("ajax_page"), 1);
string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;
sqlSelect = "select Detail,N.AddDate as AddDate,UserName";
sqlFrom = " from Questionnaire_Msg as N left join User_Info as U on N.FK_User=U.UserSN";
sqlWhere = " where Purview=1 and FK_Questionnaire=" + QuSN;
sqlOrder = " order by N.AddDate desc";
pkName = "MsgSN";
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));//页记录 30
pg.load();
Bind.BGRepeater(pg.GetDataTable(), this.rpList);
this.ucPS1.f = pg;
this.ucPS1.cs = "javascript:ajaxPage('ajax_page_msg',{0});";
lNum = pg.um.records_count.ToString();
}
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 List()
{
string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;
sqlSelect = "select ge.ExSN,gi.PicS,gi.GiftName,ge.AddDate,ge.ExIntegral,ge.Num";
sqlFrom = " from Gift_ExchangeLog as ge left join Gift_Info as gi on ge.FK_Gift=gi.GiftSN";
sqlWhere = " where ge.FK_User="******" order by ge.AddDate desc";
pkName = "ExSN";
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(12));//页记录 12
pg.load();
Bind.BGRepeater(pg.GetDataTable(), this.rpList);
this.ucPS1.f = pg;
this.ucPS1.cs = "?p={0}";
countN.Text = pg.um.records_count.ToString();//总数
}
//菜谱列表
private void List()
{
string sqlSelect, sqlFrom, sqlWhere = string.Empty, sqlOrder, pkName;
if (t == 1)
{
sqlSelect = "select ProSN,ProName,PicS,Item,Number,UnitNum,StockN,Unit";
}
else
{
sqlSelect = "select ProSN,ProName,PicS,Item";
}
sqlFrom = " from vgCaiPu_Info a inner join T_CaiPu_Class_GetChildAndSelf(" + id + ") b on a.FK_Pro_Class=b.id";
switch (ord)
{
case 1:
sqlOrder = " order by Hit asc";
break;
case 2:
sqlOrder = " order by Hit desc";
break;
default:
sqlOrder = " order by EditDate desc";
break;
}
pkName = "ProSN";
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(16, pageIndex));
pg.load();
if (t == 1)
{
stypeModel = "2";
this.showPic.Visible = false;
this.rpList.dt = pg.GetDataTable();
this.rpList.listEvent = CaiPuLay.f_1;
}
else
{
this.showList.Visible = false;
this.rpPic.dt = pg.GetDataTable();
this.rpPic.listEvent = new CycleEvent(CaiPuLay.d_list2);
}
this.ucPS1.f = pg;
this.ucPS1.cs = GetURL.CaiPu.Class(id + "-{0}-" + t);
}
public static Paging List(int pUserId, string pType)
{
string sOrder = " order by CouponsCodeSN desc";
string sWhere = " where FK_User="******"used":
sWhere += " and Status=1";
break;
case "unused":
sWhere += " and Status=0 and getdate() between StartTime and EndTime";
break;
case "out":
sWhere += " and Status=0 and getdate() not between StartTime and EndTime";
break;
default:
break;
}
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0) from Act_Coupons_Code" + sWhere;
pv.SQLRead = "select CouponsCodeSN from Act_Coupons_Code" + sWhere + sOrder;
pv.SQL = "select CodeNumber,Item,StartTime,EndTime,Remark,Status from Act_Coupons_Code left join Act_Rule on FK_Rule=RuleSN where CouponsCodeSN in({0})" + sOrder;
Paging pg = new Paging(pv, new PagingUrlVar(10));
pg.load();
return(pg);
}
private void FromCaiPu()
{
string sql;
sql = "select ProName from vgCaiPu_Info where ProSN=" + id;
title = DbHelp.First(sql);
string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;
sqlSelect = "select ProSN,ProName,PicS";
sqlFrom = " from vgCaiPu_Info";
sqlWhere = " where ProSN in (select FK_CaiPu from CaiPu_Pro where FK_Pro in (select FK_Pro from CaiPu_Pro where FK_CaiPu=" + id + "))";
sqlOrder = " order by EditDate desc";
pkName = "ProSN";
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(24));//页记录 16
pg.load();
this.rpList.dt = pg.GetDataTable();
this.rpList.listEvent = new CycleEvent(CaiPuLay.list1);
this.ucPS1.f = pg;
}
/// <summary>
/// 添加订单
/// </summary>
/// <param name="pMod"></param>
/// <returns>返回订单编号</returns>
//public int Add(Ord_InfoM pMod)
//{
// //string sql = "FK_Pay,PayType,OrdNumber,FK_User,Caption,FixTel,Tel,Address,RealName,UserName,TotalPrice,Status,StatusPay,Area,AreaTime,ToMinTime,ToMaxTime,FK_AdminUser_PeiSong,FK_AdminUser_ChuKu";
// string sql = "insert into Ord_Info(FK_Pay,PayType,OrdNumber,FK_User,UserName,RealName,FixTel,Tel,Area,Address,TotalPrice,Status,StatusPay,Caption,AreaTime,ToMinTime,ToMaxTime,FK_AdminUser_PeiSong,FK_AdminUser_ChuKu,UserType,UserLevel) values(@FK_Pay,@PayType,@OrdNumber,@FK_User,@UserName,@RealName,@FixTel,@Tel,@Area,@Address,@TotalPrice,@Status,@StatusPay,@Caption,@AreaTime,@ToMinTime,@ToMaxTime,@FK_AdminUser_PeiSong,@FK_AdminUser_ChuKu,@UserType,@UserLevel);select SCOPE_IDENTITY()";
// IDataParameter[] dp = {
// DbHelp.Def.AddParam("@FK_Pay",pMod.FK_Pay),
// DbHelp.Def.AddParam("@PayType",pMod.PayType),
// DbHelp.Def.AddParam("@OrdNumber",pMod.OrdNumber),
// DbHelp.Def.AddParam("@FK_User",pMod.FK_User),
// DbHelp.Def.AddParam("@UserName",pMod.UserName),
// DbHelp.Def.AddParam("@RealName",pMod.RealName),
// DbHelp.Def.AddParam("@FixTel",pMod.FixTel),
// DbHelp.Def.AddParam("@Tel",pMod.Tel),
// DbHelp.Def.AddParam("@Area",pMod.Area),
// DbHelp.Def.AddParam("@Address",pMod.Address),
// DbHelp.Def.AddParam("@TotalPrice",pMod.TotalPrice),
// DbHelp.Def.AddParam("@Status",pMod.Status),
// DbHelp.Def.AddParam("@StatusPay",pMod.StatusPay),
// DbHelp.Def.AddParam("@Caption",pMod.Caption),
// DbHelp.Def.AddParam("@AreaTime",pMod.AreaTime),
// DbHelp.Def.AddParam("@ToMinTime",pMod.ToMinTime),
// DbHelp.Def.AddParam("@ToMaxTime",pMod.ToMaxTime),
// DbHelp.Def.AddParam("@FK_AdminUser_PeiSong",pMod.FK_AdminUser_PeiSong),
// DbHelp.Def.AddParam("@FK_AdminUser_ChuKu",pMod.FK_AdminUser_ChuKu),
// DbHelp.Def.AddParam("@UserType",pMod.UserType),
// DbHelp.Def.AddParam("@UserLevel",pMod.UserLevel),
// };
// int ordId = int.Parse(curHelp.Scalar(sql, dp).ToString());// SqlData.AddReturnID(pMod, sql);// Convert.ToInt32(DbHelp.Scalar(sSQL, dp));
// if (ordId > 0)
// {
// string sRemark = "订单-创建:<ss>" + pMod.OrdNumber + "</ss>";
// Log_OrdM mod = new Log_OrdM();
// mod.FK_Ord = ordId;
// mod.FK_User = pMod.FK_User;
// mod.Operator = pMod.UserName;
// mod.Remark = sRemark;
// new Log_OrdL(this.curHelp).Add(mod);
// }
// return ordId;
//}
public static Paging List(int pUserId, string pType)
{
string sOrder = " order by AddDate desc";
string sWhere = " where FK_User="******"finish":
sWhere += string.Format(" and (Status={0} or Status={1})", 已完成, 已取消);
break;
case "ongoing":
sWhere += string.Format(" and (Status<>{0} and Status<>{1})", 已完成, 已取消);
break;
default:
break;
}
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0) from Ord_Info" + sWhere;
pv.SQLRead = "select OrdSN from Ord_Info" + sWhere + sOrder;
pv.SQL = "select OrdSN,OrdNumber,TotalPrice,Status,StatusPay,AddDate,ToMinTime from Ord_Info where OrdSN in({0})" + sOrder;
Paging pg = new Paging(pv, new PagingUrlVar(10));
pg.load();
return(pg);
}
private void LL()
{
string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;
sqlSelect = "select ev.Detail,ev.ReDetail,ev.AddDate,ev.Purview,ui.UserName,pi.ProSN,pi.ProName,pi.PicS";
sqlFrom = " from Pro_Msg ev left join User_Info ui on ev.FK_User=ui.UserSN left join vgPro_Info pi on ev.FK_Pro=pi.ProSN";
sqlWhere = " where ev.FK_User="******" order by ev.purview asc,ev.AddDate desc";
pkName = "MsgSN";
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(10));
pg.load();
DataTable dt = pg.GetDataTable();
Bind.BGRepeater(dt, this.rpList);
this.ucPS1.f = pg;
}
private void GetPro()
{
string sqlSelect, sqlFrom, sqlWhere = string.Empty, sqlOrder, pkName;
sqlSelect = "select ProSN,ProName,PicS,Price2,Unit,UnitNum";
sqlFrom = " from vgPro_Info";
if (classID > 0)
{
sqlFrom = " from vgPro_Info a inner join T_Pro_Class_GetChildAndSelf(" + classID + ") b on a.FK_Pro_Class=b.id";
}
sqlWhere = " where Item&2048=2048";
sqlOrder = " order by EditDate desc";
pkName = "ProSN";
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(16));
pg.load();
Bind.BGRepeater(pg.GetDataTable(), this.rpPro);
this.ucPS1.f = pg;
}
//产品列表
private void List()
{
string sqlSelect, sqlFrom, sqlWhere = string.Empty, sqlOrder, pkName;
if (t == 1)
{
sqlSelect = "select ProSN,ProName,PicS,Price,PriceMarket,Item,Number,UnitNum,StockN,Unit";
}
else
{
sqlSelect = "select ProSN,ProName,PicS,Price,PriceMarket,Item";
}
sqlFrom = " from vgPro_Info";
sqlWhere = " where Item&1=1";
switch (ord)
{
case 1:
sqlOrder = " order by Price asc";
break;
case 2:
sqlOrder = " order by Price desc";
break;
default:
sqlOrder = " order by EditDate desc";
break;
}
pkName = "ProSN";
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(16, pageIndex));
pg.load();
if (t == 1)
{
stypeModel = "2";
this.showPic.Visible = false;
this.rpList.dt = pg.GetDataTable();
this.rpList.listEvent = ProLay.f_1;
}
else
{
this.showList.Visible = false;
rpPic.dt = pg.GetDataTable();
this.rpPic.listEvent = ProLay.d_listNew;
}
this.ucPS1.f = pg;
this.ucPS1.cs = Request.Url.AbsolutePath + "?s=" + id + "-{0}-" + t;
}
//分类列表
private void List()
{
if (keyword.Length > 0)
{
this.curPath.Text += " <span class=\"search-color\">" + keyword + "</span>";
}
string sqlSelect, sqlFrom, sqlWhere = string.Empty, sqlOrder, pkName;
sqlSelect = "select NewsSN,Source,Title,EditDate,Detail,UrlType,Url";
sqlFrom = " from News_Info";
if (id > 0)
{
sqlWhere = " where FK_News_Class" + id;
}
if (item > 0)
{
string aw = sqlWhere.Length > 0 ? " and " : " where ";
sqlWhere += aw + "Item&" + item + "=" + item;
}
if (keyword.Length > 0)
{
string aw = sqlWhere.Length > 0 ? " and " : " where ";
sqlWhere += aw + " Title like '%'+@Title+'%'";
}
sqlOrder = " order by EditDate desc";
pkName = "NewsSN";
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;
IDataParameter[] dp =
{
DbHelp.Def.AddParam("@Title", keyword)
};
pv.DataParm = dp;
Paging pg = new Paging(pv, new PagingUrlVar(8, pageIndex));//页记录
pg.load();
Bind.BGRepeater(pg.GetDataTable(), this.rpNewsList);
this.ucPS1.f = pg;
this.ucPS1.cs = Request.Url.AbsolutePath + "?s=" + id + "-{0}----" + keywordEncode;
}
public Paging List(bool isWhere)
{
SetGetList();
PagingVar pv = new PagingVar();
#region where
if (ArrWhereSQL != null)
{
int searchWhereType = Req.GetID("SearchType", -1);
if (searchWhereType != -1)
{
string sKeyWrod = Req.GetQueryString("KeyWord").Trim();
this.SqlWhere += " and " + ArrWhereSQL[searchWhereType];
paramList.Add(DbHelp.Def.AddParam("@KeyWrod", sKeyWrod));
}
}
#endregion
if (paramList.Count > 0)
{
pv.DataParm = paramList.ToArray();
}
#region order by
int searchOrder = Req.GetID("SearchOrderBy", -1);
if (searchOrder != -1)
{
int searchOrderValue = Req.GetID("SearchOrderValue", 0);//0降序 1升序
this.sqlOrder = " order by " + this.structDt.Columns[searchOrder].ColumnName + " " + (searchOrderValue == 1 ? "asc" : "desc");
}
#endregion
pv.SQLCount = "select count(0)" + this.sqlFrom + this.sqlWhere;
pv.SQLRead = "select " + pKName + this.sqlFrom + this.sqlWhere + this.sqlOrder;
//abc a,def b where a.id=b.id 这种情况时,需要where
if (isWhere)
{
pv.SQL = this.sqlSelect + this.sqlFrom + this.sqlWhere + " and " + pKName + " in({0})" + this.sqlOrder;
}
else
{
pv.SQL = this.sqlSelect + this.sqlFrom + " where " + pKName + " in({0})" + this.sqlOrder;
}
Paging pg = new Paging(pv, this.puv);
pg.load();
return(pg);
}
public static Paging GetMsgList(int newsId)
{
string sOrder = " order by msgSN desc";
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0) from News_Msg where Purview='0' and FK_News=" + newsId;
pv.SQLRead = "select msgSN from News_Msg where Purview='0' and FK_News=" + newsId + sOrder;
pv.SQL = "select userName,Detail,News_msg.AddDate as date from News_Msg left join User_Info on user_Info.usersn=News_msg.FK_user where msgSN in({0}) " + sOrder;
Paging pg = new Paging(pv, new PagingUrlVar(12));
pg.load();
return(pg);
}
public static Paging List(int pOrderId, int pPageSize)
{
string sOrder = " order by AddDate desc";
string sWhere = " where FK_Ord=" + pOrderId;
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0) from Log_Ord" + sWhere;
pv.SQLRead = "select LOSN from Log_Ord" + sWhere + sOrder;
pv.SQL = "select LOSN,FK_Ord,FK_User,Operator,Remark,AddDate,IP from Log_Ord where LOSN in({0})" + sOrder;
Paging pg = new Paging(pv, new PagingUrlVar(pPageSize));
pg.load();
return(pg);
}
public static Paging List(int pUserID, int pPageSize)
{
string sOrder = " order by AddDate desc";
string sWhere = " where FK_User="******"select count(0) from Log_SetUserFreezeMoney" + sWhere;
pv.SQLRead = "select SUFMID from Log_SetUserFreezeMoney" + sWhere + sOrder;
pv.SQL = "select SUFMID,FK_User,Number,Operator,SetFreezeMoney,Remark,AddDate,IP from Log_SetUserFreezeMoney where SUFMID in({0})" + sOrder;
Paging pg = new Paging(pv, new PagingUrlVar(pPageSize));
pg.load();
return(pg);
}
public static Paging List(int pUserID, int pPageSize)
{
string sOrder = " order by AddDate desc";
string sWhere = " where FK_User="******"select count(0) from Log_SetUserIntegral" + sWhere;
pv.SQLRead = "select SUISN from Log_SetUserIntegral" + sWhere + sOrder;
pv.SQL = "select SUISN,FK_User,Operator,SetValue,Remark,AddDate,IP from Log_SetUserIntegral where SUISN in({0})" + sOrder;
Paging pg = new Paging(pv, new PagingUrlVar(pPageSize));
pg.load();
return(pg);
}
//评论列表
private void List()
{
//PagingList pl = new PagingList("News_Msg", "MsgSN", new PagingUrlVar(10, pageIndex));
//pl.SqlSelect = "select N.FK_User,Detail,N.AddDate as AddDate,UserName";
//pl.SqlFrom = "from News_Msg as N left join User_Info as U on N.FK_User=U.UserSN";
//pl.SqlWhere = "where Purview=1 and FK_News=" + id;
//pl.SqlOrder = "order by N.AddDate desc";
//Paging pg = pl.List(true);
//Bind.BGRepeater(pg.GetDataTable(), this.rpMsgList);
//this.ucPS1.f = pg;
//this.ucPS1.cs = GetURL.News.Msg(id) + "-{0}";
#region ajax提交
int cur_pageIndex = Fn.IsInt(Req.GetForm("ajax_page"), 1);
string sqlSelect, sqlFrom, sqlWhere = string.Empty, sqlOrder, pkName;
sqlSelect = "select N.FK_User,Detail,N.AddDate as AddDate,UserName";
sqlFrom = " from News_Msg as N left join User_Info as U on N.FK_User=U.UserSN";
sqlWhere = " where Purview=1 and FK_News=" + id;
sqlOrder = " order by N.AddDate desc";
pkName = "MsgSN";
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();
Bind.BGRepeater(pg.GetDataTable(), this.rpMsgList);
lNum = pg.um.records_count.ToString();
this.ucPS1.f = pg;
this.ucPS1.cs = "javascript:ajaxPage('ajax_page_msg',{0});";
#endregion
}
private void GetCaiPu()
{
string sOrder = " order by a.AddDate desc";
string sWhere = " where a.FK_User="******" and InfoType=" + t;
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0) from User_Fav a" + sWhere;
pv.SQLRead = "select FavSN from User_Fav a" + sWhere + sOrder;
pv.SQL = "select FavSN,FK_All,FK_User,ProName,PicS,Item,a.AddDate from User_Fav a left join CaiPu_Info b on a.FK_All=b.ProSN where FavSN in({0})" + sOrder;
Paging pg = new Paging(pv, new PagingUrlVar(10));
pg.load();
Bind.BGRepeater(pg.GetRead(), this.rpCaiPu);
this.ucPS1.f = pg;
}
private void LL()
{
string sOrder = " order by op_AddDate desc";
string sWhere = " where FK_User="******" from Ord_Pro op left join Pro_Info pi on FK_Pro=pi.ProSN";
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0) from Ord_Pro op" + sWhere;
pv.SQLRead = "select op_ID from Ord_Pro op" + sWhere + sOrder;
pv.SQL = "select FK_Pro,op_ProName,PicS,op_AddDate" + sFrom + " where op_ID in({0})" + sOrder;
Paging pg = new Paging(pv, new PagingUrlVar(12));
pg.load();
DataTable dt = pg.GetDataTable();
buyCout = dt.Rows.Count.ToString();
Bind.BGRepeater(dt, this.rpPro);
this.ucPS1.f = pg;
}
private void L1()
{
string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;
sqlSelect = "select prosn,proname ";
sqlFrom = " from cs..pro_info";
sqlWhere = "";
sqlOrder = " order by prosn desc";
pkName = "prosn";
PagingVar pv = new PagingVar();
//pv.PageCount = 100;
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(32));
pg.load();
dt = pg.GetDataTable();
}
private void LL()
{
int userID = LoginInfo.UserID;
string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;
sqlSelect = "select UserSN,UserName,UserAddDate";
sqlFrom = " from User_Info";
sqlWhere = " where UserBTJ=" + userID;
sqlOrder = " order by UserSN desc";
pkName = "UserSN";
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(10));
pg.load();
Bind.BGRepeater(pg.GetDataTable(), this.rpList);
this.ucPS1.f = pg;
}
private void LL()
{
string sqlSelect, sqlFrom, sqlWhere = string.Empty, sqlOrder, pkName;
sqlSelect = "select LetSN,FK_User_From,FK_User_To,Title,IsRead,AddDate,(select UserName from User_Info where UserSN=User_Letter.FK_User_From) as fromUserName";
sqlFrom = " from User_Letter";
sqlWhere = " where FK_User_To=" + LoginInfo.UserID;
sqlOrder = " order by AddDate desc";
pkName = "LetSN";
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(10));
pg.load();
Bind.BGRepeater(pg.GetDataTable(), this.rpList);
this.ucPS1.f = pg;
}
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});";
}
//private int oneLevelClassID = 0;
//产品列表
private void List()
{
string sqlSelect, sqlFrom, sqlWhere = string.Empty, sqlOrder, pkName;
if (t == 1)
{
sqlSelect = "select ProSN,ProName,PicS,Price,PriceMarket,Item,Number,UnitNum,StockN,Unit";
}
else
{
sqlSelect = "select ProSN,ProName,PicS,Price,PriceMarket,Item";
}
sqlFrom = " from vgPro_Info";
string aw = "";
if (keyword.Length > 0)
{
aw = sqlWhere.Length > 0 ? " and " : " where ";
sqlWhere += aw + "ProName like '%'+@ProName+'%'";
}
aw = sqlWhere.Length > 0 ? " and " : " where ";
switch (joinType)
{
case 0:
break;
case 1:
sqlWhere += aw + "JoinType=0";
this.curPath.Text += " （菜蓝子）";
break;
case 2:
sqlWhere += aw + "JoinType=1";
this.curPath.Text += " （商家）";
break;
}
switch (ord)
{
case 1:
sqlOrder = " order by Price asc";
break;
case 2:
sqlOrder = " order by Price desc";
break;
default:
sqlOrder = " order by EditDate desc";
break;
}
pkName = "ProSN";
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;
IDataParameter[] dp =
{
DbHelp.Def.AddParam("@ProName", keyword)
};
pv.DataParm = dp;
Paging pg = new Paging(pv, new PagingUrlVar(32, pageIndex));//页记录
pg.load();
if (t == 1)
{
stypeModel = "2";
this.showPic.Visible = false;
this.rpList.dt = pg.GetDataTable();
this.rpList.listEvent = ProLay.f_1;
}
else
{
this.showList.Visible = false;
this.rpPic.dt = pg.GetDataTable();
this.rpPic.listEvent = new CycleEvent(ProLay.d_list1);
}
this.ucPS1.f = pg;
this.ucPS1.cs = Request.Url.AbsolutePath + "?s=" + id + "-{0}-" + t + "-" + ord + "--" + keywordEncode;
}
//产品列表
private void List()
{
string sqlSelect, sqlFrom, sqlWhere = string.Empty, sqlOrder, pkName;
if (t == 1)
{
sqlSelect = "select ProSN,ProName,PicS,Item,Number,UnitNum,Unit";
}
else
{
sqlSelect = "select ProSN,ProName,PicS,Item";
}
sqlFrom = " from vgCaiPu_Info pi";
string aw = "";
if (keyword.Length > 0)
{
aw = sqlWhere.Length > 0 ? " and " : " where ";
sqlWhere += aw + "ProName like '%'+@ProName+'%'";
}
if (item > 0)
{
aw = sqlWhere.Length > 0 ? " and " : " where ";
sqlWhere += aw + "Item&" + item + ">0";
}
switch (ord)
{
case 1:
sqlOrder = " order by Hit asc";
break;
case 2:
sqlOrder = " order by Hit desc";
break;
default:
sqlOrder = " order by EditDate desc";
break;
}
pkName = "ProSN";
if (searchClassAttr.Length > 0)
{
aw = sqlWhere.Length > 0 ? " and " : " where ";
sqlWhere += aw + "EXISTS (select top 1 AttrSN from CaiPu_ClassAttrInfo where FK_Info=pi.ProSN and FK_Info_ClassAttr2 in(" + searchClassAttr + "))";
}
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;
IDataParameter[] dp =
{
DbHelp.Def.AddParam("@ProName", keyword)
};
pv.DataParm = dp;
Paging pg = new Paging(pv, new PagingUrlVar(32, pageIndex));//页记录
pg.load();
if (t == 1)
{
stypeModel = "2";
this.showPic.Visible = false;
this.rpList.dt = pg.GetDataTable();
this.rpList.listEvent = CaiPuLay.f_1;
}
else
{
this.showList.Visible = false;
this.rpPic.dt = pg.GetDataTable();
this.rpPic.listEvent = new CycleEvent(CaiPuLay.d_list2);
}
this.ucPS1.f = pg;
this.ucPS1.cs = Request.Url.AbsolutePath + "?s=" + id + "-{0}-" + t + "---" + keywordEncode;
}
