public List <CTPT> getAll(string Top, string Where, string Order) { List <CTPT> lst = new List <CTPT>(); string selectQuery = "select "; if (Top.Length != 0) { selectQuery += "Top " + Top; } selectQuery += "* "; selectQuery += "from tb_CTPT "; if (Where.Length != 0) { selectQuery += "Where " + Where; } if (Order.Length != 0) { selectQuery += "Order by " + Order; } using (SqlCommand cmd = new SqlCommand(selectQuery, openConnection())) { SqlDataReader dr; dr = cmd.ExecuteReader(); while (dr.Read()) { CTPT obj = new CTPT(); obj.CTPTIDataReader(dr); lst.Add(obj); } dr.Close(); } return(lst); }
public bool updateData(CTPT data) { bool check = false; String sql = String.Format("UPDATE tb_CTPT SET maPT ='{0}', maSach ='{1}', thanhTien ='{2}' where maCTPT ='{3}'", data.MaPhieuTra, data.MaSach, data.ThanhTien, data.MaCTPT); openConnection(); int r = ExecuteNonQuery(sql); if (r > 0) { check = true; } closeConnection(); return(check); }
public bool insertData(CTPT data) { bool check = false; String sql = String.Format("INSERT INTO [dbo].[tb_CTPT](maCTPT, maPT, maSach, thanhTien) VALUES('{0}','{1}','{2}','{3}')", data.MaCTPT, data.MaPhieuTra, data.MaSach, data.ThanhTien); openConnection(); int r = ExecuteNonQuery(sql); if (r > 0) { check = true; } closeConnection(); return(check); }
public bool updateData(CTPT data) { return(obj.updateData(data)); }
public bool insertData(CTPT data) { return(obj.insertData(data)); }
private void btnTaoPT_Click(object sender, EventArgs e) { if (cmbMaDocGia.SelectedIndex < 0) { MessageBox.Show("Chọn mã độc giả trước!"); return; } if (lstctpt.Count < 1) { MessageBox.Show("Dữ liệu trống!"); return; } PhieuTra data = new PhieuTra(); string idPT = frm.getIDPT(); data.MaPhieuTra = idPT; data.MaDocGia = cmbMaDocGia.SelectedValue.ToString(); data.NgayTra = DateTime.Today.ToShortDateString(); data.ThanhTien = 0; for (int i = 0; i < lstctpt.Count; i++) { data.ThanhTien += lstctpt[i].ThanhTien; } bool check = false; check = objpt.insertData(data); String idPM = ""; List <CTPM> temp = new List <CTPM>(); for (int i = 0; i < lstctpt.Count; i++) { CTPT pt = new CTPT(); pt.MaCTPT = frm.getIDCTPT(); MessageBox.Show(pt.MaCTPT); pt.MaPhieuTra = idPT; pt.MaSach = lstctpt[i].MaSach; pt.ThanhTien = lstctpt[i].ThanhTien; temp = objctpm.getAll("", "maCTPM= '" + lstctpt[i].MaCTPM + "'", ""); idPM = temp[0].MaPM; temp = objctpm.getAll("", "maPM= '" + idPM + "'", ""); check = objctpt.insertData(pt); objctpm.deleteData(lstctpt[i].MaCTPM); if (temp.Count == 1) { objpm.deleteData(idPM); } } if (check) { MessageBox.Show("Tạo phiếu trả thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); if (MessageBox.Show("Bạn muốn xuất phiếu trả?", "Thông báo!", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { new frmPTReport(data.MaPhieuTra, data.MaDocGia, data.ThanhTien.ToString()).ShowDialog(); } } else { MessageBox.Show("Tạo phiếu trả không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } this.Hide(); }