zhuanye.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.Collections;
using System.Collections.Generic;
using System.Data.SqlClient;

/// <summary>
/// Summary description for ZhuanYe
/// </summary>
namespace BLL {
    
    public class ZhuanYe
    {
        SQLHelper sqlHelper = new SQLHelper();
       
        private int _zhuanYeId;
        private string _mingCheng;
        private static  List<ZhuanYe> _zhuanYeAll=new List<ZhuanYe> ();
        public int ZhuanYeId {
            get {
                return _zhuanYeId;
            }
            set {
                _zhuanYeId = value;
            }
        }

        public string MingCheng {
            get {
                return _mingCheng;
            }
            set {
                _mingCheng = value;
            }
        }

        public static  List<ZhuanYe> ZhuanYeAll {
            get {
                return _zhuanYeAll;
            }
            
        }


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

        public static List<ZhuanYe > GetAllZhuanYe() {
            _zhuanYeAll.Clear();
            string sql = "select * from ZhuanYe";
            SQLHelper sqlHelper = new SQLHelper();
            SqlDataReader dr;
            sqlHelper.RunSQL(sql,out dr);
            while(dr.Read ()){
                ZhuanYe ZY = new ZhuanYe();
                ZY.ZhuanYeId =Convert.ToInt32 ( dr["ZhuanYeId"]);
                ZY.MingCheng = dr["MingCheng"].ToString();
                _zhuanYeAll.Add(ZY);
            }
            dr.Close();
            return ZhuanYeAll;
        }

        public bool DeleteRelf() {
            bool flag = false;
            string sql = "delete from ZhuanYe where ZhuanYeId="+this._zhuanYeId ;
            sqlHelper.RunSQL(sql);
            flag = true;
            return flag;
        }

        public bool UpdateRelf() {
            bool flag = false;
            string sql = string.Format("update ZhuanYe set MingCheng='{0}' where ZhuanYeId={1}",this._mingCheng,this._zhuanYeId );
            sqlHelper.RunSQL(sql);
            flag = true;
            return flag;
           
        }

        public int InsertRelf() {
            int id = -1;
           SqlParameter [] ParaList={
               sqlHelper .CreateInParam ("@MingCheng",SqlDbType.VarChar ,50,this._mingCheng )
           };

           id=sqlHelper.RunProc("InsertZhuanYe",ParaList );
           return id;
            
        }
    }

}