组织架构去掉分页 班组管理，角色管理，岗位管理导入功能开发

yl

2023-09-12 50aeb4c0145561bc137732bc4d383a890bd401dd

 VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs

@@ -680,7 +680,7 @@


        #region[组织架构,查询组织信息]
        public static ToMessage STorgData(string storg_code, string storg_name, int startNum, int endNum, string prop, string order)
        public static ToMessage STorgData(string storg_code, string storg_name)
        {
            var dynamicParams = new DynamicParameters();
            string search = "";
@@ -696,18 +696,16 @@
                    search += "and T.torg_name like '%'+@storg_name+'%' ";
                    dynamicParams.Add("@storg_name", storg_name);
                }
                // --------------查询指定数据--------------
                var total = 0; //总条数
                var sql = @"select T.id,T.parent_id,T.torg_code,T.torg_name,T.status,T.leve,T.torg_seq,
                            T.lm_user  as usercode,U.username,T.lm_date  
                            from TOrganization T
                            left join  TUser U on T.lm_user=U.usercode
                            where 1=1" + search + "";
                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                            where 1=1" + search + " order by T.lm_date desc";
                var data = DapperHelper.selectdata(sql, dynamicParams);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.count = total;
                mes.data = data.ToList();
                mes.count = data.Rows.Count;
                mes.data = data;
            }
            catch (Exception e)
            {
@@ -764,7 +762,7 @@
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了组织:"+ OrganCode, us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了组织:" + OrganCode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
@@ -862,7 +860,7 @@
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了组织:"+ OrganCode, us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了组织:" + OrganCode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "修改操作成功!";
@@ -922,7 +920,7 @@
                if (cont > 0)
                {
                    //写入操作记录表
                    LogHelper.DbOperateLog(us.usercode, "新增", "删除了组织:"+orgcode, us.usertype);
                    LogHelper.DbOperateLog(us.usercode, "新增", "删除了组织:" + orgcode, us.usertype);
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "删除操作成功!";
@@ -1032,7 +1030,7 @@
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了岗位:"+ postcode, us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了岗位:" + postcode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
@@ -1083,7 +1081,7 @@
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了岗位:"+ postcode, us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了岗位:" + postcode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "修改操作成功!";
@@ -1134,7 +1132,7 @@
                if (cont > 0)
                {
                    //写入操作记录表
                    LogHelper.DbOperateLog(us.usercode, "删除", "删除了岗位:"+ postcode, us.usertype);
                    LogHelper.DbOperateLog(us.usercode, "删除", "删除了岗位:" + postcode, us.usertype);
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "删除操作成功!";
@@ -1325,7 +1323,7 @@
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了用户:"+ usercode, us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了用户:" + usercode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
@@ -1369,7 +1367,7 @@
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了用户:"+usercode, us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了用户:" + usercode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "修改操作成功!";
@@ -1411,7 +1409,7 @@
                if (aa)
                {
                    //写入操作记录表
                    LogHelper.DbOperateLog(us.usercode, "删除", "删除了用户:"+ usercode, us.usertype);
                    LogHelper.DbOperateLog(us.usercode, "删除", "删除了用户:" + usercode, us.usertype);
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "删除用户成功!";
@@ -1520,7 +1518,7 @@
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了班组:"+ groupcode, us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了班组:" + groupcode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
@@ -1571,7 +1569,7 @@
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了班组:"+ groupcode, us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了班组:" + groupcode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "修改操作成功!";
@@ -1622,7 +1620,7 @@
                if (cont > 0)
                {
                    //写入操作记录表
                    LogHelper.DbOperateLog(us.usercode, "删除", "删除了班组:"+ groupcode, us.usertype);
                    LogHelper.DbOperateLog(us.usercode, "删除", "删除了班组:" + groupcode, us.usertype);
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "删除操作成功!";
@@ -1750,7 +1748,7 @@
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了角色:"+ ((List<string>)mes.data)[0].ToString(), us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了角色:" + ((List<string>)mes.data)[0].ToString(), us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "成功!";
@@ -1839,7 +1837,7 @@
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了角色名称:"+ rolecode, us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了角色名称:" + rolecode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "成功!";
@@ -1896,7 +1894,7 @@
                if (aa)
                {
                    //写入操作记录表
                    LogHelper.DbOperateLog(us.usercode, "删除", "删除了角色:"+ rolecode, us.usertype);
                    LogHelper.DbOperateLog(us.usercode, "删除", "删除了角色:" + rolecode, us.usertype);
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "成功!";
@@ -2044,7 +2042,7 @@
                if (aa)
                {
                    //写入操作记录表
                    LogHelper.DbOperateLog(us.usercode, "取消", "取消了角色关联的用户:"+ string.Join(",", user), us.usertype);
                    LogHelper.DbOperateLog(us.usercode, "取消", "取消了角色关联的用户:" + string.Join(",", user), us.usertype);
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "成功!";
@@ -2177,7 +2175,7 @@
                //查询所有默认菜单及按钮、数据
                sql = @"select menucode,menuname,parent_id,buttoncodelist 
                        from TMenu 
                        where Type=@type";
                        where is_show='Y' and Type=@type ";
                dynamicParams.Add("@type", type);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
@@ -2256,7 +2254,7 @@
                if (aa)
                {
                    //写入操作记录表
                    LogHelper.DbOperateLog(us.usercode, "分配", "分配了角色权限:"+"-->角色:"+rolecode, us.usertype);
                    LogHelper.DbOperateLog(us.usercode, "分配", "分配了角色权限:" + "-->角色:" + rolecode, us.usertype);
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "成功!";
@@ -2375,7 +2373,7 @@
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了往来单位分类:"+ customerclasscode, us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了往来单位分类:" + customerclasscode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
@@ -2423,7 +2421,7 @@
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了往来单位分类:"+ customerclasscode, us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了往来单位分类:" + customerclasscode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "修改操作成功!";
@@ -2484,7 +2482,7 @@
                if (aa)
                {
                    //写入操作记录表
                    LogHelper.DbOperateLog(us.usercode, "删除", "删除了往来单位分类:"+ string.Join(",", classcode), us.usertype);
                    LogHelper.DbOperateLog(us.usercode, "删除", "删除了往来单位分类:" + string.Join(",", classcode), us.usertype);
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "修改操作成功!";
@@ -2616,7 +2614,7 @@
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了往来单位:"+ customercode, us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了往来单位:" + customercode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
@@ -2668,7 +2666,7 @@
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了往来单位:"+ customercode, us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了往来单位:" + customercode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "修改操作成功!";
@@ -2719,7 +2717,7 @@
                if (aa)
                {
                    //写入操作记录表
                    LogHelper.DbOperateLog(us.usercode, "删除", "删除了往来单位:"+ customercode, us.usertype);
                    LogHelper.DbOperateLog(us.usercode, "删除", "删除了往来单位:" + customercode, us.usertype);
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "删除操作成功!";
@@ -2735,7 +2733,7 @@
            }
            catch (Exception e)
            {
             

                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
@@ -2774,9 +2772,9 @@
                    search += "and S.ishasPosition=@ishasPosition ";
                    dynamicParams.Add("@ishasPosition", ishasPosition);
                }
                sql = @"select S.code,S.name,S.status,S.ishasPosition,S.description,S.lm_user as usercode,U.username,S.data_sources  
                sql = @"select S.code,S.name,S.status,S.ishasPosition,S.description,S.lm_user as usercode,U.username,S.lm_date,S.data_sources  
                        from TSecStck S
                        left join TUser U on C.lm_user=U.usercode
                        left join TUser U on S.lm_user=U.usercode
                        where 1=1 " + search;
                // --------------查询指定数据--------------
                var total = 0; //总条数
@@ -2853,7 +2851,7 @@
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了仓库:"+ stckcode, us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了仓库:" + stckcode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
@@ -2883,7 +2881,7 @@
                        return mes;
                    }
                    //更新仓库
                    sql = @"update TCustomer set name=@name,status=@status,ishasPosition=@ishasPosition,description=@description,lm_user=@lm_user,lm_date=@lm_date
                    sql = @"update TSecStck set name=@name,status=@status,ishasPosition=@ishasPosition,description=@description,lm_user=@lm_user,lm_date=@lm_date
                            where code=@code";
                    list.Add(new
                    {
@@ -2899,11 +2897,26 @@
                            lm_date = DateTime.Now.ToString()
                        }
                    });
                    if (status == "1")  //仓库停用时,下面所有的仓位停用
                    {
                        //更新库位状态为禁用
                        sql = @"update TSecLoca set status=@status where idwarehouse=@code";
                        list.Add(new
                        {
                            str = sql,
                            parm = new
                            {
                                status = status,
                                code = stckcode
                            }
                        });
                    }

                    bool aa = DapperHelper.DoTransaction(list);
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了仓库:"+ stckcode, us.usertype);
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了仓库:" + stckcode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "修改操作成功!";
@@ -2964,7 +2977,297 @@
                if (aa)
                {
                    //写入操作记录表
                    LogHelper.DbOperateLog(us.usercode, "删除", "删除了仓库:"+ stckcode, us.usertype);
                    LogHelper.DbOperateLog(us.usercode, "删除", "删除了仓库:" + stckcode, us.usertype);
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "删除操作成功!";
                    mes.data = null;
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "删除操作失败!";
                    mes.data = null;
                }
            }
            catch (Exception e)
            {

                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion


        #region[仓位树型信息]
        public static ToMessage TSecLocaTree()
        {
            string sql = "";
            try
            {
                //获取开启仓位管控的仓库信息
                sql = @"select S.code,S.name,'-1' as idparent   from TSecStck S where S.ishasPosition='1'
                       union all
                       select L.code,L.name,case when L.idparent is NULL or L.idparent='' then L.idwarehouse else L.idparent end as idparent 
                       from TSecLoca L ";
                var data = DapperHelper.selecttable(sql);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[仓位信息列表]
        public static ToMessage TSecLocaData(string stckcode, string locacode, string locaname, int startNum, int endNum, string prop, string order)
        {
            var dynamicParams = new DynamicParameters();
            string search = "", sql = "";
            IEnumerable<object> data;
            try
            {
                if (stckcode != "" && stckcode != null)
                {
                    string[] classcode = Array.ConvertAll<string, string>(stckcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string分割转string[]
                    search += "and C.idparent in @classcode ";
                    dynamicParams.Add("@classcode", classcode);
                }
                if (locacode != "" && locacode != null)
                {
                    search += "and C.code like '%'+@locacode+'%' ";
                    dynamicParams.Add("@locacode", locacode);
                }
                if (locaname != "" && locaname != null)
                {
                    search += "and C.name like '%'+@locaname+'%' ";
                    dynamicParams.Add("@locaname", locaname);
                }
                sql = @"select C.code,C.name,C.status,C.description,C.idwarehouse as stckcode,T.name as stckname,C.idparent as parentcode,L.name as parentname,
                        C.lm_user as usercode,U.username,C.lm_date,C.data_sources   
                        from (
                        select L.code,L.name,L.idwarehouse,L.status,L.description,L.lm_user,L.lm_date,L.data_sources,case when L.idparent is NULL or L.idparent='' then L.idwarehouse else L.idparent end as idparent 
                        from TSecLoca L
                        ) as C
                        left join TSecStck T  on C.idwarehouse=T.code
                        left join TSecLoca L  on C.idparent=L.code
                        left join TUser U on C.lm_user=U.usercode
                        where 1=1 " + search;
                // --------------查询指定数据--------------
                var total = 0; //总条数
                data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.count = total;
                mes.data = data.ToList();
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[仓位信息新增/编辑保存]
        public static ToMessage TSecStckAddUpdate(string data_sources, string locacode, string locaname, string stckcode, string parentlocacode, string status, string description, string OperType, User us)
        {
            string sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                if (OperType == "Add")
                {
                    //判断仓位编码是否重复
                    sql = @"select *  from TSecLoca where code=@locacode";
                    dynamicParams.Add("@locacode", locacode);
                    var data = DapperHelper.selectdata(sql, dynamicParams);
                    if (data.Rows.Count > 0)
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "仓位编码已存在,请重新输入!";
                        mes.data = null;
                        return mes;
                    }
                    //判断往来单位名称是否重复
                    sql = @"select *  from TSecLoca where name=@locaname";
                    dynamicParams.Add("@locaname", locaname);
                    var data1 = DapperHelper.selectdata(sql, dynamicParams);
                    if (data1.Rows.Count > 0)
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "仓位已存在,请重新输入!";
                        mes.data = null;
                        return mes;
                    }
                    //写入往来单位
                    sql = @"insert into TSecLoca(code,name,idwarehouse,idparent,status,description,lm_user,lm_date,data_sources) 
                            values(@code,@name,@idwarehouse,@idparent,@status,@description,@lm_user,@lm_date,@data_sources)";
                    list.Add(new
                    {
                        str = sql,
                        parm = new
                        {
                            code = locacode,
                            name = locaname,
                            idwarehouse = stckcode,
                            idparent = parentlocacode,
                            status = status,
                            description = description,
                            lm_user = us.usercode,
                            lm_date = DateTime.Now.ToString(),
                            data_sources = data_sources
                        }
                    });
                    bool aa = DapperHelper.DoTransaction(list);
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "新增", "新增了仓位:" + locacode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "新增操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "新增操作失败!";
                        mes.data = null;
                    }
                }
                if (OperType == "Update")
                {
                    //判断往来单位名称是否重复
                    sql = @"select *  from TSecLoca where  code<>@code and name=@name";
                    dynamicParams.Add("@code", locacode);
                    dynamicParams.Add("@name", locaname);
                    var data1 = DapperHelper.selectdata(sql, dynamicParams);
                    if (data1.Rows.Count > 0)
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "仓位名称已存在,请重新输入!";
                        mes.data = null;
                        return mes;
                    }
                    //更新存货分类
                    sql = @"update TSecLoca set name=@name,idwarehouse=@idwarehouse,idparent=@idparent,status=@status,description=@description,lm_user=@lm_user,lm_date=@lm_date
                            where code=@code";
                    list.Add(new
                    {
                        str = sql,
                        parm = new
                        {
                            code = locacode,
                            name = locaname,
                            idwarehouse = stckcode,
                            idparent = parentlocacode,
                            status = status,
                            description = description,
                            lm_user = us.usercode,
                            lm_date = DateTime.Now.ToString()
                        }
                    });
                    if (status == "1")  //仓位停用时,下面所有的仓位停用
                    {
                        //更新库位状态为禁用
                        sql = @"update TSecLoca set status=@status where idparent=@code";
                        list.Add(new
                        {
                            str = sql,
                            parm = new
                            {
                                status = status,
                                code = locacode
                            }
                        });
                    }
                    bool aa = DapperHelper.DoTransaction(list);
                    if (aa)
                    {
                        //写入操作记录表
                        LogHelper.DbOperateLog(us.usercode, "修改", "修改了仓位:" + locacode, us.usertype);
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "修改操作成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "修改操作失败!";
                        mes.data = null;
                    }
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[仓位信息删除]
        public static ToMessage TSecLocaDelete(string data_sources, string locacode, User us)
        {
            string sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                //判断当前仓位下是否有子项
                sql = @"select *  from TSecLoca where idparent=@locacode";
                dynamicParams.Add("@locacode", locacode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "当前仓位下存在子项,不允许删除!";
                    mes.data = null;
                    return mes;
                }
                //删除仓位
                sql = @"delete TSecLoca  where code=@code and data_sources=@data_sources";
                list.Add(new
                {
                    str = sql,
                    parm = new
                    {
                        code = locacode,
                        data_sources = data_sources
                    }
                });
                bool aa = DapperHelper.DoTransaction(list);
                if (aa)
                {
                    //写入操作记录表
                    LogHelper.DbOperateLog(us.usercode, "删除", "删除了仓位:" + locacode, us.usertype);
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "删除操作成功!";