예제 #1
0
        public bool Fnc_Reserve(Fnc_Reserve_Entity fre)
        {
            Function_DL fdl = new Function_DL();
            DataTable   dt  = fdl.Fnc_Reserve(fre);

            if (dt.Rows.Count > 0)
            {
                fre.Result           = dt.Rows[0]["Result"].ToString();
                fre.Error            = dt.Rows[0]["Error"].ToString();
                fre.LastDay          = dt.Rows[0]["LastDay"].ToString();
                fre.OutKariHikiateNo = dt.Rows[0]["OutKariHikiateNo"].ToString();

                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #2
0
        /// <summary>
        /// 商品引当処理
        /// </summary>
        /// <param name="fre"></param>
        /// <returns></returns>
        public DataTable Fnc_Reserve(Fnc_Reserve_Entity fre)
        {
            string sp = "Fnc_Reserve";
            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@AdminNO", new ValuePair {
                      value1 = SqlDbType.Int, value2 = fre.AdminNO
                  } },
                { "@ChangeDate", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = fre.ChangeDate
                  } },
                { "@StoreCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = fre.StoreCD
                  } },
                { "@SoukoCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = fre.SoukoCD
                  } },
                { "@Suryo", new ValuePair {
                      value1 = SqlDbType.Int, value2 = fre.Suryo
                  } },
                { "@DenType", new ValuePair {
                      value1 = SqlDbType.TinyInt, value2 = fre.@DenType
                  } },
                { "@DenNo", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = fre.@DenNo
                  } },
                { "@DenGyoNo", new ValuePair {
                      value1 = SqlDbType.Int, value2 = fre.@DenGyoNo
                  } },
                { "@KariHikiateNo", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = fre.@KariHikiateNo
                  } }
            };

            return(SelectData(dic, sp));
        }