// 需求与押车
public static ResNeedDeleyListDto NeedDeley(ThroughRateModel model)
{
ResNeedDeleyListDto list = new ResNeedDeleyListDto();
using (IDbConnection conn = MySqlConnection())
{
var p = new DynamicParameters();
p.Add("@_DateTimeStart", model.StartTime);
p.Add("@_DateTimeEnd", model.EndTime);
p.Add("@_Area", model.Line);
list.ListNeed = conn.Query <ResNeedDeleyDto>("SP_RequireSum", p,
commandType: CommandType.StoredProcedure, commandTimeout: 0).ToList();
list.ListDeley = conn.Query <ResNeedDeleyDto>("SP_YaCheSum", p,
commandType: CommandType.StoredProcedure, commandTimeout: 0).ToList();
}
return(list);
}
public JsonResult NeedDeley(ThroughRateModel model)
{
var Successed = true;
var Message = "";
ResNeedDeleyListDto list = new ResNeedDeleyListDto();
try
{
list = DapperService.SqlHelp.NeedDeley(model);
Message = "成功!";
}
catch (Exception e)
{
Successed = false;
Message = "失败！";
}
return(Json(new { listnd = list, Success = Successed, Mess = Message }, JsonRequestBehavior.AllowGet));
}
