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("操作失败"));
}
/// <summary>
/// 创建空实例
/// </summary>
/// <returns></returns>
public static ContentData CreateEmptyInstance(string siteNum, string columnNum, string accountNum = "")
{
return(new ContentData
{
Num = RandomHelper.CreateNum(),
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
CreateAccountNum = accountNum,
UpdateAccountNum = accountNum,
SiteNum = siteNum,
ColumnNum = columnNum,
});
}
public virtual void Init()
{
if (this.Num.IsEmpty())
{
this.Num = RandomHelper.CreateNum();
}
if (CreateDate.Year == 1)
{
CreateDate = DateTime.Now;
}
if (UpdateDate.Year == 1)
{
UpdateDate = DateTime.Now;
}
}
/// <summary>
/// 获取新文件名
/// </summary>
/// <param name="oldFileName"></param>
/// <param name="ext"></param>
/// <returns></returns>
protected virtual string GetNewFileName(string oldFileName, string ext)
{
return(Path.GetFileNameWithoutExtension(oldFileName) + "_" + RandomHelper.CreateNum() + ext);
}
public DefaultQuerySql(string fieldName, QuerySymbol symbol = QuerySymbol.Equal) :
this(fieldName, $"p_{RandomHelper.CreateNum()}", symbol)
{
}
public async Task <HandleResult> Edit(JObject form, string accountNum)
{
var itemNum = form["num"].ToStr();
var columnNum = form["columnNum"].ToStr();
if (columnNum.IsEmpty())
{
return(HandleResult.Error("无效的提交数据"));
}
var column = await _columnService.GetByNum(columnNum);
if (column == null)
{
return(HandleResult.Error("无效的提交数据"));
}
var model = await _modelTableService.GetByNum(column.ModelNum);
if (model == null)
{
return(HandleResult.Error("栏目未绑定模型"));
}
ContentData oldData = null;
if (column.IsSingle)
{
oldData = await GetFirstByColumnNum(model.SqlTableName, column.Num);
}
else if (itemNum.IsNotEmpty())
{
oldData = await GetByItem(model.SqlTableName, itemNum);
}
var id = oldData?.Id ?? 0;
var contentEdit = new DynamicTableSqlHelper(model.SqlTableName);
contentEdit.SetData(await _columnFieldService.GetByColumnNum(columnNum), form);
contentEdit.AddFieldAndValue("SeoTitle", form["seoTitle"].ToStr());
contentEdit.AddFieldAndValue("SeoKeyword", form["seoKeyword"].ToStr());
contentEdit.AddFieldAndValue("SeoDesc", form["seoDesc"].ToStr());
contentEdit.AddFieldAndValue("CategoryNum", form["categoryNum"].ToStr());
contentEdit.AddFieldAndValue("IsTop", form["isTop"].ToBoolean());
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);
}
return(id > 0 ? await Update(contentEdit, id) : await Add(contentEdit));
}