/// <summary>
/// 直通率基础数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static List <ThroughRateDto> ThroughRateData(ThroughRateModel model)
{
List <ThroughRateDto> list;
using (IDbConnection conn = MySqlConnection())
{
var p = new DynamicParameters();
p.Add("@_DateTimeStart", model.StartTime);
p.Add("@_DateTimeEnd", model.EndTime);
p.Add("@_Area", model.Line);
list = conn.Query <ThroughRateDto>("SP_FirstPassYied", p, commandType: CommandType.StoredProcedure,
commandTimeout: 0).ToList();
}
return(list);
}
// 需求与押车
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));
}
public JsonResult ThroughRate(ThroughRateModel model)
{
System.Web.Script.Serialization.JavaScriptSerializer sj = new System.Web.Script.Serialization.JavaScriptSerializer();
ResThroughDataDto res = new ResThroughDataDto();
List <double> StationRate = new List <double>();
List <string> Station = new List <string>();
List <int> OutPut = new List <int>();
var TotalCount = 0;
double AllRate = 1.00;
try
{
List <ThroughRateDto> list = DapperService.SqlHelp.ThroughRateData(model);
foreach (var item in list)
{
OutPut.Add(item.TOTAL);
Station.Add(item.STATION);
StationRate.Add(item.RATE);
AllRate = AllRate * (item.RATE / 100);
TotalCount = TotalCount + item.TOTAL;
}
List <ResAllRateDto> listallrate = new List <ResAllRateDto>()
{
new ResAllRateDto()
{
value = Convert.ToInt32(TotalCount * AllRate), name = "直通率"
},
new ResAllRateDto()
{
value = TotalCount - Convert.ToInt32(TotalCount * AllRate), name = "其他"
}
};
res.Data = sj.Serialize(listallrate);
res.OutPut = sj.Serialize(OutPut);
res.Station = sj.Serialize(Station);
res.StationThroughRate = sj.Serialize(StationRate);
}
catch (Exception ex)
{
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
