Exemple #1
0
        /// <summary>
        /// 实体更新可用状态
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="entity"></param>
        /// <returns></returns>
        public void UpdateState <T>(int state, string key_value)
        {
            string tableName  = EntityAttribute.GetEntityTable <T>();
            string columName  = DatabaseCommon.GetEnableColumn <T>();
            string primaryKey = DatabaseCommon.GetKeyField <T>().ToString();

            SqlParameter[] paramsMenber =
            {
                new SqlParameter("@TABLE",      tableName),
                new SqlParameter("@COLUMN",     columName),
                new SqlParameter("@STATE",      state),
                new SqlParameter("@PRIMARYKEY", primaryKey),
                new SqlParameter("@KEY_VALUE",  key_value)
            };
            ExecuteByProcReturn("P_UPDATESTATE", paramsMenber);
        }