Exemplo n.º 1
0
        private void phraseLoadData()
        {
            dgvPhrase.Rows.Clear();
            DataGridViewRowCollection rows = dgvPhrase.Rows;
            PhraseInfo view = new PhraseInfo(APConfig.Conn);

            view.Conditions  = " 1=1 ";
            view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.category.ToString(), ddlPhraseCategory.SelectedItem.ToString());
            if (!string.IsNullOrEmpty(txtPhraseName.Text))
            {
                view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.name.ToString(), txtPhraseName.Text);
            }
            if (!string.IsNullOrEmpty(txtPhraseType.Text))
            {
                view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.type.ToString(), txtPhraseType.Text);
            }
            if (view.load())
            {
                while (!view.IsEof)
                {
                    rows.Add(new Object[] { view.PHS_SERNO, view.PHS_NAME, view.PHS_TYPE, view.PHS_INDEX });
                    view.next();
                }
            }
            lblPhraseTotal.Text = view.calculateCount().ToString();
        }
Exemplo n.º 2
0
        private void ItemSearch()
        {
            lbxItem.Items.Clear();
            PhraseInfo view = new PhraseInfo(APConfig.Conn);

            view.Conditions  = " 1=1 ";
            view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.category.ToString(), PhraseCategory.銷售商品資訊.ToString());
            if (!string.IsNullOrEmpty(txtName.Text))
            {
                view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.name.ToString(), txtName.Text);
            }
            view.load();
            while (!view.IsEof)
            {
                lbxItem.Items.Add(view.PHS_TYPE + view.PHS_NAME);
                view.next();
            }
        }
Exemplo n.º 3
0
        public static ComboBox loadPhrase(ComboBox c, string category, bool isALL = false)
        {
            c.Items.Clear();
            if (isALL)
            {
                c.Items.Add("全部");
            }
            PhraseInfo view = new PhraseInfo(APConfig.Conn);

            view.Conditions  = " 1=1 ";
            view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.category.ToString(), category);
            view.load();
            while (!view.IsEof)
            {
                c.Items.Add(view.PHS_NAME);
                view.next();
            }
            return(c);
        }
Exemplo n.º 4
0
        private void ItemSearch()
        {
            dgvItem.Rows.Clear();
            DataGridViewRowCollection rows = dgvItem.Rows;
            PhraseInfo view = new PhraseInfo(APConfig.Conn);

            view.Conditions  = " 1=1 ";
            view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.category.ToString(), PhraseCategory.商品資訊.ToString());
            if (!string.IsNullOrEmpty(txtName.Text))
            {
                view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.name.ToString(), txtName.Text);
            }
            view.load();
            while (!view.IsEof)
            {
                rows.Add(new Object[] { view.PHS_NAME, view.PHS_TYPE, view.PHS_COLOR, view.PHS_SIZE });
                view.next();
            }
        }