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