private List <Class_PhieuDatBan> test1() { string sql = "SELECT * FROM PhieuDatban"; List <Class_PhieuDatBan> list = new List <Class_PhieuDatBan>(); SqlConnection con = new SqlConnection(); con.ConnectionString = @"Data Source=ADMIN\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 MaNhanVien = reader.GetString(1); string MaKhach = reader.GetString(2); DateTime NgayDat = reader.GetDateTime(3); DateTime NgayDung = reader.GetDateTime(4); decimal TongTien = reader.GetDecimal(5); Class_PhieuDatBan Test = new Class_PhieuDatBan(MaPhieu, MaKhach, MaNhanVien, NgayDat, NgayDung, TongTien); list.Add(Test); } } } con.Close(); return(list); }
public new List <Class_PhieuDatBan> Select() { string sql = "SELECT * FROM PhieuDatban"; List <Class_PhieuDatBan> list = new List <Class_PhieuDatBan>(); query.ketnoiSQL(); using (DbDataReader reader = query.Reader(sql)) { if (reader.HasRows) { while (reader.Read()) { string MaPhieu = reader.GetString(0); string MaNhanVien = reader.GetString(1); string MaKhach = reader.GetString(2); DateTime NgayDat = reader.GetDateTime(3); DateTime NgayDung = reader.GetDateTime(4); double TongTien; var Tg = reader.GetValue(5); if (Tg == DBNull.Value) { TongTien = 0; } else { TongTien = Convert.ToDouble(Tg); } Class_PhieuDatBan Test = new Class_PhieuDatBan(MaPhieu, MaKhach, MaNhanVien, NgayDat, NgayDung, TongTien); list.Add(Test); } } } query.DongketnoiSQL(); return(list); }
public void update(Class_PhieuDatBan PDB) { string sql = "UPDATE PhieuDatBan WHERE SET MaPhieu=" + PDB.MaPhieu1 + ",MaKhach=N'" + PDB.MaKhach1 + "', MaNhanVien=N'" + PDB.MaNhanVien1 + "', NgayDat='" + PDB.NgayDat1 + ",NgayDung=N'" + PDB.NgayDung1 + ",TongTien=N'" + PDB.TongTien1 + "')"; query.insert(sql); }
public void insert(Class_PhieuDatBan PDB) { string sql = "INSERT INTO PhieuDatBan(MaPhieu,MaKhach,MaNhanVien,NgayDat,NgayDung,TongTien) VALUES("; sql += PDB.MaPhieu1 + ",N'" + PDB.MaKhach1 + "',N'" + PDB.MaNhanVien1 + "',N'" + PDB.NgayDat1 + "',N'" + PDB.NgayDung1 + "',N'" + PDB.TongTien1 + "')"; query.insert(sql); }
public new List <Class_PhieuDatBan> Select() { string sql = "SELECT * FROM PhieuDatban"; List <Class_PhieuDatBan> list = new List <Class_PhieuDatBan>(); 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 MaNhanVien = reader.GetString(1); string MaKhach = reader.GetString(2); DateTime NgayDat = reader.GetDateTime(3); DateTime NgayDung = reader.GetDateTime(4); double TongTien; var Tg = reader.GetValue(5); if (Tg == DBNull.Value) { TongTien = 0; } else { TongTien = Convert.ToDouble(Tg); } Class_PhieuDatBan Test = new Class_PhieuDatBan(MaPhieu, MaKhach, MaNhanVien, NgayDat, NgayDung, TongTien); list.Add(Test); } } } con.Close(); return(list); }
public void delete(Class_PhieuDatBan PDB) { string sql = "DELETE FROM PhieuDatBan WHERE MaPhieu = " + PDB.MaPhieu1; query.insert(sql); }