clstb_gongyuanzonggui.cs

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

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

namespace DBProvider
{
    class clsTB_GongYuanZongGui : clsTableBase
    {
        protected override void SetTableAndKey()
        {
            mstrTable = "TB_GongYuanZongGui";
            mstrKeys = "ID";
        }

        private DateTime mdatBianZhiShiJian;

        private byte[] mbytFuJian;

        private int mintGuiHuaNianXian;

        private int mintID;

        private Single msglTouZiEDu;

        private double mdblYongDiMianJi;

        private string mstrZongGuiMingCheng;


        public DateTime BianZhiShiJian
        {
            get { return mdatBianZhiShiJian; }
            set { mdatBianZhiShiJian = value; }
        }

        public byte[] FuJian
        {
            get { return mbytFuJian; }
            set { mbytFuJian = value; }
        }

        public int GuiHuaNianXian
        {
            get { return mintGuiHuaNianXian; }
            set { mintGuiHuaNianXian = value; }
        }

        public int ID
        {
            set { mintID = value; }
        }

        public Single TouZiEDu
        {
            get { return msglTouZiEDu; }
            set { msglTouZiEDu = value; }
        }

        public double YongDiMianJi
        {
            get { return mdblYongDiMianJi; }
            set { mdblYongDiMianJi = value; }
        }

        public string ZongGuiMingCheng
        {
            get { return mstrZongGuiMingCheng; }
            set { mstrZongGuiMingCheng = value; }
        }


        protected override void InitProperty()
        {
            if (mdtbData.Rows.Count == 0)
            {
                mdatBianZhiShiJian = DateTime.MinValue;
                mbytFuJian = null;
                mintGuiHuaNianXian = 0;
                mintID = 0;
                msglTouZiEDu = 0.0F;
                mdblYongDiMianJi = 0.0;
                mstrZongGuiMingCheng = "";
                return;
            }


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

            if (mdtbData.Rows[CurPos]["FuJian"] != DBNull.Value)
            {
                mbytFuJian = (byte[])mdtbData.Rows[CurPos]["FuJian"];
            }
            else
            {
                mbytFuJian = null;
            }

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

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

            if (mdtbData.Rows[CurPos]["TouZiEDu"] != DBNull.Value)
            {
                msglTouZiEDu = (Single)mdtbData.Rows[CurPos]["TouZiEDu"];
            }
            else
            {
                msglTouZiEDu = 0.0F;
            }

            if (mdtbData.Rows[CurPos]["YongDiMianJi"] != DBNull.Value)
            {
                mdblYongDiMianJi = (double)mdtbData.Rows[CurPos]["YongDiMianJi"];
            }
            else
            {
                mdblYongDiMianJi = 0.0;
            }

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

        }

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

            mdtbData.Rows[CurPos]["BianZhiShiJian"] = mdatBianZhiShiJian;
            mdtbData.Rows[CurPos]["FuJian"] = mbytFuJian;
            mdtbData.Rows[CurPos]["GuiHuaNianXian"] = mintGuiHuaNianXian;
            mdtbData.Rows[CurPos]["ID"] = mintID;
            mdtbData.Rows[CurPos]["TouZiEDu"] = msglTouZiEDu;
            mdtbData.Rows[CurPos]["YongDiMianJi"] = mdblYongDiMianJi;
            mdtbData.Rows[CurPos]["ZongGuiMingCheng"] = mstrZongGuiMingCheng;
            mdtbData.AcceptChanges();
        }
    }
}