예제 #1
0
        /// <summary>
        /// 請求締処理よりデータ抽出時に使用
        /// </summary>
        /// <param name="dme"></param>
        /// <returns></returns>
        public DataTable D_BillingProcessing_SelectAll(D_BillingProcessing_Entity dme)
        {
            string sp = "D_BillingProcessing_SelectAll";

            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@StoreCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = dme.StoreCD
                  } },
            };

            return(SelectData(dic, sp));
        }
예제 #2
0
        /// <summary>
        /// 締処理済の場合(以下のSelectができる場合)Error
        /// </summary>
        /// <param name="de"></param>
        /// <returns></returns>
        public bool CheckBillingDate(D_BillingProcessing_Entity de)
        {
            D_BillingProcessing_DL dpd = new D_BillingProcessing_DL();
            DataTable dt = dpd.CheckBillingDate(de);

            bool ret = false;

            if (dt.Rows.Count > 0)
            {
                de.ProcessingNO = dt.Rows[0]["ProcessingNO"].ToString();
                ret             = true;
            }

            return(ret);
        }
예제 #3
0
        /// <summary>
        /// 締処理済の場合(以下のSelectができる場合)Error
        /// </summary>
        /// <param name="de"></param>
        /// <returns></returns>
        public DataTable CheckBillingDate(D_BillingProcessing_Entity de)
        {
            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@StoreCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = de.StoreCD
                  } },
                { "@CustomerCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = de.CustomerCD
                  } },
                { "@BillingDate", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = de.BillingDate
                  } }
            };

            return(SelectData(dic, "CheckBillingDate"));
        }
예제 #4
0
        protected override void ExecDisp()
        {
            D_BillingProcessing_Entity dbe = new D_BillingProcessing_Entity
            {
                StoreCD = CboStoreCD.SelectedValue.ToString()
            };

            DataTable dt = ssbl.D_BillingProcessing_SelectAll(dbe);

            GvDetail.DataSource = dt;

            if (dt.Rows.Count > 0)
            {
                GvDetail.SelectionMode       = DataGridViewSelectionMode.RowHeaderSelect;
                GvDetail.CurrentRow.Selected = true;
                GvDetail.Enabled             = true;
                //GvDetail.Focus();
            }
            else
            {
                //ssbl.ShowMessage("E128");
            }
        }