DAL/Base/BaseRecord/BaseRecord.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using Common;

namespace DAL.Base.BaseRecord
{
    /// <summary>
    /// 基础档案
    /// </summary>
    /// <remarks></remarks>
    public class BaseRecord
    {
        private string str;
        /// <summary>
        /// 创建实例
        /// </summary>
        /// <returns></returns>
        /// <remarks></remarks>
        public static BaseRecord Create()
        {
            return new BaseRecord();
        }

        public void ClearData(System.Data.Common.DbCommand cmd)
        {
            str = "delete from BaseRecord";
            DataBase.execCmd(str, cmd);
        }
        /// <summary>
        /// 执行最新升级
        /// </summary>
        /// <remarks></remarks>
        public void UpgradeNew(System.Data.Common.DbCommand cmd)
        {
            this.Upgrade20090906(cmd);
        }

        private void Upgrade20090906(System.Data.Common.DbCommand cmd)
        {
            this.Upgrade20090428(cmd);
            try
            {
                if (DataBase.Provider == DataBase.DataProvider.AccessClient)
                {
                    str = "alter table BaseRecord alter column cName text(100)";
                    DataBase.execCmd(str, cmd);
                }
                else if (DataBase.Provider == DataBase.DataProvider.SqlClient)
                {
                    str = "alter table BaseRecord alter column cName nvarchar(100)";
                    DataBase.execCmd(str, cmd);
                }
            }
            catch (Exception ex)
            {
                Common.Debug.myMsg(ex.Message, "");
            }
        }

        private void Upgrade20090428(System.Data.Common.DbCommand cmd)