public static bool updateHDN(EC_HDN cthd)
{
conn = GetData.KetNoi();
string sTruyVan = "HoaDonNhap_Update";
cmd = new SqlCommand(sTruyVan, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MAHDN", SqlDbType.NVarChar).Value = cthd.MaHDN;
cmd.Parameters.Add("@NGAYNHAP", SqlDbType.Date).Value = cthd.NgayNhap;
cmd.Parameters.Add("@MANV", SqlDbType.NVarChar).Value = cthd.MaNV;
cmd.Parameters.Add("@MANCC", SqlDbType.NVarChar).Value = cthd.MaNCC;
cmd.Parameters.Add("@TONGTIEN", SqlDbType.Float).Value = cthd.TongTien;
cmd.ExecuteNonQuery();
cmd.Dispose();
try
{
GetData.ThucThiTruyVanNonQuery(sTruyVan, conn);
//Đóng kết nối
GetData.DongKetNoi(conn);
return(true);
}
catch (Exception ex)
{
//Đóng kết nối
GetData.DongKetNoi(conn);
return(false);
}
}
public static bool deleteHDN(EC_HDN cthd)
{
conn = GetData.KetNoi();
string sTruyVan = "HoaDonNhap_Delete";
cmd = new SqlCommand(sTruyVan, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MAHDN", SqlDbType.NVarChar).Value = cthd.MaHDN;
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
try
{
GetData.ThucThiTruyVanNonQuery(sTruyVan, conn);
//Đóng kết nối
GetData.DongKetNoi(conn);
return(true);
}
catch (Exception ex)
{
//Đóng kết nối
GetData.DongKetNoi(conn);
return(false);
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (txtMaHDN.Text != "")
{
if (manv != "")
{
EC_HDN hdn = new EC_HDN();
hdn.MaHDN = txtMaHDN.Text;
if (thucthi.deleteHDN(hdn))
{
MessageBox.Show("Xóa thành công");
loaddata();
}
else
{
MessageBox.Show("Xóa thất bại");
}
}
}
else
{
MessageBox.Show("Mã hóa đơn rỗng");
}
}
public void UpdateHDN(EC_HDN _hdn)
{
string sqlquery = (@"UPDATE tb_HDN
SET mancc =N'{0}', ngaynhap ='{1}', manv =N'{2}', tongtien ='{3}' where sohdn=N'{4}'");
sqlquery = string.Format(sqlquery, _hdn.MaNCC, _hdn.NgayNhap, _hdn.MaNV, _hdn.TongTien, _hdn.SoHDN);
Connect.ExcuteNonQuery(sqlquery);
}
public void AddHDN(EC_HDN _hdn)
{
string sqlquery = (@"INSERT INTO tb_HDN ( sohdn, mancc, ngaynhap, manv, tongtien)
VALUES (N'{0}',N'{1}','{2}',N'{3}','{4}')");
sqlquery = string.Format(sqlquery, _hdn.SoHDN, _hdn.MaNCC, _hdn.NgayNhap, _hdn.MaNV, _hdn.TongTien);
Connect.ExcuteNonQuery(sqlquery);
}
public void AddHDN(EC_HDN _hdn)
{
if (!sqlhdn.CheckHDN(_hdn.SoHDN))
{
sqlhdn.AddHDN(_hdn);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public DataTable CreateTbHDN(EC_HDN _hdn)
{
if (_hdn.NgayNhap != "%")
{
return(Connect.CreateTable(string.Format("select * from tb_HDN where sohdn like N'%{0}%' and mancc like N'%{1}%' and ngaynhap = '{2}' and manv like N'%{3}%' and tongtien like '%{4}%'", _hdn.SoHDN, _hdn.MaNCC, _hdn.NgayNhap, _hdn.MaNV, _hdn.TongTien)));
}
else
{
return(Connect.CreateTable(string.Format("select * from tb_HDN where sohdn like N'%{0}%' and mancc like N'%{1}%' and ngaynhap like '%{2}%' and manv like N'%{3}%' and tongtien like '%{4}%'", _hdn.SoHDN, _hdn.MaNCC, _hdn.NgayNhap, _hdn.MaNV, _hdn.TongTien)));
}
}
private void btnSua_Click(object sender, EventArgs e)
{
if (txtMaHDN.Text != "")
{
EC_HDN hdn = new EC_HDN();
hdn.MaHDN = txtMaHDN.Text;
hdn.MaNCC = cbxNCC.SelectedValue.ToString();
hdn.MaNV = manv;
hdn.NgayNhap = dateNgayNhap.Value;
if (thucthi.updateHDN(hdn))
{
MessageBox.Show("Sửa thành công");
loaddata();
}
else
{
MessageBox.Show("Sửa thất bại");
}
}
else
{
MessageBox.Show("Mã hóa đơn rỗng");
}
}
public void DeleteHDN(EC_HDN _hdn)
{
sqlhdn.DeleteHDN(_hdn);
}
public void UpdateHDN(EC_HDN _hdn)
{
sqlhdn.UpdateHDN(_hdn);
}
public DataTable CreateTbHDN(EC_HDN _hdn)
{
return(sqlhdn.CreateTbHDN(_hdn));
}
public void DeleteHDN(EC_HDN _hdn)
{
Connect.ExcuteNonQuery("DELETE FROM [tb_CTHDN] WHERE sohdn=N'" + _hdn.SoHDN + "'");
Connect.ExcuteNonQuery("DELETE FROM [tb_HDN] WHERE sohdn=N'" + _hdn.SoHDN + "'");
}
public bool deleteHDN(EC_HDN cthdn)
{
return(DA_HDN.deleteHDN(cthdn));
}
public bool updateHDN(EC_HDN cthdn)
{
return(DA_HDN.updateHDN(cthdn));
}
public bool insertHDN(EC_HDN cthdn)
{
return(DA_HDN.insertHDN(cthdn));
}
