public RouteData <Wms_StockInMaterialDetailDto> SearchMaterial(long storeId, long stockInId, string materialNo)
{
Wms_material material = _client.Queryable <Wms_material>().First(x => x.MaterialNo == materialNo);
if (material == null)
{
return(RouteData <Wms_StockInMaterialDetailDto> .From(PubMessages.E1005_MATERIALNO_NOTFOUND));
}
Wms_stockindetail detail = _stockindetailServices.QueryableToEntity(x => x.StockInId == stockInId && x.MaterialId == material.MaterialId);
if (detail == null)
{
return(RouteData <Wms_StockInMaterialDetailDto> .From(PubMessages.E2015_STOCKIN_HASNOT_MATERIAL));
}
Wms_StockInMaterialDetailDto detailDto = new Wms_StockInMaterialDetailDto()
{
StockInId = detail.StockInId.ToString(),
StockInDetailId = detail.StockInDetailId.ToString(),
MaterialId = material.MaterialId.ToString(),
MaterialNo = material.MaterialNo,
MaterialName = material.MaterialName,
PlanInQty = (int)detail.PlanInQty,
ActInQty = (int)detail.ActInQty,
Qty = 0
};
return(RouteData <Wms_StockInMaterialDetailDto> .From(detailDto));
}
public IActionResult AddOrUpdate([FromForm] Wms_material model, [FromForm] string id)
{
var validator = new MaterialFluent();
var results = validator.Validate(model);
var success = results.IsValid;
if (!success)
{
string msg = results.Errors.Aggregate("", (current, item) => (current + item.ErrorMessage + "</br>"));
return(BootJsonH((PubEnum.Failed.ToInt32(), msg)));
}
if (id.IsEmptyZero())
{
if (_materialServices.IsAny(c => c.MaterialNo == model.MaterialNo || c.MaterialName == model.MaterialName))
{
return(BootJsonH((false, PubConst.Material1)));
}
model.MaterialId = PubId.SnowflakeId;
model.CreateBy = UserDtoCache.UserId;
bool flag = _materialServices.Insert(model);
return(BootJsonH(flag ? (flag, PubConst.Add1) : (flag, PubConst.Add2)));
}
else
{
model.MaterialId = id.ToInt64();
model.ModifiedBy = UserDtoCache.UserId;
model.ModifiedDate = DateTimeExt.DateTime;
var flag = _materialServices.Update(model);
return(BootJsonH(flag ? (flag, PubConst.Update1) : (flag, PubConst.Update2)));
}
}
public async Task <RouteData <Wms_StockOutMaterialDetailDto> > SearchMaterial(long storeId, long stockOutId, string materialNo)
{
Wms_material material = await _client.Queryable <Wms_material>().FirstAsync(x => x.MaterialNo == materialNo);
if (material == null)
{
return(RouteData <Wms_StockOutMaterialDetailDto> .From(PubMessages.E1005_MATERIALNO_NOTFOUND));
}
Wms_stockout stockout = await _client.Queryable <Wms_stockout>().FirstAsync(x => x.StockOutId == stockOutId);
if (stockout == null)
{
return(RouteData <Wms_StockOutMaterialDetailDto> .From(PubMessages.E2115_STOCKOUT_HASNOT_MATERIAL));
}
Wms_stockoutdetail detail = await _client.Queryable <Wms_stockoutdetail>().FirstAsync(x => x.StockOutId == stockOutId && x.MaterialId == material.MaterialId);
if (detail == null)
{
return(RouteData <Wms_StockOutMaterialDetailDto> .From(PubMessages.E2115_STOCKOUT_HASNOT_MATERIAL));
}
Wms_StockOutMaterialDetailDto detailDto = new Wms_StockOutMaterialDetailDto()
{
StockOutId = detail.StockOutId.ToString(),
StockOutDetailId = detail.StockOutDetailId.ToString(),
MaterialId = material.MaterialId.ToString(),
MaterialNo = material.MaterialNo,
MaterialName = material.MaterialName,
OrderNo = stockout.OrderNo,
PlanOutQty = (int)detail.PlanOutQty,
ActOutQty = (int)detail.ActOutQty,
Qty = 0
};
return(RouteData <Wms_StockOutMaterialDetailDto> .From(detailDto));
}
public IActionResult AddOrUpdate([FromForm] Wms_material model, [FromForm] string id)
{
var validator = new MaterialFluent();
var results = validator.Validate(model);
var success = results.IsValid;
if (!success)
{
string msg = results.Errors.Aggregate("", (current, item) => (current + item.ErrorMessage + "</br>"));
return(BootJsonH((PubEnum.Failed.ToInt32(), msg)));
}
Sys_dict unitDict = _client.Queryable <Sys_dict>().First(x => x.DictId == model.Unit && x.DictType == PubDictType.unit.ToInt32().ToString());
if (unitDict == null)
{
return(BootJsonH((false, PubConst.UnitNotFound)));
}
Sys_dict typeDict = _client.Queryable <Sys_dict>().First(x => x.DictId == model.MaterialType && x.DictType == PubDictType.material.ToInt32().ToString());
if (typeDict == null)
{
return(BootJsonH((false, PubConst.MaterialTypeNotFound)));
}
if (id.IsEmptyZero())
{
if (_materialServices.IsAny(c => c.MaterialNo == model.MaterialNo || c.MaterialName == model.MaterialName))
{
return(BootJsonH((false, PubConst.Material1)));
}
model.MaterialId = PubId.SnowflakeId;
model.UnitName = unitDict.DictName;
model.MaterialTypeName = typeDict.DictName;
model.CreateBy = UserDtoCache.UserId;
model.CreateDate = DateTime.Now;
model.CreateUser = UserDtoCache.UserName;
model.ModifiedBy = UserDtoCache.UserId;
model.ModifiedDate = DateTime.Now;
model.ModifiedUser = UserDtoCache.UserName;
bool flag = _materialServices.Insert(model);
return(BootJsonH(flag ? (flag, PubConst.Add1) : (flag, PubConst.Add2)));
}
else
{
model.MaterialId = id.ToInt64();
model.UnitName = unitDict.DictName;
model.MaterialTypeName = typeDict.DictName;
model.ModifiedBy = UserDtoCache.UserId;
model.ModifiedDate = DateTimeExt.DateTime;
var flag = _materialServices.Update(model);
return(BootJsonH(flag ? (flag, PubConst.Update1) : (flag, PubConst.Update2)));
}
}
public async Task <RouteData <Wms_material> > SearchMaterialNo(long storeId, string materialNo)
{
Wms_material material = await _materialServices.Queryable().FirstAsync(x => x.WarehouseId == storeId && x.MaterialNo == materialNo);
if (material == null)
{
return(RouteData <Wms_material> .From(PubMessages.E1005_MATERIALNO_NOTFOUND));
}
return(RouteData <Wms_material> .From(material));
}
public IActionResult Add(string id)
{
var model = new Wms_material();
if (id.IsEmpty())
{
return(View(model));
}
else
{
model = _materialServices.QueryableToEntity(c => c.MaterialId == SqlFunc.ToInt64(id));
return(View(model));
}
}