ed.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 Ed
/// </summary>
namespace BLL {
    public class Ed
    {
        SQLHelper sqlHelper = new SQLHelper();
        SqlDataReader dr;
        
        private static List<Ed> _ygEdList = new List<Ed>();
        private int _edId;
        private string _startSJ;
        private string _endSJ;
        private string _zhuanYe;
        private string _biYeYuanXiao;
        private string _xueLi;
        private string _zhengShuBH;
        private int _ygId;

        public int EdId { 
            get {
                return _edId;
            }
            set {
                _edId = value;
            }
        }

        public string StartSJ {
            get {
                return _startSJ;
            }
            set {
                _startSJ = value;
            }
        }

        public string EndSJ
        {
            get
            {
                return _endSJ;
            }
            set
            {
                _endSJ = value;
            }
        }

        public string ZhuanYe
        {
            get
            {
                return _zhuanYe;
            }
            set
            {
                _zhuanYe = value;
            }
        }

        public string BiYeYuanXiao {
            get {
                return _biYeYuanXiao;
            }
            set {
                _biYeYuanXiao = value;
            }
        }

        public string XueLi {
            get {
                return _xueLi;
            }
            set {
                _xueLi = value;
            }
        }

        public string ZhengShuBH {
            get {
                return _zhengShuBH;
            }
            set {
                _zhengShuBH = value;
            }
        }

        public int YGId {
            get {
                return _ygId;
            }
            set {
                _ygId = value; 
            }
        }
        
        public static List<Ed>  GetYGEds(string YGId){
            SQLHelper sqlHelper = new SQLHelper();
            SqlDataReader dr;

            _ygEdList.Clear();

            string sql = "select * from Ed where YGId=" + YGId ;
            sqlHelper.RunSQL(sql,out dr);

            while(dr.Read ()){
                Ed ed = new Ed();
                ed._edId = Convert.ToInt32(dr["EdId"]);
                ed._startSJ = Convert.ToDateTime (dr["StartSJ"]).ToShortDateString ();
                ed._endSJ = Convert.ToDateTime(dr["EndSJ"]).ToShortDateString();
                ed._biYeYuanXiao = dr["BiYeYuanXiao"].ToString();
                ed._xueLi = dr["XueLi"].ToString();
                ed._zhuanYe = dr["ZhuanYe"].ToString();
                ed._zhengShuBH = dr["ZhengShuBH"].ToString();
                ed._ygId = Convert.ToInt32(dr["YGId"]);
                _ygEdList.Add(ed);
            }
            dr.Close();
            return _ygEdList;
            

        }

        public int InsertRelf() {
            int EdId=-1;
            SqlParameter[] ParaList ={
                sqlHelper .CreateInParam ("@StartSJ",SqlDbType.SmallDateTime ,4,this._startSJ ),
                sqlHelper .CreateInParam ("@EndSJ",SqlDbType.SmallDateTime ,4,this._endSJ ),
                sqlHelper .CreateInParam ("@ZhuanYe",SqlDbType.VarChar ,90,this._zhuanYe ),
                sqlHelper .CreateInParam ("@BiYeYuanXiao",SqlDbType.VarChar ,90,this._biYeYuanXiao ),
                sqlHelper .CreateInParam ("@XueLi",SqlDbType.VarChar ,30,this._xueLi ),
                sqlHelper .CreateInParam ("@ZhengShuBH",SqlDbType.VarChar,50,this._zhengShuBH  ),
                sqlHelper .CreateInParam ("@YGId",SqlDbType.Int ,4,this._ygId )
            };

          EdId= sqlHelper.RunProc("InsertEd",ParaList );

          return EdId;

        }

        public bool DeleteRelf() {
            bool Flag = false;
            string sql = "delete from Ed where EdId="+this._edId;

            sqlHelper.RunSQL (sql);
            Flag = true;
            return Flag;

        }


        public bool UpdateRelf() {
            bool Flag = false;
            string sql = string.Format("update Ed set StartSJ='{0}',EndSJ='{1}',ZhuanYe='{2}',BiYeYuanXiao='{3}',XueLi='{4}',ZhengShuBH='{5}' where EdId={6}",this._startSJ ,this._endSJ ,this._zhuanYe ,this._biYeYuanXiao ,this._xueLi,this._zhengShuBH,this._edId  );
            sqlHelper.RunSQL(sql);
            Flag = true;
            return Flag;


        }


        public void LoadRelf() {
            string sql = string.Format("select StartSJ,EndSJ,ZhuanYe,BiYeYuanXiao,XueLi,ZhengShuBH from Ed where EdId={0}",this._edId );
            sqlHelper.RunSQL(sql,out dr);

            if(dr.Read ()){
                this._startSJ = Convert.ToDateTime(dr["StartSJ"]).ToShortDateString();
                this._endSJ = Convert.ToDateTime(dr["EndSJ"]).ToShortDateString();
                this._xueLi = dr["XueLi"].ToString();
                this._zhuanYe = dr["ZhuanYe"].ToString();
                this._zhengShuBH = dr["ZhengShuBH"].ToString();
                this._biYeYuanXiao = dr["BiYeYuanXiao"].ToString();
            }
            dr.Close();
        }

        public static bool DeleteYGEd(string YGId) {
            SQLHelper sqlHelper = new SQLHelper();
            bool Flag = false;
            string sql = string.Format("delete from Ed where YGId={0}",YGId );
            sqlHelper.RunSQL(sql);
            Flag = true;
            return Flag;
            

        }
        public Ed()
        {
            //
            // TODO: Add constructor logic here
            //
        }
    }
}