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