public async Task<int> Save(T_Customer_Task model) { using (db = new KBLDataContext()) { var entity = await (from t in db.CustomerTasks where t.TaskId == model.TaskId select t).FirstOrDefaultAsync(); if (entity == null) { entity = await (from t in db.CustomerTasks where t.CId == model.CId orderby t.StartDate descending select t).FirstOrDefaultAsync(); if (entity != null) { model.Describe = entity.Describe; model.Other = entity.Other; model.During = (model.StartDate - entity.StartDate).Value.Days + ""; model.Review = (model.StartDate - entity.StartDate).Value.Days + ""; } db.CustomerTasks.Add(model); } else { entity.StartDate = model.StartDate; entity.Describe = model.Describe; entity.Review = model.Review; entity.ReviewStatus = model.ReviewStatus; entity.During = model.During; entity.Other = model.Other; db.Entry(entity).State = EntityState.Modified; } return await db.SaveChangesAsync(); } }
public async Task<int> Save(T_Customer_Product model) { using (db = new KBLDataContext()) { var entity = from t in db.CustomerProducts where t.Pid == model.Pid select t; T_Customer_Product _prodcut = await entity.FirstOrDefaultAsync(); if (_prodcut == null) { db.CustomerProducts.Add(model); } else { _prodcut.Name = model.Name; _prodcut.Price = model.Price; _prodcut.Quantity = model.Quantity; _prodcut.SaleAmount = model.SaleAmount; _prodcut.Vp = model.Vp; _prodcut.PurchasingDate = model.PurchasingDate; _prodcut.GeneratintVpDate = model.GeneratintVpDate; db.Entry(_prodcut).State = EntityState.Modified; } return await db.SaveChangesAsync(); } }
public async Task<object> Save(T_Customer model) { var cname = model.CName; var contact = model.Contact; using (db = new KBLDataContext()) { var exist = await (from c in db.Customers where c.Cid == model.Cid select c).FirstOrDefaultAsync(); if (exist == null) { db.Customers.Add(model); int effects = await db.SaveChangesAsync(); return new { effects = effects, model = model }; } else { //UpdateModel(); exist.Dietitian = model.Dietitian; exist.CName = model.CName; exist.CustomerNo = model.CustomerNo; exist.Age = model.Age; exist.CategoryID = model.CategoryID; exist.Addr = model.Addr; exist.Weight = model.Weight; exist.Height = model.Height; exist.Gender = model.Gender; exist.Contact = model.Contact; exist.CardType = model.CardType; exist.Married = model.Married; exist.Address = model.Address; exist.Remark = model.Remark; db.Entry(exist).State = EntityState.Modified; int effects = await db.SaveChangesAsync(); return new { effects = effects }; } } }
/// <summary> /// 用户信息修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public async Task<int> Save(T_Customer_Role model) { using (db = new KBLDataContext()) { var entity = from r in db.CustomerRoles where r.Rid == model.Rid select r; T_Customer_Role role = await entity.FirstOrDefaultAsync(); if (role == null) { model.CreateDate = Helper.Comm.GetIntFromTime(DateTime.Now); model.UpdateAccountDate = Helper.Comm.GetIntFromTime(DateTime.Now); db.CustomerRoles.Add(model); } else { role.UserName = model.UserName; role.Password = model.Password; role.Cid = model.Cid; role.UpdateAccountDate = Helper.Comm.GetIntFromTime(DateTime.Now); db.Entry(role).State = EntityState.Modified; } return await db.SaveChangesAsync(); } }