hangye.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 HangYe
/// </summary>
namespace BLL {
    public class HangYe
    {
        SQLHelper sqlHelper = new SQLHelper();
        private static List<HangYe> _hangYeInZhuanYe = new List<HangYe>();
        private int _hangYeId;
        private string _mingCheng;
        private int _zhuanYeId;

        public int HangYeId {
            get {
                return _hangYeId;
            }
            set {
                _hangYeId = value;
            }
        }

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

        public int ZhuanYeId
        {
            get
            {
                return _zhuanYeId ;
            }
            set
            {
               _zhuanYeId  = value;
            }
        }
        
        public HangYe()
        {
            //
            // TODO: Add constructor logic here
            //
        }
        public static List<HangYe> GetHangYeByZhuanYe(string ZhuanYeId) {
            SQLHelper sqlHelper = new SQLHelper();
            SqlDataReader dr;

            _hangYeInZhuanYe.Clear();
            string sql = "select * from HangYe where ZhuanYeId="+ZhuanYeId ;
            sqlHelper.RunSQL(sql,out dr);

            while(dr.Read ()){
                HangYe HY = new HangYe();
                HY.MingCheng = dr["MingCheng"].ToString();
                HY._hangYeId = Convert.ToInt32(dr["HangYeId"]);
                _hangYeInZhuanYe.Add(HY);
            }
            dr.Close();
            return _hangYeInZhuanYe;
        }

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

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

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

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

    }
}