using Model.ModelVm.SysVm;
|
using Newtonsoft.Json;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq.Expressions;
|
using System.Text;
|
using WMS.DAL;
|
using WMS.Entity.Context;
|
using WMS.Entity.SysEntity;
|
using WMS.IBLL.ISysServer;
|
|
namespace WMS.BLL.SysServer
|
{
|
public class HeaderSettingsServer : DbHelper<SysHeaderSettings>, IHeaderSettingsServer
|
{
|
private static readonly SqlSugarScope Db = DataContext.Db;
|
|
public HeaderSettingsServer() : base(Db)
|
{
|
}
|
|
//获取用户自定义表头
|
public string GetTableColsByUserId(HeaderSetVm model)
|
{
|
try
|
{
|
string cols = string.Empty;
|
var data = Db.Queryable<SysHeaderSettings>().First(w => w.IsDel == "0" && w.Href == model.Href && w.CreateUser == model.UserId);
|
if (data != null)
|
{
|
cols = data.ColsJson;
|
}
|
return cols;
|
}
|
catch (Exception ex)
|
{
|
return "";
|
}
|
}
|
|
//获取系统表头
|
public object GetTableColsSys(HeaderSetVm model)
|
{
|
try
|
{
|
string colsSys = string.Empty;
|
string colsUser = string.Empty;
|
|
colsSys = model.ColsSysArr.Substring(1);
|
colsSys = colsSys.Substring(0, colsSys.Length - 1);
|
colsSys = colsSys.Replace("field", "value");//穿梭框的名称属性字段是value，所以这里将table里field属性临时改为value
|
colsSys = colsSys.Replace("fixed", "fixeds");//table里fixed属性会和穿梭框的fixed属性冲突，所以这里将table里fixed属性临时改为fixeds
|
if (colsSys.Contains("[["))
|
{
|
colsSys = colsSys.Substring(1);
|
colsSys = colsSys.Substring(0, colsSys.Length - 1);
|
colsSys = colsSys.Replace("'", "\"");
|
colsSys = JsonRegex2(colsSys);
|
}
|
|
List<ClosData> _colsSysLinList = JsonConvert.DeserializeObject(colsSys, typeof(List<ClosData>)) as List<ClosData>;
|
|
List<string> chooseArr = new List<string>();
|
var colsUserEntry = Db.Queryable<SysHeaderSettings>().First(w => w.IsDel == "0" && w.Href == model.Href && w.CreateUser == model.UserId);
|
if (colsUserEntry != null)
|
{
|
colsUser = colsUserEntry.ColsJson.Substring(1);
|
colsUser = colsUser.Substring(0, colsUser.Length - 1);
|
colsUser = colsUser.Replace("field", "value");
|
|
List<ClosData> colsUserLinList = JsonConvert.DeserializeObject(colsUser, typeof(List<ClosData>)) as List<ClosData>;
|
//判断已添加的列
|
foreach (var item in colsUserLinList)
|
{
|
var entry = _colsSysLinList.Find(w => w.value == item.value);
|
if (entry != null)
|
{
|
chooseArr.Add(item.value);
|
}
|
}
|
}
|
else
|
{
|
foreach (var item in _colsSysLinList)
|
{
|
chooseArr.Add(item.value);
|
}
|
}
|
var obj = new
|
{
|
colsSys = colsSys,
|
colsUser = chooseArr
|
};
|
return obj;
|
}
|
catch (Exception ex)
|
{
|
return null;
|
}
|
}
|
|
//保存自定义表头
|
public string SaveClosUser(HeaderSetVm model)
|
{
|
try
|
{
|
string ColsJson = model.ColsJson;
|
string ColsSysArr = model.ColsSysArr;
|
//前端转json会自动给key加上单引号，这里把单引号给去掉
|
if (!string.IsNullOrEmpty(ColsJson) && ColsJson.Length > 2)
|
{
|
ColsJson = JsonRegex(ColsJson);
|
ColsJson = ColsJson.Replace("value", "field").Replace("fixeds", "fixed").Replace("\"", "'");
|
ColsJson = $"[{ColsJson}]";
|
}
|
ColsSysArr = JsonRegex(ColsSysArr);
|
ColsSysArr = ColsSysArr.Replace("\"", "'");
|
SysHeaderSettings entry = Db.Queryable<SysHeaderSettings>().First(w => w.IsDel == "0" && w.Href == model.Href && w.CreateUser == model.UserId);
|
if (entry != null)
|
{
|
//更新列宽
|
if (!string.IsNullOrEmpty(model.ColText))
|
{
|
ColsJson = entry.ColsJson.Replace("fixed", "fixeds");
|
ColsJson = ColsJson.Substring(1);
|
ColsJson = ColsJson.Substring(0, ColsJson.Length - 1);
|
ColsJson = ColsJson.Replace("'", "\"");
|
ColsJson = JsonRegex2(ColsJson);
|
List<TableCols> _colsSysLinList = JsonConvert.DeserializeObject(ColsJson, typeof(List<TableCols>)) as List<TableCols>;
|
foreach (var item in _colsSysLinList)
|
{
|
if (item.title == model.ColText)
|
{
|
item.width = Convert.ToInt32(model.ColWidth);
|
break;
|
}
|
}
|
var jsonSetting = new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore };//滤掉值为NULL得属性
|
ColsJson = JsonConvert.SerializeObject(_colsSysLinList, Formatting.Indented, jsonSetting);
|
ColsJson = JsonRegex(ColsJson);
|
ColsJson = $"[{ColsJson}]";
|
ColsJson = ColsJson.Replace("fixeds", "fixed").Replace("\"", "'").Replace("\n", "").Replace(" ", "").Replace("\t", "").Replace("\r", "");
|
|
entry.ColsJson = ColsJson;
|
var x = Db.Storageable(entry).ToStorage();
|
x.AsUpdateable.ExecuteCommand();
|
}
|
else
|
{
|
//删除
|
if (string.IsNullOrEmpty(ColsJson) || ColsJson.Length <= 2 || ColsJson == ColsSysArr)
|
{
|
//物理删除
|
Db.Deleteable(entry).ExecuteCommand();
|
|
//假删
|
/*string sqlString = string.Empty;
|
sqlString += $"UPDATE SysHeaderSettings SET IsDel = '1',";
|
sqlString += $"UpdateTime = GETDATE(),UpdateUser = '{model.UserId}' ";
|
sqlString += $"WHERE Id = '{entry.Id}' and IsDel = '0';";
|
Db.Ado.ExecuteCommand(sqlString);*/
|
ColsJson = "删除成功";
|
}
|
else//更新列显示隐藏/排序
|
{
|
string oldColsJson = string.Empty;
|
oldColsJson = entry.ColsJson.Substring(1);
|
oldColsJson = oldColsJson.Substring(0, oldColsJson.Length - 1);
|
oldColsJson = oldColsJson.Replace("fixed", "fixeds");//table里fixed属性会和穿梭框的fixed属性冲突，所以这里将table里fixed属性临时改为fixeds
|
|
List<TableCols> oldColsJsonList = JsonConvert.DeserializeObject(oldColsJson, typeof(List<TableCols>)) as List<TableCols>;
|
|
string newColsJson = string.Empty;
|
newColsJson = ColsJson.Substring(1);
|
newColsJson = newColsJson.Substring(0, newColsJson.Length - 1);
|
newColsJson = newColsJson.Replace("fixed", "fixeds");//table里fixed属性会和穿梭框的fixed属性冲突，所以这里将table里fixed属性临时改为fixeds
|
|
List<TableCols> newColsJsonList = JsonConvert.DeserializeObject(newColsJson, typeof(List<TableCols>)) as List<TableCols>;
|
foreach (var item in newColsJsonList)
|
{
|
var info = oldColsJsonList.Find(w => w.field == item.field);
|
if (info != null && info.width != item.width)
|
{
|
//判断之前是否设置列宽
|
item.width = info.width;
|
}
|
}
|
var jsonSetting = new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore };//滤掉值为NULL得属性
|
ColsJson = JsonConvert.SerializeObject(newColsJsonList, Formatting.Indented, jsonSetting);
|
ColsJson = JsonRegex(ColsJson);
|
ColsJson = $"[{ColsJson}]";
|
ColsJson = ColsJson.Replace("fixeds", "fixed").Replace("\"", "'").Replace("\n", "").Replace(" ", "").Replace("\t", "").Replace("\r", "");
|
|
entry.ColsJson = ColsJson;
|
var x = Db.Storageable(entry).ToStorage();
|
x.AsUpdateable.ExecuteCommand();
|
}
|
}
|
}
|
else
|
{
|
if (string.IsNullOrEmpty(ColsJson) && !string.IsNullOrEmpty(model.ColText))//设置列宽
|
{
|
string colsSys = string.Empty;
|
colsSys = model.ColsSysArr.Substring(1);
|
colsSys = colsSys.Substring(0, colsSys.Length - 1);
|
colsSys = colsSys.Replace("fixed", "fixeds");//table里fixed属性会和穿梭框的fixed属性冲突，所以这里将table里fixed属性临时改为fixeds
|
|
List<TableCols> _colsSysLinList = JsonConvert.DeserializeObject(colsSys, typeof(List<TableCols>)) as List<TableCols>;
|
foreach (var item in _colsSysLinList)
|
{
|
if (item.title == model.ColText)
|
{
|
item.width =Convert.ToInt32(model.ColWidth);
|
break;
|
}
|
}
|
var jsonSetting = new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore };//滤掉值为NULL得属性
|
ColsJson = JsonConvert.SerializeObject(_colsSysLinList, Formatting.Indented, jsonSetting);
|
ColsJson = JsonRegex(ColsJson);
|
ColsJson = $"[{ColsJson}]";
|
ColsJson = ColsJson.Replace("fixeds", "fixed").Replace("\"", "'").Replace("\n", "").Replace(" ", "").Replace("\t", "").Replace("\r", "");
|
|
entry = new SysHeaderSettings();
|
entry.Href = model.Href;
|
entry.ColsJson = ColsJson;
|
entry.CreateUser = model.UserId;
|
|
var x = Db.Storageable(entry).ToStorage();
|
x.AsInsertable.ExecuteCommand();
|
}
|
else//设置列隐藏显示/排序
|
{
|
if (string.IsNullOrEmpty(ColsJson) || ColsJson.Length <= 2 || ColsJson == ColsSysArr)
|
{
|
return "设置成功";
|
}
|
|
entry = new SysHeaderSettings();
|
entry.Href = model.Href;
|
entry.ColsJson = ColsJson;
|
entry.CreateUser = model.UserId;
|
|
var x = Db.Storageable(entry).ToStorage();
|
x.AsInsertable.ExecuteCommand();
|
}
|
}
|
return ColsJson;
|
}
|
catch (Exception ex)
|
{
|
return "";
|
}
|
}
|
|
/// <summary>
|
/// 去除json key双引号
|
/// </summary>
|
/// <param name="jsonInput">json</param>
|
/// <returns>去除key引号</returns>
|
public string JsonRegex(string jsonInput)
|
{
|
string result = string.Empty;
|
string pattern = "\"(\\w+)\"(\\s*:\\s*)";
|
string replacement = "$1$2";
|
System.Text.RegularExpressions.Regex rgx = new System.Text.RegularExpressions.Regex(pattern);
|
result = rgx.Replace(jsonInput, replacement);
|
|
return result;
|
}
|
/// <summary>
|
/// 加上json key双引号
|
/// </summary>
|
/// <param name="jsonInput"></param>
|
/// <returns>加上key引号</returns>
|
public string JsonRegex2(string jsonInput)
|
{
|
string pattern = @"(\w+):";
|
string replacement = "\"$1\":";
|
|
System.Text.RegularExpressions.Regex rgx = new System.Text.RegularExpressions.Regex(pattern);
|
return rgx.Replace(jsonInput, replacement);
|
}
|
|
}
|
public class ClosData
|
{
|
public string value { get; set; }
|
/*public string title { get; set; }
|
public string fixeds { get; set; }
|
public bool disabled { get; set; } = false;*/
|
}
|
/// <summary>
|
/// 表头参数
|
/// 参考layui官网，http://layui.dotnetcms.cn/web/doc/modules/table.html
|
/// cols - 表头参数一览表
|
/// </summary>
|
public class TableCols
|
{
|
public string field { get; set; }
|
public string title { get; set; }
|
public int? width { get; set; }
|
public int? minWidth { get; set; }
|
public string type { get; set; }
|
public bool? LAY_CHECKED { get; set; }
|
/// <summary>
|
/// 固定列,layui原值为fixed，因为和C#系统fixed冲突，所以这里改为fixeds
|
/// </summary>
|
public string fixeds { get; set; }
|
public bool? hide { get; set; }
|
public string totalRow { get; set; }
|
public string totalRowText { get; set; }
|
public bool? sort { get; set; }
|
public bool? unresize { get; set; }
|
public string edit { get; set; }
|
//public string event{ get;set; }
|
public string style { get; set; }
|
public string align { get; set; }
|
public int? colspan { get; set; }
|
public int? rowspan { get; set; }
|
public string templet { get; set; }
|
public string toolbar { get; set; }
|
public bool? disabled { get; set; }
|
}
|
}
|
