C# (CSharp) inv SQL_TASKS.load_data示例

示例#1

        public override void search_textBox_TextChanged(object sender, EventArgs e)
        {
            if (search_textBox.Text != "")
            {
                ListBox lb = new ListBox();

                lb.Items.Add(supplierIDGV);

                lb.Items.Add(suppliernameGV);

                lb.Items.Add(contactpersonnameGV);

                lb.Items.Add(phone1GV);

                lb.Items.Add(phone2GV);

                lb.Items.Add(addressGV);

                lb.Items.Add(ntnGV);

                lb.Items.Add(statusGV);

                Hashtable ht = new Hashtable();

                ht.Add("@data", search_textBox.Text);

                SQL_TASKS.load_data("st_searchSUPPLIERS", suppliers_dataGridView, lb, ht);
            }
            else
            {
                loadSuppliers();
            }
        }

示例#2

文件： Products.cs 项目： SyedHassaanAli880/Inventory-Management-System

        public override void search_textBox_TextChanged(object sender, EventArgs e)
        {
            if (search_textBox.Text != "")
            {
                ListBox lb = new ListBox();

                lb.Items.Add(productidGV);

                lb.Items.Add(productnameGV);

                lb.Items.Add(productbarcodeGV);

                lb.Items.Add(expirydateGV);

                lb.Items.Add(categoryIDGV);

                lb.Items.Add(productcategoryGV);

                Hashtable ht = new Hashtable();

                ht.Add("@data", search_textBox.Text);

                SQL_TASKS.load_data("st_searchPRODUCTS", products_dataGridView, lb, ht);
            }
            else
            {
                LoadProducts();
            }
        }

示例#3

文件： STOCK.cs 项目： SyedHassaanAli880/Inventory-Management-System

        private void STOCK_Load(object sender, EventArgs e)
        {
            ListBox lb = new ListBox();

            lb.Items.Add(productidGV);

            lb.Items.Add(productnameGV);

            lb.Items.Add(productbarcodeGV);

            lb.Items.Add(productbuyingpriceGV);

            lb.Items.Add(BuyingDateGV);

            lb.Items.Add(expirydateGV);

            lb.Items.Add(productcategoryGV);

            lb.Items.Add(availablestockGV);

            lb.Items.Add(statusGV);

            SQL_TASKS.load_data("st_getSTOCK", stocks_dataGridView, lb);

            //foreach(DataGridViewRow row in stocks_dataGridView.Rows)
            //{
            //    if(Convert.ToInt32(row.Cells["availablestockGV"].Value) == 0)
            //    {
            //        stocks_dataGridView.Columns["availablestockGV"].DefaultCellStyle.BackColor = Color.Red;

            //        //row.Cells["availablestockGV"].Style.BackColor = Color.Red;
            //        //row.DefaultCellStyle.BackColor = Color.Red;
            //    }
            //}
        }

示例#4

文件： STOCK.cs 项目： SyedHassaanAli880/Inventory-Management-System

        public void LoadStocks()
        {
            ListBox lb = new ListBox();

            lb.Items.Add(productidGV);

            lb.Items.Add(productnameGV);

            lb.Items.Add(productbarcodeGV);

            //lb.Items.Add(PerUnitPriceGV);

            lb.Items.Add(productbuyingpriceGV);

            lb.Items.Add(BuyingDateGV);

            lb.Items.Add(expirydateGV);

            lb.Items.Add(productcategoryGV);

            lb.Items.Add(availablestockGV);

            lb.Items.Add(statusGV);

            SQL_TASKS.load_data("st_getSTOCK", stocks_dataGridView, lb);
        }

示例#5

        public void LoadCategory()
        {
            ListBox lb = new ListBox();

            lb.Items.Add(categoryidGV);

            lb.Items.Add(categorynameGV);

            lb.Items.Add(categorystatusGV);

            SQL_TASKS.load_data("st_getcategoriesdata", categories_dataGridView, lb);
        }

示例#6

文件： Products.cs 项目： SyedHassaanAli880/Inventory-Management-System

        void LoadProducts()
        {
            ListBox lb = new ListBox();

            lb.Items.Add(productidGV);

            lb.Items.Add(productnameGV);

            lb.Items.Add(productbarcodeGV);

            lb.Items.Add(expirydateGV);

            lb.Items.Add(categoryIDGV);

            lb.Items.Add(productcategoryGV);

            SQL_TASKS.load_data("st_getPRODUCTS", products_dataGridView, lb);
        }

示例#7

文件： STOCK.cs 项目： SyedHassaanAli880/Inventory-Management-System

        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            if (search_stock_textBox.Text != "")
            {
                ListBox lb = new ListBox();

                lb.Items.Add(productnameGV);

                Hashtable ht = new Hashtable();

                ht.Add("@data", search_stock_textBox.Text);

                SQL_TASKS.load_data("st_searchSTOCKS", stocks_dataGridView, lb, ht);
            }
            else
            {
                LoadStocks();
            }
        }

示例#8

文件： users.cs 项目： SyedHassaanAli880/Inventory-Management-System

        public void loadUsers()
        {
            ListBox lb = new ListBox();

            lb.Items.Add(useridGV);

            lb.Items.Add(nameGV);

            lb.Items.Add(emailGV);

            lb.Items.Add(passwordGV);

            lb.Items.Add(phonenumberGV);

            lb.Items.Add(statusGV);

            lb.Items.Add(roleGV);

            SQL_TASKS.load_data("st_getusersdata", users_dataGridView, lb);
        }

示例#9

文件： users.cs 项目： SyedHassaanAli880/Inventory-Management-System

        private void search_textBox_TextChanged_1(object sender, EventArgs e)
        {
            if (search_textBox.Text != "")
            {
                ListBox lb = new ListBox();

                lb.Items.Add(useridGV);

                lb.Items.Add(nameGV);

                lb.Items.Add(emailGV);

                lb.Items.Add(passwordGV);

                lb.Items.Add(phonenumberGV);

                lb.Items.Add(statusGV);

                lb.Items.Add(roleGV);

                Hashtable ht = new Hashtable();

                ht.Add("@data", search_textBox.Text);

                SQL_TASKS.load_data("st_searchUSERS", users_dataGridView, lb, ht);

                if (users_dataGridView.Rows.Count == 0)
                {
                    not_found_label.Visible = true;
                }
                else
                {
                    not_found_label.Visible = false;
                }
            }
            else
            {
                loadUsers();
            }
        }

示例#10

文件： SALES RETURN.cs 项目： SyedHassaanAli880/Inventory-Management-System

        void LoadSales()
        {
            var ht = new Hashtable();

            ht.Add("@saleID", Convert.ToInt64(sale_ID_textBox.Text));

            var lb = new ListBox();

            lb.Items.Add(saleIDGV);

            lb.Items.Add(BarcodeGV);

            lb.Items.Add(ProductGV);

            lb.Items.Add(QuantityGV);

            lb.Items.Add(TotalDiscountGV);

            lb.Items.Add(TotalAmountGV);

            lb.Items.Add(AmountGivenGV);

            lb.Items.Add(AmountReturnedGV);

            lb.Items.Add(DateGV);

            lb.Items.Add(ProductPriceGV);

            lb.Items.Add(PerProductDiscountGV);

            lb.Items.Add(PerProductTotalGV);

            lb.Items.Add(UserIDGV);

            lb.Items.Add(PaymentGV);

            lb.Items.Add(ProductIDGV);

            SQL_TASKS.load_data("st_getSalesReceiptwrtSalesID", sales_return_dataGridView, lb, ht);
        }

示例#11

        private void LoadPurchaseInvoiceDetails()
        {
            Hashtable ht = new Hashtable();

            ht.Add("@purchaseinvoiceID", Convert.ToInt64(purchaseinvoice_comboBox.SelectedValue));

            ListBox lb = new ListBox();

            lb.Items.Add(purchaseinvoiceIDGV);

            lb.Items.Add(productIDGV);

            lb.Items.Add(productnameGV);

            lb.Items.Add(productquantityGV);

            lb.Items.Add(perunitpriceGV);

            lb.Items.Add(totalGV);

            SQL_TASKS.load_data("st_getPURCHASEINVOICEDETAILS", purchaseinvoice_dataGridView, lb, ht);
        }

示例#12

        public void loadSuppliers()
        {
            ListBox lb = new ListBox();

            lb.Items.Add(supplierIDGV);

            lb.Items.Add(suppliernameGV);

            lb.Items.Add(contactpersonnameGV);

            lb.Items.Add(phone1GV);

            lb.Items.Add(phone2GV);

            lb.Items.Add(addressGV);

            lb.Items.Add(ntnGV);

            lb.Items.Add(statusGV);

            SQL_TASKS.load_data("st_getSUPPLIERS", suppliers_dataGridView, lb);
        }

示例#13

        void LoadProducts()
        {
            Hashtable ht = new Hashtable();

            ht.Add("@categID", Convert.ToInt32(category_comboBox_product_pricing.SelectedValue));

            ListBox lb = new ListBox();

            lb.Items.Add(productIDGV);

            lb.Items.Add(productnameGV);

            lb.Items.Add(buyingpriceGV);

            lb.Items.Add(PerUnitPriceGV);

            lb.Items.Add(QuantityGV);

            lb.Items.Add(BarcodeGV);

            SQL_TASKS.load_data("getPRODUCTSwrtCATEGORIES", product_pricing_dataGridView, lb, ht);
        }

示例#14

        public override void search_textBox_TextChanged(object sender, EventArgs e)
        {
            if (search_textBox.Text != "")
            {
                ListBox lb = new ListBox();

                lb.Items.Add(categoryidGV);

                lb.Items.Add(categorynameGV);

                lb.Items.Add(categorystatusGV);

                Hashtable ht = new Hashtable();

                ht.Add("@data", search_textBox.Text);

                SQL_TASKS.load_data("st_searchCATEGORIES", categories_dataGridView, lb, ht);
            }
            else
            {
                LoadCategory();
            }
        }

示例#15

        void LoadSalesDetails()
        {
            var ht = new Hashtable();

            ht.Add("@date", dateTimePicker_sales.Value);

            var lb = new ListBox();

            lb.Items.Add(saleIDGV);

            lb.Items.Add(TotalAmountGV);

            lb.Items.Add(AmountGivenGV);

            lb.Items.Add(AmountReturnedGV);

            lb.Items.Add(UserGV);

            lb.Items.Add(TotalDiscountGV);

            lb.Items.Add(UserIDGV);

            SQL_TASKS.load_data("st_GetDailySales", sales_details_dataGridView, lb, ht);
        }