private void btnXoa_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có muốn xóa không?", "Cảnh Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
CHITIET_PHIEUXUAT ct = new CHITIET_PHIEUXUAT();
ct.SOPX = txtSPX.Text;
if (bllct.DeleteCHITIET_PHIEUXUAT(ct))
{
ShowAllCHITIET_PHIEUXUAT();
}
else
{
MessageBox.Show("Đã xảy ra lỗi xin thử lại sau", "Thông Báo Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
}
private void btnSua_Click(object sender, EventArgs e)
{
if (CheckData())
{
CHITIET_PHIEUXUAT ct = new CHITIET_PHIEUXUAT();
ct.SOPX = txtSPX.Text;
ct.MAHH = txtMHH.Text;
ct.SLXUAT = txtSLX.Text;
if (bllct.UpdateCHITIET_PHIEUXUAT(ct))
{
ShowAllCHITIET_PHIEUXUAT();
}
else
{
MessageBox.Show("Đã có lỗi xin thử lại sau", "Thông Báo Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
}
public bool DeleteCHITIET_PHIEUXUAT(CHITIET_PHIEUXUAT ct)
{
string sql = "DELETE CHITIET_PHIEUXUAT WHERE SOPX = @SOPX ";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@SOPX", SqlDbType.NChar).Value = ct.SOPX;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool UpdateCHITIET_PHIEUXUAT(CHITIET_PHIEUXUAT ct)
{
string sql = "UPDATE CHITIET_PHIEUXUAT SET MAHH = @MAHH, SLXUAT=@SLXUAT WHERE SOPX = @SOPX ";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@SOPX", SqlDbType.NChar).Value = ct.SOPX;
cmd.Parameters.Add("@MAHH", SqlDbType.NChar).Value = ct.MAHH;
cmd.Parameters.Add("@SLXUAT", SqlDbType.Int).Value = ct.SLXUAT;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool InsertCHITIET_PHIEUXUAT(CHITIET_PHIEUXUAT ct)
{
string sql = "INSERT INTO CHITIET_PHIEUXUAT (SOPX, MAHH, SLXUAT) VALUES (@SOPX, @MAHH, @SLXUAT) ";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@SOPX", SqlDbType.NChar).Value = ct.SOPX;
cmd.Parameters.Add("@MAHH", SqlDbType.NChar).Value = ct.MAHH;
cmd.Parameters.Add("@SLXUAT", SqlDbType.Int).Value = ct.SLXUAT;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool DeleteCHITIET_PHIEUXUAT(CHITIET_PHIEUXUAT ct)
{
return(dalct.DeleteCHITIET_PHIEUXUAT(ct));
}
public bool UpdateCHITIET_PHIEUXUAT(CHITIET_PHIEUXUAT ct)
{
return(dalct.UpdateCHITIET_PHIEUXUAT(ct));
}
public bool InsertCHITIET_PHIEUXUAT(CHITIET_PHIEUXUAT ct)
{
return(dalct.InsertCHITIET_PHIEUXUAT(ct));
}
