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));
}
