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