public static void DeliveryBag(string username) { opendb(); cmd.CommandText = "SELECT OrderDetail.CakeID, OrderDetail.Finish, OrderDetail.UserName, User.Address, User.Telephone, OrderDetail.Price, OrderDetail.Payment, OrderDetail.CakeFace, OrderDetail.DeliverBy " + "FROM[User] INNER JOIN OrderDetail ON User.UserName = OrderDetail.UserName " + "WHERE(((OrderDetail.Finish) = 'Y') AND((OrderDetail.Payment) = 'N') AND((OrderDetail.DeliverBy) = '" + username + "'))"; OleDbDataReader dr = cmd.ExecuteReader(); dtdeliverybag.Rows.Clear(); bag.Clear(); dtdeliverybag.Load(dr); foreach (DataRow row in dtdeliverybag.Rows) { cake tmp = new cake(); tmp.cakeid = row["CakeID"].ToString(); tmp.cakeusername = row["UserName"].ToString(); tmp.cakeaddress = row["Address"].ToString(); tmp.tel = row["Telephone"].ToString(); tmp.cakeprice = (double)row["Price"]; tmp.cakeimg = (Byte[])row["CakeFace"]; bag.Add(tmp); } closedb(); }
public static void DeliveryInfo() { opendb(); cmd.CommandText = "SELECT * FROM[CopyDeliveryQuery]"; OleDbDataReader dr = cmd.ExecuteReader(); dtdelivery.Rows.Clear(); cake.Clear(); dtdelivery.Load(dr); foreach (DataRow row in dtdelivery.Rows) { cake tmp = new cake(); tmp.cakeid = row["CakeID"].ToString(); tmp.cakeusername = row["UserName"].ToString(); tmp.cakeaddress = row["Address"].ToString(); tmp.tel = row["Telephone"].ToString(); tmp.cakeprice = (double)row["Price"]; tmp.cakeimg = (Byte[])row["CakeFace"]; cake.Add(tmp); } closedb(); }