organizationstore.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 OrganizationStore
    {
        //Define a private variables
        private PlayerDataContext _playContext = new PlayerDataContext();


        //define a method,Get Organization Entity

        public OrganizationsEntity OrganizationObjectToEntity(Organizations organization)
        {
            OrganizationsEntity organizationEntity = new OrganizationsEntity();
            organizationEntity.OrgID = organization.OrgID;
            organizationEntity.OrgName = organization.OrgName;
            organizationEntity.IsSubOrg = organization.IsSubOrg;
            organizationEntity.RegionID = organization.RegionID;
            organizationEntity.ReportTo = organization.ReportTo;
            organizationEntity.CanCreateOrder = organization.CanCreateOrder;
            organizationEntity.CanRelayRequire = organization.CanReplayRequire;
            organizationEntity.CanInputTransportInfo = organization.CanInputTransportInfo;
            organizationEntity.CanConfirmReceive = organization.CanConfirmReceive;
            organizationEntity.CanCloseOrder = organizationEntity.CanCloseOrder;
            return organizationEntity;
        }



        //define a method,Get Organization table Informention 
        public OrganizationsCollection GetOrganizationList()
        {
            OrganizationsCollection organizationCollection = new OrganizationsCollection();

            IEnumerable<Organizations> organizationList = from organization in _playContext.Organizations
                                                          select organization;
            foreach (Organizations myorganization in organizationList)
            {
                organizationCollection.Add(OrganizationObjectToEntity(myorganization));
            }
            return organizationCollection;
        }
        /// <summary>
        /// Select the OrganizationInfo
        /// </summary>
        /// <param name="_orgID"></param>
        /// <returns></returns>
        public OrganizationsEntity GetOrganizationInfo(int _orgID)
        {
            OrganizationsEntity _organizationsEntity = new OrganizationsEntity();
            IEnumerable<Organizations> orgainzationList = from organization in this._playContext.Organizations
                                                          where organization.OrgID == _orgID
                                                          select organization;
            foreach (Organizations orgain in orgainzationList)
            {
                _organizationsEntity = this.OrganizationObjectToEntity(orgain);
            }
            return _organizationsEntity;
        }
        //define a method,Add Organization table Informention 
        public void AddOrganizationsinfo(OrganizationsEntity organzationEntity)
        {
            _playContext.ExecuteCommand(@"insert into organizations(OrgName,IsSubOrg,RegionID,ReportTo,CanCreateOrder,CanReplayRequire,CanInputTransportInfo," +
                                          "CanConfirmReceive,CanCloseOrder) values ({0},{1},{2},{3},{4},{5},{6},{7},{8})",
                                         organzationEntity.OrgName,
                                         organzationEntity.IsSubOrg,
                                         organzationEntity.RegionID,
                                         organzationEntity.ReportTo,
                                         organzationEntity.CanCreateOrder,
                                         organzationEntity.CanRelayRequire,
                                         organzationEntity.CanInputTransportInfo,
                                         organzationEntity.CanConfirmReceive,
                                         organzationEntity.CanCloseOrder);

        }

        //define a method,Update Organization table row Informention 
        public void UpdateOrganizitioninfo(OrganizationsEntity organizationEntity)
        {
            _playContext.ExecuteCommand(@"update organizations set OrgName= {0},IsSubOrg={1},RegionID={2},ReportTo={3},CanCreateOrder={4},CanReplayRequire={5},CanInputTransportInfo={6}," +
                                        "CanConfirmReceive={7},CanCloseOrder={8} where OrgID={9}",
                
                                         organizationEntity.OrgName,
                                         organizationEntity.IsSubOrg,
                                         organizationEntity.RegionID,
                                         organizationEntity.ReportTo,
                                         organizationEntity.CanCreateOrder,
                                         organizationEntity.CanRelayRequire,
                                         organizationEntity.CanInputTransportInfo,
                                         organizationEntity.CanConfirmReceive,
                                         organizationEntity.CanCloseOrder,
                                         organizationEntity.OrgID);

        }

        //define a method,Delete Organization table row Informention 
        public void DeleteOrganizationinfo(OrganizationsEntity organizationEntity)
        {
            _playContext.ExecuteCommand(@"delete from organizations where OrgID={0}",
                                        organizationEntity.OrgID);

        }

        /// <summary>
        /// 获取当前节点的子结点//Carter
        /// </summary>
        /// <param name="_parentOrgID">当前作为父节点的节点ID</param>
        /// <returns></returns>
        public OrganizationsCollection GetChildOrgInfo(int _parentOrgID)
        {
            OrganizationsCollection _organizationsCollection = new OrganizationsCollection();
            IEnumerable<Organizations> orgList = from organization in this._playContext.Organizations
                                             where organization.ReportTo == _parentOrgID && organization.OrgID != organization.ReportTo
                                             select organization;
            foreach (Organizations org in orgList)
            {
                _organizationsCollection.Add(OrganizationObjectToEntity(org));
            }
            return _organizationsCollection;
        }
        /// <summary>
        /// Select the SubOrg Info
        /// </summary>
        /// <returns></returns>
        public OrganizationsCollection GetSubOrg(int _isSubOrg)
        {
            OrganizationsCollection _organizationsCollection = new OrganizationsCollection();
            IEnumerable<Organizations> orgList = from organization in this._playContext.Organizations
                                                 where organization.IsSubOrg ==_isSubOrg
                                                 select organization;
            foreach (Organizations org in orgList)
            {
                _organizationsCollection.Add(OrganizationObjectToEntity(org));
            }
            return _organizationsCollection;
        }

        //Chark.XU 
        //define a method,,Get  OrganizationsEntity   By RegionID 
        #region  
         public OrganizationsEntity GetOrgByRegID(int _RegionID)
        {
            OrganizationsEntity _organizationsEntity = new OrganizationsEntity();
            IEnumerable<Organizations> orgainzationList = from organization in this._playContext.Organizations
                                                          where organization.RegionID == _RegionID
                                                          select organization;
            foreach (Organizations orgain in orgainzationList)
            {
                _organizationsEntity = this.OrganizationObjectToEntity(orgain);
            }
            return _organizationsEntity;
        }
        #endregion

    }
           

}