Beispiel #1
0
        /// <summary>
        /// Bindings the list.
        /// </summary>
        /// <param name="status">The status.</param>
        private void BindingList(EnumHelper.Status status)
        {
            SqlDataReader reader;

            reader = this.DataSource(EnumHelper.Status.Draft.ToString("d"), false);
            this.BindingHoldingList(reader);
        }
        /// <summary>
        /// Findings the order number.
        /// </summary>
        private void FindingOrderNumber()
        {
            this.errorProvider.SetError(this.txtOrderNumber, string.Empty);
            if (this.txtOrderNumber.Text.Trim().Length > 0)
            {
                using (var ctx = new EF6.RT2020Entities())
                {
                    var objHeader = ctx.PurchaseOrderHeader.Where(x => x.OrderNumber.Contains(this.txtOrderNumber.Text.Trim())).AsNoTracking().FirstOrDefault();
                    if (objHeader != null)
                    {
                        EnumHelper.Status objStatus = (EnumHelper.Status)Enum.Parse(typeof(EnumHelper.Status), objHeader.Status.ToString());
                        switch (objStatus)
                        {
                        case EnumHelper.Status.Draft:     // Holding
                            this.tabREJAuthorization.SelectedIndex = 1;
                            break;

                        case EnumHelper.Status.Active:     // Posting
                            this.tabREJAuthorization.SelectedIndex = 0;
                            break;
                        }

                        this.BindingList(objStatus);
                    }
                    else
                    {
                        this.errorProvider.SetError(this.txtOrderNumber, "Cash Purchase Number field does not exist!");
                    }
                }
            }
            else
            {
                this.errorProvider.SetError(this.txtOrderNumber, "Cash Purchase Number field cannot be blank!");
            }
        }
        /// <summary>
        /// Bindings the list.
        /// </summary>
        /// <param name="status">The status.</param>
        private void BindingList(EnumHelper.Status status)
        {
            SqlDataReader reader;

            switch (status)
            {
            case EnumHelper.Status.Draft:     //// Holding
                reader = this.DataSource(EnumHelper.Status.Draft.ToString("d"), false);
                this.BindingHoldingList(reader);
                break;

            case EnumHelper.Status.Active:     //// Posting
                reader = this.DataSource(EnumHelper.Status.Active.ToString("d"), true);
                this.BindingPostingList(reader);
                break;

            default:
                break;
            }
        }
Beispiel #4
0
        private void FindingTxNumber()
        {
            errorProvider.SetError(txtTxNumber, string.Empty);
            if (txtTxNumber.Text.Trim().Length > 0)
            {
                using (var ctx = new EF6.RT2020Entities())
                {
                    //string sql = "TxNumber LIKE '%" + txtTxNumber.Text.Trim() + "%'";
                    var oHeader = ctx.StockTakeHeader.Where(x => x.TxNumber.Contains(txtTxNumber.Text.Trim())).AsNoTracking().FirstOrDefault();
                    if (oHeader != null)
                    {
                        EnumHelper.Status oStatus = (EnumHelper.Status)Enum.Parse(typeof(EnumHelper.Status), oHeader.Status.ToString());
                        switch (oStatus)
                        {
                        case EnumHelper.Status.Draft:     // Holding
                            tabSTKAuthorization.SelectedIndex = 1;
                            BindingHoldingList();
                            break;

                        case EnumHelper.Status.Active:     // Posting
                            tabSTKAuthorization.SelectedIndex = 0;
                            BindingPostingList();
                            break;
                        }
                    }
                    else
                    {
                        errorProvider.SetError(txtTxNumber, "StockTake Number field does not exist!");
                    }
                }
            }
            else
            {
                errorProvider.SetError(txtTxNumber, "StockTake Number field cannot be blank!");
            }
        }