DAL/Base/ComputationUnit/ComputationGroup.cs

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

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

using System;
using System.Data;
using Common;

namespace DAL.Base.ComputationUnit
{
    /// <summary>
    /// 计量单位组
    /// </summary>
    /// <remarks></remarks>
    public class ComputationGroup
    {
        private string str;
        /// <summary>
        /// 创建实例
        /// </summary>
        /// <returns></returns>
        /// <remarks></remarks>
        public static ComputationGroup Create()
        {
            return new ComputationGroup();
        }

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

        private void Upgrade20090428(System.Data.Common.DbCommand cmd)
        {
            try
            {
                if (DataBase.ExistTable("ComputationGroup", cmd) == false)
                {
                    if (DataBase.Provider == DataBase.DataProvider.AccessClient)
                    {
                        str = "CREATE TABLE [ComputationGroup] (" + "[cComGroupCode] text(20) ," + "[cComGroupName] text(20) ," + "[iType] int " + ") ";
                        DataBase.execCmd(str, cmd);
                    }
                    else if (DataBase.Provider == DataBase.DataProvider.SqlClient)
                    {
                        str = "CREATE TABLE [dbo].[ComputationGroup] (" + "[cComGroupCode] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ," + "[cComGroupName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ," + "[iType] [int] NULL " + ") ON [PRIMARY]";
                        DataBase.execCmd(str, cmd);
                    }
                }
            }
            catch (Exception ex)
            {
                Common.Debug.myMsg(ex.Message, "");
            }
        }