// Delete du lieu
public bool Delete(ChiTietObj vo)
{
string str = "delete from tb_CTHD where MaHD = @MaHD";
SQLiteCommand cmd = new SQLiteCommand(str, da.Conn);
cmd.Parameters.Add("@MaHD", SqlDbType.Text).Value = vo.MaHD;
return(da.executeNonQuery(cmd));
}
public bool Add(ChiTietObj vo)
{
string str = "insert into tb_CTHD (MaHD, MaHH, SoLuong, DonGia) values (@MaHD, @MaHH, @SoLuong, @DonGia)";
SQLiteCommand cmd = new SQLiteCommand(str, da.Conn);
cmd.Parameters.Add("@MaHD", SqlDbType.Text).Value = vo.MaHD;
cmd.Parameters.Add("@MaHH", SqlDbType.Text).Value = vo.MaHH;
cmd.Parameters.Add("@SoLuong", SqlDbType.Int).Value = vo.SoLuong;
cmd.Parameters.Add("@DonGia", SqlDbType.Int).Value = vo.DonGia;
return(da.executeNonQuery(cmd));
}
// Update du lieu
public bool Update(ChiTietObj vo)
{
StringBuilder sb = new StringBuilder();
sb.Append("update tb_CTHD ");
sb.Append("set MaHH = @MaHH, SoLuong = @SoLuong, DonGia = @DonGia ");
sb.Append("where MaHD = @MaHD");
SQLiteCommand cmd = new SQLiteCommand(sb.ToString(), da.Conn);
cmd.Parameters.Add("@MaHD", SqlDbType.Text).Value = vo.MaHD;
cmd.Parameters.Add("@MaHH", SqlDbType.Text).Value = vo.MaHH;
cmd.Parameters.Add("@SoLuong", SqlDbType.Text).Value = vo.SoLuong;
cmd.Parameters.Add("@DonGia", SqlDbType.Text).Value = vo.DonGia;
return(da.executeNonQuery(cmd));
}
public bool AddData(ChiTietObj ctObj)
{
cmd.CommandText = "INSERT INTO CTHD VALUES ('" + ctObj.Mahd + "','" + ctObj.Masp + "','" + ctObj.Sl + "','" + ctObj.Gg + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();// đóng phiên làm việc
con.CloseConn();
}
return(false);
}
public bool addData(ChiTietObj ctObj)
{
return(ctMod.AddData(ctObj));
}
public bool Delete(ChiTietObj vo)
{
return(sql.Delete(vo));
}
public bool Update(ChiTietObj vo)
{
return(sql.Update(vo));
}
public bool Add(ChiTietObj vo)
{
return(sql.Add(vo));
}
