private List <Class_ChiTietPhieuDB> test1() { string sql = "SELECT * FROM ChiTietPhieuDB"; List <Class_ChiTietPhieuDB> list = new List <Class_ChiTietPhieuDB>(); SqlConnection con = new SqlConnection(); con.ConnectionString = @"Data Source=MINH_VU_PC\SQLEXPRESS;Initial Catalog=BTL;Integrated Security=True"; con.Open(); SqlCommand cmd = new SqlCommand(sql, con); using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { string MaPhieu = reader.GetString(0); string MaMonAn = reader.GetString(1); string MaLoai = reader.GetString(2); double SoLuong = reader.GetDouble(3); decimal GiamGia = reader.GetDecimal(4); decimal ThanhTien = reader.GetDecimal(5); Class_ChiTietPhieuDB Test = new Class_ChiTietPhieuDB(MaPhieu, MaMonAn, MaLoai, SoLuong, GiamGia, ThanhTien); list.Add(Test); } } } con.Close(); return(list); }
private List <Class_ChiTietPhieuDB> test1() { string sql = "SELECT * FROM ChiTietPhieuDB"; List <Class_ChiTietPhieuDB> list = new List <Class_ChiTietPhieuDB>(); query.ketnoiSQL(); using (DbDataReader reader = query.Reader(sql)) { if (reader.HasRows) { while (reader.Read()) { string MaPhieu = reader.GetString(0); string MaMonAn = reader.GetString(1); string MaLoai = reader.GetString(2); double SoLuong = reader.GetDouble(3); double GiamGia = reader.GetDouble(4); double ThanhTien; var Tg = reader.GetValue(5); if (Tg == DBNull.Value) { ThanhTien = 0; } else { ThanhTien = Convert.ToDouble(Tg); } Class_ChiTietPhieuDB Test = new Class_ChiTietPhieuDB(MaPhieu, MaMonAn, MaLoai, SoLuong, GiamGia, ThanhTien); list.Add(Test); } } } query.DongketnoiSQL(); return(list); }
public void update(Class_ChiTietPhieuDB CTPDB) { string sql = "UPDATE ChiTietPhieuDB WHERE SET MaPhieu = " + CTPDB.MaPhieu1 + ",MaMonAn=N'" + CTPDB.MaMonAn1 + "', MaLoai=N'" + CTPDB.MaLoai1 + "', SoLuong='" + CTPDB.SoLuong1 + ",GiamGia=N'" + CTPDB.GiamGia1 + ",ThanhTien=N'" + CTPDB.ThanhTien1 + "')"; query.insert(sql); }
public void insert(Class_ChiTietPhieuDB CTPDB) { string sql = "INSERT INTO ChiTietPhieuDB(MaPhieu,MaMonAn,MaLoai,SoLuong,GiamGia,ThanhTien) VALUES("; sql += CTPDB.MaPhieu1 + ",N'" + CTPDB.MaMonAn1 + "',N'" + CTPDB.MaLoai1 + "',N'" + CTPDB.SoLuong1 + "',N'" + CTPDB.GiamGia1 + "',N'" + CTPDB.ThanhTien1 + "')"; query.insert(sql); }
private List <Class_ChiTietPhieuDB> test1() { string sql = "SELECT * FROM ChiTietPhieuDB"; List <Class_ChiTietPhieuDB> list = new List <Class_ChiTietPhieuDB>(); SqlConnection con = new SqlConnection(); con.ConnectionString = @"Data Source=DESKTOP-MFCIF4Q\SQLEXPRESS;Initial Catalog=QLNhaHang;Integrated Security=True"; con.Open(); SqlCommand cmd = new SqlCommand(sql, con); using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { string MaPhieu = reader.GetString(0); string MaMonAn = reader.GetString(1); string MaLoai = reader.GetString(2); double SoLuong = reader.GetDouble(3); double GiamGia = reader.GetDouble(4); double ThanhTien; var Tg = reader.GetValue(5); if (Tg == DBNull.Value) { ThanhTien = 0; } else { ThanhTien = Convert.ToDouble(Tg); } Class_ChiTietPhieuDB Test = new Class_ChiTietPhieuDB(MaPhieu, MaMonAn, MaLoai, SoLuong, GiamGia, ThanhTien); list.Add(Test); } } } con.Close(); return(list); }
public void delete(Class_ChiTietPhieuDB CTPDB) { string sql = "DELETE FROM ChiTietPhieuDB WHERE MaPhieu = " + CTPDB.MaPhieu1 + " and MaMonAn = " + CTPDB.MaMonAn1; query.insert(sql); }