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