first commit

懒羊羊

2023-12-28 e46d3baaf3e8d7d85f4bafec3aad75e52b078408

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Text;
using YX.DAL;
using YX.Entity;
 
namespace YX.BLL
{
    public class SystemOrganization_Bll
    {
        SystemOrganization_Dal org_dal = new SystemOrganization_Dal();
        public List<Base_Organization>GetOrganizations()
        {
            try
            {
                //using (Sam_DBEntities db = new Sam_DBEntities())
                //{
                //    return db.Base_Organization.ToList();
                //}
                return org_dal.GetOrganizations();
            }
            catch (Exception ex)
            {
                
                throw ex;
            }
        }
        public DataTable GetInitParentId()
        {
            try
            {
                return org_dal.GetInitParentId();
            }
            catch (Exception)
            {
 
                throw;
            }
        }
        public List<Base_Organization> GetOrganizationDetail(string Organization_ID)
        {
            try
            {
                return org_dal.GetOrganizationDetail(Organization_ID);
            }
            catch (Exception)
            {
 
                throw;
            }
        }
            /// <summary>
            /// 获取所在部门
            /// </summary>
            /// <param name="User_ID"></param>
            /// <returns></returns>
            public List<Base_StaffOrganize> GetStaffOrganize(string User_ID)
        {
            try
            {
                //using (Sam_DBEntities db = new Sam_DBEntities())
                //{
                //    return db.Base_StaffOrganize.Where(o => o.Base_UserInfo.User_ID == User_ID).ToList(); ;
                //}
                return org_dal.GetStaffOrganize(User_ID);
            }
            catch (Exception ex)
            {
 
                throw ex;
            }
        }
        /// <summary>
        /// 添加部门
        /// </summary>
        /// <param name="info"></param>
        public int AddSysOrganization(Base_Organization info)
        {
            try
            {
                //using (Sam_DBEntities db = new Sam_DBEntities())
                //{
                //    db.Base_Organization.Add(info);
                //    return db.SaveChanges();
                //}
                return org_dal.AddSysOrganization(info);
            }
            catch (Exception)
            {
 
                throw;
            }
        }
        /// <summary>
        /// 修改部门
        /// </summary>
        /// <param name="info"></param>
        /// <returns></returns>
        public int UpdateSysOrganization(Base_Organization info)
        {
            try
            {
                //using (Sam_DBEntities db = new Sam_DBEntities())
                //{
                //    db.Base_Organization.Attach(info);
                //    //把当前实体的状态改为Modified
                //    db.Entry(info).State = EntityState.Modified;
                //    return db.SaveChanges();
                //}
                return org_dal.UpdateSysOrganization(info);
            }
            catch (Exception)
            {
 
                throw;
            }
        }
        /// <summary>
        /// 删除部门
        /// </summary>
        /// <param name="key"></param>
        /// <returns></returns>
        public int DeleteSysOrganization(string key)
        {
            try
            {
                //using (Sam_DBEntities db = new Sam_DBEntities())
                //{
                //    var obj = new Base_Organization {  Organization_ID = key };
                //    db.Base_Organization.Attach(obj);
                //    db.Base_Organization.Remove(obj);
                //    return db.SaveChanges();
                //}
                return org_dal.DeleteSysOrganization(key);
            }
            catch (Exception)
            {
 
                throw;
            }
        }
 
    }
}