public ReturnType UpdateStockCat(string stockcatCode, string catName)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
StockCat result = alading.StockCat.Where(p => p.StockCid == stockcatCode).FirstOrDefault();
if (result == null)
{
return(ReturnType.NotExisted);
}
result.StockCatName = catName;
alading.SaveChanges();
return(ReturnType.Success);
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType UpdateStockCat(StockCat stockcat)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*StockCat result = alading.StockCat.Where(p => p.StockCatID == stockcat.StockCatID).FirstOrDefault();*/
StockCat result = alading.StockCat.Where(p => p.StockCid == stockcat.StockCid).FirstOrDefault();
if (result == null)
{
return(ReturnType.NotExisted);
}
//result.StockCid = stockcat.StockCid;
result.ParentCid = stockcat.ParentCid;
result.StockCatName = stockcat.StockCatName;
result.IsParent = stockcat.IsParent;
alading.SaveChanges();
return(ReturnType.Success);
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType DeleteStockCat(string cid)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
StockCat stockCat = alading.StockCat.FirstOrDefault(c => c.StockCid == cid);
if (stockCat != null)
{
if (stockCat.IsParent)
{
return(ReturnType.Conflicted);
}
IEnumerable <StockProp> propList = alading.StockProp.Where(c => c.StockCid == cid);
IEnumerable <StockPropValue> valueList = alading.StockPropValue.Where(c => c.StockCid == cid);
foreach (StockProp stockProp in propList)
{
alading.DeleteObject(stockProp);
}
foreach (StockPropValue value in valueList)
{
alading.DeleteObject(value);
}
List <StockCat> catList = alading.StockCat.Where(c => c.ParentCid == stockCat.ParentCid).ToList();
if (catList.Count == 1)
{
StockCat fatherStockCat = alading.StockCat.FirstOrDefault(c => c.StockCid == stockCat.ParentCid);
fatherStockCat.IsParent = false;
alading.SaveChanges();
}
alading.DeleteObject(stockCat);
alading.SaveChanges();
return(ReturnType.Success);
}
else
{
return(ReturnType.NotExisted);
}
}
}
catch (System.Exception ex)
{
throw ex;
}
}
public async Task <StockCatDto> Handle(Command request, CancellationToken cancellationToken)
{
var stockCat = new StockCat
{
Title = request.Title
};
_context.StockCats.Add(stockCat);
var success = await _context.SaveChangesAsync() > 0;
if (success)
{
var toReturn = _mapper.Map <StockCat, StockCatDto>(stockCat);
return(toReturn);
}
throw new Exception("Problem saving changes");
}
public ReturnType RemoveStockCat(string stockCid)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
StockCat result = alading.StockCat.FirstOrDefault(p => p.StockCid == stockCid);
if (result == null)
{
return(ReturnType.NotExisted);
}
else
{
if (result.ParentCid != "0")
{
//查找此类目的父类目是否有其他子类目,没有则父类目IsParent为false
List <StockCat> catList = alading.StockCat.Where(i => i.ParentCid == result.ParentCid).ToList();
//只有一个子类目即本stockCid
if (catList.Count == 1)
{
StockCat parentCat = alading.StockCat.FirstOrDefault(i => i.StockCid == result.ParentCid);
if (parentCat != null)
{
parentCat.IsParent = false;
}
}
}
}
alading.DeleteObject(result);
alading.SaveChanges();
return(ReturnType.Success);
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType UpdateStockCat(string stockcatCode, StockCat stockcat)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*var result = alading.StockCat.Where(p => p.StockCatID == stockcatID).ToList();*/
var result = alading.StockCat.Where(p => p.StockCid == stockcatCode).ToList();
if (result.Count == 0)
{
return(ReturnType.NotExisted);
}
StockCat ob = result.First();
ob.StockCid = stockcat.StockCid;
ob.ParentCid = stockcat.ParentCid;
ob.StockCatName = stockcat.StockCatName;
ob.IsParent = stockcat.IsParent;
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.OthersError);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType AddStockCat(StockCat stockcat)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
alading.AddToStockCat(stockcat);
if (stockcat.ParentCid != "0")
{
StockCat result = alading.StockCat.FirstOrDefault(i => i.StockCid == stockcat.ParentCid);
if (result != null)
{
result.IsParent = true;
}
}
alading.SaveChanges();
return(ReturnType.Success);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static ReturnType UpdateStockCat(string stockcatCode, StockCat stockcat)
{
return(DataProviderClass.Instance().UpdateStockCat(stockcatCode, stockcat));
}
public static ReturnType AddStockCat(StockCat stockcat)
{
return(DataProviderClass.Instance().AddStockCat(stockcat));
}