/// <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(); } }
public BookModel Bind(ProBook book, ViewModelBindOption bindOptions) { this.Id = book.BookId; this.Name = book.BookName; this.BookSize = book.BookSize; this.BookType = book.BookType; this.Introduction = book.Introduction; this.CreateTime = book.CreateTime; this.EditeTime = book.EditeTime; this.BookCover = book.BookCover; if (ContainEnumType <BookBindType>(bindOptions.BookBindType, BookBindType.Pics)) { this.Pics = PicModel.BindList(book.Pics, bindOptions); } if (ContainEnumType <BookBindType>(bindOptions.BookBindType, BookBindType.Author)) { UserServiceClient client = new UserServiceClient(); AdvancedResult <AdUser> userRes = client.GetUserInfoByID(book.AdUserId); if (userRes.Error == DataStructure.AppError.ERROR_SUCCESS && userRes.Data != null) { this.Author = new UserModel().Bind(userRes.Data, bindOptions); } } return(this); }
public AdvancedResult <int> AddBook(string bookname, BookSize booksize, BookCoverType bookcover, int booktype, string introduction, string token) { AdvancedResult <int> result = new AdvancedResult <int>(); try { if (string.IsNullOrEmpty(bookname)) { result.Error = AppError.ERROR_BOOK_NOT_NULL; return(result); } if (!CacheManagerFactory.GetMemoryManager().Contains(token)) { result.Error = AppError.ERROR_PERSON_NOT_LOGIN; } else { int userid = Convert.ToInt32(CacheManagerFactory.GetMemoryManager().Get(token)); //int userid = 5; ProBook book = new ProBook(); book.BookName = bookname.Trim(); book.BookSize = booksize; book.BookType = booktype; book.AdUserId = userid; book.BookCover = bookcover; book.Introduction = string.IsNullOrEmpty(introduction) ? string.Empty : introduction.Trim(); result.Data = ProBookAccessor.Instance.Insert(book); result.Error = AppError.ERROR_SUCCESS; } } catch (Exception e) { result.Error = AppError.ERROR_FAILED; result.ExMessage = e.ToString(); } return(result); }
public AdvancedResult<int> AddBook(string bookname, BookSize booksize,BookCoverType bookcover, int booktype, string introduction, string token) { AdvancedResult<int> result = new AdvancedResult<int>(); try { if (string.IsNullOrEmpty(bookname)) { result.Error = AppError.ERROR_BOOK_NOT_NULL; return result; } if (!CacheManagerFactory.GetMemoryManager().Contains(token)) { result.Error = AppError.ERROR_PERSON_NOT_LOGIN; } else { int userid = Convert.ToInt32(CacheManagerFactory.GetMemoryManager().Get(token)); //int userid = 5; ProBook book = new ProBook(); book.BookName = bookname.Trim(); book.BookSize = booksize; book.BookType = booktype; book.AdUserId = userid; book.BookCover = bookcover; book.Introduction = string.IsNullOrEmpty(introduction) ? string.Empty : introduction.Trim(); result.Data = ProBookAccessor.Instance.Insert(book); result.Error = AppError.ERROR_SUCCESS; } } catch (Exception e) { result.Error = AppError.ERROR_FAILED; result.ExMessage = e.ToString(); } return result; }
public RespResult EditBook(int bookid, string bookname, BookSize booksize, BookCoverType bookcover, int booktype, string introduction, string token) { RespResult result = new RespResult(); try { if (string.IsNullOrEmpty(bookname)) { result.Error = AppError.ERROR_BOOK_NOT_NULL; return(result); } if (!CacheManagerFactory.GetMemoryManager().Contains(token)) { result.Error = AppError.ERROR_PERSON_NOT_LOGIN; } else { ProBook book = new ProBook(); book.BookId = bookid; book.BookName = bookname.Trim(); book.BookSize = booksize; book.BookType = booktype; book.BookCover = bookcover; book.Introduction = string.IsNullOrEmpty(introduction) ? string.Empty : introduction.Trim(); book.State = StateType.Active; ProBookAccessor.Instance.Update(book); result.Error = AppError.ERROR_SUCCESS; } } catch (Exception e) { result.Error = AppError.ERROR_FAILED; result.ExMessage = e.ToString(); } return(result); }
/// <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> /// 添加数据 /// <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="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); }
public RespResult EditBook(int bookid, string bookname, BookSize booksize, BookCoverType bookcover, int booktype, string introduction, string token) { RespResult result = new RespResult(); try { if (string.IsNullOrEmpty(bookname)) { result.Error = AppError.ERROR_BOOK_NOT_NULL; return result; } if (!CacheManagerFactory.GetMemoryManager().Contains(token)) { result.Error = AppError.ERROR_PERSON_NOT_LOGIN; } else { ProBook book = new ProBook(); book.BookId = bookid; book.BookName = bookname.Trim(); book.BookSize = booksize; book.BookType = booktype; book.BookCover = bookcover; book.Introduction = string.IsNullOrEmpty(introduction) ? string.Empty : introduction.Trim(); book.State = StateType.Active; ProBookAccessor.Instance.Update(book); result.Error = AppError.ERROR_SUCCESS; } } catch (Exception e) { result.Error = AppError.ERROR_FAILED; result.ExMessage = e.ToString(); } return result; }