工资结算单个人集体数据库分页

wtt

2024-10-15 a2ba0925be296ea2d3e792c57ec746799cb9e407

 WebAPI/Controllers/BLL/Xt_UserController.cs

@@ -1,6 +1,7 @@
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Pub_Class;
using SyntacticSugar.constant;
using System;
using System.Collections;
using System.Collections.Generic;
@@ -107,6 +108,26 @@
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                //获取当前用户身份列表
                string sql = "select HLev from System_UserGroupInfo u " +
                        " left join System_UserGroup r " +
                        "on u.GroupId = r.GroupID where u.UserId = '" + HCzybm + "'";

                //用户身份判断
                DataSet hLev = oCN.RunProcReturn(sql, "System_UserGroupInfo");
                foreach(DataRow dr in hLev.Tables[0].Rows)
                {
                    if (!dr["HLev"].Equals(RoleConstant.EMPLOYEE))
                    {
                        objJsonResult.code = CodeConstant.FAIL;
                        objJsonResult.count = CountConstant.FAIL;
                        objJsonResult.Message = "管理员身份不允许删除！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }      

                oCN.BeginTran();
                //删除用户信息
                oCN.RunProc("delete from  Gy_Czygl where Czybm='" + HCzybm + "'");