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