Пример #1
0
        /// <summary>
        /// 定时发送更改数据库
        /// </summary>
        /// <param name="MessageID"></param>
        /// <param name="ErrorCode"></param>
        /// <param name="Id"></param>
        /// <returns></returns>
        public int PushTimingUpdateStatu(long MessageID, int ErrorCode, int Id)
        {
            string sql = @"UPDATE dbo.SC_APPPush SET MessageID=@MessageID,ErrorCode=@ErrorCode WHERE Id=@Id";

            SqlParameter[] para = new SqlParameter[]
            {
                new SqlParameter("@MessageID", SqlDbType.BigInt)
                {
                    Value = MessageID
                },
                new SqlParameter("@ErrorCode", SqlDbType.Int)
                {
                    Value = ErrorCode
                },
                new SqlParameter("@Id", SqlDbType.Int)
                {
                    Value = Id
                }
            };
            if (SqlDBProvider.ExecuteNonQuery(sql, para) > 0)
            {
                return(1);
            }
            else
            {
                return(0);
            }
        }