public bool CheckMaLo(LoSX Losx)
{
string query = "sp_CheckMaLo '" + Losx.MaLo + "'";
DataTable result = DataProvider.Instance.ExecuteQuery(query);
return(result.Rows.Count > 0);
}
public DataTable ChiTietLoSx_Select(LoSX Losx)
{
string query = "sp_XemChiTietLoSx '" + Losx.MaLo + "'";
DataTable result = DataProvider.Instance.ExecuteQuery(query);
return(result);
}
void LoadChiTietLo()
{
string MaLo = txtMaLo.Text;
lbMaLo.Text = MaLo;
LoSX Losx = new LoSX(MaLo, "", "");
dtgChiTietLoSX.DataSource = ChiTietLoSx;
ChiTietLoSx.DataSource = LosxBill.ChiTietLoSX_Select(Losx);
}
private void btnThem_Click(object sender, EventArgs e)
{
string MaLo = txtMaLo.Text;
string NSX = dtpNSX.Value.ToString("MM/dd/yyyy");
string HSD = dtpHSD.Value.ToString("MM/dd/yyyy");
LoSX Losx = new LoSX(MaLo, NSX, HSD);
dtgLoSX.DataSource = Lo_Insert;
Lo_Insert.DataSource = LosxBill.LoSX_Insert(Losx);
LoadLoSx();
}
public bool LoSX_Update(LoSX Losx)
{
try
{
string query = " sp_LoSX_Update '" + Losx.MaLo + "', '" + Losx.NSX + "', '" + Losx.HSD + "'";
int result = DataProvider.Instance.ExecuteNonQuery(query);
return(true);
}
catch (Exception e)
{ }
return(false);
}
private void btnSua_Click(object sender, EventArgs e)
{
string MaLo = txtMaLo.Text;
string NSX = dtpNSX.Value.ToString("MM/dd/yyyy");
string HSD = dtpHSD.Value.ToString("MM/dd/yyyy");
LoSX Losx = new LoSX(MaLo, NSX, HSD);
if (LosxBill.LoSX_Update(Losx))
{
LoadLoSx();
}
else
{
MessageBox.Show("Cập nhật thất bại");
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
string MaLo = txtMaLo.Text;
LoSX Losx = new LoSX(MaLo, "", "");
if (MessageBox.Show("Bạn có thực sự muốn xóa??", "Thông báo", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK)
{
if (LosxBill.LoSX_Delete(Losx))
{
LoadLoSx();
}
else
{
MessageBox.Show("Xóa thất bại");
}
}
}
private void txtMaLo_TextChanged(object sender, EventArgs e)
{
string MaLo = txtMaLo.Text;
LoSX Losx = new LoSX(MaLo, "", "");
if (LosxBill.CheckMaLo(Losx))
{
btnThem.Enabled = false;
btnSua.Enabled = true;
btnXoa.Enabled = true;
}
else
{
btnThem.Enabled = true;
btnSua.Enabled = false;
btnXoa.Enabled = false;
}
}
public bool LoSX_Update(LoSX LoSX)
{
return(Losx.LoSX_Update(LoSX));
}
public bool CheckMaLo(LoSX LoSX)
{
return(Losx.CheckMaLo(LoSX));
}
public bool LoSX_Delete(LoSX LoSX)
{
return(Losx.LoSX_Delete(LoSX));
}
public bool LoSX_Insert(LoSX LoSX)
{
return(Losx.LoSX_Insert(LoSX));
}
public DataTable ChiTietLoSX_Select(LoSX LoSX)
{
return(Losx.ChiTietLoSx_Select(LoSX));
}
