DAL/Base/ComputationUnit/ComputationUnit.cs

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

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

using System;
using System.Data;
using Common;

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

        public void ClearData(System.Data.Common.DbCommand cmd)
        {
            str = "delete from ComputationUnit";
            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("ComputationUnit", cmd) == false)
                {
                    if (DataBase.Provider == DataBase.DataProvider.AccessClient)
                    {
                        str = "CREATE TABLE [ComputationUnit] (" + "[cComUnitCode] text(20)  ," + "[cComUnitName] text(20)  ," + "[cComGroupCode] text(20) ," + "[bMainUnit] bit ," + "[iChangeRate] float " + ")";
                        DataBase.execCmd(str, cmd);
                    }
                    else if (DataBase.Provider == DataBase.DataProvider.SqlClient)
                    {
                        str = "CREATE TABLE [dbo].[ComputationUnit] (" + "[cComUnitCode] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ," + "[cComUnitName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ," + "[cComGroupCode] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ," + "[bMainUnit] [bit] NULL ," + "[iChangeRate] [float] NULL " + ") ON [PRIMARY]";
                        DataBase.execCmd(str, cmd);
                    }
                }
            }
            catch (Exception ex)
            {
                Common.Debug.myMsg(ex.Message, "");
            }
        }