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 FrmTAPay_Load(object sender, EventArgs e)
{
OnLoadSystemCommonData onLoadSystemCommonData = new OnLoadSystemCommonData();
onLoadSystemCommonData.GetTAPayType();
onLoadSystemCommonData.GetTAOrderItem();
onLoadSystemCommonData.GetTAPaymentList();
if (string.IsNullOrEmpty(strMenuID))
{
strMenuID = CommonData.TaMenuSetList.FirstOrDefault().SystemKey.ToString();
}
strCtlName = "txtPay1";
#region 各种附件事件
btn0.Click += BtnNum_Click;
btn1.Click += BtnNum_Click;
btn2.Click += BtnNum_Click;
btn3.Click += BtnNum_Click;
btn4.Click += BtnNum_Click;
btn5.Click += BtnNum_Click;
btn6.Click += BtnNum_Click;
btn7.Click += BtnNum_Click;
btn8.Click += BtnNum_Click;
btn9.Click += BtnNum_Click;
btnPoint.Click += BtnNum_Click;
txtPay1.MouseDown += txtPay_Click;
txtPay2.MouseDown += txtPay_Click;
txtPay3.MouseDown += txtPay_Click;
txtPay4.MouseDown += txtPay_Click;
btnDriver1.Click += BtnDriver_Click;
btnDriver2.Click += BtnDriver_Click;
btnDriver3.Click += BtnDriver_Click;
btnDriver4.Click += BtnDriver_Click;
btnDriver5.Click += BtnDriver_Click;
btnDriver6.Click += BtnDriver_Click;
#endregion
#region 查询会员
//查询会员
new OnLoadSystemCommonData().GetTACust();
var custList = CommonData.TaCustList.Where(s => s.SystemKey.ToString().Equals(CustNum));
if (custList.Any())
{
TACustInfo taCustInfo = custList.FirstOrDefault();
txtPhone.Text = taCustInfo.Phone1;
txtName.Text = taCustInfo.Name;
txtHouseNo.Text = taCustInfo.HouseNo;
txtAddress.Text = taCustInfo.Address1;
txtPostcode.Text = taCustInfo.Postcode1;
txtDistance.Text = taCustInfo.Distance;
txtPCZone.Text = taCustInfo.PcZone;
txtDelCharge.Text = taCustInfo.DelCharge;
txtReadyTime.Text = taCustInfo.ReadyTime;
txtIntNotes.Text = taCustInfo.IntNotes;
txtNotes.Text = taCustInfo.NotesOnBill;
chkBlackListed.Checked = taCustInfo.IsBlackListed.Equals("Y");
}
#endregion
#region Delivery / Collection Note
new OnLoadSystemCommonData().GetTAPreDefined();
var cmbList = CommonData.TaPreDefinedList.Select(lstPD => new { Prevalue = lstPD.PreTxtValue });
cmbNote.DataSource = cmbList.ToList();
cmbNote.ValueMember = "Prevalue";
cmbNote.DisplayMember = "Prevalue";
#endregion
#region 控件数组
lblPayType[0] = lblPayType1;
lblPayType[1] = lblPayType2;
lblPayType[2] = lblPayType3;
lblPayType[3] = lblPayType4;
txtPay[0] = txtPay1;
txtPay[1] = txtPay2;
txtPay[2] = txtPay3;
txtPay[3] = txtPay4;
lblPaySurcharge[0] = lblSurcharge1;
lblPaySurcharge[1] = lblSurcharge2;
lblPaySurcharge[2] = lblSurcharge3;
lblPaySurcharge[3] = lblSurcharge4;
btnDriver[0] = btnDriver1;
btnDriver[1] = btnDriver2;
btnDriver[2] = btnDriver3;
btnDriver[3] = btnDriver4;
btnDriver[4] = btnDriver5;
btnDriver[5] = btnDriver6;
lblSCharge[0] = lblSCharge1;
lblSCharge[1] = lblSCharge2;
lblSCharge[2] = lblSCharge3;
lblSCharge[3] = lblSCharge4;
//付款
int i = 0;
foreach (var taPayTypeInfo in CommonData.TaPayTypeList)
{
if (i >= 4)
{
break;
}
lblSCharge[i].Visible = true;
lblPaySurcharge[i].Visible = true;
lblPaySurcharge[i].Text = "0.00";
txtPay[i].Visible = true;
lblPayType[i].Visible = true;
lblPayType[i].Text = taPayTypeInfo.PaymentType;
i++;
}
for (int j = i + 1; j <= 3; j++)
{
lblSCharge[j].Visible = false;
lblPaySurcharge[j].Visible = false;
txtPay[j].Visible = false;
lblPayType[j].Visible = false;
}
#region 司机清单
//司机清单
if (!string.IsNullOrEmpty(GetWeek(DateTime.Today.DayOfWeek.ToString())))
{
i = 0;
foreach (
var driverSet in
CommonData.TaDriverSetUpList.Where(
s => s.DriverWorkDay.Contains(GetWeek(DateTime.Today.DayOfWeek.ToString())))
.TakeWhile(driverSet => i < 6))
{
btnDriver[i].Text = driverSet.DriverName;
}
for (int j = i + 1; j < btnDriver.Length; j++)
{
btnDriver[j].Visible = false;
}
}
#endregion
#endregion
#region 查询账单
if (CommonData.TAPaymentList.Any(s => s.ChkNum.Equals(chkNum) && s.IsPaid.Equals("N")))
{
var payList = CommonData.TAPaymentList.Where(s => s.ChkNum.Equals(chkNum) && s.IsPaid.Equals("N"));
TAPaymentInfo taPaymentInfo = payList.FirstOrDefault();
txtDiscount.Text = taPaymentInfo.Discount;
txtSurcharge.Text = taPaymentInfo.Surcharge;
txtTotal.Text = taPaymentInfo.Total;
txtNotPaid.Text = taPaymentInfo.NotPaid;
txtDelivery.Text = taPaymentInfo.Delivery;
txtTendered.Text = taPaymentInfo.Tendered;
txtToPay.Text = Convert.ToDecimal(taPaymentInfo.Total) > Convert.ToDecimal(taPaymentInfo.Tendered)
? (Convert.ToDecimal(taPaymentInfo.Total) - Convert.ToDecimal(taPaymentInfo.Tendered)).ToString()
: "0.00";
AcctPay = Convert.ToDecimal(taPaymentInfo.AcctPay);
if (lblSCharge[0].Visible)
{
txtPay[0].Text = taPaymentInfo.PayType1;
lblPaySurcharge[0].Text = taPaymentInfo.PayTypeSurCharge1;
}
if (lblSCharge[1].Visible)
{
txtPay[1].Text = taPaymentInfo.PayType2;
lblPaySurcharge[1].Text = taPaymentInfo.PayTypeSurCharge2;
}
if (lblSCharge[2].Visible)
{
txtPay[2].Text = taPaymentInfo.PayType3;
lblPaySurcharge[2].Text = taPaymentInfo.PayTypeSurCharge3;
}
if (lblSCharge[3].Visible)
{
txtPay[3].Text = taPaymentInfo.PayType4;
lblPaySurcharge[3].Text = taPaymentInfo.PayTypeSurCharge4;
}
GetAmount();
}
else
{
return;
}
#endregion
}
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();
}
private void FrmTAPayShop_Load(object sender, EventArgs e)
{
OnLoadSystemCommonData onLoadSystemCommonData = new OnLoadSystemCommonData();
onLoadSystemCommonData.GetTAPayType();
onLoadSystemCommonData.GetTAOrderItem();
onLoadSystemCommonData.GetTAPaymentList();
if (string.IsNullOrEmpty(strMenuID))
{
strMenuID = CommonData.TaMenuSetList.FirstOrDefault().SystemKey.ToString();
}
strCtlName = "txtPay1";
#region 各种附件事件
btn0.Click += BtnNum_Click;
btn1.Click += BtnNum_Click;
btn2.Click += BtnNum_Click;
btn3.Click += BtnNum_Click;
btn4.Click += BtnNum_Click;
btn5.Click += BtnNum_Click;
btn6.Click += BtnNum_Click;
btn7.Click += BtnNum_Click;
btn8.Click += BtnNum_Click;
btn9.Click += BtnNum_Click;
btnPoint.Click += BtnNum_Click;
txtPay1.MouseDown += txtPay_Click;
txtPay2.MouseDown += txtPay_Click;
txtPay3.MouseDown += txtPay_Click;
txtPay4.MouseDown += txtPay_Click;
#endregion
#region 控件数组
lblPayType[0] = lblPayType1;
lblPayType[1] = lblPayType2;
lblPayType[2] = lblPayType3;
lblPayType[3] = lblPayType4;
txtPay[0] = txtPay1;
txtPay[1] = txtPay2;
txtPay[2] = txtPay3;
txtPay[3] = txtPay4;
lblPaySurcharge[0] = lblSurcharge1;
lblPaySurcharge[1] = lblSurcharge2;
lblPaySurcharge[2] = lblSurcharge3;
lblPaySurcharge[3] = lblSurcharge4;
lblSCharge[0] = lblSCharge1;
lblSCharge[1] = lblSCharge2;
lblSCharge[2] = lblSCharge3;
lblSCharge[3] = lblSCharge4;
//付款
int i = 0;
foreach (var taPayTypeInfo in CommonData.TaPayTypeList)
{
if (i >= 4)
{
break;
}
lblSCharge[i].Visible = true;
lblPaySurcharge[i].Visible = true;
lblPaySurcharge[i].Text = "0.00";
txtPay[i].Visible = true;
lblPayType[i].Visible = true;
lblPayType[i].Text = taPayTypeInfo.PaymentType;
i++;
}
for (int j = i + 1; j <= 3; j++)
{
lblSCharge[j].Visible = false;
lblPaySurcharge[j].Visible = false;
txtPay[j].Visible = false;
lblPayType[j].Visible = false;
}
#endregion
#region 查询账单
if (CommonData.TAPaymentList.Any(s => s.ChkNum.Equals(chkNum) && s.IsPaid.Equals("N")))
{
var payList = CommonData.TAPaymentList.Where(s => s.ChkNum.Equals(chkNum) && s.IsPaid.Equals("N"));
TAPaymentInfo taPaymentInfo = payList.FirstOrDefault();
txtDiscount.Text = taPaymentInfo.Discount;
txtSurcharge.Text = taPaymentInfo.Surcharge;
txtTotal.Text = taPaymentInfo.Total;
txtNotPaid.Text = taPaymentInfo.NotPaid;
txtDelivery.Text = taPaymentInfo.Delivery;
txtTendered.Text = taPaymentInfo.Tendered;
txtToPay.Text = Convert.ToDecimal(taPaymentInfo.Total) > Convert.ToDecimal(taPaymentInfo.Tendered)
? (Convert.ToDecimal(taPaymentInfo.Total) - Convert.ToDecimal(taPaymentInfo.Tendered)).ToString()
: "0.00";
AcctPay = Convert.ToDecimal(taPaymentInfo.AcctPay);
if (lblSCharge[0].Visible)
{
txtPay[0].Text = taPaymentInfo.PayType1;
lblPaySurcharge[0].Text = taPaymentInfo.PayTypeSurCharge1;
}
if (lblSCharge[1].Visible)
{
txtPay[1].Text = taPaymentInfo.PayType2;
lblPaySurcharge[1].Text = taPaymentInfo.PayTypeSurCharge2;
}
if (lblSCharge[2].Visible)
{
txtPay[2].Text = taPaymentInfo.PayType3;
lblPaySurcharge[2].Text = taPaymentInfo.PayTypeSurCharge3;
}
if (lblSCharge[3].Visible)
{
txtPay[3].Text = taPaymentInfo.PayType4;
lblPaySurcharge[3].Text = taPaymentInfo.PayTypeSurCharge4;
}
GetAmount();
}
else
{
return;
}
#endregion
}
