DAL/Admin/GZXX_UserDepartMent.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using DBUtility;

namespace DAL.Admin
{
    public class GZXX_UserDepartMent
    {
        protected string _menu = string.Empty;
        protected string _newmenu = string.Empty;
        protected DataTable dtAll;
        protected DataTable dtNewAll;
        protected DataTable dtDrpAll;

        public object[] Delete(int departid)
        {
            object[] obj;
            Model.Admin.GZXX_UserDepartMent model = new Model.Admin.GZXX_UserDepartMent();
            model = getDepartMentInfo(departid);
            SqlParameter[] p1 = new SqlParameter[]{
                new SqlParameter("@departid",SqlDbType.Int)
            };
            p1[0].Value = departid;
            if (model.partentid == 0) {
                obj = new object[] { false, "根组织架构不能删除！" };
                return obj;
            }
            else
            {
                if (DbHelperSQL.Exists("select * from GZXX_UserDepartMent where parentid =@departid", p1))
                {
                    obj = new object[] { false, "请先删除子组织架构！" };
                    return obj;
                }
                else
                {
                    string sql1 = "delete from GZXX_UserDepartMent where departid = @departid";
                    string sql2 = "update GZXX_UserDepartMent set child = child - 1 where departid = @departid";
                    SqlParameter[] p2 = new SqlParameter[] {
                        new SqlParameter("@departid",SqlDbType.Int)
                    };
                    p2[0].Value = model.partentid;

                    List<CommandInfo> list = new List<CommandInfo>();
                    CommandInfo info = new CommandInfo();
                    info.CommandText = sql1;
                    info.Parameters = p1;
                    info.EffentNextType = EffentNextType.ExcuteEffectRows;
                    list.Add(info);
                    CommandInfo info1 = new CommandInfo();
                    info1.CommandText = sql2;
                    info1.Parameters = p2;
                    info1.EffentNextType = EffentNextType.ExcuteEffectRows;
                    list.Add(info1);
                    if (DbHelperSQL.ExecuteSqlTran(list) > 0)
                    {
                        obj = new object[] { true, "操作成功！" };