コード例 #1
0
        /// <summary>
        /// プレゼント判断Function
        /// </summary>
        /// <param name="fre"></param>
        /// <returns></returns>
        public DataTable Fnc_Present(Fnc_Present_Entity fre)
        {
            string sp = "Fnc_Present";
            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
                  } }
            };

            return(SelectData(dic, sp));
        }
コード例 #2
0
        public bool Fnc_Present(Fnc_Present_Entity fpe)
        {
            Function_DL fdl = new Function_DL();
            DataTable   dt  = fdl.Fnc_Present(fpe);

            if (dt.Rows.Count > 0)
            {
                fpe.outPresentCD1 = dt.Rows[0]["PresentCD1"].ToString();
                fpe.outPresentCD2 = dt.Rows[0]["PresentCD2"].ToString();
                fpe.outPresentCD3 = dt.Rows[0]["PresentCD3"].ToString();
                fpe.outPresentCD4 = dt.Rows[0]["PresentCD4"].ToString();
                fpe.outPresentCD5 = dt.Rows[0]["PresentCD5"].ToString();

                return(true);
            }
            else
            {
                return(false);
            }
        }