private void btnnop_Click(object sender, EventArgs e)
{
try
{
QuyenDoAn QDA = new QuyenDoAn();
QDA.MaQuyenDA = tbxmaQDA.Text.Trim();
QDA.MaPhieuDK = tbxmaPDK.Text.Trim();
QDA.NgayNop = dTPngaynop.Value;
QDA.DiemDA = tbxdiemda.Text.Trim(); //h
QDA.NhanXet = tbxnhanxet.Text.Trim(); //f
QuyenDoAnBLL QDABLL = new QuyenDoAnBLL();
string _MaQuyenDA = tbxmaQDA.Text.Trim();
if (!(QDABLL.CheckID(_MaQuyenDA)))
{
QDABLL.Insert(QDA);
LoadData();
}
else
{
MessageBox.Show("Mã quyen do an " + _MaQuyenDA.ToString() + "đã tồn tại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
MessageBox.Show("Thêm bị lỗi: " + ex.Message.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public int Update(QuyenDoAn obj)
{
int result = 0;
string strQuery = "update QUYENDOAN set NgayNop='" + obj.NgayNop + "',DiemDA='" + obj.DiemDA + "',NhanXet=N'" + obj.NhanXet + "',FK_MaPhieuDK='" + obj.MaPhieuDK + "' where MaQuyenDA='" + obj.MaQuyenDA + "'";
DataConfig config = new DataConfig();
result = config.excuteNoneQuery(strQuery);
return(result); //tra ve so ghi nhan thuc hien
}
////ham tim kiem
//public DataTable TimKiem(string chuoi)
//{
// DataTable result = new DataTable();
// DataConfig config = new DataConfig();//tao ket noi
// string strQuery = "select * from QUYENDOAN Where MaQuyenDA like'%" + chuoi + "%'"; // tim kiem theo ma
// result = config.GetData(strQuery);// form load len thi thuc hien load data
// return result;
//}
//them csdl
public int Insert(QuyenDoAn obj)
{
int result = 0;
string strQuery = "insert into QUYENDOAN (MaQuyenDA,NgayNop,NhanXet,DiemDA,FK_MaPhieuDK) values ('" + obj.MaQuyenDA + "','" + obj.NgayNop + "',N'" + obj.NhanXet + "','" + obj.DiemDA + "','" + obj.MaPhieuDK + "')";
DataConfig config = new DataConfig();
result = config.excuteNoneQuery(strQuery);
return(result); //tra ve so ghi nhan thuc hien
}
private void btncapnhat_Click(object sender, EventArgs e)
{
try
{
QuyenDoAn QDA = new QuyenDoAn();
QDA.MaQuyenDA = tbxmaQDA.Text.Trim();
QDA.DiemDA = tbxdiemDA.Text.Trim();
QDA.NhanXet = tbxnhanxet.Text.Trim();
QuyenDoAnBLL QDABLL = new QuyenDoAnBLL();
string _MaQuyenDA = tbxmaQDA.Text.Trim();
QDABLL.Update(QDA);
// LoadData();
}
catch (Exception ex)
{
MessageBox.Show("Sua bị lỗi: " + ex.Message.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
//CẬP NHẬT-SỬA
private void button1_Click(object sender, EventArgs e)
{
try
{
QuyenDoAn QDA = new QuyenDoAn();
QDA.MaQuyenDA = tbxmaQDA.Text.Trim();
QDA.MaPhieuDK = tbxmaPDK.Text.Trim();
QDA.NgayNop = dTPngaynop.Value;
QuyenDoAnBLL QDABLL = new QuyenDoAnBLL();
string _MaQuyenDA = tbxmaQDA.Text.Trim();
QDABLL.Update(QDA);
LoadData();
}
catch (Exception ex)
{
MessageBox.Show("Sua bị lỗi: " + ex.Message.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
