public JsonResult GetList(PeijianSearchModel searchModel) { try { using (var context = ZhangweiContextFactory.Create()) { var query = context.Peijian.AsQueryable(); List <PeijianDataModel> peijianList = null; if (!string.IsNullOrEmpty(searchModel.Keyword)) { query = query .Where(p => p.Name.IndexOf(searchModel.Keyword) > -1); } peijianList = query .OrderByDescending(p => p.Id) .ToList(); return(Json(new { success = true, peijianList = peijianList.Skip(searchModel.Start).Take(searchModel.PageSize), totalCount = peijianList.Count })); } } catch (Exception ex) { return(Json(new { success = false, message = ex.Message })); } }
public JsonResult Create(WeixiuCreateModel webModel) { try { using (var context = ZhangweiContextFactory.Create()) { var pejianDataModel = context.Peijian.Where(p => p.Id == webModel.PeijianId).FirstOrDefault(); WeixiuDataModel dataModel = ObjectMapperHelper.Map <WeixiuDataModel>(webModel); dataModel.CreatedTime = DateTime.Now; dataModel.PeijianId = pejianDataModel.Id; dataModel.PeijianName = pejianDataModel.Name; dataModel.Tuhao = pejianDataModel.Tuhao; dataModel.Danwei = pejianDataModel.Danwei; dataModel.Danjia = pejianDataModel.Danjia; dataModel.Kucun = pejianDataModel.Kucun - webModel.Shuliang; dataModel.Heji = pejianDataModel.Danjia * webModel.Shuliang; context.Weixiu.Add(dataModel); context.SaveChanges(); } WebHelper.PeijianManager.Chuku(webModel.PeijianId, webModel.Shuliang); return(Json(new { success = true })); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message })); } }
public JsonResult GetList(WeixiuSearchModel searchModel) { try { using (var context = ZhangweiContextFactory.Create()) { var query = context.Weixiu.AsQueryable(); if (!string.IsNullOrEmpty(searchModel.PeijianName)) { query = query.Where(p => p.PeijianName.IndexOf(searchModel.PeijianName) > -1); } if (!string.IsNullOrEmpty(searchModel.CheliangName)) { query = query.Where(p => p.CheliangName.IndexOf(searchModel.CheliangName) > -1); } if (!string.IsNullOrEmpty(searchModel.Tuhao)) { query = query.Where(p => p.Tuhao.IndexOf(searchModel.Tuhao) > -1); } if (!string.IsNullOrEmpty(searchModel.Remark)) { query = query.Where(p => p.Remark.IndexOf(searchModel.Remark) > -1); } if (searchModel.WeixiuTimeRange != null && !searchModel.WeixiuTimeRange.IsEmpty) { if (searchModel.WeixiuTimeRange.StartTime.HasValue) { query = query.Where(p => p.CreatedTime >= searchModel.WeixiuTimeRange.StartTime); } if (searchModel.WeixiuTimeRange.EndTime.HasValue) { query = query.Where(p => p.CreatedTime <= searchModel.WeixiuTimeRange.EndTime); } } var weixiuList = query.OrderByDescending(w => w.Id).ToList(); return(Json(new { success = true, weixiuList = weixiuList.Skip(searchModel.Start).Take(searchModel.PageSize), totalCount = weixiuList.Count, shuliangHeji = weixiuList.Sum(k => k.Shuliang), kucunHeji = weixiuList.Sum(k => k.Kucun), jineHeji = weixiuList.Sum(k => k.Heji) })); } } catch (Exception ex) { return(Json(new { success = false, message = ex.Message })); } }
public void UpdateTag() { using (var context = ZhangweiContextFactory.Create()) { var peijianList = context.Peijian.ToList(); foreach (var model in peijianList) { model.Tag = this.GetTag(model); context.Peijian.Update(model); context.SaveChanges(); } } }
public void Chuku(int peijianId, int shuliang) { lock (rukuLockObject) { using (var context = ZhangweiContextFactory.Create()) { var pejianDataModel = context.Peijian.Where(p => p.Id == peijianId).FirstOrDefault(); pejianDataModel.Kucun -= shuliang; context.Peijian.Update(pejianDataModel); context.SaveChanges(); } } }
public JsonResult GetById(int gongyingshangId) { try { GongyingshangDataModel dataModel = null; using (var context = ZhangweiContextFactory.Create()) { dataModel = context.Gongyingshang.Where(p => p.Id == gongyingshangId).First(); } return Json(new { success = true, gongyingshang = dataModel }); } catch (Exception ex) { return Json(new { success = false, message = ex.Message }); } }
public JsonResult GetById(int peijianId) { try { PeijianDataModel dataModel = null; using (var context = ZhangweiContextFactory.Create()) { dataModel = context.Peijian.Where(p => p.Id == peijianId).First(); } return(Json(new { success = true, peijian = dataModel })); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message })); } }
public JsonResult Create(GongyingshangDataModel webModel) { try { using (var context = ZhangweiContextFactory.Create()) { GongyingshangDataModel dataModel = ObjectMapperHelper.Map<GongyingshangDataModel>(webModel); context.Gongyingshang.Add(dataModel); context.SaveChanges(); } return Json(new { success = true }); } catch (Exception ex) { return Json(new { success = false, message = ex.Message }); } }
public JsonResult Edit(GongyingshangDataModel webModel) { try { using (var context = ZhangweiContextFactory.Create()) { var dataModel = context.Gongyingshang.Where(p => p.Id == webModel.Id).First(); ObjectMapperHelper.Map(dataModel, webModel); context.Gongyingshang.Update(dataModel); context.SaveChanges(); } return Json(new { success = true }); } catch (Exception ex) { return Json(new { success = false, message = ex.Message }); } }
public JsonResult Create(PeijianCreateModel webModel) { try { using (var context = ZhangweiContextFactory.Create()) { PeijianDataModel dataModel = ObjectMapperHelper.Map <PeijianDataModel>(webModel); dataModel.Tag = WebHelper.PeijianManager.GetTag(dataModel); context.Peijian.Add(dataModel); context.SaveChanges(); } return(Json(new { success = true })); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message })); } }
public JsonResult Edit(PeijianDataModel webModel) { try { using (var context = ZhangweiContextFactory.Create()) { var dataModel = context.Peijian.Where(p => p.Id == webModel.Id).First(); ObjectMapperHelper.Map(dataModel, webModel); dataModel.Tag = WebHelper.PeijianManager.GetTag(dataModel); context.Peijian.Update(dataModel); context.SaveChanges(); } return(Json(new { success = true })); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message })); } }
public JsonResult GetAutoCompleteList(string name) { try { using (var context = ZhangweiContextFactory.Create()) { List<GongyingshangDataModel> gongyingshangList = null; if (string.IsNullOrEmpty(name)) { gongyingshangList = context.Gongyingshang.ToList(); } else { gongyingshangList = context.Gongyingshang.Where(p => p.Name.IndexOf(name) > -1).Take(30).ToList(); } return Json(new { success = true, gongyingshangList = gongyingshangList }); } } catch (Exception ex) { return Json(new { success = false, message = ex.Message }); } }
public JsonResult GetAutoCompleteList(PeijianSearchModel searchModel) { try { using (var context = ZhangweiContextFactory.Create()) { List <PeijianDataModel> peijianList = null; if (string.IsNullOrEmpty(searchModel.Keyword)) { peijianList = context.Peijian.ToList(); } else { peijianList = context.Peijian.Where(p => p.Name.IndexOf(searchModel.Keyword) > -1 || p.Tag.IndexOf(searchModel.Keyword) > -1).Take(30).ToList(); } return(Json(new { success = true, peijianList = peijianList })); } } catch (Exception ex) { return(Json(new { success = false, message = ex.Message })); } }