/// <summary>
/// 获取关于用户自己的回复数
/// <param name="refUserId">用户ID</param>
/// </summary>
public int GetBBReplyCount(Int32 ObjId, ReplyType ObjType, Int32 CreateId, StateType State, Int32 RefUserId, Int32 RefReplyId)
{
int returnValue = 0;
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdGetGenReplyCount = cmdGetGenReplyCount.Clone() as MySqlCommand;
_cmdGetGenReplyCount.Connection = oc;
try
{
_cmdGetGenReplyCount.Parameters["@ObjId"].Value = DBConvert.ToDBValue(ObjId);
_cmdGetGenReplyCount.Parameters["@ObjType"].Value = DBConvert.ToDBValue((int)ObjType);
_cmdGetGenReplyCount.Parameters["@CreateId"].Value = DBConvert.ToDBValue(CreateId);
_cmdGetGenReplyCount.Parameters["@State"].Value = DBConvert.ToDBValue((int)State);
_cmdGetGenReplyCount.Parameters["@RefUserId"].Value = DBConvert.ToDBValue(RefUserId);
_cmdGetGenReplyCount.Parameters["@RefReplyId"].Value = DBConvert.ToDBValue(RefReplyId);
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
returnValue = Convert.ToInt32(_cmdGetGenReplyCount.ExecuteScalar());
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdGetGenReplyCount.Dispose();
_cmdGetGenReplyCount = null;
GC.Collect();
}
return(returnValue);
}
/// <summary>
/// 获取获取用户发布帖子数
/// <param name="userid"></param>
/// </summary>
public int GetProductCountByUserId(int userid)
{
int returnValue = 0;
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdGetProProductCount = cmdGetProProductCountByUserId.Clone() as MySqlCommand;
_cmdGetProProductCount.Connection = oc;
try
{
_cmdGetProProductCount.Parameters["@CreateId"].Value = userid;
_cmdGetProProductCount.Parameters["@State"].Value = 1;
_cmdGetProProductCount.Parameters["@Level"].Value = 1;
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
returnValue = Convert.ToInt32(_cmdGetProProductCount.ExecuteScalar());
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdGetProProductCount.Dispose();
_cmdGetProProductCount = null;
GC.Collect();
}
return(returnValue);
}
/// <summary>
/// 修改指定的数据
/// <param name="e">修改后的数据实体对象</param>
/// <para>数据对应的主键必须在实例中设置</para>
/// </summary>
public void Update(GenBless e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdUpdateGenBless = cmdUpdateGenBless.Clone() as MySqlCommand;
_cmdUpdateGenBless.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdUpdateGenBless.Parameters["@Bid"].Value = e.Bid;
_cmdUpdateGenBless.Parameters["@Content"].Value = e.Content;
_cmdUpdateGenBless.Parameters["@CreateTime"].Value = e.CreateTime;
_cmdUpdateGenBless.Parameters["@CreateId"].Value = e.CreateId;
_cmdUpdateGenBless.ExecuteNonQuery();
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdUpdateGenBless.Dispose();
_cmdUpdateGenBless = null;
GC.Collect();
}
}
/// <summary>
/// 添加数据
/// <param name="es">数据实体对象数组</param>
/// <returns></returns>
/// </summary>
public int Insert(AdUser e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdInsertAdUser = cmdInsertAdUser.Clone() as MySqlCommand;
int returnValue = 0;
_cmdInsertAdUser.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdInsertAdUser.Parameters["@UserAccount"].Value = e.UserAccount;
_cmdInsertAdUser.Parameters["@Pwd"].Value = e.Pwd;
_cmdInsertAdUser.Parameters["@BabyBirthday"].Value = e.BabyBirthday;
_cmdInsertAdUser.Parameters["@Sex"].Value = e.Sex;
_cmdInsertAdUser.Parameters["@Qq"].Value = e.Qq;
_cmdInsertAdUser.Parameters["@Mobile"].Value = e.Mobile;
_cmdInsertAdUser.ExecuteNonQuery();
returnValue = Convert.ToInt32(_cmdInsertAdUser.LastInsertedId);
return(returnValue);
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdInsertAdUser.Dispose();
_cmdInsertAdUser = null;
}
}
/// <summary>
/// 添加数据
/// <param name="es">数据实体对象数组</param>
/// <returns></returns>
/// </summary>
public bool Insert(GenVoteType e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdInsertGenVoteType = cmdInsertGenVoteType.Clone() as MySqlCommand;
bool returnValue = false;
_cmdInsertGenVoteType.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdInsertGenVoteType.Parameters["@VtId"].Value = e.VtId;
_cmdInsertGenVoteType.Parameters["@VtTitle"].Value = e.VtTitle;
_cmdInsertGenVoteType.Parameters["@VtDescription"].Value = e.VtDescription;
_cmdInsertGenVoteType.Parameters["@TotalVoteNum"].Value = e.TotalVoteNum;
_cmdInsertGenVoteType.Parameters["@ImgUrl"].Value = e.ImgUrl;
_cmdInsertGenVoteType.Parameters["@CreateTime"].Value = e.CreateTime;
_cmdInsertGenVoteType.Parameters["@CreateId"].Value = e.CreateId;
_cmdInsertGenVoteType.Parameters["@State"].Value = e.State;
_cmdInsertGenVoteType.ExecuteNonQuery();
return(returnValue);
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdInsertGenVoteType.Dispose();
_cmdInsertGenVoteType = null;
}
}
/// <summary>
/// 修改指定的数据
/// <param name="e">修改后的数据实体对象</param>
/// <para>数据对应的主键必须在实例中设置</para>
/// </summary>
public void Update(SocialUser e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdUpdateSocialUser = cmdUpdateSocialUser.Clone() as MySqlCommand;
_cmdUpdateSocialUser.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdUpdateSocialUser.Parameters["@SocialUserType"].Value = e.SocialUserType;
_cmdUpdateSocialUser.Parameters["@AccessToken"].Value = e.AccessToken;
_cmdUpdateSocialUser.Parameters["@AccessTokenSecret"].Value = e.AccessTokenSecret;
_cmdUpdateSocialUser.Parameters["@Uid"].Value = e.Uid;
_cmdUpdateSocialUser.Parameters["@UserId"].Value = e.UserId;
_cmdUpdateSocialUser.ExecuteNonQuery();
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdUpdateSocialUser.Dispose();
_cmdUpdateSocialUser = null;
GC.Collect();
}
}
/// <summary>
/// 添加数据
/// <param name="es">数据实体对象数组</param>
/// <returns></returns>
/// </summary>
public bool Insert(GenVoteUser e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdInsertGenVoteUser = cmdInsertGenVoteUser.Clone() as MySqlCommand;
bool returnValue = false;
_cmdInsertGenVoteUser.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdInsertGenVoteUser.Parameters["@Vid"].Value = e.Vid;
_cmdInsertGenVoteUser.Parameters["@UserId"].Value = e.UserId;
_cmdInsertGenVoteUser.Parameters["@CreateTime"].Value = e.CreateTime;
_cmdInsertGenVoteUser.Parameters["@VIp"].Value = e.VIp;
_cmdInsertGenVoteUser.Parameters["@Id"].Value = e.Id;
_cmdInsertGenVoteUser.ExecuteNonQuery();
return(returnValue);
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdInsertGenVoteUser.Dispose();
_cmdInsertGenVoteUser = null;
}
}
/// <summary>
/// 获取指定记录
/// <param name="id">Id值</param>
/// </summary>
public GenVote Get(int Vid)
{
GenVote returnValue = null;
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdGetGenVote = cmdGetGenVote.Clone() as MySqlCommand;
_cmdGetGenVote.Connection = oc;
try
{
_cmdGetGenVote.Parameters["@Vid"].Value = Vid;
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
MySqlDataReader reader = _cmdGetGenVote.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
returnValue = new GenVote().BuildSampleEntity(reader);
}
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdGetGenVote.Dispose();
_cmdGetGenVote = null;
GC.Collect();
}
return(returnValue);
}
/// <summary>
/// 删除数据
/// <param name="es">数据实体对象数组</param>
/// <returns></returns>
/// </summary>
public bool Delete(GenReply e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdDeleteGenReply = cmdDeleteGenReply.Clone() as MySqlCommand;
bool returnValue = false;
_cmdDeleteGenReply.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdDeleteGenReply.Parameters["@Rid"].Value = e.Rid;
_cmdDeleteGenReply.ExecuteNonQuery();
return(returnValue);
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdDeleteGenReply.Dispose();
_cmdDeleteGenReply = null;
}
}
/// <summary>
/// 添加数据
/// <param name="es">数据实体对象数组</param>
/// <returns></returns>
/// </summary>
public bool Insert(GenReply e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdInsertGenReply = cmdInsertGenReply.Clone() as MySqlCommand;
bool returnValue = false;
_cmdInsertGenReply.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdInsertGenReply.Parameters["@ObjId"].Value = e.ObjId;
_cmdInsertGenReply.Parameters["@ObjType"].Value = e.ObjType;
_cmdInsertGenReply.Parameters["@Content"].Value = e.Content;
_cmdInsertGenReply.Parameters["@CreateId"].Value = e.CreateId;
_cmdInsertGenReply.Parameters["@RefUserId"].Value = e.RefUserId;
_cmdInsertGenReply.Parameters["@RefReplyId"].Value = e.RefReplyId;
_cmdInsertGenReply.ExecuteNonQuery();
return(returnValue);
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdInsertGenReply.Dispose();
_cmdInsertGenReply = null;
}
}
/// <summary>
/// 修改指定的数据
/// <param name="e">修改后的数据实体对象</param>
/// <para>数据对应的主键必须在实例中设置</para>
/// </summary>
public void Update(GenReply e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdUpdateGenReply = cmdUpdateGenReply.Clone() as MySqlCommand;
_cmdUpdateGenReply.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdUpdateGenReply.Parameters["@Rid"].Value = e.Rid;
_cmdUpdateGenReply.Parameters["@ObjId"].Value = e.ObjId;
_cmdUpdateGenReply.Parameters["@ObjType"].Value = e.ObjType;
_cmdUpdateGenReply.Parameters["@Content"].Value = e.Content;
_cmdUpdateGenReply.Parameters["@CreateId"].Value = e.CreateId;
_cmdUpdateGenReply.Parameters["@State"].Value = e.State;
_cmdUpdateGenReply.Parameters["@RefUserId"].Value = e.RefUserId;
_cmdUpdateGenReply.Parameters["@RefReplyId"].Value = e.RefReplyId;
_cmdUpdateGenReply.ExecuteNonQuery();
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdUpdateGenReply.Dispose();
_cmdUpdateGenReply = null;
GC.Collect();
}
}
/// <summary>
/// 添加数据
/// <param name="es">数据实体对象数组</param>
/// <returns></returns>
/// </summary>
public bool Insert(SocialUser e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdInsertSocialUser = cmdInsertSocialUser.Clone() as MySqlCommand;
bool returnValue = false;
_cmdInsertSocialUser.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdInsertSocialUser.Parameters["@SocialUserType"].Value = e.SocialUserType;
_cmdInsertSocialUser.Parameters["@AccessToken"].Value = e.AccessToken;
_cmdInsertSocialUser.Parameters["@AccessTokenSecret"].Value = e.AccessTokenSecret;
_cmdInsertSocialUser.Parameters["@Uid"].Value = e.Uid;
_cmdInsertSocialUser.Parameters["@UserId"].Value = e.UserId;
_cmdInsertSocialUser.ExecuteNonQuery();
return(returnValue);
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdInsertSocialUser.Dispose();
_cmdInsertSocialUser = null;
}
}
/// <summary>
/// 添加数据
/// <param name="es">数据实体对象数组</param>
/// <returns></returns>
/// </summary>
public int Insert(ResPic e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdInsertResPic = cmdInsertResPic.Clone() as MySqlCommand;
int returnValue = 0;
_cmdInsertResPic.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdInsertResPic.Parameters["@PicDescription"].Value = e.PicDescription;
_cmdInsertResPic.Parameters["@ObjId"].Value = e.ObjId;
_cmdInsertResPic.Parameters["@ObjType"].Value = e.ObjType;
_cmdInsertResPic.Parameters["@PicUrl"].Value = e.PicUrl;
_cmdInsertResPic.Parameters["@PicHeight"].Value = e.PicHeight;
_cmdInsertResPic.Parameters["@PicWidth"].Value = e.PicWidth;
_cmdInsertResPic.ExecuteNonQuery();
returnValue = Convert.ToInt32(_cmdInsertResPic.LastInsertedId);
return(returnValue);
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdInsertResPic.Dispose();
_cmdInsertResPic = null;
}
}
/// <summary>
/// 修改指定的数据
/// <param name="e">修改后的数据实体对象</param>
/// <para>数据对应的主键必须在实例中设置</para>
/// </summary>
public void Update(AdUser e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdUpdateAdUser = cmdUpdateAdUser.Clone() as MySqlCommand;
_cmdUpdateAdUser.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdUpdateAdUser.Parameters["@AdUserId"].Value = e.AdUserId;
_cmdUpdateAdUser.Parameters["@UserAccount"].Value = e.UserAccount;
_cmdUpdateAdUser.Parameters["@Pwd"].Value = e.Pwd;
_cmdUpdateAdUser.Parameters["@BabyBirthday"].Value = e.BabyBirthday;
_cmdUpdateAdUser.Parameters["@Sex"].Value = e.Sex;
_cmdUpdateAdUser.Parameters["@Qq"].Value = e.Qq;
_cmdUpdateAdUser.Parameters["@Mobile"].Value = e.Mobile;
_cmdUpdateAdUser.Parameters["@State"].Value = e.State;
_cmdUpdateAdUser.ExecuteNonQuery();
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdUpdateAdUser.Dispose();
_cmdUpdateAdUser = null;
GC.Collect();
}
}
/// <summary>
/// 删除数据
/// <param name="es">数据实体对象数组</param>
/// <returns></returns>
/// </summary>
public bool Delete(int bookid)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdDeleteProBook = cmdDeleteProBook.Clone() as MySqlCommand;
bool returnValue = false;
_cmdDeleteProBook.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdDeleteProBook.Parameters["@BookId"].Value = bookid;
_cmdDeleteProBook.Parameters["@EditeTime"].Value = DateTime.Now;
int i = _cmdDeleteProBook.ExecuteNonQuery();
if (i == 1)
{
returnValue = true;
}
return(returnValue);
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdDeleteProBook.Dispose();
_cmdDeleteProBook = null;
}
}
/// <summary>
/// 获取全部数据
/// </summary>
public List <GenVote> Search()
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdLoadAllGenVote = cmdLoadAllGenVote.Clone() as MySqlCommand;
_cmdLoadAllGenVote.Connection = oc; List <GenVote> returnValue = new List <GenVote>();
try
{
_cmdLoadAllGenVote.CommandText = string.Format(_cmdLoadAllGenVote.CommandText, string.Empty);
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
MySqlDataReader reader = _cmdLoadAllGenVote.ExecuteReader();
while (reader.Read())
{
returnValue.Add(new GenVote().BuildSampleEntity(reader));
}
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdLoadAllGenVote.Dispose();
_cmdLoadAllGenVote = null;
GC.Collect();
}
return(returnValue);
}
/// <summary>
/// 修改指定的数据
/// <param name="e">修改后的数据实体对象</param>
/// <para>数据对应的主键必须在实例中设置</para>
/// </summary>
public void Update(ProBook e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdUpdateProBook = cmdUpdateProBook.Clone() as MySqlCommand;
_cmdUpdateProBook.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdUpdateProBook.Parameters["@BookId"].Value = e.BookId;
_cmdUpdateProBook.Parameters["@BookName"].Value = e.BookName;
_cmdUpdateProBook.Parameters["@BookSize"].Value = e.BookSize;
_cmdUpdateProBook.Parameters["@BookType"].Value = e.BookType;
_cmdUpdateProBook.Parameters["@Introduction"].Value = e.Introduction;
_cmdUpdateProBook.Parameters["@State"].Value = (int)e.State;
_cmdUpdateProBook.Parameters["@EditeTime"].Value = DateTime.Now;
_cmdUpdateProBook.Parameters["@BookCover"].Value = (int)e.BookCover;
_cmdUpdateProBook.ExecuteNonQuery();
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdUpdateProBook.Dispose();
_cmdUpdateProBook = null;
GC.Collect();
}
}
/// <summary>
/// 删除数据
/// <param name="es">数据实体对象数组</param>
/// <returns></returns>
/// </summary>
public bool Delete(int picId)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdDeleteResPic = cmdDeleteResPic.Clone() as MySqlCommand;
bool returnValue = false;
_cmdDeleteResPic.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdDeleteResPic.Parameters["@PicId"].Value = picId;
_cmdDeleteResPic.ExecuteNonQuery();
return(returnValue);
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdDeleteResPic.Dispose();
_cmdDeleteResPic = null;
}
}
/// <summary>
/// 获取指定记录
/// <param name="id">Id值</param>
/// </summary>
public List <ResPic> Search(int ObjId, PicType objType)
{
List <ResPic> returnValue = new List <ResPic>();
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdSearchResPicByProId = cmdSearchResPicByProId.Clone() as MySqlCommand;
_cmdSearchResPicByProId.Connection = oc;
try
{
_cmdSearchResPicByProId.Parameters["@ObjId"].Value = ObjId;
_cmdSearchResPicByProId.Parameters["@ObjType"].Value = (int)objType;
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
MySqlDataReader reader = _cmdSearchResPicByProId.ExecuteReader();
while (reader.Read())
{
returnValue.Add(new ResPic().BuildSampleEntity(reader));
}
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdSearchResPicByProId.Dispose();
_cmdSearchResPicByProId = null;
GC.Collect();
}
return(returnValue);
}
/// <summary>
/// 修改指定的数据
/// <param name="e">修改后的数据实体对象</param>
/// <para>数据对应的主键必须在实例中设置</para>
/// </summary>
public void Update(ResPic e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdUpdateResPic = cmdUpdateResPic.Clone() as MySqlCommand;
_cmdUpdateResPic.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdUpdateResPic.Parameters["@PicId"].Value = e.PicId;
_cmdUpdateResPic.Parameters["@PicDescription"].Value = e.PicDescription;
_cmdUpdateResPic.Parameters["@ObjId"].Value = e.ObjId;
_cmdUpdateResPic.Parameters["@ObjType"].Value = e.ObjType;
_cmdUpdateResPic.Parameters["@PicUrl"].Value = e.PicUrl;
_cmdUpdateResPic.Parameters["@PicHeight"].Value = e.PicHeight;
_cmdUpdateResPic.Parameters["@PicWidth"].Value = e.PicWidth;
_cmdUpdateResPic.Parameters["@State"].Value = e.State;
_cmdUpdateResPic.Parameters["@CreateTime"].Value = e.CreateTime;
_cmdUpdateResPic.ExecuteNonQuery();
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdUpdateResPic.Dispose();
_cmdUpdateResPic = null;
GC.Collect();
}
}
/// <summary>
/// 获取指定用户已绑定的第三方账号
/// <param name="userId">UserId</param>
/// </summary>
public IList <SocialUser> GetSocialUserByUserId(int userId)
{
IList <SocialUser> returnValue = new List <SocialUser>();
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdGetSocialUser = cmdGetSocialUser.Clone() as MySqlCommand;
_cmdGetSocialUser.Connection = oc;
try
{
_cmdGetSocialUser.Parameters["@uid"].Value = string.Empty;
_cmdGetSocialUser.Parameters["@sutype"].Value = SocialUserTypeEnum.Ignore;
_cmdGetSocialUser.Parameters["@user_id"].Value = userId;
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
MySqlDataReader reader = _cmdGetSocialUser.ExecuteReader();
while (reader.Read())
{
returnValue.Add(new SocialUser().BuildSampleEntity(reader));
}
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdGetSocialUser.Dispose();
_cmdGetSocialUser = null;
GC.Collect();
}
return(returnValue);
}
/// <summary>
/// 添加数据
/// <param name="es">数据实体对象数组</param>
/// <returns></returns>
/// </summary>
public bool Insert(GenBless e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdInsertGenBless = cmdInsertGenBless.Clone() as MySqlCommand;
bool returnValue = false;
_cmdInsertGenBless.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdInsertGenBless.Parameters["@Bid"].Value = e.Bid;
_cmdInsertGenBless.Parameters["@Content"].Value = e.Content;
_cmdInsertGenBless.Parameters["@CreateTime"].Value = e.CreateTime;
_cmdInsertGenBless.Parameters["@CreateId"].Value = e.CreateId;
_cmdInsertGenBless.ExecuteNonQuery();
return(returnValue);
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdInsertGenBless.Dispose();
_cmdInsertGenBless = null;
}
}
/// <summary>
/// 修改指定的数据
/// <param name="e">修改后的数据实体对象</param>
/// <para>数据对应的主键必须在实例中设置</para>
/// </summary>
public void Update(GenVoteUser e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdUpdateGenVoteUser = cmdUpdateGenVoteUser.Clone() as MySqlCommand;
_cmdUpdateGenVoteUser.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdUpdateGenVoteUser.Parameters["@Vid"].Value = e.Vid;
_cmdUpdateGenVoteUser.Parameters["@UserId"].Value = e.UserId;
_cmdUpdateGenVoteUser.Parameters["@CreateTime"].Value = e.CreateTime;
_cmdUpdateGenVoteUser.Parameters["@VIp"].Value = e.VIp;
_cmdUpdateGenVoteUser.Parameters["@Id"].Value = e.Id;
_cmdUpdateGenVoteUser.ExecuteNonQuery();
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdUpdateGenVoteUser.Dispose();
_cmdUpdateGenVoteUser = null;
GC.Collect();
}
}
/// <summary>
/// 根据条件分页获取指定数据
/// <param name="pageIndex">当前页</param>
/// <para>索引从0开始</para>
/// <param name="pageSize">每页记录条数</param>
/// <para>记录数必须大于0</para>
/// </summary>
public PageEntity <GenReply> Search(int ObjId, ReplyType ObjType, Int32 CreateId, StateType State, Int32 RefUserId, Int32 RefReplyId, int pageIndex, int pageSize)
{
PageEntity <GenReply> returnValue = new PageEntity <GenReply>();
List <GenReply> rlist = new List <GenReply>();
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdLoadGenReply = cmdLoadGenReply.Clone() as MySqlCommand;
MySqlCommand _cmdGetGenReplyCount = cmdGetGenReplyCount.Clone() as MySqlCommand;
_cmdLoadGenReply.Connection = oc;
_cmdGetGenReplyCount.Connection = oc;
try
{
_cmdLoadGenReply.Parameters["@PageIndex"].Value = pageIndex * pageSize;
_cmdLoadGenReply.Parameters["@PageSize"].Value = (pageIndex + 1) * pageSize;
_cmdLoadGenReply.Parameters["@ObjId"].Value = DBConvert.ToDBValue(ObjId);
_cmdLoadGenReply.Parameters["@ObjType"].Value = DBConvert.ToDBValue((int)ObjType);
_cmdLoadGenReply.Parameters["@CreateId"].Value = DBConvert.ToDBValue(CreateId);
_cmdLoadGenReply.Parameters["@State"].Value = DBConvert.ToDBValue((int)State);
_cmdLoadGenReply.Parameters["@RefUserId"].Value = DBConvert.ToDBValue(RefUserId);
_cmdLoadGenReply.Parameters["@RefReplyId"].Value = DBConvert.ToDBValue(RefReplyId);
_cmdGetGenReplyCount.Parameters["@ObjId"].Value = DBConvert.ToDBValue(ObjId);
_cmdGetGenReplyCount.Parameters["@ObjType"].Value = DBConvert.ToDBValue((int)ObjType);
_cmdGetGenReplyCount.Parameters["@CreateId"].Value = DBConvert.ToDBValue(CreateId);
_cmdGetGenReplyCount.Parameters["@State"].Value = DBConvert.ToDBValue((int)State);
_cmdGetGenReplyCount.Parameters["@RefUserId"].Value = DBConvert.ToDBValue(RefUserId);
_cmdGetGenReplyCount.Parameters["@RefReplyId"].Value = DBConvert.ToDBValue(RefReplyId);
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
MySqlDataReader reader = _cmdLoadGenReply.ExecuteReader();
while (reader.Read())
{
rlist.Add(new GenReply().BuildSampleEntity(reader));
}
returnValue.Items = rlist;
reader.Close();
returnValue.PageIndex = pageIndex;
returnValue.PageSize = pageSize;
returnValue.RecordsCount = Convert.ToInt32(_cmdGetGenReplyCount.ExecuteScalar());
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdLoadGenReply.Dispose();
_cmdLoadGenReply = null;
_cmdGetGenReplyCount.Dispose();
_cmdGetGenReplyCount = null;
GC.Collect();
}
return(returnValue);
}
/// <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);
}