using Microsoft.AspNetCore.Mvc; using Newtonsoft.Json; using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; using System.Data; using System.IO; using System.Linq; using System.Threading.Tasks; using VueWebCoreApi.DLL.BLL; using VueWebCoreApi.Models; using VueWebCoreApi.Models.RolePermission; using VueWebCoreApi.Tools; using static VueWebCoreApi.Models.RolePermission.RolePermissionSava; namespace VueWebCoreApi.Controllers { [ApiExplorerSettings(GroupName = "基础设置")] [ApiController] [Route("api/[controller]")] [ChannelActionFilter] public class BasicSettingController : Controller { //定义全局信息返回变量 ToMessage mes = new ToMessage(); RedisHelper redis = new RedisHelper(); #region[组织架构,查询组织信息] /// /// 组织架构,查询组织信息 /// /// 组织编码 /// 组织名称 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "STorgData")] [HttpGet] public JsonResult STorgData(string storg_code,string storg_name, int page = 0, int rows = 0, string prop = null, string order = null) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = BasicSettingBLL.STorgData(storg_code,storg_name,startNum,endNum,prop,order); return Json(mes); } #endregion #region[组织架构新增编辑] /// /// 组织架构新增编辑 /// /// 提交数据对象 /// [Route(template: "AddUpdateOrganization")] [HttpPost] public JsonResult AddUpdateOrganization([FromBody] JObject obj) { var token =HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string OrganCode = obj["OrganCode"].ToString(); //组织编码 string OrganName = obj["OrganName"].ToString(); //组织名称 string leve = obj["leve"].ToString(); //层级编码 string parent_id = obj["parent_id"].ToString(); //parent_id string storgcode = obj["storgcode"].ToString(); //所属组织编码 string torg_seq = obj["torg_seq"].ToString(); //排序序号 string status = obj["status"].ToString(); //状态 string OperType = obj["OperType"].ToString(); //操作类型 mes = BasicSettingBLL.AddUpdateOrganization(OrganCode, OrganName, leve, parent_id, storgcode, torg_seq, status, OperType, us); return Json(mes); } #endregion #region[组织架构删除] /// /// 组织架构删除 /// /// 组织编码 /// [Route(template: "DeleteOrganization")] [HttpPost] public JsonResult DeleteOrganization(string orgcode) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = BasicSettingBLL.DeleteOrganization(orgcode,us); return Json(mes); } #endregion #region[岗位信息列表查询] /// /// 岗位信息列表查询 /// /// 岗位编码 /// 岗位名称 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "PostData")] [HttpGet] public JsonResult PostData(string postcode, string postname, int page = 0, int rows = 0, string prop = null, string order = null) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = BasicSettingBLL.PostData(postcode, postname, startNum, endNum, prop, order); return Json(mes); } #endregion #region[岗位新增编辑] /// /// 岗位新增编辑 /// /// 提交数据对象 /// [Route(template: "AddUpdatePost")] [HttpPost] public JsonResult AddUpdatePost([FromBody] JObject obj) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string postcode = obj["postcode"].ToString(); //岗位编码 string postname = obj["postname"].ToString(); //岗位名称 string description = obj["description"].ToString();//岗位描述 string status = obj["status"].ToString(); //状态 string OperType = obj["OperType"].ToString(); //操作类型 mes = BasicSettingBLL.AddUpdatePost(postcode, postname, description, status, OperType, us); return Json(mes); } #endregion #region[岗位删除] /// /// 岗位删除 /// /// 岗位编码 /// [Route(template: "DeletePost")] [HttpPost] public JsonResult DeletePost(string postcode) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = BasicSettingBLL.DeletePost(postcode,us); return Json(mes); } #endregion #region[用户信息列表查询] /// /// 用户信息列表查询 /// /// 左侧组织编码 /// 用户编码 /// 用户名称 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "UserData")] [HttpGet] public JsonResult UserData(string storgcode, string usercode, string username, int page = 0, int rows = 0, string prop = null, string order = null) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = BasicSettingBLL.UserData(storgcode,usercode, username, startNum, endNum, prop, order); return Json(mes); } #endregion #region[用户信息新增编辑] /// /// 用户信息新增编辑 /// /// 提交数据 /// [Route(template: "AddUpdateUserSave")] [HttpPost] public JsonResult AddUpdateUserSave([FromBody] JObject obj) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string usercode = obj["usercode"].ToString(); //用户编码 string username = obj["username"].ToString(); //用户名称 string password = obj["password"].ToString();//用户密码 string mobile = obj["mobile"].ToString();//手机号 string email = obj["email"].ToString();//邮箱 string storg_code = obj["storg_code"].ToString();//所属组织 string status = obj["status"].ToString(); //状态 string post_code = obj["post_code"].ToString();//岗位 string role_code = obj["role_code"].ToString();//角色 string group_code = obj["group_code"].ToString();//班组 string opertype = obj["OperType"].ToString(); //操作类型 mes = BasicSettingBLL.AddUpdateUserSave(usercode, username, password, mobile, email, storg_code, status, post_code, role_code, group_code, opertype, us); return Json(mes); } #endregion #region[用户信息删除] /// /// 用户信息删除 /// /// 用户编码 /// [Route(template: "DeleteUserSave")] [HttpPost] public JsonResult DeleteUserSave(string usercode) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = BasicSettingBLL.DeleteUserSave(usercode,us); return Json(mes); } #endregion #region[班组信息列表查询] /// /// 班组信息列表查询 /// /// 班组编码 /// 班组名称 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "GroupData")] [HttpGet] public JsonResult GroupData(string groupcode, string groupname, int page = 0, int rows = 0, string prop = null, string order = null) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = BasicSettingBLL.GroupData(groupcode, groupname, startNum, endNum, prop, order); return Json(mes); } #endregion #region[班组新增编辑] /// /// 班组新增编辑 /// /// 提交数据对象 /// [Route(template: "AddUpdateGroup")] [HttpPost] public JsonResult AddUpdateGroup([FromBody] JObject obj) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string groupcode = obj["groupcode"].ToString(); //班组编码 string groupname = obj["groupname"].ToString(); //班组名称 string description = obj["description"].ToString();//班组描述 string status = obj["status"].ToString(); //状态 string OperType = obj["OperType"].ToString(); //操作类型 mes = BasicSettingBLL.AddUpdateGroup(groupcode, groupname, description, status, OperType, us); return Json(mes); } #endregion #region[班组删除] /// /// 班组删除 /// /// 班组编码 /// [Route(template: "DeleteGroup")] [HttpPost] public JsonResult DeleteGroup(string groupcode) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = BasicSettingBLL.DeleteGroup(groupcode,us); return Json(mes); } #endregion #region[角色管理列表查询] /// /// 角色管理列表查询 /// /// 角色编码 /// 角色名称 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "RoleData")] [HttpGet] public JsonResult RoleData(string role_code, string role_name, int page = 0, int rows = 0, string prop = null, string order = null) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = BasicSettingBLL.RoleData(role_code, role_name, startNum, endNum, prop, order); return Json(mes); } #endregion #region[角色管理新增、编辑保存] /// /// 角色管理新增、编辑保存 /// /// 提交数据对象 /// [Route(template: "RoleAddUpdateSava")] [HttpPost] public JsonResult RoleAddUpdateSava([FromBody] JObject obj) { var token =HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); var menucode = HttpContext.Request.Headers["Menucode"].ToString(); //菜单编码 string rolecode = obj["rolecode"].ToString(); //角色编码 string rolename = obj["rolename"].ToString(); //角色名称 string status = obj["status"].ToString();//状态 string datacode = obj["datacode"].ToString(); //数据范围 string datapermissions = obj["datapermissions"].ToString(); //数据权限 string description = obj["description"].ToString(); //描述 string OperType = obj["OperType"].ToString(); //操作类型 mes = BasicSettingBLL.RoleAddUpdateSava(menucode, rolecode, rolename, status, datacode, datapermissions, description, OperType, us); return Json(mes); } #endregion #region[角色管理删除] [Route(template: "RoleDeleteSava")] [HttpPost] public JsonResult RoleDeleteSava(string rolecode) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = BasicSettingBLL.RoleDeleteSava(rolecode, us); return Json(mes); } #endregion #region[角色管理分配用户,获取已分配用户列表] /// /// 角色管理分配用户,获取已分配用户列表 /// /// TRUE(已关联) FALSE(未关联) /// 角色编码 /// 用户编码 /// 用户名称 /// 组织编码 /// 岗位编码 /// 班组编码 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "RoleAssignedUserData")] [HttpGet] public JsonResult RoleAssignedUserData(string flag, string role_code,string usercode,string username,string storg_code,string post_code,string group_code,int page = 0, int rows = 0, string prop = null, string order = null) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = BasicSettingBLL.RoleAssignedUserData(flag,role_code, usercode,username,storg_code,post_code,group_code, startNum, endNum, prop, order); return Json(mes); } #endregion #region[角色管理分配用户,批量取消已分配的用户] /// /// 角色编码 /// /// 角色编码 /// 用户编码数组 /// [Route(template: "RoleAssignedUserBatchCancel")] [HttpPost] public JsonResult RoleAssignedUserBatchCancel(string role_code,string [] user) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = BasicSettingBLL.RoleAssignedUserBatchCancel(role_code, user, us); return Json(mes); } #endregion #region[角色管理分配用户,批量添加未分配的用户] /// /// 角色编码 /// /// 角色编码 /// 用户编码数组 /// [Route(template: "RoleAssignedUserBatchAdd")] [HttpPost] public JsonResult RoleAssignedUserBatchAdd(string role_code, string[] user) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = BasicSettingBLL.RoleAssignedUserBatchAdd(role_code, user, us); return Json(mes); } #endregion #region[角色权限查询角色] /// /// 角色权限查询角色 /// /// [Route(template: "RolePermissionSearchRole")] [HttpGet] public JsonResult RolePermissionSearchRole() { mes = BasicSettingBLL.RolePermissionSearchRole(); return Json(mes); } #endregion #region[角色权限查询默认菜单按钮数据] /// /// 角色权限查询默认菜单按钮数据 /// /// 操作端类型(PC/APP) /// [Route(template: "RolePermissionSearchRoleMenu")] [HttpGet] public JsonResult RolePermissionSearchRoleMenu(string type) { mes = BasicSettingBLL.RolePermissionSearchRoleMenu(type); return Json(mes); } #endregion #region[角色权限,根据角色查找关联权限] /// /// 角色权限,根据角色查找关联权限 /// /// 角色编码 /// 菜单编码 /// [Route(template: "RolePermissionSearchRoleMenuButton")] [HttpGet] public JsonResult RolePermissionSearchRoleMenuButton(string rolecode,string type) { mes = BasicSettingBLL.RolePermissionSearchRoleMenuButton(rolecode, type); return Json(mes); } #endregion #region[角色权限,提交] /// /// 角色权限,提交 /// /// 类型 /// 角色编码 /// 提交数据 /// [Route(template: "RolePermissionSava")] [HttpPost] public JsonResult RolePermissionSava([FromBody] object json, string rolecode,string type) { var jsonStr = JsonConvert.SerializeObject(json); var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = BasicSettingBLL.RolePermissionSava(jsonStr, rolecode, type, us); return Json(mes); } #endregion #region[往来单位分类信息] /// /// 往来单位分类信息 /// /// [Route(template: "TCunstomerClassTree")] [HttpGet] public JsonResult TCunstomerClassTree() { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = BasicSettingBLL.TCunstomerClassTree(); return Json(mes); } #endregion #region[往来单位分类新增/编辑提交] /// /// 往来单位分类新增/编辑提交 /// /// 数据来源:ERP/MES /// 往来单位分类编码 /// 往来单位分类名称 /// 上级分类编码 /// 操作类型:Add/Update /// [Route(template: "TCunstomerClassTreeAddUpdate")] [HttpPost] public JsonResult TCunstomerClassTreeAddUpdate(string data_sources, string customerclasscode, string customerclassname, string parentcode, string OperType) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = BasicSettingBLL.TCunstomerClassTreeAddUpdate(data_sources, customerclasscode, customerclassname, parentcode, OperType, us); return Json(mes); } #endregion #region[往来单位分类删除] /// /// 往来单位分类删除 /// /// 往来单位分类编码字串集 /// [Route(template: "TCunstomerClassTreeDelete")] [HttpPost] public JsonResult TCunstomerClassTreeDelete(string customerclasscode) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = BasicSettingBLL.TCunstomerClassTreeDelete(customerclasscode, us); return Json(mes); } #endregion #region[往来单位信息列表] /// /// 往来单位信息列表 /// /// 往来单位分类编码字符串集 /// 往来单位编码 /// 往来单位名称 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "TCunstomerData")] [HttpGet] public JsonResult TCunstomerData(string customerclasscode, string customercode, string customername, int page = 0, int rows = 0, string prop = null, string order = null) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = BasicSettingBLL.TCunstomerData(customerclasscode, customercode, customername, startNum, endNum, prop, order); return Json(mes); } #endregion #region[往来单位新增/编辑保存] /// /// 往来单位新增/编辑保存 /// /// 提交数据 /// [Route(template: "TCunstomerAddUpdate")] [HttpPost] public JsonResult TCunstomerAddUpdate([FromBody] JObject obj) { var token =HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string data_sources = obj["data_sources"].ToString(); //数据来源:ERP/MES string customercode = obj["customercode"].ToString(); //往来单位编码 string customername = obj["customername"].ToString(); //往来单位名称 string customerclasscode = obj["customerclasscode"].ToString(); //往来单位类型编码 string status = obj["status"].ToString(); //状态 string conttacts = obj["conttacts"].ToString(); //联系人 string conttphone = obj["conttphone"].ToString(); //联系方式 string addr = obj["addr"].ToString(); //地址 string OperType = obj["OperType"].ToString(); //操作类型 mes = BasicSettingBLL.TCunstomerAddUpdate(data_sources, customercode, customername, customerclasscode,status, conttacts, conttphone,addr, OperType, us); return Json(mes); } #endregion #region[往来单位信息删除] /// /// 往来单位信息删除 /// /// 数据来源:ERP/MES /// 往来单位编码 /// [Route(template: "TCunstomerDelete")] [HttpPost] public JsonResult TCunstomerDelete(string data_sources, string customercode) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = BasicSettingBLL.TCunstomerDelete(data_sources, customercode, us); return Json(mes); } #endregion #region[仓库信息列表] /// /// 仓库信息列表 /// /// 仓库编码 /// 仓库名称 /// 状态 /// 货位管理 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "TSecStckData")] [HttpGet] public JsonResult TSecStckData(string code, string name, string status,string ishasPosition, int page = 0, int rows = 0, string prop = null, string order = null) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = BasicSettingBLL.TSecStckData(code, name, status,ishasPosition,startNum, endNum, prop, order); return Json(mes); } #endregion #region[仓库新增/编辑保存] /// /// 仓库新增/编辑保存 /// /// 提交数据 /// [Route(template: "TSecStckAddUpdate")] [HttpPost] public JsonResult TSecStckAddUpdate([FromBody] JObject obj) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string data_sources = obj["data_sources"].ToString(); //数据来源:ERP/MES string stckcode = obj["stckcode"].ToString(); //仓库编码 string stckname = obj["stckname"].ToString(); //仓库名称 string ishaspostion = obj["ishaspostion"].ToString(); //是否货位管理 string status = obj["status"].ToString(); //状态 string description = obj["description"].ToString(); //备注 string OperType = obj["OperType"].ToString(); //操作类型 mes = BasicSettingBLL.TSecStckAddUpdate(data_sources, stckcode, stckname, ishaspostion, status, description, OperType, us); return Json(mes); } #endregion #region[仓库删除] /// /// 仓库删除 /// /// 数据来源:ERP/MES /// 仓库编码 /// [Route(template: "TSecStckDelete")] [HttpPost] public JsonResult TSecStckDelete(string data_sources, string stckcode) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = BasicSettingBLL.TSecStckDelete(data_sources, stckcode, us); return Json(mes); } #endregion #region[仓位树型信息] /// /// 仓位树型信息 /// /// [Route(template: "TSecLocaTree")] [HttpGet] public JsonResult TSecLocaTree() { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = BasicSettingBLL.TSecLocaTree(); return Json(mes); } #endregion #region[仓位信息列表] /// /// 仓位信息列表 /// /// 仓库编码字符串集 /// 仓位编码 /// 仓位名称 /// 页码 /// 每页显示条数 /// 排序字段 /// 排序规则 /// [Route(template: "TSecLocaData")] [HttpGet] public JsonResult TSecLocaData(string stckcode, string locacode, string locaname, int page = 0, int rows = 0, string prop = null, string order = null) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); int startNum = rows * (page - 1) + 1; //起始记录rowNum int endNum = rows * page; //结束记录 rowNum mes = BasicSettingBLL.TSecLocaData(stckcode, locacode, locaname, startNum, endNum, prop, order); return Json(mes); } #endregion #region[仓位信息新增/编辑保存] /// /// 仓位信息新增/编辑保存 /// /// 提交数据 /// [Route(template: "TSecLocaAddUpdate")] [HttpPost] public JsonResult TSecLocaAddUpdate([FromBody] JObject obj) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); string data_sources = obj["data_sources"].ToString(); //数据来源:ERP/MES string locacode = obj["locacode"].ToString(); //货位编码 string locaname = obj["locaname"].ToString(); //货位名称 string stckcode = obj["stckcode"].ToString(); //对应仓库编码 string parentlocacode = obj["parentlocacode"].ToString(); //上级货位编码 string status = obj["status"].ToString(); //状态 string description = obj["description"].ToString(); //备注 string OperType = obj["OperType"].ToString(); //操作类型 mes = BasicSettingBLL.TSecLocaAddUpdate(data_sources, locacode, locaname, stckcode, parentlocacode, status, description, OperType, us); return Json(mes); } #endregion #region[仓位信息删除] /// /// /// /// 数据来源:ERP/MES /// 仓库编码 /// [Route(template: "TSecLocaDelete")] [HttpPost] public JsonResult TSecLocaDelete(string data_sources, string locacode) { var token = HttpContext.Request.Headers["Token"].ToString(); User us = JwtTools.Denocode(token.ToString()); mes = BasicSettingBLL.TSecLocaDelete(data_sources, locacode, us); return Json(mes); } #endregion } }