public Shop ShopSave(Shop shop)
{
Shop findOne = db.Shop.Where(x => (x.ShopId == shop.ShopId)).FirstOrDefault();
if (findOne == null)
{
shop.InDateTime = DateTime.Now;
shop.ModifyDateTime = DateTime.Now;
db.Shop.Add(shop);
}
else
{
findOne.ShopCode = shop.ShopCode;
findOne.ShopName = shop.ShopName;
findOne.ShopNameEn = shop.ShopNameEn;
findOne.AreaId = shop.AreaId;
findOne.Budget = shop.Budget;
findOne.Balance = shop.Balance;
findOne.City = shop.City;
findOne.ModifyDateTime = DateTime.Now;
findOne.ModifyUserId = shop.ModifyUserId;
shop = findOne;
}
db.SaveChanges();
return(shop);
}
public DMFItem DMFItemSave(DMFItem dmfItem)
{
DMFItem findOne = db.DMFItem.Where(x => (x.DMFItemId == dmfItem.DMFItemId)).FirstOrDefault();
if (findOne == null)
{
dmfItem.InDateTime = DateTime.Now;
dmfItem.ModifyDateTime = DateTime.Now;
db.DMFItem.Add(dmfItem);
}
else
{
findOne.DMFItemName = dmfItem.DMFItemName;
findOne.DMFItemNameEn = dmfItem.DMFItemNameEn;
findOne.DMFItemRemark = dmfItem.DMFItemRemark;
findOne.ExpenseAccountChk = dmfItem.ExpenseAccountChk;
findOne.ModifyDateTime = DateTime.Now;
findOne.ModifyUserId = dmfItem.ModifyUserId;
findOne.PublishChk = dmfItem.PublishChk;
dmfItem = findOne;
}
db.SaveChanges();
return(dmfItem);
}
public void ShopCommitFileRecordSave(ShopCommitFileRecord shopCommitFileRecord)
{
if (shopCommitFileRecord.SeqNO == 0)
{
ShopCommitFileRecord findOneMax = db.ShopCommitFileRecord.Where(x => (x.ShopId == shopCommitFileRecord.ShopId && x.FileId == shopCommitFileRecord.FileId)).OrderByDescending(x => x.SeqNO).FirstOrDefault();
if (findOneMax == null)
{
shopCommitFileRecord.SeqNO = 1;
}
else
{
shopCommitFileRecord.SeqNO = findOneMax.SeqNO + 1;
}
shopCommitFileRecord.InDateTime = DateTime.Now;
shopCommitFileRecord.ModifyDateTime = DateTime.Now;
db.ShopCommitFileRecord.Add(shopCommitFileRecord);
db.SaveChanges();
}
}
