private void button3_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có chắc chắn muốn xóa?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
CT_KKSL CTKKSL = new CT_KKSL();
CTKKSL.SOPSL = txtSOPSL.Text;
if (bllCT_KKSL.DeleteCT_KKSL(CTKKSL))
{
ShowAllCT_KKSL();
}
else
{
MessageBox.Show("Lỗi", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public bool DeleteCT_KKSL(CT_KKSL CTKKSL)
{
string sql = "DELETE CHITIET_PHIEUKKSL WHERE SOPSL = @SOPSL ";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@SOPSL", SqlDbType.NChar).Value = CTKKSL.SOPSL;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
private void button2_Click(object sender, EventArgs e)
{
CT_KKSL CTKKSL = new CT_KKSL();
CTKKSL.SOPSL = txtSOPSL.Text;
CTKKSL.MAHH = txtMAHH.Text;
CTKKSL.PHUONGTHUCKK = txtPHUONGTHUCKK.Text;
CTKKSL.SOLUONGCT = int.Parse(txtSOLUONGCT.Text);
CTKKSL.SOLUONGTT = int.Parse(txtSOLUONGTT.Text);
CTKKSL.GHICHU = txtGHICHU.Text;
if (bllCT_KKSL.UpdateCT_KKSL(CTKKSL))
{
ShowAllCT_KKSL();
}
else
{
MessageBox.Show("Lỗi", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool UpdateCT_KKSL(CT_KKSL CTKKSL)
{
string sql = "UPDATE CHITIET_PHIEUKKSL SET SOPSL = @SOPSL, MAHH = @MAHH, PHUONGTHUCKK = @PHUONGTHUCKK, SOLUONGCT = @SOLUONGCT, SOLUONGTT = @SOLUONGTT, GHICHU = @GHICHU WHERE SOPSL = @SOPSL ";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@SOPSL", SqlDbType.NChar).Value = CTKKSL.SOPSL;
cmd.Parameters.Add("@MAHH", SqlDbType.NChar).Value = CTKKSL.MAHH;
cmd.Parameters.Add("@PHUONGTHUCKK", SqlDbType.NVarChar).Value = CTKKSL.PHUONGTHUCKK;
cmd.Parameters.Add("@SOLUONGCT", SqlDbType.Int).Value = CTKKSL.SOLUONGCT;
cmd.Parameters.Add("@SOLUONGTT", SqlDbType.Int).Value = CTKKSL.SOLUONGTT;
cmd.Parameters.Add("@GHICHU", SqlDbType.NVarChar).Value = CTKKSL.GHICHU;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool InsertCT_KKSL(CT_KKSL CTKKSL)
{
string sql = "INSERT INTO CHITIET_PHIEUKKSL( SOPSL, MAHH, PHUONGTHUCKK, SOLUONGCT, SOLUONGTT, GHICHU) VALUES(@SOPSL, @MAHH, @PHUONGTHUCKK, @SOLUONGCT, @SOLUONGTT, @GHICHU) ";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@SOPSL", SqlDbType.NChar).Value = CTKKSL.SOPSL;
cmd.Parameters.Add("@MAHH", SqlDbType.NChar).Value = CTKKSL.MAHH;
cmd.Parameters.Add("@PHUONGTHUCKK", SqlDbType.NVarChar).Value = CTKKSL.PHUONGTHUCKK;
cmd.Parameters.Add("@SOLUONGCT", SqlDbType.Int).Value = CTKKSL.SOLUONGCT;
cmd.Parameters.Add("@SOLUONGTT", SqlDbType.Int).Value = CTKKSL.SOLUONGTT;
cmd.Parameters.Add("@GHICHU", SqlDbType.NVarChar).Value = CTKKSL.GHICHU;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool DeleteCT_KKSL(CT_KKSL CTKKSL)
{
return(dalCT_KKSL.DeleteCT_KKSL(CTKKSL));
}
public bool UpdateCT_KKSL(CT_KKSL CTKKSL)
{
return(dalCT_KKSL.UpdateCT_KKSL(CTKKSL));
}
public bool InsertCT_KKSL(CT_KKSL CTKKSL)
{
return(dalCT_KKSL.InsertCT_KKSL(CTKKSL));
}
