public async Task <HandleResult> GetSeo([FromBody] JObject form)
{
string num = form["num"].ToStr();
string columnNum = form["columnNum"].ToStr();
if (num.IsEmpty() || columnNum.IsEmpty())
{
return(HandleResult.Error("无效数据"));
}
var data = await _service.GetByNumAndColumn(columnNum, num);
if (data == null)
{
return(HandleResult.Error("无效数据"));
}
var content = new ContentData(data);
return(HandleResult.Success(new
{
content.SeoTitle,
content.SeoKeyword,
content.SeoDesc
}));
}
public async Task <HandleResult> Export([FromBody] JObject form)
{
string columnNum = form["columnNum"].ToStr();
if (columnNum.IsEmpty())
{
return(HandleResult.Error());
}
var fields = await _columnFieldService.GetByColumnNum(columnNum);
var dataResp = await _service.PageByColumn(columnNum, new SqlServerPageRequest
{
Current = 1,
Size = 1000
});
if (dataResp.Data.Count() <= 0)
{
return(HandleResult.Error("未能查询出数据"));
}
var fullPath = Path.GetFullPath("wwwroot/Export.xls");
var webPath = $"/temp/数据导出_{DateTime.Now:yyyyMMddHHmmss}.xls";
var saveFullPath = Path.GetFullPath($"wwwroot/{webPath}");
using (var excel = new ExcelUtil(fullPath))
{
var column = new ExcelRowItem();
var columnIndex = 0;
foreach (var columnField in fields)
{
column.Add(columnField.Explain, excel.GetColumnLetter(columnIndex));
columnIndex++;
}
excel.SetRowValue(0, column);
var contentData = dataResp.Data.ToList();
excel.CirculateLetterSetValue(1, (dataIndex, row) =>
{
var item = contentData[dataIndex];
var contentDataColumnIndex = 0;
foreach (var columnField in fields)
{
row.Add(item[columnField.Name].ToStr(), excel.GetColumnLetter(contentDataColumnIndex));
contentDataColumnIndex++;
}
return(contentData.Count - 1 > dataIndex);
});
excel.Save(saveFullPath);
}
return(HandleResult.Success(webPath));
}
public async Task <HandleResult> Edit(JObject form, string accountNum)
{
var num = form["num"].ToStr();
var columnNum = form["columnNum"].ToStr();
if (columnNum.IsEmpty())
{
return(HandleResult.Error("无效的提交数据"));
}
var cm = await _columnService.GetModelByNum(columnNum);
if (cm == null)
{
return(HandleResult.Error("无效的提交数据"));
}
var column = cm?.Column;
var model = cm?.ModelTable;
var oldData = num.IsEmpty() ? null : await _dapper.GetByNum(model.SqlCategoryTableName, num);
var id = oldData?.Id ?? 0;
var parentNum = form["parentNum"].ToStr();
if (oldData != null && oldData.Num == parentNum)
{
return(HandleResult.Error("父类别不能是自身"));
}
var contentEdit = new DynamicTableSqlHelper(model.SqlCategoryTableName);
contentEdit.AddFieldAndValue("Name", form["name"].ToStr());
contentEdit.AddFieldAndValue("ParentNum", parentNum);
if (id > 0)
{
contentEdit.AddFieldAndValue("UpdateAccountNum", accountNum);
contentEdit.AddFieldAndValue("UpdateDate", DateTime.Now);
}
else
{
contentEdit.AddFieldAndValue("Num", RandomHelper.CreateNum());
contentEdit.AddFieldAndValue("CreateDate", DateTime.Now);
contentEdit.AddFieldAndValue("UpdateDate", DateTime.Now);
contentEdit.AddFieldAndValue("CreateAccountNum", accountNum);
contentEdit.AddFieldAndValue("UpdateAccountNum", accountNum);
contentEdit.AddFieldAndValue("IsDel", false);
contentEdit.AddFieldAndValue("Status", 0);
contentEdit.AddFieldAndValue("SiteNum", column.SiteNum);
contentEdit.AddFieldAndValue("ColumnNum", columnNum);
}
var sql = id > 0 ? contentEdit.GetUpdateSql(id) : contentEdit.GetAddSql();
var res = await _dapper.Execute(sql, contentEdit.GetValue());
return(res > 0 ? HandleResult.Success() : HandleResult.Error("操作失败"));
}
public async Task <HandleResult> Add(DynamicTableSqlHelper form)
{
var sql = form.GetAddSql();
if (sql.IsEmpty())
{
return(HandleResult.Error());
}
var res = await _dapper.Execute(sql, form.GetValue());
return(res > 0 ? HandleResult.Success() : HandleResult.Error("操作失败"));
}
/// <summary>
/// 更新是否置顶
/// </summary>
/// <param name="columnNum"></param>
/// <param name="num"></param>
/// <param name="isTop"></param>
/// <returns></returns>
public async Task <HandleResult> UpdateIsTop(string columnNum, string num, bool isTop)
{
var cm = await _columnService.GetModelByNum(columnNum);
if (cm == null || cm?.ModelTable == null)
{
return(HandleResult.Error());
}
var count = await _dapper.UpdateIsTop(cm?.ModelTable.SqlTableName, num, isTop);
return(count > 0 ? HandleResult.Success() : HandleResult.Error(""));
}
public async Task <HandleResult> Delete(string columnNum, string ids)
{
var cm = await _columnService.GetModelByNum(columnNum);
if (cm == null)
{
return(HandleResult.Error());
}
var count = await _dapper.Delete(cm?.ModelTable.SqlCategoryTableName,
ids.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries));
return(count > 0 ? HandleResult.Success() : HandleResult.Error(""));
}
public async Task <HandleResult> Add(TModal modal)
{
var id = await GetDapper().Add(modal);
if (id > 0)
{
var property = modal.GetType().GetProperty("Id");
if (property != null)
{
property.SetValue(modal, id);
}
}
return(HandleResult.Success());
}
public async Task <HandleResult> FormFields([FromBody] JObject form)
{
var id = form["id"].ToInt();
var role = id > 0 ? await _service.GetById(id) : new Role();
if (role == null)
{
return(HandleResult.Error("无效数据"));
}
return(HandleResult.Success(new
{
EditData = role,
Field = ReactForm.ToFormFields <Role>(role.Id > 0)
}));
}
public async Task <HandleResult> GetSeo([FromBody] JObject form)
{
string num = form["num"].ToStr();
if (num.IsEmpty())
{
return(HandleResult.Error("无效数据"));
}
var site = await _service.GetByNum(num);
if (site == null)
{
return(HandleResult.Error("无效数据"));
}
return(HandleResult.Success(new
{
site.SeoTitle,
site.SeoKeyword,
site.SeoDesc
}));
}
public HandleResult FuillImportRowData <T>(IEnumerable <T> data, int startRowIndex,
Func <T, string, int, string> getValueFunc)
{
if (_currentSheet == null)
{
return(HandleResult.Error("未能找到Sheet数据"));
}
if (data == null)
{
return(HandleResult.Error("没有要填充导入的数据"));
}
if (_currentSheet.LastRowNum < startRowIndex)
{
return(HandleResult.Error("起始行超过Sheet最大行数"));
}
var list = data.ToList();
try
{
for (int dataIndex = 0, currentRowIndex = startRowIndex;
dataIndex < list.Count;
dataIndex++, currentRowIndex++)
{
if (dataIndex < list.Count - 1)
{
_currentSheet.CreateRow(currentRowIndex + 1);
_currentSheet.CopyRow(currentRowIndex, currentRowIndex + 1);
}
T item = list[dataIndex];
IRow row = _currentSheet.GetRow(currentRowIndex);
foreach (var rowCell in row.Cells)
{
string cellValue = ExcelHelper.GetCellValue(rowCell).ToStr();
var macths = _placeholderRegex.Matches(cellValue);
if (macths.Count <= 0)
{
continue;
}
foreach (Match macth in macths)
{
string placeholder = macth.Groups[1].ToStr();
var newVal = "";
if (macth.Groups.Count == 2)
{
newVal = getValueFunc.Invoke(item, placeholder, dataIndex);
}
cellValue = cellValue.Replace(macth.ToString(), newVal);
}
rowCell.SetCellValue(cellValue);
}
}
}
catch (Exception ex)
{
}
return(HandleResult.Success());
}
public async Task <HandleResult> CascaderData([FromBody] JObject form)
{
return(HandleResult.Success(await _service.GetCascaderData()));
}
public async Task <HandleResult> Clear(string[] columnNums)
{
var count = await GetDapper().Clear(columnNums);
return(count > 0 ? HandleResult.Success() : HandleResult.Error(""));
}
public async Task <HandleResult> Add(List <TModal> modal)
{
var count = await GetDapper().Add(modal);
return(count > 0 ? HandleResult.Success() : HandleResult.Error(""));
}
public async Task <HandleResult> Removed(string tableName, List <int> ids)
{
var count = await _dapper.Recycle(tableName, ids, false);
return(count > 0 ? HandleResult.Success() : HandleResult.Error(""));
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="tableName"></param>
/// <param name="ids"></param>
/// <returns></returns>
public async Task <HandleResult> Delete(string tableName, List <int> ids)
{
var count = await _dapper.Delete(tableName, ids);
return(count > 0 ? HandleResult.Success() : HandleResult.Error(""));
}
public async Task <HandleResult> UpdateClickCount(string tableName, int id, int count)
{
var exCount = await _dapper.UpdateClickCount(tableName, id, count);
return(exCount > 0 ? HandleResult.Success() : HandleResult.Error(""));
}
