yuangong.cs

明日Asp.net销售管理系统明日Asp.net销售管理系统

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections .Generic;

/// <summary>
/// Summary description for YuanGong
/// </summary>
namespace BLL {
    public class YuanGong
    {
        private int _yGId;
        private string _xingMing;
        private string _shenFenZheng;
        private string _xingBie;
        private string _cSNianYue;
        private string _cellPhone;
        private string _email;
        private static  List<YuanGong > _yuanGongList=new List<YuanGong> ();
        SQLHelper sqlHelper = new SQLHelper();
        SqlDataReader dr;
        public int YGId {
            get {
                return _yGId;
            }
            set {
                _yGId = value;
            }
           
        }
        public string XingMing
        {
            get
            {
                return _xingMing ;
            }
            set
            {
                _xingMing  = value;
            }
        }

        public string  ShenFenZheng
        {
            get
            {
                return _shenFenZheng ;
            }
            set
            {
                _shenFenZheng  = value;
            }
        }


        public string XingBie
        {
            get
            {
                return _xingBie ;
            }
            set
            {
                _xingBie  = value;
            }
        }


        public string  CSNianYue
        {
            get
            {
                return _cSNianYue ;
            }
            set
            {
                _cSNianYue  = value;
            }
        }

        public string  CellPhone
        {
            get
            {
                return _cellPhone;
            }
            set
            {
                _cellPhone  = value;
            }
        }

       

        

        public string  Email
        {
            get
            {
                return _email  ;
            }
            set
            {
                _email   = value;
            }
        }

        public static List<YuanGong > YuanGongList{
            get{
                return _yuanGongList;
            }
            set{
                _yuanGongList=value;
            }
        }
        
        public static List<YuanGong > GetYuanGongList(){
            _yuanGongList.Clear();
            return _yuanGongList;
        }


        public void  LoadData(YuanGong YGInstance){
            this.XingMing = YGInstance.XingMing;
            this.XingBie = YGInstance.XingBie;
            this.ShenFenZheng = YGInstance.ShenFenZheng;
            this.CSNianYue = YGInstance.CSNianYue;
            this.CellPhone = YGInstance.CellPhone;
            this.Email = YGInstance.Email;

        }
        public int InsertData() {
            SqlParameter[] ParaList ={ 
                sqlHelper .CreateInParam ("@XingMing",SqlDbType.VarChar ,50,this.XingMing ),
                sqlHelper .CreateInParam ("@ShenFenZheng",SqlDbType.VarChar,50,this.ShenFenZheng ),
                sqlHelper .CreateInParam ("@XingBie",SqlDbType.VarChar ,8,this.XingBie ),
                sqlHelper .CreateInParam ("@CSNianYue",SqlDbType.SmallDateTime ,4,this.CSNianYue ),
                sqlHelper .CreateInParam ("@CellPhone",SqlDbType.VarChar,50,this._cellPhone),
                sqlHelper .CreateInParam ("@Email",SqlDbType.VarChar ,50,this._email  )
            };

            return (sqlHelper.RunProc("InsertYGInfo", ParaList));
        }

        public bool DeleteRelf(){
            bool Flag = false;

            string sql = "delete from YuGongInfo where YGId="+this._yGId ;
            sqlHelper.RunSQL(sql);
            Flag = true;
            return Flag;
        }


        public void LoadRelf() {
            string sql = string.Format("select * from YuGongInfo where YGId={0}",this._yGId );

            sqlHelper.RunSQL(sql,out dr);

            if(dr.Read ()){
                this._xingMing = dr["XingMing"].ToString();
                this._xingBie = dr["XingBie"].ToString();
                this._cellPhone = dr["CellPhone"].ToString();
                this._email = dr["Email"].ToString();
                this._shenFenZheng = dr["ShenFenZheng"].ToString();
                this._cSNianYue = Convert.ToDateTime(dr["CSNianYue"]).ToShortDateString();

            }
            dr.Close();
        }

        public bool UpdateRelf() {
            bool Flag = false;
            string sql = string.Format("update YuGongInfo set XingMing='{0},XingBie='{1}',ShenFenZheng='{2}',CSNianYe='{3}',Email='{4}',CellPhone='{5}' where YGId={6}",this._xingMing ,this._xingBie,this._shenFenZheng ,this._cSNianYue ,this._email ,this._cellPhone,this._yGId );
            sqlHelper.RunSQL(sql);
            Flag = true;
            return Flag;
        }
    }

}