public IActionResult JsonIndex(FormulaJsonIndexModel model)
{
//if (model.BeginDateTime == null)
// model.BeginDateTime = DateTime.Now.ToString("yyyy-MM-dd");
//if (model.EndDateTime == null)
// model.EndDateTime = DateTime.Now.ToString("yyyy-MM-dd");
var dal = new FormulaDal();
var param = new FormulaDal.QueryByParam1In()
{
//BeginDateTime = DateTime.Parse(model.BeginDateTime),
//EndDateTime = DateTime.Parse(model.EndDateTime),
Rows = model.Rows,
Page = model.Page,
};
var list = dal.QueryByParam1(param);
var list2 = from o in list
select new
{
FormulaId = o.FormulaId,
FormulaName = o.FormulaName,
FormulaCode = o.FormulaCode,
FormulaPinYin = o.FormulaPinYin,
CreateDateTime = o.CreateDateTime.ToString(),
UpdateDateTime = o.UpdateDateTime.ToString(),
};
var grid = new
{
total = param.Total,
rows = list2,
};
return(Json(grid));
}
public IActionResult Update(string formulaId)
{
var dal = new FormulaDal();
var p = dal.Find(formulaId);
var model = mapper.Map <FormulaUpdateModel>(p);
return(View(model));
}
public IActionResult Add()
{
var formulaDal = new FormulaDal();
var model = new ZkGetOrderAddModel()
{
FormulaList = formulaDal.Query(),
};
return(View(model));
}
public IActionResult Update(string zkGetOrderId)
{
var dal = new ZkGetOrderDal();
var formulaDal = new FormulaDal();
var p = dal.Find(zkGetOrderId);
var model = mapper.Map <ZkGetOrderUpdateModel>(p);
model.FormulaList = formulaDal.Query();
return(View(model));
}
public IActionResult Add(FormulaAddModel model)
{
if (!ModelState.IsValid)
{
return(Json(new { state = "error", data = "提交信息验证失败" }));
}
try
{
var dal = new FormulaDal();
var p = mapper.Map <FormulaDefinition>(model);
dal.Add(p);
return(Json(new { state = "ok", data = 1 }));
}
catch (Exception ex)
{
return(Json(new { state = "error", data = ex.Message }));
}
}
public IActionResult Delete(string formulaId)
{
var dal = new FormulaDal();
var p = dal.Find(formulaId);
if (p == null)
{
return(Json(new { state = "error", data = "找不到这一条数据" }));
}
try
{
dal.Remove(p);
return(Json(new { state = "ok", data = 1 }));
}
catch (Exception ex)
{
return(Json(new { state = "error", data = ex.Message }));
}
}
public IActionResult Update(FormulaUpdateModel model)
{
if (!ModelState.IsValid)
{
return(Json(new { state = "error", data = "提交信息验证失败" }));
}
try
{
var dal = new FormulaDal();
var p = dal.Find(model.FormulaId);
mapper.Map(model, p);
dal.Update(p);
return(Json(new { state = "ok", data = 1 }));
}
catch (Exception ex)
{
return(Json(new { state = "error", data = ex.Message }));
}
}
public IActionResult JsonIndex(ZkGetOrderJsonIndexParamModel model)
{
var formulaDal = new FormulaDal();
var formulaList = formulaDal.Query();
var findFormulaName = new Func <string, string>((formulaId) => {
var p = formulaList.SingleOrDefault(o => o.FormulaId == formulaId);
if (p == null)
{
return(string.Empty);
}
return(p.FormulaName);
});
var findFormulaCode = new Func <string, string>((formulaId) => {
var p = formulaList.SingleOrDefault(o => o.FormulaId == formulaId);
if (p == null)
{
return(string.Empty);
}
return(p.FormulaCode);
});
var zkGetOrderDal = new ZkGetOrderDal();
var param = mapper.Map <ZkGetOrderDal.QueryByParamIn>(model);
var list = zkGetOrderDal.QueryByParam(param);
var list2 = mapper.Map <List <ZkGetOrderJsonIndexItemModel> >(list);
foreach (var p in list2)
{
p.FormulaCode = findFormulaCode(p.FormulaId);
p.FormulaName = findFormulaName(p.FormulaId);
}
var grid = new
{
total = param.Total,
rows = list2,
};
return(Json(grid));
}
