public static int Add(PhieuMuonDto pm) { OleDbConnection cn; cn = DataProvider.ConnectionData(); string strSQL; strSQL = "Insert into PhieuMuon(MDocGia,NgayMuon,SoNgayMuon) values (?,?,?)"; OleDbCommand cmd = new OleDbCommand(strSQL, cn); cmd.Parameters.Add("@MDocGia", OleDbType.Integer); cmd.Parameters.Add("@NgayMuon", OleDbType.Date); cmd.Parameters.Add("@SoNgayMuon", OleDbType.Integer); cmd.Parameters["@MDocGia"].Value = pm.MDocGia; cmd.Parameters["@NgayMuon"].Value = pm.NgayMuon; cmd.Parameters["@SoNgayMuon"].Value = pm.SoNgayMuon; cmd.ExecuteNonQuery(); strSQL = "Select @@IDENTITY"; cmd = new OleDbCommand(strSQL, cn); pm.MPhieu = (int)cmd.ExecuteScalar(); cn.Close(); return pm.MPhieu; }
public static IList GetList() { ArrayList ds = new ArrayList(); OleDbConnection cn; cn = DataProvider.ConnectionData(); string strSQL; strSQL = "Select * From PhieuMuon"; OleDbCommand cmd = new OleDbCommand(strSQL, cn); OleDbDataReader dr; dr = cmd.ExecuteReader(); while (dr.Read()) { PhieuMuonDto pm = new PhieuMuonDto(); pm.MPhieu = (int)dr["MPhieu"]; pm.MDocGia = (int)dr["MDocGia"]; pm.NgayMuon = (DateTime)dr["NgayMuon"]; pm.SoNgayMuon = (int)dr["SoNgayMuon"]; ds.Add(pm); } dr.Close(); cn.Close(); return ds; }
private void btDongy_Click(object sender, EventArgs e) { try { if (docgia == null) { MessageBox.Show("Bạn chưa chọn độc giả !!"); return; } if ((DataTable)dtgSachchon.DataSource == null) { MessageBox.Show("Bạn chưa chọn sách mượn !!"); return; } if (((DataTable)dtgSachchon.DataSource).Rows.Count == 0) { MessageBox.Show("Bạn chưa chọn sách mượn !!"); return; } PhieuMuonDto phieu = new PhieuMuonDto(); int count; phieu.MDocGia = docgia.MDocGia; phieu.NgayMuon = dayNgaymuon.Value; phieu.SoNgayMuon = (int)numSongaymuon.Value; phieu.TrangThai = trangThai; if (sachlist != null) for (count = 0; count < sachlist.Tables[0].Rows.Count; count++ ) if (trangThai == false) { BUS.SachBus.UpdateTrangThai((int)sachlist.Tables[0].Rows[count][0], true); } if (type == 0) { int maphieu = BUS.PhieuMuonBus.Add(phieu); DataTable dt = (DataTable)dtgSachchon.DataSource; ChiTietPhieuMuonDto chitiet = new ChiTietPhieuMuonDto(); chitiet.MaPhieu = maphieu; for (count = 0; count < dt.Rows.Count; count++) { chitiet.MaSach = int.Parse(dt.Rows[count][1].ToString()); BUS.ChiTietPhieuMuonBus.Add(chitiet); BUS.SachBus.UpdateTrangThai(chitiet.MaSach, false); } MessageBox.Show("Lập phiếu thành công"); this.Close(); } else { BUS.PhieuMuonBus.Delete(mPhieu); int maphieu = BUS.PhieuMuonBus.Add(phieu); DataTable dt = (DataTable)dtgSachchon.DataSource; ChiTietPhieuMuonDto chitiet = new ChiTietPhieuMuonDto(); chitiet.MaPhieu = maphieu; for (count = 0; count < dt.Rows.Count; count++) { chitiet.MaSach = int.Parse(dt.Rows[count][1].ToString()); BUS.ChiTietPhieuMuonBus.Add(chitiet); if (trangThai == false) BUS.SachBus.UpdateTrangThai(chitiet.MaSach, false); } MessageBox.Show("Sửa phiếu thành công"); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static PhieuMuonDto Search(int MaPh) { PhieuMuonDto pm = null; OleDbConnection cn; cn = DataProvider.ConnectionData(); string strSQL; strSQL = "Select * From PhieuMuon Where MPhieu= ? "; OleDbCommand cmd = new OleDbCommand(strSQL, cn); cmd.Parameters.Add("@MPhieu", OleDbType.Integer); cmd.Parameters["@MPhieu"].Value = MaPh; OleDbDataReader dr; dr = cmd.ExecuteReader(); while (dr.Read()) { pm = new PhieuMuonDto(); pm.MPhieu = (int)dr["MPhieu"]; pm.MDocGia = (int)dr["MDocGia"]; pm.NgayMuon = (DateTime)dr["NgayMuon"]; pm.SoNgayMuon = (int)dr["SoNgayMuon"]; } dr.Close(); cn.Close(); return pm; }
public static void Update(PhieuMuonDto pm) { OleDbConnection cn; cn = DataProvider.ConnectionData(); string strSQL; strSQL = "Update PhieuMuon Set MDocGia = ? , NgayMuon = ? , SoNgayMuon = ? Where MPhieu = ?"; OleDbCommand cmd = new OleDbCommand(strSQL, cn); cmd.Parameters.Add("@MDocGia", OleDbType.Integer); cmd.Parameters.Add("@NgayMuon", OleDbType.Date); cmd.Parameters.Add("@SoNgayMuon", OleDbType.Integer); cmd.Parameters.Add("@MPhieu", OleDbType.Integer); cmd.Parameters["@MDocGia"].Value = pm.MDocGia; cmd.Parameters["@NgayMuon"].Value = pm.NgayMuon; cmd.Parameters["@SoNgayMuon"].Value = pm.SoNgayMuon; cmd.Parameters["@MPhieu"].Value = pm.MPhieu; cmd.ExecuteNonQuery(); cn.Close(); }