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