示例#1
0
        /// <summary>
        ///  更新一条数据
        /// </summary>
        public static bool Check(UserPayBankAppInfo model)
        {
            try
            {
                int            rowsAffected = 0;
                SqlParameter[] parameters   =
                {
                    new SqlParameter("@id",       SqlDbType.Int,       4),
                    new SqlParameter("@status",   SqlDbType.TinyInt,   1),
                    new SqlParameter("@SureTime", SqlDbType.DateTime),
                    new SqlParameter("@SureUser", SqlDbType.Int, 4)
                };
                parameters[0].Value = model.id;
                parameters[1].Value = (int)model.status;
                parameters[2].Value = model.SureTime;
                parameters[3].Value = model.SureUser;

                rowsAffected = DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_userspaybankapp_Check", parameters);
                if (rowsAffected > 0)
                {
                    UserFactory.ClearCache(model.userid);
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(ex);
                return(false);
            }
        }