User/Dal/Upgrade.cs

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

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

using System;
using Common;

namespace User.Dal
{
    /// <summary>
    /// 升级
    /// </summary>
    /// <remarks></remarks>
    public class Upgrade
    {
        private static string str;
        public static Upgrade Create()
        {
            return new Upgrade();
        }
        /// <summary>
        /// 执行最新升级
        /// </summary>
        /// <remarks></remarks>
        public void UpgradeNew(System.Data.Common.DbCommand cmd)
        {
            this.Upgrade20090106(cmd);
        }

        private void Upgrade20090106(System.Data.Common.DbCommand cmd)
        {
            this.Upgrade20081216(cmd);
            try
            {
                if (DataBase.ExistField("__Users", "bStop", cmd) == false)
                {
                    if (DataBase.Provider == DataBase.DataProvider.AccessClient)
                    {
                        str = "alter table __Users " + "add bStop bit";
                        DataBase.execCmd(str, cmd);
                    }
                    else if (DataBase.Provider == DataBase.DataProvider.SqlClient)
                    {
                        str = "alter table __Users " + "add bStop bit";
                        DataBase.execCmd(str, cmd);
                    }
                }
            }
            catch (Exception ex)
            {
                Common.Debug.myMsg(ex.Message, "");
            }
        }

        private void Upgrade20081216(System.Data.Common.DbCommand cmd)
        {
            try
            {
                if (DataBase.ExistTable("__Users", cmd) == false)
                {
                    if (DataBase.Provider == DataBase.DataProvider.AccessClient)
                    {
                        str = "CREATE TABLE [__Users] (" + "[cName] text(20) NOT NULL ," + "[cPW] text(20)," + "[bAdm] bit," + "[cMemo] text(100) " + ")";
                        DataBase.execCmd(str, cmd);