/// <summary> /// /// </summary> /// <param name="express_id"></param> /// <param name="shop_id"></param> public void SetDefaultExpress(int express_id,int shop_id=0) { if (express_id <= 0) { throw new KMJXCException("快递公司不能为空"); } using (KuanMaiEntities db = new KuanMaiEntities()) { int[] child_shop = (from c in this.DBChildShops select c.Shop_ID).ToArray<int>(); var tmpNew = from express in db.Express_Shop where (express.IsDefault == 0 && express.Express_ID==express_id) select express; var tmp = from express in db.Express_Shop where express.IsDefault==1 select express; if (shop_id > 0) { tmp = tmp.Where(t => t.Shop_ID == shop_id); tmpNew = tmpNew.Where(t => t.Shop_ID == shop_id); } else { tmp = tmp.Where(t => t.Shop_ID == this.Shop.Shop_ID); tmpNew = tmpNew.Where(t => t.Shop_ID == this.Shop.Shop_ID); } Express_Shop old = tmp.FirstOrDefault<Express_Shop>(); Express_Shop newDefault = tmpNew.FirstOrDefault<Express_Shop>(); if (old != null) { old.IsDefault = 0; old.Modified = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); old.Modified_By = this.CurrentUser.ID; db.Entry(old).State = System.Data.EntityState.Modified; //db.Express_Shop.SqlQuery("Update Express_Shop set IsDefault=0 where Express_ID="+old.Express_ID+" and Shop_ID="+old.Shop_ID); } if (newDefault != null) { newDefault.IsDefault = 1; newDefault.Modified = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); newDefault.Modified_By = this.CurrentUser.ID; db.Entry(newDefault).State = System.Data.EntityState.Modified; //db.Express_Shop.SqlQuery("Update Express_Shop set IsDefault=1 where Express_ID=" + newDefault.Express_ID + " and Shop_ID=" + newDefault.Shop_ID); } else { throw new KMJXCException("设置默认快递公司前,请先确保快递公司已经添加到店铺"); } db.SaveChanges(); } }