public string Change(Member m, byte[] picData) { YogaEntities ye = new YogaEntities(); Member cc = ye.Member.FirstOrDefault((ccc) => ccc.Id == m.Id); if (cc == null) return string.Format("编号为{0}的会员不存在", m.Id); cc.Mobilephone = m.Mobilephone; cc.Name = m.Name; cc.Nation = m.Nation; cc.People = m.People; //cc.Picture = m.Picture; cc.Remarks = m.Remarks; //cc.Score = m.Score; cc.Telephone = m.Telephone; cc.CardNo = m.CardNo; cc.Gender = m.Gender; bool result = ye.SaveChanges() == 1; if (result && picData != null) { FileStream fs = null; try { fs = new FileStream(Server.MapPath(string.Format("Images/{0}.jpg", m.Id)), FileMode.Create, FileAccess.Write); fs.Write(picData, 0, picData.Length); } finally { if (fs != null) fs.Close(); } } return result ? "转卡成功" : "转卡失败"; }
public string Delete(int id) { YogaEntities ey = new YogaEntities(); Adviser cc = ey.Adviser.FirstOrDefault((ccc) => ccc.Id == id); if (cc == null) return string.Format("顾问为{0}的教练不存在", id); ey.DeleteObject(cc); return ey.SaveChanges() == 1 ? "成功" : "失败"; }
public string Update(Collect c) { YogaEntities ey = new YogaEntities(); Collect cc = ey.Collect.FirstOrDefault((ccc) => ccc.Id == c.Id); if (cc == null) return string.Format("编号为{0}的商品不存在", c.Id); cc.GoodsId = c.GoodsId; return ey.SaveChanges() == 1 ? "成功" : "失败"; }
public User Login(string userName,string pwd) { YogaEntities ye = new YogaEntities(); User u = ye.User.FirstOrDefault((uu) => uu.Name == userName && pwd == uu.Password); if(u!=null) u.Password = ""; return u; }
public int Add(PotentialMember c) { YogaEntities ey = new YogaEntities(); c.CreateTime = DateTime.Now; c.LastContact = DateTime.Now; ey.AddToPotentialMember(c); return ey.SaveChanges() == 1 ? c.Id:-1; }
public string Delete(int id) { YogaEntities ey = new YogaEntities(); PotentialMember cc = ey.PotentialMember.FirstOrDefault((ccc) => ccc.Id == id); if (cc == null) return string.Format("编号为{0}的潜在会员不存在", id); ey.DeleteObject(cc); return ey.SaveChanges() == 1 ? "成功" : "失败"; }
public string Delete(int id) { YogaEntities ey = new YogaEntities(); Collect cc = ey.Collect.FirstOrDefault((ccc) => ccc.Id == id); if (cc == null) return string.Format("编号为{0}的商品不存在", id); ey.DeleteObject(cc); return ey.SaveChanges() == 1 ? "成功" : "失败"; }
public string Update(Payment c) { YogaEntities ey = new YogaEntities(); Payment cc = ey.Payment.FirstOrDefault((ccc) => ccc.Id == c.Id); if (cc == null) return string.Format("顾问为{0}的教练不存在", c.Id); cc.Money = c.Money; cc.Date = c.Date; return ey.SaveChanges() == 1 ? "成功" : "失败"; }
public string Update(Goods c) { YogaEntities ey = new YogaEntities(); Goods cc = ey.Goods.FirstOrDefault((ccc) => ccc.Id == c.Id); if (cc == null) return string.Format("编号为{0}的商品不存在", c.Id); cc.Price = c.Price; cc.Name = c.Name; return ey.SaveChanges() == 1 ? "成功" : "失败"; }
public string AddExprire(int id,DateTime exprire,string remarks) { YogaEntities ye = new YogaEntities(); Member cc = ye.Member.FirstOrDefault((ccc) => ccc.Id == id); if (cc == null) return string.Format("编号为{0}的会员不存在", id); if (cc.ExpireDate < exprire) cc.ExpireDate = exprire; cc.Remarks = remarks; return ye.SaveChanges() == 1? "延期成功" : "延期失败"; }
public User[] List() { YogaEntities ye = new YogaEntities(); User[] us = ye.User.ToArray(); foreach (var item in us) { item.Password = ""; } return us; }
public string Update(Coach c) { YogaEntities ey = new YogaEntities(); Coach cc = ey.Coach.FirstOrDefault((ccc) => ccc.Id == c.Id); if (cc == null) return string.Format("编号为{0}的教练不存在",c.Id); cc.IsPrivate = c.IsPrivate; cc.Mobilephone = c.Mobilephone; cc.Name = c.Name; return ey.SaveChanges() == 1 ? "成功" : "失败"; }
public string Update(User c) { YogaEntities ey = new YogaEntities(); User cc = ey.User.FirstOrDefault((ccc) => ccc.Id == c.Id); if (cc == null) return string.Format("{0}不存在", c.Id); cc.Password = c.Password; cc.UserType = c.UserType; cc.Name = c.Name; return ey.SaveChanges() == 1 ? "成功" : "失败"; }
public string Allots(int[] pids, int aid) { YogaEntities ey = new YogaEntities(); PotentialMember[] cc = ey.PotentialMember.Where((ccc) => pids.Contains(ccc.Id)).ToArray(); if (cc == null || cc.Length < 1) return "指定编号的潜在客户不存在"; foreach (var item in cc) { item.AdviserId = aid; } return ey.SaveChanges() == cc.Length ? string.Format("已经成功分配给编号为{0}的顾问", aid) : "分配失败"; }
public string DeleteBatch(int[] pids) { YogaEntities ey = new YogaEntities(); PotentialMember[] cc = ey.PotentialMember.Where((ccc) => pids.Contains(ccc.Id)).ToArray(); if (cc == null || cc.Length < 1) return "指定编号的潜在客户不存在"; foreach (var item in cc) { ey.DeleteObject(item); } return ey.SaveChanges() == cc.Length ? "成功删除": "失败"; }
public string Update(Adviser c) { YogaEntities ey = new YogaEntities(); Adviser cc = ey.Adviser.FirstOrDefault((ccc) => ccc.Id == c.Id); if (cc == null) return string.Format("顾问为{0}的教练不存在", c.Id); cc.Position = c.Position; cc.Mobilephone = c.Mobilephone; cc.Name = c.Name; cc.UserId = c.UserId; return ey.SaveChanges() == 1 ? "成功" : "失败"; }
public string Update(Rack c, DateTime start, DateTime end) { YogaEntities ey = new YogaEntities(); Rack cc = ey.Rack.FirstOrDefault((ccc) => ccc.Id == c.Id); if (cc == null) return string.Format("编号为{0}的柜子不存在", c.Id); cc.RackNo = c.RackNo; cc.RentDate = start; cc.RentExpire = end; cc.RenterId = c.RenterId>0?c.RenterId:null; cc.Remarks = c.Remarks; return ey.SaveChanges() == 1 ? "成功" : "失败"; }
public User[] Search(User c, ref int page, int pageSize, out int totalPages) { YogaEntities ey = new YogaEntities(); var query = from cc in ey.User where cc.Name.Contains(c.Name) select cc; if (c.Id > 0) query = query.Where((cc) => cc.Id == c.Id); totalPages = (int)Math.Ceiling(query.Count() * 1.0 / pageSize); if (totalPages < 1) { page = 0; return null; } if (page == -1 || page > totalPages) page = totalPages; else if (page < 1) page = 1; return query.OrderBy((cc) => cc.Id).Skip((page - 1) * pageSize).Take(pageSize).ToArray(); }
public ImportRecord[] Search(ImportRecord c,string cardNo,DateTime begin,DateTime end, ref int page, int pageSize, out int totalPages) { YogaEntities ey = new YogaEntities(); var query = from cc in ey.ImportRecord where cc.MemberName.Contains(c.MemberName) && cc.Member.CardNo.Contains(cardNo) select cc; if (c.MemberId > 0) query = query.Where((cc) => cc.MemberId == c.MemberId); totalPages = (int)Math.Ceiling(query.Count() * 1.0 / pageSize); if (totalPages < 1) { page = 0; return null; } if (page == -1 || page > totalPages) page = totalPages; else if (page < 1) page = 1; return query.OrderBy((cc) => cc.Id).Skip((page - 1) * pageSize).Take(pageSize).ToArray(); }
public Collect[] Search(Collect c, DateTime dateStart, DateTime dateEnd, ref int page, int pageSize, out int totalPages) { YogaEntities ey = new YogaEntities(); var query = from cc in ey.Collect where cc.Datie >= dateStart && cc.Datie <= dateEnd select cc; if (c.Id > 0) query = query.Where((cc) => cc.Id == c.Id); if (c.GoodsId > 0) query = query.Where((cc) => cc.GoodsId == c.GoodsId); totalPages = (int)Math.Ceiling(query.Count() * 1.0 / pageSize); if (totalPages < 1) { page = 0; return null; } if (page == -1 || page > totalPages) page = totalPages; else if (page < 1) page = 1; return query.OrderBy((cc) => cc.Id).Skip((page - 1) * pageSize).Take(pageSize).ToArray(); }
public PrepaidRecord[] Search(DateTime begin, DateTime end, string cardNo, string name, int operatorId, ref int page, int pageSize, out int totalPages) { YogaEntities ye = new YogaEntities(); var query = from p in ye.PrepaidRecord where p.Member.Name.Contains(name) && p.Member.CardNo.Contains(cardNo) && p.Date >= begin && p.Date <= end select p; //if (mid > 0) query = query.Where((p) => p.MemberId == mid); if (operatorId > 0) query = query.Where((p) => p.UserId == operatorId); totalPages = (int)Math.Ceiling(query.Count() * 1.0 / pageSize); if (totalPages < 1) { page = 0; return null; } if (page == -1 || page > totalPages) page = totalPages; else if (page < 1) page = 1; return query.OrderBy((cc) => cc.Id).Skip((page - 1) * pageSize).Take(pageSize).ToArray(); }
public PotentialMember[] Search(PotentialMember c,bool includeNULLAid, ref int page, int pageSize, out int totalPages) { YogaEntities ey = new YogaEntities(); var query = from cc in ey.PotentialMember where cc.Name.Contains(c.Name) select cc; if (c.Id > 0) query = query.Where((cc) => cc.Id == c.Id); if (c.AdviserId.ToString().Length < 1) query = query.Where((cc) => cc.AdviserId == null); else if (c.AdviserId > 0 && includeNULLAid) query = query.Where((cc) => cc.AdviserId == c.AdviserId || cc.AdviserId==null); else if (c.AdviserId > 0 && !includeNULLAid) query = query.Where((cc) => cc.AdviserId == c.AdviserId); totalPages = (int)Math.Ceiling(query.Count() * 1.0 / pageSize); if (totalPages < 1) { page = 0; return null; } if (page == -1 || page > totalPages) page = totalPages; else if (page < 1) page = 1; return query.OrderBy((cc) => cc.Id).Skip((page - 1) * pageSize).Take(pageSize).ToArray(); }
public string Import(int mid,string name,bool isTemp,int rid) { YogaEntities ye = new YogaEntities(); Member cc = ye.Member.FirstOrDefault((ccc) => ccc.Id == mid); if (cc == null) return string.Format("编号为{0}的会员不存在", mid); ImportRecord ir = new ImportRecord() { Date = DateTime.Now, IsTemp = isTemp, MemberId = mid, MemberName = name, }; ye.AddToImportRecord(ir); if (ye.SaveChanges() != 1) return "进场失败"; Rack r = ye.Rack.FirstOrDefault((rr) => rr.Id == rid && (rr.RenterId==null || rr.RentExpire<=DateTime.Now)); if (r != null) { r.RentDate = DateTime.Now; r.RentExpire = r.RentDate.AddHours(8); r.RenterId = mid; ye.SaveChanges(); } Member m = ye.Member.FirstOrDefault((rr) => rr.Id == ir.Member.Id); if (m == null) return "没有该会员"; if (m.IsTemp && m.TempTimes > 0) { m.TempTimes -= 1; cc.JoneCount += 1; ye.SaveChanges(); return "进场成功"; } if (m.IsTemp && m.TempTimes <= 0) { return "次数不足"; } cc.JoneCount += 1; ye.SaveChanges(); return "进场成功"; }
public int AddMember(Member m,byte[] picData) { YogaEntities ye = new YogaEntities(); var mmm = ye.Member.FirstOrDefault((mm) =>mm.CardNo == m.CardNo); if (mmm != null) return -2;//已经存在卡号 ye.AddToMember(m); int id = ye.SaveChanges()==1 ? m.Id : -1; if (id > 0&& picData!=null) { FileStream fs = null; try { fs = new FileStream(Server.MapPath(string.Format("Images/{0}.jpg", m.Id)), FileMode.Create, FileAccess.Write); fs.Write(picData, 0, picData.Length); } finally { if (fs != null) fs.Close(); } } return id; }
public string Track(int pid) { YogaEntities ey = new YogaEntities(); PotentialMember cc = ey.PotentialMember.FirstOrDefault((ccc) => ccc.Id == pid); if (cc == null) return string.Format("编号为{0}的潜在客户不存在", pid); cc.LastContact = DateTime.Now; return ey.SaveChanges() == 1 ? "成功" : "失败"; }
public int Add(Goods a) { YogaEntities ey = new YogaEntities(); ey.AddToGoods(a); return ey.SaveChanges() == 1 ? a.Id:-1; }
public int Add(Collect a) { YogaEntities ey = new YogaEntities(); ey.AddToCollect(a); return ey.SaveChanges() == 1 ? a.Id : -1; }
public int Add(User a) { YogaEntities ey = new YogaEntities(); ey.AddToUser(a); return ey.SaveChanges() == 1 ? a.Id : -1; }
public string Add(Adviser a) { YogaEntities ey = new YogaEntities(); ey.AddToAdviser(a); return ey.SaveChanges() == 1 ? "成功" : "失败"; }
public string Update(PotentialMember c) { YogaEntities ey = new YogaEntities(); PotentialMember cc = ey.PotentialMember.FirstOrDefault((ccc) => ccc.Id == c.Id); if (cc == null) return string.Format("编号为{0}的潜在客户不存在", c.Id); cc.AdviserId = c.AdviserId; cc.CustomerChannel = c.CustomerChannel; cc.Gender = c.Gender; cc.Mobilephone = c.Mobilephone; cc.Name = c.Name; cc.Remarks = c.Remarks; return ey.SaveChanges() == 1 ? "成功" : "失败"; }