/// <summary> /// 取得書籍狀態清單 /// </summary> /// <returns>BOOK_CODE</returns> public List <BOOK_CODE> GetCodeList() { DataTable dt = new DataTable(); string sql = @"Select CODE_ID, CODE_NAME From dbo.BOOK_CODE"; using (SqlConnection conn = new SqlConnection(_conn)) { conn.Open(); SqlDataAdapter sda = new SqlDataAdapter(sql, conn); sda.Fill(dt); conn.Close(); } List <BOOK_CODE> codes = new List <BOOK_CODE>(); for (int i = 0; i < dt.Rows.Count; i++) { BOOK_CODE code = new BOOK_CODE(); code.CODE_ID = dt.Rows[i][0].ToString(); code.CODE_NAME = dt.Rows[i][1].ToString(); codes.Add(code); } return(codes); }
public ActionResult Edit(BOOK_CODE Book) { String BOOK_CLASS_ID = Book.BOOK_CLASS_ID; var Books = db.BOOK_CODE.Where(m => m.BOOK_CLASS_ID == BOOK_CLASS_ID).FirstOrDefault(); Books.BOOK_CLASS_NAME = Book.BOOK_CLASS_NAME; Books.CREATE_DATE = Book.CREATE_DATE; Books.CREATE_USER = Book.CREATE_USER; Books.MODIFY_DATE = Book.MODIFY_DATE; Books.MODIFY_USER = Books.MODIFY_USER; db.SaveChanges(); return(RedirectToAction("index")); }
public ActionResult Create(BOOK_CODE Books) { db.BOOK_CODE.Add(Books); db.SaveChanges(); return(RedirectToAction("index")); }