void Bind()
{
var scre = sc.GetTaskInfo();
dgvSortInfo.Rows.Clear();
if (scre.IsSuccess)
{
List <TaskInfo> list = scre.Content.Select(x => new TaskInfo {
SYNSEQ = x.SYNSEQ, REGIONCODE = x.REGIONCODE, Count = x.Count, QTY = x.QTY
}).ToList();
foreach (var item in list)
{
DataGridViewCellStyle dgvStyle = new DataGridViewCellStyle();
dgvStyle.BackColor = Color.LightGreen;
// 存了状态值
//string status = "";
int index = this.dgvSortInfo.Rows.Add();
this.dgvSortInfo.Rows[index].Cells[0].Value = item.SYNSEQ; //户序
this.dgvSortInfo.Rows[index].Cells[1].Value = item.REGIONCODE; //分拣任务号
this.dgvSortInfo.Rows[index].Cells[2].Value = item.Count; //车组号
this.dgvSortInfo.Rows[index].Cells[3].Value = item.QTY; //抓烟数量
//this.dgvSortInfo.Rows[index].Cells[4].Value = item.CusName;//客户名称
//this.dgvSortInfo.Rows[index].Cells[5].Value = item.CigCode;//香烟编号
//this.dgvSortInfo.Rows[index].Cells[6].Value = item.CigName;//香烟名称
//this.dgvSortInfo.Rows[index].Cells[8].Value = item.ThroughNum;//物理通道号
//this.dgvSortInfo.Rows[index].Cells[9].Value = item.BillCode;//订单号
}
LblCusCount.Text = "总订货户数：" + scre.Content.Sum(item => item.Count).ToString();
LblCigCount.Text = "总订单条烟数量：" + scre.Content.Sum(item => item.QTY).ToString();
}
}
void Bind()
{
var scre = sc.GetTaskInfo();
if (scre.IsSuccess)
{
//dgvSortInfo.DataSource = scre.Content.GroupBy(x => new { x.REGIONCODE }).Select(x => new { 车组信息 = x.Key.REGIONCODE, 订单数量 = scre.Content.Where(a => a.REGIONCODE == x.Key.REGIONCODE).Sum(a => a.TASKQUANTITY), 订单户数 = scre.Content.Where(b => b.REGIONCODE == x.Key.REGIONCODE).GroupBy(b => b.CUSTOMERCODE).Count() }).ToList();
dgvSortInfo.DataSource = scre.Content.Select(x => new { synseq = x.SYNSEQ, regioncode = x.REGIONCODE, count = x.Count, qty = x.QTY }).ToList();
//{
// 车组信息 = a.REGIONCODE,
// 任务数 = scre.Content.Where(b => b.REGIONCODE == a.REGIONCODE).Sum(c => c.TASKQUANTITY),
// 状态 = a.STATE,
// 订单日期 = a.ORDERDATE
//}).ToList();
}
}