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
}
}