clssys_bzinst.cs

通过配置数据库连接并选择数据库表,可自动生成数据库表的实体类,并且实体类中包含记录集合,可在类中对各记录集合进行修改后一次性提交保存,支持事务.

using System;
using System.Data;
using System.Collections.Generic;
using System.Text;

namespace DBProvider
{
    class clsSys_BzInst : clsTableBase
    {
        protected override void SetTableAndKey()
        {
            mstrTable = "Sys_BzInst";
            mstrKeys = "Bi_Code";
        }

        private int mintBi_Auto;

        private int mintBi_Bizz;

        private string mstrBi_Clue;

        private string mstrBi_Code;

        private int mintBi_Flow;

        private string mstrBi_Name;

        private DateTime mdatBi_Over;

        private string mstrBi_Ownr;

        private string mstrBi_Rule;

        private string mstrBi_Same;

        private int mintBi_State;

        private DateTime mdatBi_Time;

        private int mintBi_Ver;

        private string mstrBi_Wave;


        public int Bi_Auto
        {
            get { return mintBi_Auto; }
            set { mintBi_Auto = value; }
        }

        public int Bi_Bizz
        {
            get { return mintBi_Bizz; }
            set { mintBi_Bizz = value; }
        }

        public string Bi_Clue
        {
            get { return mstrBi_Clue; }
            set { mstrBi_Clue = value; }
        }

        public string Bi_Code
        {
            set { mstrBi_Code = value; }
        }

        public int Bi_Flow
        {
            get { return mintBi_Flow; }
            set { mintBi_Flow = value; }
        }

        public string Bi_Name
        {
            get { return mstrBi_Name; }
            set { mstrBi_Name = value; }
        }

        public DateTime Bi_Over
        {
            get { return mdatBi_Over; }
            set { mdatBi_Over = value; }
        }

        public string Bi_Ownr
        {
            get { return mstrBi_Ownr; }
            set { mstrBi_Ownr = value; }
        }

        public string Bi_Rule
        {
            get { return mstrBi_Rule; }
            set { mstrBi_Rule = value; }
        }

        public string Bi_Same
        {
            get { return mstrBi_Same; }
            set { mstrBi_Same = value; }
        }

        public int Bi_State
        {
            get { return mintBi_State; }
            set { mintBi_State = value; }
        }

        public DateTime Bi_Time
        {
            get { return mdatBi_Time; }
            set { mdatBi_Time = value; }
        }

        public int Bi_Ver
        {
            get { return mintBi_Ver; }
            set { mintBi_Ver = value; }
        }

        public string Bi_Wave
        {
            get { return mstrBi_Wave; }
            set { mstrBi_Wave = value; }
        }


        protected override void InitProperty()
        {
            if (mdtbData.Rows.Count == 0)
            {
                mintBi_Auto = 0;
                mintBi_Bizz = 0;
                mstrBi_Clue = "";
                mstrBi_Code = "";
                mintBi_Flow = 0;
                mstrBi_Name = "";
                mdatBi_Over = DateTime.MinValue;
                mstrBi_Ownr = "";
                mstrBi_Rule = "";
                mstrBi_Same = "";
                mintBi_State = 0;
                mdatBi_Time = DateTime.MinValue;
                mintBi_Ver = 0;
                mstrBi_Wave = "";
                return;
            }


            if (mdtbData.Rows[CurPos]["Bi_Auto"] != DBNull.Value)
            {
                mintBi_Auto = (int)mdtbData.Rows[CurPos]["Bi_Auto"];
            }
            else
            {
                mintBi_Auto = 0;
            }

            if (mdtbData.Rows[CurPos]["Bi_Bizz"] != DBNull.Value)
            {
                mintBi_Bizz = (int)mdtbData.Rows[CurPos]["Bi_Bizz"];
            }
            else
            {
                mintBi_Bizz = 0;
            }

            if (mdtbData.Rows[CurPos]["Bi_Clue"] != DBNull.Value)
            {
                mstrBi_Clue = (string)mdtbData.Rows[CurPos]["Bi_Clue"];
            }
            else
            {
                mstrBi_Clue = "";
            }

            if (mdtbData.Rows[CurPos]["Bi_Code"] != DBNull.Value)
            {
                mstrBi_Code = (string)mdtbData.Rows[CurPos]["Bi_Code"];
            }
            else
            {
                mstrBi_Code = "";
            }

            if (mdtbData.Rows[CurPos]["Bi_Flow"] != DBNull.Value)
            {
                mintBi_Flow = (int)mdtbData.Rows[CurPos]["Bi_Flow"];
            }
            else
            {
                mintBi_Flow = 0;
            }

            if (mdtbData.Rows[CurPos]["Bi_Name"] != DBNull.Value)
            {
                mstrBi_Name = (string)mdtbData.Rows[CurPos]["Bi_Name"];
            }
            else
            {
                mstrBi_Name = "";
            }

            if (mdtbData.Rows[CurPos]["Bi_Over"] != DBNull.Value)
            {
                mdatBi_Over = (DateTime)mdtbData.Rows[CurPos]["Bi_Over"];
            }
            else
            {
                mdatBi_Over = DateTime.MinValue;
            }

            if (mdtbData.Rows[CurPos]["Bi_Ownr"] != DBNull.Value)
            {
                mstrBi_Ownr = (string)mdtbData.Rows[CurPos]["Bi_Ownr"];
            }
            else
            {
                mstrBi_Ownr = "";
            }

            if (mdtbData.Rows[CurPos]["Bi_Rule"] != DBNull.Value)
            {
                mstrBi_Rule = (string)mdtbData.Rows[CurPos]["Bi_Rule"];
            }
            else
            {
                mstrBi_Rule = "";
            }

            if (mdtbData.Rows[CurPos]["Bi_Same"] != DBNull.Value)
            {
                mstrBi_Same = (string)mdtbData.Rows[CurPos]["Bi_Same"];
            }
            else
            {
                mstrBi_Same = "";
            }

            if (mdtbData.Rows[CurPos]["Bi_State"] != DBNull.Value)
            {
                mintBi_State = (int)mdtbData.Rows[CurPos]["Bi_State"];
            }
            else
            {
                mintBi_State = 0;
            }

            if (mdtbData.Rows[CurPos]["Bi_Time"] != DBNull.Value)
            {
                mdatBi_Time = (DateTime)mdtbData.Rows[CurPos]["Bi_Time"];
            }
            else
            {
                mdatBi_Time = DateTime.MinValue;
            }

            if (mdtbData.Rows[CurPos]["Bi_Ver"] != DBNull.Value)
            {
                mintBi_Ver = (int)mdtbData.Rows[CurPos]["Bi_Ver"];
            }
            else
            {
                mintBi_Ver = 0;
            }

            if (mdtbData.Rows[CurPos]["Bi_Wave"] != DBNull.Value)
            {
                mstrBi_Wave = (string)mdtbData.Rows[CurPos]["Bi_Wave"];
            }
            else
            {
                mstrBi_Wave = "";
            }

        }

        protected override void UpdateToTable()
        {
            if (CurPos == -1)
            {
                return;
            }

            mdtbData.Rows[CurPos]["Bi_Auto"] = mintBi_Auto;
            mdtbData.Rows[CurPos]["Bi_Bizz"] = mintBi_Bizz;
            mdtbData.Rows[CurPos]["Bi_Clue"] = mstrBi_Clue;
            mdtbData.Rows[CurPos]["Bi_Code"] = mstrBi_Code;
            mdtbData.Rows[CurPos]["Bi_Flow"] = mintBi_Flow;
            mdtbData.Rows[CurPos]["Bi_Name"] = mstrBi_Name;
            mdtbData.Rows[CurPos]["Bi_Over"] = mdatBi_Over;
            mdtbData.Rows[CurPos]["Bi_Ownr"] = mstrBi_Ownr;
            mdtbData.Rows[CurPos]["Bi_Rule"] = mstrBi_Rule;
            mdtbData.Rows[CurPos]["Bi_Same"] = mstrBi_Same;
            mdtbData.Rows[CurPos]["Bi_State"] = mintBi_State;
            mdtbData.Rows[CurPos]["Bi_Time"] = mdatBi_Time;
            mdtbData.Rows[CurPos]["Bi_Ver"] = mintBi_Ver;
            mdtbData.Rows[CurPos]["Bi_Wave"] = mstrBi_Wave;
            mdtbData.AcceptChanges();
        }
    }
}