/// <summary>
/// 获得一条数据
/// </summary>
/// <returns></returns>
public async Task <ApiResult <SysCodeTypeDto> > GetByGuidAsync(string parm)
{
var model = SysCodeTypeDb.GetById(parm);
var res = new ApiResult <SysCodeTypeDto>
{
statusCode = 200,
data = model != null?new SysCodeTypeDto()
{
guid = model.Guid,
name = model.Name,
parent = model.ParentGuid,
sort = model.Sort
}:null
};
if (model != null)
{
return(await Task.Run(() => res));
}
var pmdel = Db.Queryable <SysCodeType>().OrderBy(m => m.Sort, OrderByType.Desc).First();
res.data = new SysCodeTypeDto()
{
sort = pmdel?.Sort + 1 ?? 1
};
return(await Task.Run(() => res));
}
/// <summary>
/// 获得树实现
/// </summary>
/// <returns></returns>
public async Task <ApiResult <List <SysCodeTypeTree> > > GetListTreeAsync()
{
var list = SysCodeTypeDb.GetList();
var treeList = new List <SysCodeTypeTree>();
foreach (var item in list.Where(m => m.Layer == 0).OrderBy(m => m.Sort))
{
//获得子级
var children = new List <SysCodeTypeTree>();
foreach (var row in list.Where(m => m.ParentGuid == item.Guid).OrderBy(m => m.Sort))
{
children.Add(new SysCodeTypeTree()
{
guid = row.Guid,
name = row.Name,
children = null
});
}
treeList.Add(new SysCodeTypeTree()
{
guid = item.Guid,
name = item.Name,
children = children
});
}
var res = new ApiResult <List <SysCodeTypeTree> >
{
statusCode = 200,
data = treeList
};
return(await Task.Run(() => res));
}
/// <summary>
/// 删除一条或多条数据
/// </summary>
/// <returns></returns>
public async Task <ApiResult <string> > DeleteAsync(string parm)
{
var isok = SysCodeTypeDb.Delete(m => m.Guid == parm);
var res = new ApiResult <string>
{
statusCode = isok?200:500,
data = isok ? "1" : "0",
message = isok?"删除成功~":"删除失败~"
};
return(await Task.Run(() => res));
}
/// <summary>
/// 修改一条数据
/// </summary>
/// <returns></returns>
public async Task <ApiResult <string> > ModifyAsync(SysCodeType parm)
{
var res = new ApiResult <string>
{
statusCode = 200,
data = SysCodeTypeDb.Update(m => new SysCodeType()
{
Name = parm.Name, EditTime = DateTime.Now
}, m => m.Guid == parm.Guid) ? "1" : "0"
};
return(await Task.Run(() => res));
}
/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <string> > AddAsync(SysCodeType parm)
{
parm.Guid = Guid.NewGuid().ToString();
parm.AddTime = DateTime.Now;
parm.EditTime = DateTime.Now;
var res = new ApiResult <string>
{
statusCode = 200,
data = SysCodeTypeDb.Insert(parm) ?"1":"0"
};
return(await Task.Run(() => res));
}
/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <string> > AddAsync(SysCodeTypeDto parm)
{
var model = new SysCodeType()
{
Guid = Guid.NewGuid().ToString(),
Name = parm.name,
ParentGuid = parm.parent,
Layer = !string.IsNullOrEmpty(parm.parent)?1:0,
Sort = parm.sort,
AddTime = DateTime.Now,
EditTime = DateTime.Now
};
var res = new ApiResult <string>
{
statusCode = 200,
data = SysCodeTypeDb.Insert(model)?"1":"0"
};
return(await Task.Run(() => res));
}
/// <summary>
/// 添加一条数据
/// </summary>
/// <returns></returns>
public async Task <ApiResult <string> > AddAsync(ErpGoodsSku parm)
{
var res = new ApiResult <string>()
{
data = "1", statusCode = 200
};
try
{
//判断是否存在
var isExt = ErpGoodsSkuDb.IsAny(m => m.Code == parm.Code);
if (isExt)
{
res.statusCode = (int)ApiEnum.ParameterError;
res.message = "该条形码已存在~";
}
else
{
//构建Code
var codeType = SysCodeTypeDb.GetList(m => m.ParentGuid == "8d3158d6-e179-4046-99e9-53eb8c04ddb1").Select(m => m.Guid).ToList();
var codeList = SysCodeDb.GetList(m => codeType.Contains(m.ParentGuid));
parm.Code = codeList.Find(m => m.Guid == parm.BrankGuid).CodeType
+ codeList.Find(m => m.Guid == parm.YearGuid).CodeType
+ codeList.Find(m => m.Guid == parm.SeasonGuid).CodeType
+ codeList.Find(m => m.Guid == parm.StyleGuid).CodeType
+ codeList.Find(m => m.Guid == parm.BatchGuid).CodeType
+ codeList.Find(m => m.Guid == parm.SizeGuid).CodeType
+ parm.SalePrice
+ "-" + parm.DisPrice;
//构建商品标题
var brankName = codeList.Find(m => m.Guid == parm.BrankGuid).Name;
var styleName = codeList.Find(m => m.Guid == parm.StyleGuid).Name;
var goodsName = brankName + codeList.Find(m => m.Guid == parm.SeasonGuid).Name + styleName;
//构建商品信息
var goodsModel = new ErpGoods()
{
Guid = Guid.NewGuid().ToString(),
Title = goodsName,
Brank = brankName,
Style = styleName
};
parm.GoodsGuid = goodsModel.Guid;
parm.Guid = Guid.NewGuid().ToString();
//事务保证数据一致性
Db.Ado.BeginTran();
var goodsres = ErpGoodsDb.Insert(goodsModel);
if (goodsres)
{
var dbres = ErpGoodsSkuDb.Insert(parm);
if (!dbres)
{
res.statusCode = (int)ApiEnum.Error;
res.message = "插入数据失败~";
}
}
Db.Ado.CommitTran();
}
}
catch (Exception ex)
{
Db.Ado.RollbackTran();
res.statusCode = (int)ApiEnum.Error;
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
}
return(await Task.Run(() => res));
}
