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