private void FrmPendOrder_Load(object sender, EventArgs e) { OnLoadSystemCommonData onLoadSystemCommonData = new OnLoadSystemCommonData(); onLoadSystemCommonData.GetTAPaymentList(); onLoadSystemCommonData.GetTACust(); onLoadSystemCommonData.GetTAOrderItem(); onLoadSystemCommonData.GetTADriverSetUp(); if (!string.IsNullOrEmpty(GetWeek(DateTime.Today.DayOfWeek.ToString()))) { IList <string> lstDriver = CommonData.TaDriverSetUpList.Where( s => s.DriverWorkDay.Contains(GetWeek(DateTime.Today.DayOfWeek.ToString()))).Select(s => s.DriverName).ToList(); cmbDriver.DataSource = lstDriver; } GetDB(1, "ALL"); #region DGV设置 //dgvPendOrder.DataSource = lstTest; dgvPendOrder.Columns[0].Visible = false; dgvPendOrder.Columns[0].Width = 5; dgvPendOrder.Columns[1].HeaderText = @"Order No"; dgvPendOrder.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvPendOrder.Columns[2].HeaderText = @"Time"; dgvPendOrder.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvPendOrder.Columns[2].Width = 40; dgvPendOrder.Columns[3].HeaderText = @"Postcode"; dgvPendOrder.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvPendOrder.Columns[3].Width = 50; dgvPendOrder.Columns[4].HeaderText = @"Postcode Zone"; dgvPendOrder.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvPendOrder.Columns[4].Width = 40; dgvPendOrder.Columns[5].HeaderText = @"Address"; dgvPendOrder.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvPendOrder.Columns[5].Width = 40; dgvPendOrder.Columns[6].HeaderText = @"Type"; dgvPendOrder.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvPendOrder.Columns[6].Width = 40; dgvPendOrder.Columns[7].HeaderText = @"Customer Name"; dgvPendOrder.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvPendOrder.Columns[7].Width = 40; dgvPendOrder.Columns[8].HeaderText = @"Phone Number"; dgvPendOrder.Columns[8].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvPendOrder.Columns[9].HeaderText = @"Total"; dgvPendOrder.Columns[9].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvPendOrder.Columns[9].Width = 40; dgvPendOrder.Columns[10].HeaderText = @"Staff"; dgvPendOrder.Columns[10].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvPendOrder.Columns[10].Width = 40; dgvPendOrder.Columns[11].HeaderText = @"Driver"; dgvPendOrder.Columns[11].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvPendOrder.Columns[11].Width = 40; dgvPendOrder.Columns[12].Visible = false; dgvPendOrder.Columns[13].Visible = false; #endregion }
private void FrmTADriverSetup_Load(object sender, EventArgs e) { OnLoadSystemCommonData _onLoadSysData = new OnLoadSystemCommonData(); _onLoadSysData.GetTADriverSetUp(); dgvDriver.DataSource = CommonData.TaDriverSetUpList; dgvDriver.Columns[0].Visible = false; dgvDriver.Columns[3].Visible = false; dgvDriver.Columns[4].Visible = false; }
private void GetDB(int iType, string sParam) { OnLoadSystemCommonData onLoadSystemCommonData = new OnLoadSystemCommonData(); onLoadSystemCommonData.GetTAPaymentList(); onLoadSystemCommonData.GetTACust(); onLoadSystemCommonData.GetTAOrderItem(); onLoadSystemCommonData.GetTADriverSetUp(); //var lstOther = from pay in CommonData.TAPaymentList // join cust in CommonData.TaCustList // on pay.CustInfo equals cust.SystemKey.ToString() // join user in CommonData.UsrList // on pay.OpUsr equals user.SystemKey.ToString() // where pay.IsPaid.Equals("N") // select new // { // OrderSysKey = pay.SystemKey, // OrderNo = pay.ChkNum, // PTime = pay.PayTime, // Postcode = cust.Postcode1, // PostcodeZone = cust.PcZone, // CustAddr = cust.Address1, // OType = pay.OrderType, // CustName = cust.Name, // PhoneNum = cust.Phone1, // PTotal = pay.Total, // OrderUsr = user.UsrName, // Driver = pay.DriverName, // CustID = cust.SystemKey, // dDelivery = pay.Delivery // }; //var lstShop = from pay in CommonData.TAPaymentList.Where(s => s.OrderType.Equals(CommonBase.ORDER_TYPE_SHOP)) // join user in CommonData.UsrList on pay.OpUsr equals user.SystemKey.ToString() // where pay.IsPaid.Equals("N") // select new // { // OrderSysKey = pay.SystemKey, // OrderNo = pay.ChkNum, // PTime = pay.PayTime, // Postcode = "", // PostcodeZone = "", // CustAddr = "", // OType = pay.OrderType, // CustName = "", // PhoneNum = "", // PTotal = pay.Total, // OrderUsr = user.UsrName, // Driver = pay.DriverName, // CustID = "", // dDelivery = pay.Delivery // }; //var lstDb = Enumerable.Union(lstOther, lstShop); //此处需要在表"TA_Customer"中增加空记录,因为Shop类型的需要显示 var lstDb = from pay in CommonData.TAPaymentList join cust in CommonData.TaCustList on pay.CustInfo equals cust.SystemKey.ToString() join user in CommonData.UsrList on pay.OpUsr equals user.SystemKey.ToString() where pay.IsPaid.Equals("N") select new { OrderSysKey = pay.SystemKey, OrderNo = pay.ChkNum, PTime = pay.PayTime, Postcode = cust.Postcode1, PostcodeZone = cust.PcZone, CustAddr = cust.Address1, OType = pay.OrderType, CustName = cust.Name, PhoneNum = cust.Phone1, PTotal = pay.Total, OrderUsr = user.UsrName, Driver = pay.DriverName, CustID = cust.SystemKey, dDelivery = pay.Delivery }; //付款类型 if (iType == 1) { dgvPendOrder.DataSource = sParam.Equals("ALL") ? lstDb.ToList() : lstDb.Where(s => s.OType.Equals(sParam)).ToList(); } else { //已分配司机 if (sParam.Equals("1")) { dgvPendOrder.DataSource = lstDb.Where(s => s.OType.Equals(CommonBase.ORDER_TYPE_DELIVERY) && !string.IsNullOrEmpty(s.Driver)).ToList(); } else if (sParam.Equals("0")) //未分配司机 { dgvPendOrder.DataSource = lstDb.Where(s => s.OType.Equals(CommonBase.ORDER_TYPE_DELIVERY) && string.IsNullOrEmpty(s.Driver)).ToList(); } else //所有 { dgvPendOrder.DataSource = lstDb.Where(s => s.OType.Equals(CommonBase.ORDER_TYPE_DELIVERY)).ToList(); } } txtDeliveryCharge.Text = lstDb.Sum(sumDelivery => Convert.ToDecimal(sumDelivery.dDelivery)).ToString(); //dgvPendOrder.DataSource = lstDb.ToList(); }