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