public static Business Edit(Business business)
{
TN db = new TN();
Business oldBusiness = db.Businesses.Where(en => en.idbuss == business.idbuss).FirstOrDefault();
oldBusiness.idbuss = business.idbuss;
oldBusiness.buss = business.buss;
oldBusiness.contact = business.contact;
oldBusiness.phone = business.phone;
oldBusiness.city = business.city;
oldBusiness.addr = business.addr;
oldBusiness.sellpt = business.sellpt;
oldBusiness.cretime = business.cretime;
oldBusiness.busstime = business.busstime;
oldBusiness.price = business.price;
oldBusiness.longitude = business.longitude;
oldBusiness.latitude = business.latitude;
oldBusiness.runtime = business.runtime;
oldBusiness.notes = business.notes;
oldBusiness.blevel = business.blevel;
oldBusiness.inuse = business.inuse;
db.SaveChanges();
return(oldBusiness);
}
public static MyOrder Edit(MyOrder order)
{
TN db = new TN();
MyOrder oldOrder = db.MyOrders.Where(en => en.orderno == order.orderno).FirstOrDefault();
oldOrder.orderno = order.orderno;
oldOrder.iduser = order.iduser;
oldOrder.idmerc = order.idmerc;
oldOrder.merc = order.merc;
oldOrder.idspec = order.idspec;
oldOrder.spec = order.spec;
oldOrder.month = order.month;
oldOrder.attmonth = order.attmonth;
oldOrder.count = order.count;
oldOrder.price = order.orderno;
oldOrder.contact = order.contact;
oldOrder.addr = order.addr;
oldOrder.phone = order.phone;
oldOrder.cretime = order.cretime;
oldOrder.stime = order.stime;
oldOrder.entime = order.entime;
oldOrder.otype = order.otype;
oldOrder.status = order.status;
oldOrder.img = order.img;
oldOrder.notes = order.notes;
oldOrder.idc = order.idc;
oldOrder.idc_img1 = order.idc_img1;
oldOrder.idc_img2 = order.idc_img2;
oldOrder.inuse = order.inuse;
db.SaveChanges();
return(oldOrder);
}
public static List <MercImage> AddMuti(List <MercImage> mercImages)
{
TN db = new TN();
db.MercImages.AddRange(mercImages);
db.SaveChanges();
return(mercImages);
}
public static ManageUser Add(ManageUser manageUser)
{
TN db = new TN();
db.ManageUsers.Add(manageUser);
db.SaveChanges();
return(manageUser);
}
public static City Add(City city)
{
TN db = new TN();
db.Cities.Add(city);
db.SaveChanges();
return(city);
}
public static MercImage Add(MercImage mercImage)
{
TN db = new TN();
db.MercImages.Add(mercImage);
db.SaveChanges();
return(mercImage);
}
public static TaskRecver Add(TaskRecver taskRecver)
{
TN db = new TN();
db.TaskRecvers.Add(taskRecver);
db.SaveChanges();
return(taskRecver);
}
public static BussImage Add(BussImage bussImage)
{
TN db = new TN();
db.BussImages.Add(bussImage);
db.SaveChanges();
return(bussImage);
}
public static Business Add(Business business)
{
TN db = new TN();
db.Businesses.Add(business);
db.SaveChanges();
return(business);
}
public static SetupAddr Add(SetupAddr setup)
{
TN db = new TN();
db.SetupAddrs.Add(setup);
db.SaveChanges();
return(setup);
}
public static Merc Add(Merc merc)
{
TN db = new TN();
db.Mercs.Add(merc);
db.SaveChanges();
return(merc);
}
public static List <CityRelation> Add(List <CityRelation> cityRelations)
{
TN db = new TN();
db.CityRelations.AddRange(cityRelations);
db.SaveChanges();
return(cityRelations);
}
public static List <TaskRecver> AddMuil(List <TaskRecver> taskRecvers)
{
TN db = new TN();
db.TaskRecvers.AddRange(taskRecvers);
db.SaveChanges();
return(taskRecvers);
}
public static Spec Add(Spec spec)
{
TN db = new TN();
db.Specs.Add(spec);
db.SaveChanges();
return(spec);
}
public static List <BussImage> AddMuti(List <BussImage> bussImages)
{
TN db = new TN();
db.BussImages.AddRange(bussImages);
db.SaveChanges();
return(bussImages);
}
public static Advertise Add(Advertise advertise)
{
TN db = new TN();
db.Advertises.Add(advertise);
db.SaveChanges();
return(advertise);
}
public static Notice Add(Notice notice)
{
TN db = new TN();
db.Notices.Add(notice);
db.SaveChanges();
return(notice);
}
public static Task Add(Task task)
{
TN db = new TN();
db.Tasks.Add(task);
db.SaveChanges();
return(task);
}
public static List <CityRelation> Delete(List <CityRelation> cityRelations)
{
TN db = new TN();
List <string> idrelations = cityRelations.Select(mod => {
return(mod.idrelation);
}).ToList();
db.CityRelations.RemoveRange(db.CityRelations.Where(en => idrelations.Contains(en.idrelation)));
db.SaveChanges();
return(cityRelations);
}
public static City Edit(City city)
{
TN db = new TN();
City oldCity = db.Cities.Where(en => en.idcity == city.idcity).FirstOrDefault();
oldCity.idcity = city.idcity;
oldCity.city1 = city.city1;
oldCity.notes = city.notes;
oldCity.sortno = city.sortno;
oldCity.inuse = city.inuse;
db.SaveChanges();
return(oldCity);
}
public static AdvertiseType Edit(AdvertiseType advertiseType)
{
TN db = new TN();
AdvertiseType oldAdvertiseType = db.AdvertiseTypes.Where(en => en.idat == advertiseType.idat).FirstOrDefault();
oldAdvertiseType.idat = advertiseType.idat;
oldAdvertiseType.typename = advertiseType.typename;
oldAdvertiseType.sortno = advertiseType.sortno;
oldAdvertiseType.inuse = advertiseType.inuse;
db.SaveChanges();
return(oldAdvertiseType);
}
public static CityRelation Edit(CityRelation cityRelation)
{
TN db = new TN();
CityRelation oldCityRelation = db.CityRelations.Where(en => en.idrelation == cityRelation.idrelation).FirstOrDefault();
oldCityRelation.idrelation = cityRelation.idrelation;
oldCityRelation.idcity = cityRelation.idcity;
oldCityRelation.idmodule = cityRelation.idmodule;
oldCityRelation.moduletype = cityRelation.moduletype;
oldCityRelation.inuse = cityRelation.inuse;
db.SaveChanges();
return(oldCityRelation);
}
public static MercImage Edit(MercImage mercImage)
{
TN db = new TN();
MercImage oldMercImage = db.MercImages.Where(en => en.MercImageId == mercImage.MercImageId).FirstOrDefault();
oldMercImage.idmerc = mercImage.idmerc;
oldMercImage.InUse = mercImage.InUse;
oldMercImage.MercImageId = mercImage.MercImageId;
oldMercImage.Path = mercImage.Path;
oldMercImage.SortID = mercImage.SortID;
db.SaveChanges();
return(oldMercImage);
}
public static BussImage Edit(BussImage bussImage)
{
TN db = new TN();
BussImage oldBussImage = db.BussImages.Where(en => en.BussImageId == bussImage.BussImageId).FirstOrDefault();
oldBussImage.BussImageId = bussImage.BussImageId;
oldBussImage.idbuss = bussImage.idbuss;
oldBussImage.Path = bussImage.Path;
oldBussImage.SortID = bussImage.SortID;
oldBussImage.InUse = bussImage.InUse;
db.SaveChanges();
return(oldBussImage);
}
public static MercType Edit(MercType mercType)
{
TN db = new TN();
MercType oldMercType = db.MercTypes.Where(en => en.idtype == mercType.idtype).FirstOrDefault();
oldMercType.idtype = mercType.idtype;
oldMercType.name = mercType.name;
oldMercType.notes = mercType.notes;
oldMercType.sortno = mercType.sortno;
oldMercType.inuse = mercType.inuse;
db.SaveChanges();
return(oldMercType);
}
public Result <long> Update(TCom.EF.MyAddr data)
{
Result <long> result = new Result <long>();
try
{
using (TN db = new TN())
{
if (data.idaddr <= 0)
{
data.idaddr = Pub.ID();
db.MyAddrs.Add(data);
}
else
{
DbEntityEntry <TCom.EF.MyAddr> entry = db.Entry <TCom.EF.MyAddr>(data);
if (data.inuse == false)
{
entry.State = EntityState.Deleted;
}
else
{
entry.State = EntityState.Unchanged;
entry.Property("contact").IsModified = true;
entry.Property("phone").IsModified = true;
entry.Property("province").IsModified = true;
entry.Property("city").IsModified = true;
entry.Property("district").IsModified = true;
entry.Property("street").IsModified = true;
entry.Property("tag").IsModified = true;
entry.Property("isdv").IsModified = true;
entry.Property("notes").IsModified = true;
entry.Property("inuse").IsModified = true;
}
}
if (db.SaveChanges() > 0)
{
result.Data = data.idaddr;
}
result.Code = R.Ok;
}
}
catch (Exception)
{
result.Code = R.Error;
result.Msg = "出现异常";
}
return(result);
}
public static Advertise Edit(Advertise advertise)
{
TN db = new TN();
Advertise oldAdvertise = db.Advertises.Where(en => en.idav == advertise.idav).FirstOrDefault();
oldAdvertise.idav = advertise.idav;
oldAdvertise.idat = advertise.idat;
oldAdvertise.title = advertise.title;
oldAdvertise.img = advertise.img;
oldAdvertise.link = advertise.link;
oldAdvertise.sortno = advertise.sortno;
oldAdvertise.inuse = advertise.inuse;
db.SaveChanges();
return(oldAdvertise);
}
public static bool DeleteBussImages(long idbuss)
{
bool result = false;
try {
TN db = new TN();
db.BussImages.RemoveRange(db.BussImages.Where(en => en.idbuss == idbuss));
db.SaveChanges();
result = true;
}
catch (Exception) {
result = false;
}
return(result);
}
public static TaskRecver Edit(TaskRecver taskRecver)
{
TN db = new TN();
TaskRecver oldTaskRecver = db.TaskRecvers.Where(en => en.idtask == taskRecver.idtask).FirstOrDefault();
oldTaskRecver.idrecver = taskRecver.idrecver;
oldTaskRecver.idtask = taskRecver.idtask;
oldTaskRecver.mcode = taskRecver.mcode;
oldTaskRecver.mname = taskRecver.mname;
oldTaskRecver.smcode = taskRecver.smcode;
oldTaskRecver.smname = taskRecver.smname;
oldTaskRecver.inuse = taskRecver.inuse;
db.SaveChanges();
return(oldTaskRecver);
}
public static Notice Edit(Notice notice)
{
TN db = new TN();
Notice oldNotice = db.Notices.Where(en => en.idnotice == notice.idnotice).FirstOrDefault();
oldNotice.idnotice = notice.idnotice;
oldNotice.publish = notice.publish;
oldNotice.title = notice.title;
//oldNotice.publish_time = notice.publish_time;
oldNotice.start_time = notice.start_time;
oldNotice.end_time = notice.end_time;
oldNotice.content = notice.content;
db.SaveChanges();
return(oldNotice);
}
