/// <summary> /// 根据条件分页获取指定数据 /// <param name="pageIndex">当前页</param> /// <para>索引从0开始</para> /// <param name="pageSize">每页记录条数</param> /// <para>记录数必须大于0</para> /// </summary> public PageEntity <ResPic> Search(Int32 PicId, String PicDescription, Int32 ObjId, Int32 ObjType, String PicUrl, Int32 PicHeight, Int32 PicWidth, Int32 State, int pageIndex, int pageSize) { PageEntity <ResPic> returnValue = new PageEntity <ResPic>(); MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdLoadResPic = cmdLoadResPic.Clone() as MySqlCommand; MySqlCommand _cmdGetResPicCount = cmdGetResPicCount.Clone() as MySqlCommand; _cmdLoadResPic.Connection = oc; _cmdGetResPicCount.Connection = oc; try { _cmdLoadResPic.Parameters["@PageIndex"].Value = pageIndex * pageSize;; _cmdLoadResPic.Parameters["@PageSize"].Value = (pageIndex + 1) * pageSize;; _cmdLoadResPic.Parameters["@PicId"].Value = PicId; _cmdLoadResPic.Parameters["@PicDescription"].Value = PicDescription; _cmdLoadResPic.Parameters["@ObjId"].Value = ObjId; _cmdLoadResPic.Parameters["@ObjType"].Value = ObjType; _cmdLoadResPic.Parameters["@PicUrl"].Value = PicUrl; _cmdLoadResPic.Parameters["@PicHeight"].Value = PicHeight; _cmdLoadResPic.Parameters["@PicWidth"].Value = PicWidth; _cmdLoadResPic.Parameters["@State"].Value = State; if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdLoadResPic.ExecuteReader(); while (reader.Read()) { returnValue.Items.Add(new ResPic().BuildSampleEntity(reader)); } reader.Close(); returnValue.PageIndex = pageIndex; returnValue.PageSize = pageSize; returnValue.RecordsCount = Convert.ToInt32(_cmdGetResPicCount.ExecuteScalar()); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdLoadResPic.Dispose(); _cmdLoadResPic = null; _cmdGetResPicCount.Dispose(); _cmdGetResPicCount = null; GC.Collect(); } return(returnValue); }
/// <summary> /// 根据条件分页获取指定数据 /// <param name="pageIndex">当前页</param> /// <para>索引从0开始</para> /// <param name="pageSize">每页记录条数</param> /// <para>记录数必须大于0</para> /// </summary> public PageEntity <GenVote> Search(Int32 Vid, String Vtitle, String VDes, Int32 ObjId, Int32 ObjType, Int32 UpNum, Int32 DownNum, DateTime CreateTime, Int32 CreateId, Int32 State, int pageIndex, int pageSize) { PageEntity <GenVote> returnValue = new PageEntity <GenVote>(); MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdLoadGenVote = cmdLoadGenVote.Clone() as MySqlCommand; MySqlCommand _cmdGetGenVoteCount = cmdGetGenVoteCount.Clone() as MySqlCommand; _cmdLoadGenVote.Connection = oc; _cmdGetGenVoteCount.Connection = oc; try { _cmdLoadGenVote.Parameters["@PageIndex"].Value = pageIndex * pageSize; _cmdLoadGenVote.Parameters["@PageSize"].Value = (pageIndex + 1) * pageSize; _cmdLoadGenVote.Parameters["@Vid"].Value = Vid; _cmdLoadGenVote.Parameters["@Vtitle"].Value = Vtitle; _cmdLoadGenVote.Parameters["@VDes"].Value = VDes; _cmdLoadGenVote.Parameters["@ObjId"].Value = ObjId; _cmdLoadGenVote.Parameters["@ObjType"].Value = ObjType; _cmdLoadGenVote.Parameters["@UpNum"].Value = UpNum; _cmdLoadGenVote.Parameters["@DownNum"].Value = DownNum; _cmdLoadGenVote.Parameters["@CreateTime"].Value = CreateTime; _cmdLoadGenVote.Parameters["@CreateId"].Value = CreateId; _cmdLoadGenVote.Parameters["@State"].Value = State; if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdLoadGenVote.ExecuteReader(); while (reader.Read()) { returnValue.Items.Add(new GenVote().BuildSampleEntity(reader)); } returnValue.RecordsCount = Convert.ToInt32(_cmdGetGenVoteCount.ExecuteScalar()); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdLoadGenVote.Dispose(); _cmdLoadGenVote = null; _cmdGetGenVoteCount.Dispose(); _cmdGetGenVoteCount = null; GC.Collect(); } return(returnValue); }
/// <summary> /// 根据条件分页获取指定数据 /// <param name="pageIndex">当前页</param> /// <para>索引从0开始</para> /// <param name="pageSize">每页记录条数</param> /// <para>记录数必须大于0</para> /// </summary> public PageEntity <SocialUser> Search(Int32 SocialUserType, String AccessToken, String AccessTokenSecret, String Uid, Int32 UserId, Int32 SocialUserId, int pageIndex, int pageSize) { PageEntity <SocialUser> returnValue = new PageEntity <SocialUser>(); MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdLoadSocialUser = cmdLoadSocialUser.Clone() as MySqlCommand; MySqlCommand _cmdGetSocialUserCount = cmdGetSocialUserCount.Clone() as MySqlCommand; _cmdLoadSocialUser.Connection = oc; _cmdGetSocialUserCount.Connection = oc; try { _cmdLoadSocialUser.Parameters["@PageIndex"].Value = pageIndex * pageSize;; _cmdLoadSocialUser.Parameters["@PageSize"].Value = (pageIndex + 1) * pageSize;; _cmdLoadSocialUser.Parameters["@SocialUserType"].Value = SocialUserType; _cmdLoadSocialUser.Parameters["@AccessToken"].Value = AccessToken; _cmdLoadSocialUser.Parameters["@AccessTokenSecret"].Value = AccessTokenSecret; _cmdLoadSocialUser.Parameters["@Uid"].Value = Uid; _cmdLoadSocialUser.Parameters["@UserId"].Value = UserId; _cmdLoadSocialUser.Parameters["@SocialUserId"].Value = SocialUserId; if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdLoadSocialUser.ExecuteReader(); while (reader.Read()) { returnValue.Items.Add(new SocialUser().BuildSampleEntity(reader)); } returnValue.RecordsCount = Convert.ToInt32(_cmdGetSocialUserCount.ExecuteScalar()); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdLoadSocialUser.Dispose(); _cmdLoadSocialUser = null; _cmdGetSocialUserCount.Dispose(); _cmdGetSocialUserCount = null; GC.Collect(); } return(returnValue); }
/// <summary> /// 添加数据 /// <param name="es">数据实体对象数组</param> /// <returns></returns> /// </summary> public int Insert(ProProduct e) { MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdInsertProProduct = cmdInsertProProduct.Clone() as MySqlCommand; int returnValue = 0; _cmdInsertProProduct.Connection = oc; try { if (oc.State == ConnectionState.Closed) { oc.Open(); } _cmdInsertProProduct.Parameters["@Pid"].Value = e.Pid; _cmdInsertProProduct.Parameters["@Title"].Value = e.Title; _cmdInsertProProduct.Parameters["@BbInfo"].Value = e.BbInfo; _cmdInsertProProduct.Parameters["@State"].Value = e.State == 0 ? 1 : e.State; _cmdInsertProProduct.Parameters["@Level"].Value = e.Level; _cmdInsertProProduct.Parameters["@CreateTime"].Value = e.CreateTime; _cmdInsertProProduct.Parameters["@CreateId"].Value = e.CreateId; _cmdInsertProProduct.Parameters["@ViewNum"].Value = e.ViewNum; _cmdInsertProProduct.Parameters["@IsWash"].Value = e.IsWash ? 1 : 2; _cmdInsertProProduct.Parameters["@MinAge"].Value = e.MinAge; _cmdInsertProProduct.Parameters["@MaxAge"].Value = e.MaxAge; _cmdInsertProProduct.Parameters["@Price"].Value = e.Price; _cmdInsertProProduct.Parameters["@ItemType"].Value = (int)e.ItemType; _cmdInsertProProduct.Parameters["@ItemSort"].Value = (int)e.ItemSort; _cmdInsertProProduct.Parameters["@Sex"].Value = (int)e.Sex; _cmdInsertProProduct.ExecuteNonQuery(); returnValue = Convert.ToInt32(_cmdInsertProProduct.LastInsertedId); return(returnValue); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdInsertProProduct.Dispose(); _cmdInsertProProduct = null; } }
/// <summary> /// 根据条件分页获取指定数据 /// <param name="pageIndex">当前页</param> /// <para>索引从0开始</para> /// <param name="pageSize">每页记录条数</param> /// <para>记录数必须大于0</para> /// </summary> public PageEntity <GenVoteUser> Search(Int32 Vid, Int32 UserId, String CreateTime, String VIp, Int32 Id, int pageIndex, int pageSize) { PageEntity <GenVoteUser> returnValue = new PageEntity <GenVoteUser>(); MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdLoadGenVoteUser = cmdLoadGenVoteUser.Clone() as MySqlCommand; MySqlCommand _cmdGetGenVoteUserCount = cmdGetGenVoteUserCount.Clone() as MySqlCommand; _cmdLoadGenVoteUser.Connection = oc; _cmdGetGenVoteUserCount.Connection = oc; try { _cmdLoadGenVoteUser.Parameters["@PageIndex"].Value = pageIndex; _cmdLoadGenVoteUser.Parameters["@PageSize"].Value = pageSize; _cmdLoadGenVoteUser.Parameters["@Vid"].Value = Vid; _cmdLoadGenVoteUser.Parameters["@UserId"].Value = UserId; _cmdLoadGenVoteUser.Parameters["@CreateTime"].Value = CreateTime; _cmdLoadGenVoteUser.Parameters["@VIp"].Value = VIp; _cmdLoadGenVoteUser.Parameters["@Id"].Value = Id; if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdLoadGenVoteUser.ExecuteReader(); while (reader.Read()) { returnValue.Items.Add(new GenVoteUser().BuildSampleEntity(reader)); } returnValue.RecordsCount = Convert.ToInt32(_cmdGetGenVoteUserCount.ExecuteScalar()); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdLoadGenVoteUser.Dispose(); _cmdLoadGenVoteUser = null; _cmdGetGenVoteUserCount.Dispose(); _cmdGetGenVoteUserCount = null; GC.Collect(); } return(returnValue); }
/// <summary> /// 根据条件分页获取指定数据 /// <param name="pageIndex">当前页</param> /// <para>索引从0开始</para> /// <param name="pageSize">每页记录条数</param> /// <para>记录数必须大于0</para> /// </summary> public PageEntity <GenBless> Search(Int32 Bid, String Content, DateTime CreateTime, Int32 CreateId, int pageIndex, int pageSize) { PageEntity <GenBless> returnValue = new PageEntity <GenBless>(); MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdLoadGenBless = cmdLoadGenBless.Clone() as MySqlCommand; MySqlCommand _cmdGetGenBlessCount = cmdGetGenBlessCount.Clone() as MySqlCommand; _cmdLoadGenBless.Connection = oc; _cmdGetGenBlessCount.Connection = oc; try { _cmdLoadGenBless.Parameters["@PageIndex"].Value = pageIndex; _cmdLoadGenBless.Parameters["@PageSize"].Value = pageSize; _cmdLoadGenBless.Parameters["@Bid"].Value = Bid; _cmdLoadGenBless.Parameters["@Content"].Value = Content; _cmdLoadGenBless.Parameters["@CreateTime"].Value = CreateTime; _cmdLoadGenBless.Parameters["@CreateId"].Value = CreateId; if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdLoadGenBless.ExecuteReader(); while (reader.Read()) { returnValue.Items.Add(new GenBless().BuildSampleEntity(reader)); } returnValue.RecordsCount = Convert.ToInt32(_cmdGetGenBlessCount.ExecuteScalar()); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdLoadGenBless.Dispose(); _cmdLoadGenBless = null; _cmdGetGenBlessCount.Dispose(); _cmdGetGenBlessCount = null; GC.Collect(); } return(returnValue); }
/// <summary> /// 根据条件分页获取指定数据 /// <param name="pageIndex">当前页</param> /// <para>索引从0开始</para> /// <param name="pageSize">每页记录条数</param> /// <para>记录数必须大于0</para> /// </summary> public PageEntity <AdUser> Search(String UserAccount, DateTime BabyBirthday, int State, int pageIndex, int pageSize) { PageEntity <AdUser> returnValue = new PageEntity <AdUser>(); MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdLoadAdUser = cmdLoadAdUser.Clone() as MySqlCommand; MySqlCommand _cmdGetAdUserCount = cmdGetAdUserCount.Clone() as MySqlCommand; _cmdLoadAdUser.Connection = oc; _cmdGetAdUserCount.Connection = oc; try { _cmdLoadAdUser.Parameters["@PageIndex"].Value = pageIndex * pageSize;; _cmdLoadAdUser.Parameters["@PageSize"].Value = (pageIndex + 1) * pageSize;; _cmdLoadAdUser.Parameters["@UserAccount"].Value = UserAccount; _cmdLoadAdUser.Parameters["@BabyBirthday"].Value = BabyBirthday; _cmdLoadAdUser.Parameters["@State"].Value = State; if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdLoadAdUser.ExecuteReader(); while (reader.Read()) { returnValue.Items.Add(new AdUser().BuildSampleEntity(reader)); } returnValue.RecordsCount = Convert.ToInt32(_cmdGetAdUserCount.ExecuteScalar()); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdLoadAdUser.Dispose(); _cmdLoadAdUser = null; _cmdGetAdUserCount.Dispose(); _cmdGetAdUserCount = null; GC.Collect(); } return(returnValue); }
/// <summary> /// 获取指定记录 /// <param name="id">Id值</param> /// </summary> public ProProduct Get(int bbPostID) { ProProduct returnValue = null; MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdGetProProduct = cmdGetProProduct.Clone() as MySqlCommand; _cmdGetProProduct.Connection = oc; try { _cmdGetProProduct.Parameters["@Pid"].Value = bbPostID; if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdGetProProduct.ExecuteReader(); if (reader.HasRows) { reader.Read(); returnValue = new ProProduct().BuildSampleEntity(reader); } List <ResPic> returnValue_item = new List <ResPic>(); returnValue_item = ResPicAccessor.Instance.Search(bbPostID, PicType.BBPicture); returnValue.pics = returnValue_item; } finally { oc.Close(); oc.Dispose(); oc = null; _cmdGetProProduct.Dispose(); _cmdGetProProduct = null; GC.Collect(); } return(returnValue); }
/// <summary> /// 获取指定记录 /// <param name="id">Id值</param> /// </summary> public ProBook Get(int BookId, StateType state) { ProBook returnValue = null; MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdGetProBook = cmdGetProBook.Clone() as MySqlCommand; _cmdGetProBook.Connection = oc; try { _cmdGetProBook.Parameters["@BookId"].Value = BookId; _cmdGetProBook.Parameters["@State"].Value = (int)state; if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdGetProBook.ExecuteReader(); if (reader.HasRows) { reader.Read(); returnValue = new ProBook().BuildSampleEntity(reader); } List <ResPic> returnValue_item = new List <ResPic>(); returnValue_item = ResPicAccessor.Instance.Search(BookId, PicType.Book); returnValue.Pics = returnValue_item; } finally { oc.Close(); oc.Dispose(); oc = null; _cmdGetProBook.Dispose(); _cmdGetProBook = null; GC.Collect(); } return(returnValue); }
/// <summary> /// 获取全部数据 /// </summary> public List <ProProduct> Search() { MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdLoadAllProProduct = cmdLoadAllProProduct.Clone() as MySqlCommand; _cmdLoadAllProProduct.Connection = oc; List <ProProduct> returnValue = new List <ProProduct>(); try { _cmdLoadAllProProduct.CommandText = string.Format(_cmdLoadAllProProduct.CommandText, string.Empty); if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdLoadAllProProduct.ExecuteReader(); while (reader.Read()) { returnValue.Add(new ProProduct().BuildSampleEntity(reader)); } for (int i = 0; i < returnValue.Count; i++) { List <ResPic> returnValue_item = new List <ResPic>(); returnValue_item = ResPicAccessor.Instance.Search(returnValue[i].Pid, PicType.BBPicture); returnValue[i].pics = returnValue_item; } } finally { oc.Close(); oc.Dispose(); oc = null; _cmdLoadAllProProduct.Dispose(); _cmdLoadAllProProduct = null; GC.Collect(); } return(returnValue); }
/// <summary> /// 获取指定记录 /// <param name="id">Id值</param> /// </summary> public AdUser Get(int AdUserId, string UserAccount, string Pwd, StateType State) { AdUser returnValue = null; MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdGetAdUser = cmdGetAdUser.Clone() as MySqlCommand; _cmdGetAdUser.Connection = oc; try { _cmdGetAdUser.Parameters["@AdUserId"].Value = AdUserId; _cmdGetAdUser.Parameters["@UserAccount"].Value = UserAccount; _cmdGetAdUser.Parameters["@Pwd"].Value = Pwd; _cmdGetAdUser.Parameters["@State"].Value = (int)State; if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdGetAdUser.ExecuteReader(); if (reader.HasRows) { reader.Read(); returnValue = new AdUser().BuildSampleEntity(reader); } } finally { oc.Close(); oc.Dispose(); oc = null; _cmdGetAdUser.Dispose(); _cmdGetAdUser = null; GC.Collect(); } return(returnValue); }
/// <summary> /// 修改指定的数据 /// <param name="e">修改后的数据实体对象</param> /// <para>数据对应的主键必须在实例中设置</para> /// </summary> public void Update(GenVote e) { MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdUpdateGenVote = cmdUpdateGenVote.Clone() as MySqlCommand; _cmdUpdateGenVote.Connection = oc; try { if (oc.State == ConnectionState.Closed) { oc.Open(); } _cmdUpdateGenVote.Parameters["@Vid"].Value = e.Vid; _cmdUpdateGenVote.Parameters["@Vtitle"].Value = e.Vtitle; _cmdUpdateGenVote.Parameters["@VDes"].Value = e.VDes; _cmdUpdateGenVote.Parameters["@ObjId"].Value = e.ObjId; _cmdUpdateGenVote.Parameters["@ObjType"].Value = e.ObjType; _cmdUpdateGenVote.Parameters["@UpNum"].Value = e.UpNum; _cmdUpdateGenVote.Parameters["@DownNum"].Value = e.DownNum; _cmdUpdateGenVote.Parameters["@CreateTime"].Value = e.CreateTime; _cmdUpdateGenVote.Parameters["@CreateId"].Value = e.CreateId; _cmdUpdateGenVote.Parameters["@State"].Value = e.State; _cmdUpdateGenVote.ExecuteNonQuery(); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdUpdateGenVote.Dispose(); _cmdUpdateGenVote = null; GC.Collect(); } }
/// <summary> /// 添加数据 /// <param name="es">数据实体对象数组</param> /// <returns></returns> /// </summary> public int Insert(ProBook e) { MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdInsertProBook = cmdInsertProBook.Clone() as MySqlCommand; int returnValue = 0; _cmdInsertProBook.Connection = oc; try { if (oc.State == ConnectionState.Closed) { oc.Open(); } DateTime time = DateTime.Now; _cmdInsertProBook.Parameters["@BookName"].Value = e.BookName; _cmdInsertProBook.Parameters["@BookSize"].Value = (int)e.BookSize; _cmdInsertProBook.Parameters["@BookType"].Value = e.BookType; _cmdInsertProBook.Parameters["@AdUserId"].Value = e.AdUserId; _cmdInsertProBook.Parameters["@EditeTime"].Value = time; _cmdInsertProBook.Parameters["@CreateTime"].Value = time; _cmdInsertProBook.Parameters["@Introduction"].Value = e.Introduction; _cmdInsertProBook.Parameters["@BookCover"].Value = (int)e.BookCover; _cmdInsertProBook.ExecuteNonQuery(); returnValue = Convert.ToInt32(_cmdInsertProBook.LastInsertedId); return(returnValue); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdInsertProBook.Dispose(); _cmdInsertProBook = null; } }
/// <summary> /// 获取指定记录 /// <param name="id">Id值</param> /// </summary> public SocialUser Get(string uid, SocialUserTypeEnum sutype) { SocialUser returnValue = null; MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdGetSocialUser = cmdGetSocialUser.Clone() as MySqlCommand; _cmdGetSocialUser.Connection = oc; try { _cmdGetSocialUser.Parameters["@uid"].Value = uid; _cmdGetSocialUser.Parameters["@sutype"].Value = sutype; _cmdGetSocialUser.Parameters["@user_id"].Value = 0; if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdGetSocialUser.ExecuteReader(); if (reader.HasRows) { reader.Read(); returnValue = new SocialUser().BuildSampleEntity(reader); } } finally { oc.Close(); oc.Dispose(); oc = null; _cmdGetSocialUser.Dispose(); _cmdGetSocialUser = null; GC.Collect(); } return(returnValue); }
/// <summary> /// 根据年龄,宝贝类型(小类),宝贝分类(大类),性别查询宝贝列表 /// <param name="pageIndex">当前页</param> /// <para>索引从0开始</para> /// <param name="pageSize">每页记录条数</param> /// <para>记录数必须大于0</para> /// </summary> public PageEntity <ProProduct> Search(Int32 MaxAge, ItemType bbType, ItemSort bbSort, PriceRange bbRange, SexType sex, int pageIndex, int pageSize) { PageEntity <ProProduct> returnValue = new PageEntity <ProProduct>(); List <ProProduct> bblist = new List <ProProduct>(); MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdLoadBB = cmdLoadBB.Clone() as MySqlCommand; MySqlCommand _cmdGetBBCount = cmdGetBBCount.Clone() as MySqlCommand; _cmdLoadBB.Connection = oc; _cmdGetBBCount.Connection = oc; try { _cmdLoadBB.Parameters["@PageIndex"].Value = pageIndex * pageSize; _cmdLoadBB.Parameters["@PageSize"].Value = (pageIndex + 1) * pageSize; _cmdLoadBB.Parameters["@bbType"].Value = (int)bbType; _cmdLoadBB.Parameters["@bbSort"].Value = (int)bbSort; _cmdLoadBB.Parameters["@Sex"].Value = (int)sex; string PriceRangeSql = string.Empty; switch (bbRange) { case PriceRange.Ignore: PriceRangeSql = " "; break; case PriceRange.TenZone: PriceRangeSql = "and price>=0 and price<=10 "; break; case PriceRange.HundredZone: PriceRangeSql = "and price>=10 and price<=100"; break; default: break; } if (MaxAge > 0) { _cmdLoadBB.CommandText = string.Format(_cmdLoadBB.CommandText, " and " + MaxAge + " >= min_age and " + MaxAge + "<= max_age ", PriceRangeSql); } else { _cmdLoadBB.CommandText = string.Format(_cmdLoadBB.CommandText, " ", PriceRangeSql); } _cmdGetBBCount.Parameters["@bbType"].Value = (int)bbType; _cmdGetBBCount.Parameters["@bbSort"].Value = (int)bbSort; _cmdGetBBCount.Parameters["@Sex"].Value = (int)sex; if (MaxAge > 0) { _cmdGetBBCount.CommandText = string.Format(_cmdGetBBCount.CommandText, " and " + MaxAge + " >= min_age and " + MaxAge + "<= max_age ", PriceRangeSql); } else { _cmdGetBBCount.CommandText = string.Format(_cmdGetBBCount.CommandText, " ", PriceRangeSql); } if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdLoadBB.ExecuteReader(); while (reader.Read()) { bblist.Add(new ProProduct().BuildSampleEntity(reader)); } reader.Close(); for (int i = 0; i < bblist.Count; i++) { List <ResPic> returnValue_item = new List <ResPic>(); returnValue_item = ResPicAccessor.Instance.Search(bblist[i].Pid, PicType.BBPicture); bblist[i].pics = returnValue_item; } returnValue.Items = bblist; returnValue.PageIndex = pageIndex; returnValue.PageSize = pageSize; returnValue.RecordsCount = Convert.ToInt32(_cmdGetBBCount.ExecuteScalar()); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdLoadBB.Dispose(); _cmdLoadBB = null; _cmdGetBBCount.Dispose(); _cmdGetBBCount = null; GC.Collect(); } return(returnValue); }
/// <summary> /// 查询属于用户的宝贝列表 /// <param name="pageIndex">当前页</param> /// <para>索引从0开始</para> /// <param name="pageSize">每页记录条数</param> /// <para>记录数必须大于0</para> /// </summary> public PageEntity <ProProduct> Search(StateType State, LevelType Level, Int32 CreateId, int pageIndex, int pageSize) { PageEntity <ProProduct> returnValue = new PageEntity <ProProduct>(); List <ProProduct> prolist = new List <ProProduct>(); MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdLoadProProduct = cmdLoadProProduct.Clone() as MySqlCommand; MySqlCommand _cmdGetProProductCountByUserId = cmdGetProProductCountByUserId.Clone() as MySqlCommand; // MySqlCommand _cmdLoadAllProProductItem = cmdLoadAllProProductItem.Clone() as MySqlCommand; // _cmdLoadAllProProductItem.Connection = oc; _cmdLoadProProduct.Connection = oc; _cmdGetProProductCountByUserId.Connection = oc; try { _cmdLoadProProduct.Parameters["@PageIndex"].Value = pageIndex * pageSize; _cmdLoadProProduct.Parameters["@PageSize"].Value = (pageIndex + 1) * pageSize; _cmdLoadProProduct.Parameters["@State"].Value = (int)State; _cmdLoadProProduct.Parameters["@Level"].Value = (int)Level; _cmdLoadProProduct.Parameters["@CreateId"].Value = CreateId; _cmdGetProProductCountByUserId.Parameters["@State"].Value = (int)State; _cmdGetProProductCountByUserId.Parameters["@Level"].Value = (int)Level; _cmdGetProProductCountByUserId.Parameters["@CreateId"].Value = CreateId; if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdLoadProProduct.ExecuteReader(); while (reader.Read()) { prolist.Add(new ProProduct().BuildSampleEntity(reader)); } reader.Close(); if (oc.State == ConnectionState.Closed) { oc.Open(); } for (int i = 0; i < prolist.Count; i++) { List <ResPic> returnValue_item = new List <ResPic>(); returnValue_item = ResPicAccessor.Instance.Search(prolist[i].Pid, PicType.BBPicture); prolist[i].pics = returnValue_item; } returnValue.Items = prolist; if (oc.State == ConnectionState.Closed) { oc.Open(); } returnValue.PageIndex = pageIndex; returnValue.PageSize = pageSize; returnValue.RecordsCount = Convert.ToInt32(_cmdGetProProductCountByUserId.ExecuteScalar()); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdLoadProProduct.Dispose(); _cmdLoadProProduct = null; _cmdGetProProductCountByUserId.Dispose(); _cmdGetProProductCountByUserId = null; GC.Collect(); } return(returnValue); }
protected MySqlConnection Create() { return(ConnectManager.Create()); }
/// <summary> /// 根据条件分页获取指定数据 /// <param name="pageIndex">当前页</param> /// <para>索引从0开始</para> /// <param name="pageSize">每页记录条数</param> /// <para>记录数必须大于0</para> /// </summary> public PageEntity <ProBook> Search(Int32 AdUserId, StateType state, int pageIndex, int pageSize) { PageEntity <ProBook> returnValue = new PageEntity <ProBook>(); List <ProBook> booklist = new List <ProBook>(); MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdLoadProBook = cmdLoadProBook.Clone() as MySqlCommand; MySqlCommand _cmdGetProBookCount = cmdGetProBookCount.Clone() as MySqlCommand; _cmdLoadProBook.Connection = oc; _cmdGetProBookCount.Connection = oc; try { _cmdLoadProBook.Parameters["@PageIndex"].Value = pageIndex; _cmdLoadProBook.Parameters["@PageSize"].Value = pageSize; _cmdLoadProBook.Parameters["@AdUserId"].Value = AdUserId; _cmdLoadProBook.Parameters["@State"].Value = (int)state; if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdLoadProBook.ExecuteReader(); while (reader.Read()) { ProBook book = new ProBook(); book = book.BuildSampleEntity(reader); booklist.Add(book); } _cmdGetProBookCount.Parameters["@AdUserId"].Value = AdUserId; _cmdGetProBookCount.Parameters["@State"].Value = (int)state; reader.Close(); for (int i = 0; i < booklist.Count; i++) { List <ResPic> returnValue_item = new List <ResPic>(); returnValue_item = ResPicAccessor.Instance.Search(booklist[i].BookId, PicType.Book); booklist[i].Pics = returnValue_item; } returnValue.Items = booklist; returnValue.PageIndex = pageIndex; returnValue.PageSize = pageSize; returnValue.RecordsCount = Convert.ToInt32(_cmdGetProBookCount.ExecuteScalar()); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdLoadProBook.Dispose(); _cmdLoadProBook = null; _cmdGetProBookCount.Dispose(); _cmdGetProBookCount = null; GC.Collect(); } return(returnValue); }