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(); } }