private void LoadData() { if (frm.isAdd) { Reset(); btnXoa.Enabled = false; } else { dm = DMQuyenHoaDonDataProvider.GetHoaDonInfo(frm.kytudau, frm.kyhieuhoadon); string conlai = (Convert.ToInt32(dm.SoLuong.ToString()) - Convert.ToInt32(dm.SuDung.ToString())).ToString(); txtSoLuong.Text = dm.SoLuong.ToString(); txtKyHieuDau.Text = dm.KyTuDauSerie; txtKyHieu.Text = dm.KyHieuHoaDon; txtDaDung.Text = dm.SuDung.ToString(); txtConLai.Text = conlai; txtKyHieu.Enabled = false; txtKyHieuDau.Enabled = false; } if (frm.IsSync) { //không cho phép người dùng sửa, xóa các thông tin trên form. txtKyHieu.Enabled = false; txtKyHieuDau.Enabled = false; btnXoa.Enabled = false; } }
internal List <DMQuyenHoaDonInfor> Search(DMQuyenHoaDonInfor dmQuyenHoaDonInfor) { CreateGetListCommand(Declare.StoreProcedureNamespace.spHoaDonSearch); Parameters.AddWithValue("@KyHieuHoaDon", dmQuyenHoaDonInfor.KyHieuHoaDon); Parameters.AddWithValue("@KyTuDauSerie", dmQuyenHoaDonInfor.KyTuDauSerie); return(FillToList <DMQuyenHoaDonInfor>()); }
internal void Delete(DMQuyenHoaDonInfor dmQuyenHoaDonInfor) { CreateCommonCommand(Declare.StoreProcedureNamespace.spHoaDonDelete); Parameters.AddWithValue("@KyHieuHoaDon", dmQuyenHoaDonInfor.KyHieuHoaDon); Parameters.AddWithValue("@KyTuDauSerie", dmQuyenHoaDonInfor.KyTuDauSerie); ExecuteNoneQuery(); }
private bool Search(DMQuyenHoaDonInfor dmQuyenHoaDonInfor) { return((txtFilterKyHieuDau.Text.Trim() == String.Empty || (txtFilterKyHieuDau.Text.Trim() != String.Empty && dmQuyenHoaDonInfor.KyTuDauSerie.ToLower().Contains(txtFilterKyHieuDau.Text.Trim().ToLower()))) && (txtFilterKyHieu.Text.Trim() == String.Empty || (txtFilterKyHieu.Text.Trim() != String.Empty && dmQuyenHoaDonInfor.KyHieuHoaDon.ToLower().Contains(txtFilterKyHieu.Text.Trim().ToLower())))); }
internal void Insert(DMQuyenHoaDonInfor dmQuyenHoaDonInfor)//nếu store không trả về kiểu out hay in thì dùng hàm void { CreateCommonCommand(Declare.StoreProcedureNamespace.spHoaDonInsert); SetParams(dmQuyenHoaDonInfor); //Parameters["@KyHieuHoaDon"].Direction = ParameterDirection.Output; ExecuteNoneQuery(); //return Convert.ToInt32(Parameters["@KyHieuHoaDon"].Value.ToString()); }
private void btnTimKiem_Click(object sender, EventArgs e) { //dgvList.DataSource = DMQuyenHoaDonDataProvider.Search(Search); DMQuyenHoaDonInfor dmQuyenHoaDonInfor = new DMQuyenHoaDonInfor(); dmQuyenHoaDonInfor.KyHieuHoaDon = txtKyHieu.Text; dmQuyenHoaDonInfor.KyTuDauSerie = txtKyHieuDau.Text; dgvList.DataSource = DMQuyenHoaDonDataProvider.Search(dmQuyenHoaDonInfor); }
internal bool Exist(DMQuyenHoaDonInfor dmQuyenHoaDonInfor) { CreateCommonCommand(Declare.StoreProcedureNamespace.spHoaDonExist); Parameters.AddWithValue("@Count", 0).Direction = ParameterDirection.Output; Parameters.AddWithValue("@KyHieuHoaDon", dmQuyenHoaDonInfor.KyHieuHoaDon); Parameters.AddWithValue("@KyTuDauSerie", dmQuyenHoaDonInfor.KyTuDauSerie); ExecuteNoneQuery(); return(Convert.ToInt32(Parameters["@Count"].Value) == 1); }
private DMQuyenHoaDonInfor getinfor() { DMQuyenHoaDonInfor dmQuyenHoaDonInfor = new DMQuyenHoaDonInfor(); dmQuyenHoaDonInfor.KyHieuHoaDon = txtKyHieu.Text; dmQuyenHoaDonInfor.KyTuDauSerie = txtKyHieuDau.Text; dmQuyenHoaDonInfor.SoLuong = Convert.ToInt32(txtSoLuong.Text); dmQuyenHoaDonInfor.SuDung = Convert.ToInt32(txtDaDung.Text); return(dmQuyenHoaDonInfor); }
internal void Update(DMQuyenHoaDonInfor dmQuyenHoaDonInfor) { CreateCommonCommand(Declare.StoreProcedureNamespace.spHoaDonUpdate); SetParams(dmQuyenHoaDonInfor); ExecuteNoneQuery(); }
private bool Exist(DMQuyenHoaDonInfor dmQuyenHoaDonInfor) { return(dmQuyenHoaDonInfor.KyTuDauSerie.ToLower() == txtKyHieuDau.Text.Trim().ToLower() && dmQuyenHoaDonInfor.KyHieuHoaDon.ToLower() == txtKyHieu.Text.Trim().ToLower()); }
internal static bool Kiemtra(DMQuyenHoaDonInfor dmQuyenHoaDonInfor) { return(DmQuyenHoaDonDAO.Instance.Exist(dmQuyenHoaDonInfor)); }
internal static void Update(DMQuyenHoaDonInfor dmQuyenHoaDonInfor) { DmQuyenHoaDonDAO.Instance.Update(dmQuyenHoaDonInfor); }
public static void Delete(DMQuyenHoaDonInfor dmQuyenHoaDonInfor) { DmQuyenHoaDonDAO.Instance.Delete(dmQuyenHoaDonInfor); }
internal static void Insert(DMQuyenHoaDonInfor dmQuyenHoaDonInfor) { DmQuyenHoaDonDAO.Instance.Insert(dmQuyenHoaDonInfor); }
public static List <DMQuyenHoaDonInfor> Search(DMQuyenHoaDonInfor dmQuyenHoaDonInfor) { return(DmQuyenHoaDonDAO.Instance.Search(dmQuyenHoaDonInfor)); }