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