private List <Class_NguyenLieu_MonAn> test1() { string sql = "SELECT * FROM NguyenLieu_MonAn"; List <Class_NguyenLieu_MonAn> list = new List <Class_NguyenLieu_MonAn>(); 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 MaMonAn = reader.GetString(0); string MaNguyenLieu = reader.GetString(1); double SoLuong = reader.GetDouble(1); Class_NguyenLieu_MonAn Test = new Class_NguyenLieu_MonAn(MaMonAn, MaNguyenLieu, SoLuong); list.Add(Test); } } } con.Close(); return(list); }
public void delete(Class_NguyenLieu_MonAn NL_MA) { string sql = "DELETE FROM NguyenLieu_MonAn WHERE MaMonAn = " + NL_MA.MaMonAn1 + " and MaNguyenLieu = " + NL_MA.MaNguyenLieu1; query.insert(sql); query.insert(sql); }
public void update(Class_NguyenLieu_MonAn NL_MA) { string sql = "UPDATE NguyenLieu_MonAn WHERE SET MaMonAn=" + NL_MA.MaMonAn1 + ",MaNguyenLieu=N'" + NL_MA.MaNguyenLieu1 + "', SoLuong=N'" + NL_MA.SoLuong1 + "')"; query.insert(sql); }
public void insert(Class_NguyenLieu_MonAn NL_MA) { string sql = "INSERT INTO NguyenLieu_MonAn(MaMonAn,MaNguyenLieu,SoLuong) VALUES("; sql += NL_MA.MaMonAn1 + ",N'" + NL_MA.MaNguyenLieu1 + "',N'" + NL_MA.SoLuong1 + "')"; query.insert(sql); }
private List <Class_NguyenLieu_MonAn> test1() { string sql = "SELECT * FROM NguyenLieu_MonAn"; List <Class_NguyenLieu_MonAn> list = new List <Class_NguyenLieu_MonAn>(); query.ketnoiSQL(); using (DbDataReader reader = query.Reader(sql)) { if (reader.HasRows) { while (reader.Read()) { string MaMonAn = reader.GetString(0); string MaNguyenLieu = reader.GetString(1); double SoLuong = reader.GetDouble(1); Class_NguyenLieu_MonAn Test = new Class_NguyenLieu_MonAn(MaMonAn, MaNguyenLieu, SoLuong); list.Add(Test); } } } query.DongketnoiSQL(); return(list); }