clssys_bztask.cs

来自「通过配置数据库连接并选择数据库表,可自动生成数据库表的实体类,并且实体类中包含记」· CS 代码 · 共 190 行

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

namespace DBProvider
{
    class clsSys_BzTask : clsTableBase
    {
        protected override void SetTableAndKey()
        {
            mstrTable = "Sys_BzTask";
            mstrKeys = "Ak_Code";
        }

        private string mstrAk_Code;

        private int mintAk_ID;

        private string mstrAk_Loger;

        private int mintAk_Share;

        private int mintAk_State;

        private int mintAk_Tache;

        private DateTime mdatAk_Time;

        private int mintAk_User;


        public string Ak_Code
        {
            set { mstrAk_Code = value; }
        }

        public int Ak_ID
        {
            get { return mintAk_ID; }
            set { mintAk_ID = value; }
        }

        public string Ak_Loger
        {
            get { return mstrAk_Loger; }
            set { mstrAk_Loger = value; }
        }

        public int Ak_Share
        {
            get { return mintAk_Share; }
            set { mintAk_Share = value; }
        }

        public int Ak_State
        {
            get { return mintAk_State; }
            set { mintAk_State = value; }
        }

        public int Ak_Tache
        {
            get { return mintAk_Tache; }
            set { mintAk_Tache = value; }
        }

        public DateTime Ak_Time
        {
            get { return mdatAk_Time; }
            set { mdatAk_Time = value; }
        }

        public int Ak_User
        {
            get { return mintAk_User; }
            set { mintAk_User = value; }
        }


        protected override void InitProperty()
        {
            if (mdtbData.Rows.Count == 0)
            {
                mstrAk_Code = "";
                mintAk_ID = 0;
                mstrAk_Loger = "";
                mintAk_Share = 0;
                mintAk_State = 0;
                mintAk_Tache = 0;
                mdatAk_Time = DateTime.MinValue;
                mintAk_User = 0;
                return;
            }


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

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

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

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

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

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

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

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

        }

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

            mdtbData.Rows[CurPos]["Ak_Code"] = mstrAk_Code;
            mdtbData.Rows[CurPos]["Ak_ID"] = mintAk_ID;
            mdtbData.Rows[CurPos]["Ak_Loger"] = mstrAk_Loger;
            mdtbData.Rows[CurPos]["Ak_Share"] = mintAk_Share;
            mdtbData.Rows[CurPos]["Ak_State"] = mintAk_State;
            mdtbData.Rows[CurPos]["Ak_Tache"] = mintAk_Tache;
            mdtbData.Rows[CurPos]["Ak_Time"] = mdatAk_Time;
            mdtbData.Rows[CurPos]["Ak_User"] = mintAk_User;
            mdtbData.AcceptChanges();
        }
    }
}