示例#1
0
        private void SaleSpendRatio_Load(object sender, EventArgs e)
        {
            m_OrderSet = m_DataSet;
            SetupBindingSource();
            var productAdapter       = new VoucherExpense.DamaiDataSetTableAdapters.ProductTableAdapter();
            var ingredientAdapter    = new VoucherExpense.DamaiDataSetTableAdapters.IngredientTableAdapter();
            var voucherAdapter       = new VoucherExpense.DamaiDataSetTableAdapters.VoucherTableAdapter();
            var voucherDetailAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VoucherDetailTableAdapter();

            productAdapter.Connection.ConnectionString    = DB.SqlConnectString(MyFunction.HardwareCfg);
            ingredientAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);


            try
            {
                productAdapter.Fill(m_OrderSet.Product);
                ingredientAdapter.Fill(m_DataSet.Ingredient);
                voucherAdapter.Fill(m_DataSet.Voucher);
                voucherDetailAdapter.Fill(m_DataSet.VoucherDetail);
            }
            catch (Exception ex)
            {
                MessageBox.Show("資料庫讀取錯誤<" + ex.Message + ">, 後續操作無法進行!");
                Close();
                return;
            }
            cSaleItemBindingSource.DataSource = m_SaleList;
            this.dgViewSale.DataSource        = cSaleItemBindingSource;
            stockItemBindingSource.DataSource = m_StockList;
            this.dgViewStock.DataSource       = stockItemBindingSource;
            Reload();
        }
示例#2
0
        private void ReportByVender_Load(object sender, EventArgs e)
        {
            SetupBindingSource();
            var vendorAdapter        = new VoucherExpense.DamaiDataSetTableAdapters.VendorTableAdapter();
            var voucherAdapter       = new VoucherExpense.DamaiDataSetTableAdapters.VoucherTableAdapter();
            var voucherDetailAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VoucherDetailTableAdapter();
            var IngredientAdapter    = new VoucherExpense.DamaiDataSetTableAdapters.IngredientTableAdapter();

            vendorAdapter.Connection.ConnectionString     = DB.SqlConnectString(MyFunction.HardwareCfg);
            IngredientAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);

            try
            {
                vendorAdapter.Fill(m_DataSet.Vendor);
                voucherAdapter.Fill(m_DataSet.Voucher);
                voucherDetailAdapter.Fill(m_DataSet.VoucherDetail);
                IngredientAdapter.Fill(m_DataSet.Ingredient);
            }
            catch (Exception ex)
            {
                MessageBox.Show("載入資料庫發生錯誤! 原因:" + ex.Message);
            }
            vendors.Add(new CNameIDForComboBox(0, " "));
            foreach (var v in m_DataSet.Vendor)
            {
                vendors.Add(new CNameIDForComboBox(v.VendorID, v.Name));
            }
            vendors.Add(new CNameIDForComboBox(int.MaxValue, "全部"));
            vendorIDComboBox.DataSource   = vendors;
            cbBoxMonth.SelectedIndex      = DateTime.Now.Month;
            this.voucherDGView.DataSource = null;  // 原本先用了 vEDataSet.Voucher做格式
        }
示例#3
0
        private void Voucher_Load(object sender, EventArgs e)
        {
            var accountingTitleAdapter = new VoucherExpense.DamaiDataSetTableAdapters.AccountingTitleTableAdapter();
            var vendorAdapter          = new VoucherExpense.DamaiDataSetTableAdapters.VendorTableAdapter();
            var operatorAdapter        = new VoucherExpense.DamaiDataSetTableAdapters.OperatorTableAdapter();

            IngredientAdapter.Connection.ConnectionString      = DB.SqlConnectString(MyFunction.HardwareCfg);
            vendorAdapter.Connection.ConnectionString          = DB.SqlConnectString(MyFunction.HardwareCfg);
            operatorAdapter.Connection.ConnectionString        = DB.SqlConnectString(MyFunction.HardwareCfg);
            accountingTitleAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);

            SetupBindingSource();
            try
            {
                voucherDetailAdapter.Fill(m_DataSet.VoucherDetail);
                operatorAdapter.Fill(m_DataSet.Operator);
                IngredientAdapter.Fill(m_DataSet.Ingredient);
                accountingTitleAdapter.Fill(m_DataSet.AccountingTitle);
                vendorAdapter.Fill(m_DataSet.Vendor);
                voucherAdapter.Fill(m_DataSet.Voucher);
                MyFunction.SetControlLengthFromDB(this, m_DataSet.Voucher);
            }
            catch (Exception ex)
            {
                MessageBox.Show("載入資料出錯:" + ex.Message);
            }

            if (checkMode)
            {
                this.Text = "查核進貨";
                blockEdit();
                dgvVoucher.Columns["columnCheck"].ReadOnly = false;
                ckBoxAllowEdit.Visible = true;
            }
            if (MyFunction.LockAll)
            {
                blockEdit();
                ckBoxAllowEdit.Visible = false;
            }
            if (MyFunction.IntHeaderYear != DateTime.Now.Year)
            {
                comboBoxMonth.SelectedIndex = comboBoxMonth.Items.Count - 1;
            }
            else
            {
                comboBoxMonth.SelectedIndex = DateTime.Now.Month;
            }
            //           this.btnEditable.BringToFront();
            BuildTitleCodeMenu();
            dateTimePicker1.MaxDate = new DateTime(MyFunction.IntHeaderYear, 12, 31);
            dateTimePicker1.MinDate = new DateTime(MyFunction.IntHeaderYear, 1, 1);
        }
示例#4
0
        private void FormIngredientInventories_Load(object sender, EventArgs e)
        {
            SetupBindingSource();
            dgvInventories.DataSource     = inventoryBindingSource;
            dgvInventoryDetail.DataSource = fKInventoryDetailInventoryBindingSource;
            dgvProducts.DataSource        = fKInventoryProductsInventoryBindingSource;
            var productAdapter    = new VoucherExpense.DamaiDataSetTableAdapters.ProductTableAdapter();
            var operatorAdapter   = new VoucherExpense.DamaiDataSetTableAdapters.OperatorTableAdapter();
            var ingredientAdapter = new VoucherExpense.DamaiDataSetTableAdapters.IngredientTableAdapter();

            productAdapter.Connection.ConnectionString    = DB.SqlConnectString(MyFunction.HardwareCfg);
            operatorAdapter.Connection.ConnectionString   = DB.SqlConnectString(MyFunction.HardwareCfg);
            ingredientAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);

            try
            {
                productAdapter.Fill(m_OrderSet.Product);
                operatorAdapter.Fill(m_DataSet.Operator);
                ingredientAdapter.Fill(m_DataSet.Ingredient);

                InventoryAdapter.Fill(m_DataSet.Inventory);
                InventoryDetailAdapter.Fill(m_DataSet.InventoryDetail);
                InventoryProductsAdapter.Fill(m_DataSet.InventoryProducts);
            }
            catch (Exception ex)
            {
                MessageBox.Show("錯誤訊息:" + ex.Message);
            }
            ColumnLocked.ReadOnly = !MyFunction.LockInventory;
            if (MyFunction.LockInventory)
            {
                dgvColumnCurrentIn.Visible       = true;
                dgvColumnLostMoney.Visible       = true;
                dgvColumnPrevStockVolume.Visible = true;
            }
            else
            {
                dgvColumnCurrentIn.Visible       = false;
                dgvColumnLostMoney.Visible       = false;
                dgvColumnPrevStockVolume.Visible = false;
            }
            //            tabControl1.DrawMode = TabDrawMode.OwnerDrawFixed;
        }
示例#5
0
        private void Ingredient_Load(object sender, EventArgs e)
        {
            IngredientBindingSource.DataSource      = m_DataSet;
            vendorBindingSource.DataSource          = m_DataSet;
            accountingTitleBindingSource.DataSource = m_DataSet;
            m_PhotoDirectoryExist   = Directory.Exists(PhotoPath());
            photoPictureBox.Visible = true;
            var vendorAdapter          = new DamaiDataSetTableAdapters.VendorTableAdapter();
            var accountingTitleAdapter = new DamaiDataSetTableAdapters.AccountingTitleTableAdapter();

            IngredientAdapter.Connection.ConnectionString      = DB.SqlConnectString(MyFunction.HardwareCfg);
            vendorAdapter.Connection.ConnectionString          = DB.SqlConnectString(MyFunction.HardwareCfg);
            PhotoAdapter.Connection.ConnectionString           = DB.SqlConnectString(MyFunction.HardwareCfg);
            accountingTitleAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);

            try
            {
                vendorAdapter.Fill(m_DataSet.Vendor);
                m_VendorList.Add(new CNameIDForComboBox(0, ""));                                // 提到 .Fill(vEdataSet.Ingredient)之前,要不然第一次 BindingSource.CurrentChanged會先發生
                foreach (var vendor in m_DataSet.Vendor)
                {
                    m_VendorList.Add(new CNameIDForComboBox(vendor.VendorID, vendor.Name));
                }
                vendorIDComboBox.DataSource = m_VendorList;
                //vendorIDComboBox.ValueMember = "ID";
                //vendorIDComboBox.DisplayMember = "Name";
                accountingTitleAdapter.Fill(m_DataSet.AccountingTitle);
                IngredientAdapter.Fill(m_DataSet.Ingredient);
            }
            catch (Exception ex)
            {
                MessageBox.Show("錯誤:" + ex.Message);
            }

            MyFunction.SetFieldLength(dgvIngredient, m_DataSet.Ingredient);
            MyFunction.SetControlLengthFromDB(this, m_DataSet.Ingredient);
        }
示例#6
0
        private void FormRecipe_Load(object sender, EventArgs e)
        {
            var ingredientAdapter = new MyIngredientAdapter();

            productAdapter.Connection.ConnectionString      = DB.SqlConnectString(MyFunction.HardwareCfg);
            ingredientAdapter.Connection.ConnectionString   = DB.SqlConnectString(MyFunction.HardwareCfg);
            recipeAdapter.Connection.ConnectionString       = DB.SqlConnectString(MyFunction.HardwareCfg);
            recipeDetailAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
            PhotoAdapter.Connection.ConnectionString        = DB.SqlConnectString(MyFunction.HardwareCfg);
            try
            {
                recipeBindingSource.DataSource = m_DataSet;
                m_PhotoDirectoryExist          = Directory.Exists(PhotoPath());
                         // fKRecipeRecipeDetailBindingSource,damaiDataSet recipeSqlBindingSource創來抄的, 實際上沒用到
                fKRecipeRecipeDetailBindingSource.DataSource = recipeBindingSource;
                dgvRecipeDetail.DataSource      = fKRecipeRecipeDetailBindingSource;
                productBindingSource.DataSource = m_DataSet;
                productAdapter.Fill(m_DataSet.Product);

                recipeAdapter.Fill(m_DataSet.Recipe);
                recipeDetailAdapter.Fill(m_DataSet.RecipeDetail);
                ingredientAdapter.Fill(m_DataSet.Ingredient);
            }
            catch (Exception ex)
            {
                MessageBox.Show("載入產品食材及配方錯誤!原因:" + ex.Message);
            }
            // 填給使用者選的產品表, 第一個為空白
            m_ProductList = new List <CNameIDForComboBox>();
            m_ProductList.Add(new CNameIDForComboBox(0, " "));
            foreach (var product in m_DataSet.Product)
            {
                if (product.IsCodeNull())
                {
                    continue;
                }
                if (product.Code <= 0)
                {
                    continue;
                }
                m_ProductList.Add(new CNameIDForComboBox(product.ProductID, product.Name));
            }
            this.cNameIDForProductBindingSource.DataSource = m_ProductList;
            // 填 食材+配方表 (RecipeID +10000)
            m_SourceList = new List <CNameIDForComboBox>();
            foreach (var ing in m_DataSet.Ingredient)
            {
                string name;
                if (ing.IsNameNull())
                {
                    name = "食材" + ing.IngredientID.ToString();
                }
                else
                {
                    name = ing.Name;
                }
                if (!ing.CanPurchase)
                {
                    name = "**" + name;
                }
                m_SourceList.Add(new CNameIDForComboBox(ing.IngredientID, name));
            }
            foreach (var recipe in m_DataSet.Recipe)
            {
                //if (recipe.IsFinalProductIDNull() || recipe.FinalProductID <= 0)   // 該配方沒有最終產品,才列入
                {
                    string name = "配方:";
                    if (recipe.IsRecipeNameNull())
                    {
                        name += recipe.RecipeID.ToString();
                    }
                    else
                    {
                        name += recipe.RecipeName;
                    }
                    m_SourceList.Add(new CNameIDForComboBox(recipe.RecipeID + 10000, name));
                }
            }
            sourceBindingSource.DataSource = m_SourceList;
            ShowProductColumn(false);
        }