public bool UpdateData(ChiTietHoaDonBanPhuTungObj chiTietHDBanPTObj)
{
cmd.CommandText = string.Format("UPDATE tblChiTietHDBanPT SET MACTHDBANPT = '{0}', MAHDBANPT = '{1}', MAPT = '{2}', SOLUONG = {3} WHERE (MACTHDBANPT = '{4}')", chiTietHDBanPTObj.MaChiTietHoaDonBanPhuTung, chiTietHDBanPTObj.MaHoaDonBanPhuTung, chiTietHDBanPTObj.MaPhuTung, chiTietHDBanPTObj.SoLuong);
cmd.Connection = con.Connection;
try
{
con.openCon();
cmd.ExecuteNonQuery();
con.closeCon();
return(true);
}
catch (Exception ex)
{
string mes = ex.Message;
cmd.Dispose();
con.closeCon();
}
return(false);
}
public bool AddData(ChiTietHoaDonBanPhuTungObj chiTietHDBanPTObj)
{
cmd.CommandText = string.Format("INSERT INTO tblChiTietHDBanPT (MACTHDBANPT, MAHDBANPT, MAPT, SOLUONG) VALUES ('{0}', '{1}', '{2}', {3})", chiTietHDBanPTObj.MaChiTietHoaDonBanPhuTung, chiTietHDBanPTObj.MaHoaDonBanPhuTung, chiTietHDBanPTObj.MaPhuTung, chiTietHDBanPTObj.SoLuong);
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.openCon();
cmd.ExecuteNonQuery();
con.closeCon();
return(true);
}
catch (Exception ex)
{
string mes = ex.Message;
cmd.Dispose();
con.closeCon();
}
return(false);
}
public bool updateData(ChiTietHoaDonBanPhuTungObj chiTietHDBanPTObj)
{
return(chiTietHDbanPTMod.UpdateData(chiTietHDBanPTObj));
}
public bool addData(ChiTietHoaDonBanPhuTungObj chiTietHDBanPTObj)
{
return(chiTietHDbanPTMod.AddData(chiTietHDBanPTObj));
}