/// <summary> /// 获取门店全称 /// </summary> /// <param name="TStoreInfoId"></param> /// <returns></returns> public TradersStore getStoreFullTitle(string TStoreInfoId) { TradersStore tradersStore = tradersStoreService.GetEntityByWhere(o => o.TStoreInfoId == TStoreInfoId && o.State == 1); if (tradersStore != null) { return(tradersStore); } else { return(new TradersStore()); } }
/// <summary> /// 获取CID /// </summary> /// <param name="keyword"></param> /// <returns></returns> public List <TradersStore> getCIDStore(string strW = "") { using (EFDbContext db = new EFDbContext()) { var sql = "select CID from TradersStore where State=1 " + strW + " group by CID order by CID"; var list = db.Database.SqlQuery <int>(sql).ToList(); List <TradersStore> list2 = new List <TradersStore>(); foreach (var v in list) { TradersStore tradersStore = new TradersStore(); tradersStore.CID = v; list2.Add(tradersStore); } return(list2); } }
public ActionResult QRCode(int mch_id, string store_id, int id = 0) { //if (store_id.Length < 5) { // store_id = store_id.PadLeft(5, '0'); //} TradersStore s = tradersStoreService.GetEntityById(id); string tit = ""; if (s != null) { tit = s.StoreName; } ViewBag.mch_id = mch_id; ViewBag.store_id = store_id; ViewBag.tit = tit; return(View()); }
/// <summary> /// 获取门店编号 /// </summary> /// <param name="CID"></param> /// <returns></returns> public List <TradersStore> getStoreNum(int CID) { var list = tradersStoreService.GetListByWhere(o => o.State == 1 && o.CID == CID).OrderBy(o => o.CID).ToList(); List <TradersStore> list2 = new List <TradersStore>(); foreach (var v in list) { TradersStore tradersStore = new TradersStore(); tradersStore.StoreNumStr = v.StoreNum.ToString(); tradersStore.TStoreInfoId = v.TStoreInfoId; list2.Add(tradersStore); } list2.Insert(0, new TradersStore() { TStoreInfoId = "", StoreNumStr = "请选择" }); return(list2); }
public ActionResult Save(int?id) { List <TradersStore> listStore = new List <TradersStore>(); var obj = new TradersStore { }; if (id.HasValue) { obj = tradersStoreService.GetEntityById(id.Value); listStore = tradersStoreService.GetListByWhere(o => o.CID == obj.CID && o.State > 0 && o.Id != obj.Id); } //指派人 ViewBag.user = ListToSelect(tradersService.getUserList().Select(o => new SelectListItem() { Value = o.UserId, Text = o.FullName }), emptyTitle: "请选择"); ViewBag.listStore = listStore; return(View(obj.IsNullThrow())); }
public ActionResult Save(int Id) { TradersStore tradersStore = new TradersStore(); if (Id == 0) { tradersStore.StoreNum = tradersStoreService.getMaxStoreNum(); tradersStore.TStoreInfoId = CommonService.GUID.ToUpper(); tradersStore.CreateUID = CurrentUser.UID; tradersStore.CreateDT = DateTime.Now; } else { tradersStore = tradersStoreService.GetEntityById(Id); } tradersStore.ModifyUID = CurrentUser.UID; tradersStore.ModifyDT = DateTime.Now; string[] s = new string[] { "CID", "MainAccount", "AssignUID", "StoreName", "StoreNum3" }; TryUpdateModel <TradersStore>(tradersStore, s); var op = tradersStoreService.Save(tradersStore, Id, Request.Params); return(new OpActionResult(op)); }
/// <summary> /// 获取门店全称 /// </summary> /// <param name="TStoreInfoId"></param> /// <returns></returns> public string getStoreFullTitle(string TStoreInfoId) { TradersStore tradersStore = tradersUserService.getStoreFullTitle(TStoreInfoId); return(tradersStore.ToJson()); }