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