C# (CSharp) DAL DbHelperMySQL.ExecuteScalar Exemples

Exemple #1

        /// <summary>
        /// 判断是否交易日(返回0表示是交易日)
        /// </summary>
        /// <returns></returns>
        public int GetIsWeek(DateTime dt)
        {
            MySqlParameter par1 = new MySqlParameter("@in_day", MySqlDbType.DateTime);

            par1.Value     = dt.ToString("yyyy-MM-dd");
            par1.Direction = ParameterDirection.Input;

            MySqlParameter par2 = new MySqlParameter("@return_value", MySqlDbType.Int32, 11);

            par2.Direction = ParameterDirection.ReturnValue;
            MySqlParameter[] parameters = { par1, par2 };

            var sd = DbHelperMySQL.ExecuteScalar("f_isweek", parameters);

            return((int)par2.Value);
        }