public static int AddPay(Pay model) { using (var entity = new BusEntities()) { var id = 0; try { model.LockFlag = "00"; model.DelFlag = "N"; entity.AddToPay(model); entity.SaveChanges(); id = model.ID; } catch { } return(id); } }
public static bool SaveEditUsers2(Users model) { using (var entity = new BusEntities()) { var obj = entity.Users.FirstOrDefault(x => x.ID == model.ID); if (obj != null) { obj.Names = model.Names; obj.Phone = model.Phone; obj.PhoneFlag = model.PhoneFlag; obj.Sex = model.Sex; obj.Password = model.Password; obj.StartTime = model.StartTime; obj.EndTime = model.EndTime; obj.CardNo = model.CardNo; obj.CardNo2 = model.CardNo2; obj.CompanyName = model.CompanyName; obj.AddressSel = model.AddressSel; obj.Address = model.Address; obj.EndAddressSel = model.EndAddressSel; obj.EndAddress = model.EndAddress; obj.StartLat = model.StartLat; obj.StartLong = model.StartLong; obj.EndLat = model.EndLat; obj.EndLong = model.EndLong; obj.EMail = model.EMail; obj.QQ = model.QQ; obj.StateID = model.StateID; obj.UserType = model.UserType == null ? "USER" : model.UserType; obj.Etc = model.Etc; obj.UpdateTime = DateTime.Now; obj.UpdateMngID = model.UpdateMngID; return(entity.SaveChanges() > 0); } return(false); } }
public static int AddPayLmng(PayLmng model) { using (var entity = new BusEntities()) { var id = 0; try { model.UpdateTime = DateTime.Now; model.CreateTime = DateTime.Now; model.DelFlag = "N"; entity.AddToPayLmng(model); entity.SaveChanges(); id = model.ID; } catch { } return(id); } }
public static bool SetUserLocal(Users model) { using (var entity = new BusEntities()) { var obj = entity.Users.FirstOrDefault(x => x.ID == model.ID); if (obj != null) { obj.Address = model.Address; obj.StartLong = model.StartLong; obj.StartLat = model.StartLat; obj.EndLong = model.EndLong; obj.EndLat = model.EndLat; obj.EndAddress = model.EndAddress; var result = entity.SaveChanges(); return(result > 0); } return(false); } }
public static bool SaveEditMyContent(MyContent model) { using (var entity = new BusEntities()) { var obj = entity.MyContent.FirstOrDefault(x => x.ID == model.ID); if (obj != null) { obj.action = model.action; obj.Title = model.Title; obj.Thumb = model.Thumb; obj.SubContent = model.SubContent; obj.LinkUrl = model.LinkUrl; obj.Contents = model.Contents; return(entity.SaveChanges() > 0); } return(false); } }
public static bool DeleteBusLine(int ID) { //using (var entity = new BusEntities()) //{ // var obj = entity.BusLine.FirstOrDefault(x => x.ID == ID); // entity.DeleteObject(obj); // return entity.SaveChanges() > 0; //} using (var entity = new BusEntities()) { var obj = entity.BusLine.FirstOrDefault(x => x.ID == ID); if (obj != null) { obj.DelFlag = "Y"; return(entity.SaveChanges() > 0); } return(false); } }
public static bool DeleteAddressByParentID(IQueryBuilder <Address> iquery) { using (var entity = new BusEntities()) { List <Address> addressList = entity.Address.Where(iquery.Expression).ToList(); if (addressList.Count != 0) { foreach (var address in addressList) { entity.DeleteObject(address); } return(entity.SaveChanges() > 0); } else { return(true); } } }
public static bool AddEtc(Users model) { using (var entity = new BusEntities()) { var obj = entity.Users.FirstOrDefault(x => x.ID == model.ID); if (obj != null) { if (obj.Etc != null && obj.Etc != "") { obj.Etc = obj.Etc + "*" + model.Etc; } else { obj.Etc = "*" + model.Etc; } return(entity.SaveChanges() > 0); } return(false); } }
public static bool SaveEditUsers_Map2(Users model) { using (var entity = new BusEntities()) { var obj = entity.Users.FirstOrDefault(x => x.ID == model.ID); if (obj != null) { //obj.Address = model.Address; //obj.StartTime = model.StartTime; //obj.EndTime = model.EndTime; //obj.StartLong = model.StartLong; //obj.StartLat = model.StartLat; obj.EndLong = model.EndLong; obj.EndLat = model.EndLat; //obj.isFinal = model.isFinal; obj.EndAddress = model.EndAddress; return(entity.SaveChanges() > 0); } return(false); } }
public static bool SaveEditUsersMyInfo(Users model) { using (var entity = new BusEntities()) { var obj = entity.Users.FirstOrDefault(x => x.ID == model.ID); if (obj != null) { obj.Names = model.Names; obj.Phone = model.Phone; obj.Sex = model.Sex; obj.EMail = model.EMail; obj.QQ = model.QQ; obj.CompanyName = model.CompanyName; obj.StartTime = model.StartTime; obj.EndTime = model.EndTime; obj.isFinal = true; return(entity.SaveChanges() > 0); } return(false); } }
public static bool SaveEditOrder(Order model) { using (var entity = new BusEntities()) { var obj = entity.Order.FirstOrDefault(x => x.ID == model.ID); if (obj != null) { //obj.LineID = model.LineID; obj.Phone = model.Phone; obj.Names = model.Names; obj.Months = model.Months; //obj.Price = model.Price; //obj.States = model.States; //obj.Memo = model.Memo; //obj.UserID = model.UserID; obj.PayTypeID = model.PayTypeID; return(entity.SaveChanges() > 0); } return(false); } }
public static bool SaveEditPayLmng(PayLmng model) { using (var entity = new BusEntities()) { var obj = entity.PayLmng.FirstOrDefault(x => x.ID == model.ID); if (obj != null) { obj.LineID = model.LineID; obj.PayTime = model.PayTime; obj.PayMoneyYS = model.PayMoneyYS; obj.PayMoneySS = model.PayMoneySS; obj.PayMoneyDC = model.PayMoneyDC; obj.Ect = model.Ect; obj.MangerID = model.MangerID; obj.UpdateTime = DateTime.Now; return(entity.SaveChanges() > 0); } return(false); } }
public static bool SaveEditDriver(Driver model) { using (var entity = new BusEntities()) { var obj = entity.Driver.FirstOrDefault(x => x.ID == model.ID); if (obj != null) { obj.Address = model.Address; obj.BirthDay = model.BirthDay; obj.BreakRules = model.BreakRules; obj.CreateTime = model.CreateTime; obj.DriverName = model.DriverName; obj.DriveStartTime = model.DriveStartTime; obj.Etc = model.Etc; //obj.ID = model.ID; obj.IdCard = model.IdCard; obj.Phone = model.Phone; obj.Sex = model.Sex; return(entity.SaveChanges() > 0); } return(false); } }
public static bool SaveEditLineUser(LineUser model) { using (var entity = new BusEntities()) { var obj = entity.LineUser.FirstOrDefault(x => x.ID == model.ID); if (obj != null) { obj.LineID = model.LineID; obj.UserID = model.UserID; obj.Names = model.Names; obj.Phone = model.Phone; obj.StartAddress = model.StartAddress; obj.EndAddress = model.EndAddress; obj.EndTime = model.EndTime; obj.Memo = model.Memo; obj.EMail = model.EMail; obj.QQ = model.QQ; obj.StateID = model.StateID; return(entity.SaveChanges() > 0); } return(false); } }
public static bool SaveEditBusLine(BusLine model) { using (var entity = new BusEntities()) { var obj = entity.BusLine.FirstOrDefault(x => x.ID == model.ID); if (obj != null) { obj.LineName = model.LineName; obj.StartBusID = model.StartBusID; obj.StartAddress = model.StartAddress; obj.StartTime = model.StartTime; //obj.StartLong = model.StartLong; //obj.StartLat = model.StartLat; obj.EndBusID = model.EndBusID; obj.EndAddress = model.EndAddress; obj.EndTime = model.EndTime; //obj.EndLong = model.EndLong; //obj.EndLat = model.EndLat; obj.Price = model.Price; obj.PriceMon = model.PriceMon; obj.PriceNgt = model.PriceNgt; //obj.MinNum = model.MinNum; //obj.TypeID = model.TypeID; //obj.Number = model.Number; //obj.Price2 = model.Price2; //obj.CheX = model.CheX; //obj.CheZ = model.CheZ; //obj.LineType = model.LineType; obj.TypeID = model.TypeID; obj.Etc = model.Etc; obj.CreateTime = model.CreateTime; return(entity.SaveChanges() > 0); } return(false); } }
public static bool SaveEditPay(Pay model) { using (var entity = new BusEntities()) { var obj = entity.Pay.FirstOrDefault(x => x.ID == model.ID); if (obj != null) { obj.UserID = model.UserID; obj.LineUserID = model.LineUserID; obj.StartDate = model.StartDate; obj.EndDate = model.EndDate; obj.PayTime = model.PayTime; obj.PayMoney = model.PayMoney; obj.PayType = model.PayType; obj.MangerID = model.MangerID; obj.UpdateTime = model.UpdateTime; obj.CreateTime = model.CreateTime; obj.Etc = model.Etc; return(entity.SaveChanges() > 0); } return(false); } }