public static bool CapNhat(PhieuMuon pm) { try { PhieuMuon phieu = PhieuMuon.GetPhieuMuonTheoID(pm.IDPhieuMuon); if (phieu != null) { string query = string.Format(@"Update PhieuMuon Set MaPhieuMuon = N'{0}', IDNhanVien = {1}, IDDocGia = {2}, IDTaiLieu = {3}, IDHinhThucMuon = {4}, SoLuong = {5}, NgayMuon = Convert(datetime,N'{6}'), ThoiHanTra = Convert(datetime,N'{7}'), NgayTra = Convert(datetime,N'{8}'), TinhTrang = {9} Where IDPhieuMuon = {10}", pm.MaPhieuMuon, pm.IDNhanVien, pm.IDDocGia, pm.IDTaiLieu, pm.IDHinhThucMuon, pm.SoLuong, pm.NgayMuon.ToString("yyyy-MM-dd HH:mm:ss"), pm.ThoiHanTra.ToString("yyyy-MM-dd HH:mm:ss"), pm.NgayTra.ToString("yyyy-MM-dd HH:mm:ss"), pm.TinhTrang, pm.IDPhieuMuon); if (DataProvider.ExecuteNonQuery(query) == 1) { return(true); } } return(false); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
public static List <PhieuMuon> GetDSPhieuMuon() { try { List <PhieuMuon> list = new List <PhieuMuon>(); string query = "Select * from dbo.PhieuMuon"; DataTable dt = DataProvider.ExecuteQuery(query); if (dt.Rows.Count <= 0) { return(null); } foreach (DataRow dr in dt.Rows) { PhieuMuon item = new PhieuMuon(); item.IDPhieuMuon = Convert.ToInt32(dr["IDPhieuMuon"]); item.IDNhanVien = Convert.ToInt32(dr["IDNhanVien"]); item.IDDocGia = Convert.ToInt32(dr["IDDocGia"]); item.IDTaiLieu = Convert.ToInt32(dr["IDTaiLieu"]); item.IDHinhThucMuon = Convert.ToInt32(dr["IDHinhThucMuon"]); item.SoLuong = Convert.ToInt32(dr["SoLuong"]); item.TinhTrang = Convert.ToInt32(dr["TinhTrang"]); item.MaPhieuMuon = dr["MaPhieuMuon"].ToString(); if (dr["NgayMuon"] != DBNull.Value) { item.NgayMuon = Convert.ToDateTime(dr["NgayMuon"]); } if (dr["ThoiHanTra"] != DBNull.Value) { item.ThoiHanTra = Convert.ToDateTime(dr["ThoiHanTra"]); } if (dr["NgayTra"] != DBNull.Value) { item.NgayTra = Convert.ToDateTime(dr["NgayTra"]); } list.Add(item); } return(list); } catch (Exception) { throw; } }
public static bool ThemMoi(PhieuMuon item) { try { string query = string.Format(@"Insert into dbo.PhieuMuon (MaPhieuMuon,IDNhanVien,IDDocGia,IDTaiLieu,IDHinhThucMuon,SoLuong,NgayMuon,ThoiHanTra,TinhTrang) Values (N'{0}',{1},{2},{3},{4},{5},Convert(datetime,N'{6}'),Convert(datetime,N'{7}'),{8})", item.MaPhieuMuon, item.IDNhanVien, item.IDDocGia, item.IDTaiLieu, item.IDHinhThucMuon, item.SoLuong, item.NgayMuon.ToString("yyyy-MM-dd HH:mm:ss"), item.ThoiHanTra.ToString("yyyy-MM-dd HH:mm:ss"), item.TinhTrang); if (DataProvider.ExecuteNonQuery(query) > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }