public ContentResult GetShopList(Lib.GridPager pager, string queryStr) { //查询出所有未删除的 IQueryable <T_ShopFromGY> queryData = db.T_ShopFromGY.Where(a => a.Isdelete == "0"); //根据订单号,提交者姓名,会员号码查询 if (!string.IsNullOrEmpty(queryStr)) { queryData = queryData.Where(a => a.name.Contains(queryStr) || a.code.Contains(queryStr)); } //根据状态查询 //分页 pager.totalRows = queryData.Count(); queryData = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows); List <T_ShopFromGY> list = new List <T_ShopFromGY>(); foreach (var item in queryData) { T_ShopFromGY i = new T_ShopFromGY(); i = item; list.Add(i); } string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
/// <summary> /// 根据店铺代码获得店铺名称 /// </summary> /// <param name="id"></param> /// <returns></returns> public static string GetShopName(string code) { EBMSEntities db = new EBMSEntities(); string ShopName = ""; T_ShopFromGY shop = db.T_ShopFromGY.SingleOrDefault(a => a.code == code); if (shop != null) { ShopName = shop.name; } return(ShopName); }
public ActionResult ViewShopEdit(int ID) { T_ShopFromGY model = db.T_ShopFromGY.Find(ID); if (model != null) { return(View(model)); } else { return(HttpNotFound()); } }
public JsonResult ShopAddSave(T_ShopFromGY model) { model.Isdelete = "0"; db.T_ShopFromGY.Add(model); try { db.SaveChanges(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (DbEntityValidationException ex) { return(Json(new { State = "Faile", Message = ex.EntityValidationErrors.First().ValidationErrors.First().ErrorMessage }, JsonRequestBehavior.AllowGet)); } }
public JsonResult ShopDelete(int ID) { T_ShopFromGY editModel = db.T_ShopFromGY.Find(ID); editModel.Isdelete = "1"; db.Entry <T_ShopFromGY>(editModel).State = System.Data.Entity.EntityState.Modified; try { db.SaveChanges(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (DbEntityValidationException ex) { return(Json(new { State = "Faile", Message = ex.EntityValidationErrors.First().ValidationErrors.First().ErrorMessage }, JsonRequestBehavior.AllowGet)); } }
public JsonResult ShopEditSave(T_ShopFromGY model) { T_ShopFromGY editModel = db.T_ShopFromGY.Find(model.ID); editModel.code = model.code; editModel.company_Name = model.company_Name; editModel.DutyFinance = model.DutyFinance; editModel.name = model.name; editModel.nick = model.nick; editModel.number = model.number; editModel.type_name = model.type_name; db.Entry <T_ShopFromGY>(editModel).State = System.Data.Entity.EntityState.Modified; try { db.SaveChanges(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (DbEntityValidationException ex) { return(Json(new { State = "Faile", Message = ex.EntityValidationErrors.First().ValidationErrors.First().ErrorMessage }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 获得补发货名字 /// </summary> /// <returns></returns> public static string GetReissueName(string code, string reson) { EBMSEntities db = new EBMSEntities(); if (reson.Equals("呼吸机专用")) { return("阿奎"); } else { T_ShopFromGY shop = db.T_ShopFromGY.SingleOrDefault(s => s.code.Equals(code)); if (shop.type_name.Equals("天猫")) { return("紫荆"); } //else if (shop.type_name.Equals("淘宝")) // return "欧阳"; else if (shop.type_name.Equals("京东")) { return("丹丹"); } else if (shop.type_name.Equals("Ebay")) { return("叮当"); } else if (shop.type_name.Equals("贝贝网")) { return("辉驮"); } else { return("成风"); } } }