public bool UpdData(ThongKeObj tkObj)
{
cmd.CommandText = " Update THONGKE set tongthu = giaban*soluongban, loinhuan = giaban*soluongban - gianhap*soluongban ";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
con.CloseConn();
}
return(false);
}
public bool AddData(ThongKeObj tkObj)
{
cmd.CommandText = "Insert into THONGKE values ('" + tkObj.MaHangHoa + "',CONVERT(DATE,'" + tkObj.NgayBan + "',103),'" + tkObj.GiaBan + "','" + tkObj.GiaNhap + "','" + tkObj.SoLuongDaBan + "','" + tkObj.TongDoanhThu + "','" + tkObj.LoiNhuan + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
con.CloseConn();
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
con.CloseConn();
}
return(false);
}
public bool updDate(ThongKeObj tkObj)
{
return(tkMod.UpdData(tkObj));
}
public bool addData(ThongKeObj tkObj)
{
return(tkMod.AddData(tkObj));
}
