C# (CSharp) DAL DC.NewCmd_usp_ServiceType_SelectAll 예제들

예제 #1

        /// <summary>
        ///
        /// </summary>
        /// <returns>int</returns>
        public static int usp_ServiceType_SelectAll()
        {
            SqlCommand cmd = DC.NewCmd_usp_ServiceType_SelectAll();

            SQLHelper.ExecuteNonQuery(cmd);
            string s = cmd.Parameters["RETURN_VALUE"].Value.ToString();

            if (string.IsNullOrEmpty(s))
            {
                return(0);
            }
            return(int.Parse(s));
        }

예제 #2

        /// <summary>
        ///
        /// </summary>
        /// <returns>int</returns>
        public static int usp_ServiceType_SelectAll(DI.usp_ServiceType_SelectAllParameters p)
        {
            SqlCommand cmd = DC.NewCmd_usp_ServiceType_SelectAll(p);

            SQLHelper.ExecuteNonQuery(cmd);
            string s = cmd.Parameters["RETURN_VALUE"].Value.ToString();

            if (string.IsNullOrEmpty(s))
            {
                p.SetReturnValue(0);
                return(0);
            }
            else
            {
                p.SetReturnValue(int.Parse(s));
                return(p._ReturnValue);
            }
        }