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