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