コード例 #1
0
        public wndw_OrderHistory(DatabaseConnection conn, string username)
        {
            InitializeComponent();
            this.conn = conn;
            userID = GetUserID(username);
            dataGrid.IsReadOnly = true;

            list = conn.ReadData("SELECT Date, Orders.ID FROM Orders WHERE Orders.Users_ID = " + userID);
            int counter = 1;
            for (int i = 0; i < list.Count; i += 2)
            {
                comboBox.Items.Add(counter + ". " + list[i].Substring(0, list[i].IndexOf(" ")));
                counter++;
            }
        }
コード例 #2
0
        public void Init(DatabaseConnection conn)
        {
            this.conn = conn;
            shipmnetsList = new List<Shipment>();

            List<string> list = conn.ReadData("select ID, Name, Price from Shipping_methods");
            for (int i = 0; i < list.Count; i += 3)
            {
                decimal result = decimal.Parse(list[i + 2], CultureInfo.InvariantCulture);
                Shipment s = new Shipment(Convert.ToInt32(list[i]), list[i + 1], result);
                shipmnetsList.Add(s);
            }
            foreach (Shipment s in shipmnetsList)
                comboBox.Items.Add(s.Name);
        }