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