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