/// <summary> /// 添加行数据 /// </summary> /// <param name="dt"></param> /// <param name="header"></param> /// <param name="model"></param> private void addRowData(DataTable dt, AkOrderModel model) { try { DataRow dr = dt.NewRow(); dr["OrderMode"] = model.OrderMode; dr["Terminal"] = model.Terminal; dr["Value"] = model.Value; dt.Rows.Add(dr); } catch (Exception ex) { //Console.WriteLine(model.UserId + "\n" + ex.ToString()); } }
/// <summary> /// 汇餐时间 /// </summary> /// <param name="dict_order"></param> /// <param name="sql"></param> /// <returns></returns> private Dictionary <string, decimal> remitTime(Dictionary <string, decimal> dict_order, string sql) { Dictionary <string, decimal> result1 = new Dictionary <string, decimal>(); Dictionary <string, decimal> result5 = new Dictionary <string, decimal>(); Dictionary <string, decimal> result = new Dictionary <string, decimal>(); var dt = SqlServerHelper.Instance.GetDataTable(AkConfig.ConnAlohaReporting, sql); if (dt != null && dt.Rows.Count > 0) { var query = (from t in dt.AsEnumerable() select new AkTempModel { Station = t.Field <int>("Station"), OrderId = t.Field <System.Guid>("OrderId").ToString("D"), Terminal = t.Field <int>("Terminal"), Timebumped = t.Field <int>("Timebumped") }).ToList(); if (query != null && query.Count() > 0) { Dictionary <string, AkTempModel> remit1 = new Dictionary <string, AkTempModel>(); Dictionary <string, AkTempModel> remit2 = new Dictionary <string, AkTempModel>(); var list1 = query.Where(l => l.Station == 5); if (list1 != null && list1.Count() > 0) { remit1 = list1.ToDictionary(key => key.OrderId, value => value); } var list2 = query.Where(l => l.Station == 1); if (list2 != null && list2.Count() > 0) { remit2 = list2.ToDictionary(key => key.OrderId, value => value); } List <AkOrderModel> list_result = new List <AkOrderModel>(); if (remit1.Count > 0 && remit2.Count > 0) { foreach (string key in remit1.Keys) { if (remit2.Keys.Contains(key)) { AkOrderModel model = new AkOrderModel(); AkTempModel temp1 = remit1[key]; AkTempModel temp2 = remit2[key]; model.Terminal = temp1.Terminal; model.Value = temp1.Timebumped - temp2.Timebumped; list_result.Add(model); } } if (list_result.Count > 0) { return(getValues(dict_order, list_result)); } } } } return(null); }