employeesstore.cs

简单的cI真的是很简单 你想要就下载吧

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using BRISDataAccess.Entity;
using BRISDataAccess.Linq;
using System.Collections;
namespace BRISDataAccess.DataAccess
{
  public class EmployeesStore
    {
        //define a private variables
        private  PlayerDataContext _playContext = new PlayerDataContext();
        //static  EmployeesCollection _staticEmployeesCollection = new EmployeesCollection();
        //static string employeesIDList = "";
       //define a method,Get Employess Entity
        
        public EmployeesEntity EmpolyeeObjectToEntity(Employees employees)
        {
            EmployeesEntity employessEntity = new EmployeesEntity();
            employessEntity.EmployeeID = employees.EmployeeID;
            employessEntity.FirstName = employees.FirstName;
            employessEntity.LastName = employees.LastName;
            employessEntity.Title = employees.Title;
            employessEntity.BirthDate = employees.BirthDate;
            employessEntity.HireDate = employees.HireDate;
            employessEntity.Address = employees.Address;
            employessEntity.City = employees.City;
            employessEntity.Notes = employees.Notes;
            employessEntity.ReportsTo =employees.ReportsTo;
            employessEntity.OrgID = employees.OrgID;
            employessEntity.IsActive = employees.IsActive;
            employessEntity.LoginName = employees.LoginName;
            employessEntity.Password = employees.Password;
            return employessEntity;
            
        }

       //define a method,Get Employess table Informention
        public EmployeesCollection GetEmployeessList()
        {
            EmployeesCollection employeesCollection = new EmployeesCollection();
          
            IEnumerable<Employees> employeesList = from empList in _playContext.Employees
                                                   select empList;
            foreach (Employees employe in employeesList)
            {

                employeesCollection.Add(EmpolyeeObjectToEntity(employe));
            
            }
            return employeesCollection;
        
        }

        public EmployeesCollection GetEmployeessListByOrgID(int _orgID)//carter
        {
            EmployeesCollection employeesCollection = new EmployeesCollection();

            IEnumerable<Employees> employeesList = from empList in _playContext.Employees
                                                   where empList.OrgID==_orgID
                                                   select empList;
            foreach (Employees employe in employeesList)
            {

                employeesCollection.Add(EmpolyeeObjectToEntity(employe));

            }
            return employeesCollection;
        }

        //define a method,Add Employees table rowInformention 
        public void InsertEmployeesInfo(EmployeesEntity employess)
        {
            _playContext.ExecuteCommand(@"insert into Employees(FirstName,LastName,Title,BirthDate,HireDate,Address,City,Notes," +
                                      "ReportsTo,OrgID,IsActive,LoginName,Password) values({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12})",
                                       employess.FirstName,
                                       employess.LastName,
                                       employess.Title,
                                       employess.BirthDate,
                                       employess.HireDate,
                                       employess.Address,
                                       employess.City,
                                       employess.Notes,
                                       employess.ReportsTo,
                                       employess.OrgID,
                                       employess.IsActive,
                                       employess.LoginName,
                                       employess.Password);
        }



        // define a method, Update Employees table row Informention 
        public void UpdateEmployeseInfo(EmployeesEntity employess)
        { 
            _playContext.ExecuteCommand(@"update Employees set FirstName={0},LastName={1},Title={2},BirthDate={3},HireDate={4},Address={5},City={6},Notes={7}," +
                                        "ReportsTo={8},OrgID={9},IsActive={10},LoginName={11},Password={12} where EmployeeID={13}",
                                       employess.FirstName,
                                       employess.LastName,
                                       employess.Title,
                                       employess.BirthDate,
                                       employess.HireDate,
                                       employess.Address,
                                       employess.City,
                                       employess.Notes,
                                       employess.ReportsTo,
                                       employess.OrgID,
                                       employess.IsActive,
                                       employess.LoginName,
                                       employess.Password,
                                       employess.EmployeeID);
        
        }


        //define a method,Delete Employees  table row Informention 
        public void DeleteEmployeesInfo(EmployeesEntity employess)
        {
            _playContext.ExecuteCommand(@"delete from Employees where EmployeeID={0}",
                                        employess.EmployeeID);

        }

        //define a method ,Get EmployeesInfo by means of importing parameter ( longinName,passWord )
        public EmployeesCollection GetEmployessInfo(string loginName, string passWord)
        {
            EmployeesCollection employessCollection = new EmployeesCollection();
            IEnumerable<Employees> emplyeesList = from emplyee in this._playContext.Employees
                                                  where emplyee.LoginName == loginName && emplyee.Password == passWord
                                                  select emplyee;

            Employees[] employee = emplyeesList.ToArray();

            
            foreach (Employees employees in emplyeesList)
            {
                employessCollection.Add(EmpolyeeObjectToEntity(employees));

            }

            return employessCollection;
            
        }

        //define a method,Get EmloyessInfo by means of importing parameter ( emloyeeID )
        public EmployeesEntity GetEmployeesInfo(int employeeID)
        {
            EmployeesEntity employeesEntity = new EmployeesEntity();
            IEnumerable<Employees> employeeData = from data in this._playContext.Employees
                                                  where data.EmployeeID == employeeID
                                                  select data;
            foreach (Employees data in employeeData)
            {
                employeesEntity = EmpolyeeObjectToEntity(data);
            }
            return employeesEntity;
        }

        public EmployeesEntity GetEmployeesInfos(int _orgID)
        {
            EmployeesEntity _employeesEntity = new EmployeesEntity();
            IEnumerable<Employees> _employeesInfo = from employees in this._playContext.Employees
                                                    where employees.OrgID ==_orgID
                                                    select employees;
            foreach (Employees _emlployees in _employeesInfo)
            {
                _employeesEntity = this.EmpolyeeObjectToEntity(_emlployees);
            }
            return _employeesEntity;
        }
      //define a method ,Get EmployessPassWord by means of importing  (employessID,password )
        public EmployeesCollection GetEmployessPassWord(int employeesID, string passWord)
        {
            EmployeesCollection employessCollection = new EmployeesCollection();
            IEnumerable<Employees> emplyeesList = from emplyee in this._playContext.Employees
                                                  where emplyee.EmployeeID==employeesID && emplyee.Password == passWord
                                                  select emplyee;

            Employees[] employee = emplyeesList.ToArray();


            foreach (Employees employees in emplyeesList)
            {
                employessCollection.Add(EmpolyeeObjectToEntity(employees));

            }
            return employessCollection;
        }


       //define a method ,UpdateEmployessPassWord by means of importing ( employessID,passWord )
        public void UpdateEmployessPassWord(int employessID, string passWord)
        {
            _playContext.ExecuteCommand(@"update Employees set Password = {0} where EmployeeID ={1}",
                                        passWord,
                                        employessID);
       }
      /// <summary>
      /// GetEmployeesInfo
      /// Return  EmployeesEntity
      /// </summary>
      /// <returns></returns>
        public EmployeesEntity GetEmployeesInfo()
        {
            EmployeesEntity _employeesEntity = new EmployeesEntity();
            IEnumerable<Employees> empList = from empID in this._playContext.Employees
                                             select empID;
            foreach (Employees employee in empList)
            {
                _employeesEntity = this.EmpolyeeObjectToEntity(employee);
            }
            return _employeesEntity;
        }
        #region//返回雇员所属分支雇员及以下分支雇员的EmployeesID字符串

      /// <summary>
      /// 返回雇员所属分支及以下分支的EmployeesID字符串

      /// </summary>
      /// <param name="employessID"></param>
      /// <returns></returns>
        public ArrayList GetAllIsSubOrgEmployeesString(int employessID)
        {
            ArrayList IDList = new ArrayList();
            EmployeesCollection employeesCollection = new EmployeesCollection();
            //先从Employees表中得到雇员的orgID名命为orgIDE
            var orgIDE = from employees in this._playContext.Employees
                         where employees.EmployeeID == employessID
                         select new { employees.OrgID };
            foreach (var or in orgIDE)
            {
                //根据Employees表中查到的orgIDE找出Organizations表中对应的OrgID,如果他是分支(org.IsSubOrg == 1)则返回orgID,否则没有返回值

                var orgID = from org in this._playContext.Organizations
                            where org.OrgID == or.OrgID && org.IsSubOrg == 1
                            select new { OrgID = org.OrgID };
                foreach (var data in orgID)
                {
                    //如果雇员是属于分支机构，则检索相关分支雇员EmployeesID
                    if (Convert.ToString(data.OrgID) != "")
                    {

                       IDList = GetIsSubOrgEmployeesString(data.OrgID);
                    }
                    //不属于分支，返回空

                    else
                    {                      
                        return null;
                    }
                }
            }
            //返回查询到的EmployeesID字符串

            return IDList;
        }
        /// <summary>
        /// 返回分支及分支以下所有雇员信息的employeesID字符串

        /// </summary>
        /// <param name="orgID"></param>
        /// <returns></returns>
        public ArrayList GetIsSubOrgEmployeesString(int orgID)
        {
            ArrayList IDList = new ArrayList();
            EmployeesCollection employeesCollection = new EmployeesCollection();
            EmployeesEntity employeesEntity = new EmployeesEntity();
            var orgList = from org in this._playContext.Organizations
                          where org.ReportTo == orgID || org.OrgID == orgID
                          select new { org.OrgID };
            foreach (var em in orgList)
            {
                //IEnumerable<Employees> employessData = from employees in this._playContext.Employees
                //                                       where employees.OrgID == em.OrgID
                //                                       select employees; 
                var employeesID = from employees in this._playContext.Employees
                                  where employees.OrgID == em.OrgID
                                  select new { employees.EmployeeID };
                foreach (var employees in employeesID)
                {
                    IDList.Add(employees.EmployeeID);

                    //employeesIDArray = EmpolyeeObjectToEntity(employees.EmployeeID);
                    //_staticEmployeesCollection.Add(employeesEntity);                  
                }
            }
            return IDList;
        }
        #endregion
    }
}