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