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 dgvDeptCode_SelectionChanged(object sender, EventArgs e)
{
if (dgvDeptCode.RowCount == 0)
{
MessageBox.Show("This table is empty,please add data first!");
return;
}
if (dgvDeptCode.CurrentRow == null)
{
return;
}
if (dgvDeptCode.CurrentRow.Index < 0)
{
return;
}
txtDeptCode.Text = dgvDeptCode.CurrentRow.Cells[1].Value.ToString();
txtDeptName.Text = dgvDeptCode.CurrentRow.Cells[2].Value.ToString();
txtOtherName.Text = dgvDeptCode.CurrentRow.Cells[3].Value.ToString();
OnLoadSystemCommonData onLoad = new OnLoadSystemCommonData();
onLoad.GetTADeptCodeDetail();
var deptCode = CommonData.TaDeptCodeDetailList.FirstOrDefault(s => s.DeptCodeSysKey.Equals(dgvDeptCode.CurrentRow.Cells[0].Value.ToString()));
if (deptCode != null)
{
cmbBoxPrinterName1.Items.Clear();
GetPrinter1();
//cmbBoxPrinterName1.SelectedItem = deptCode.PrintName1;
cmbBoxNumberOfCopy1.Items.Clear();
cmbBoxNumberOfCopy1.Items.Add("1");
cmbBoxNumberOfCopy1.Items.Add("2");
cmbBoxNumberOfCopy1.SelectedIndex = cmbBoxNumberOfCopy1.Items.IndexOf(deptCode.NumCopy1.Equals("1") ? "1" : "2");
chkPrtDishSeper1.Checked = deptCode.PrtDishSeper1.Equals("Y");
cmbBoxPrinterName2.Items.Clear();
GetPrinter2();
//cmbBoxPrinterName2.SelectedItem = deptCode.PrintName2;
cmbBoxNumberOfCopy2.Items.Clear();
cmbBoxNumberOfCopy2.Items.Add("1");
cmbBoxNumberOfCopy2.Items.Add("2");
cmbBoxNumberOfCopy2.SelectedIndex = cmbBoxNumberOfCopy2.Items.IndexOf(deptCode.NumCopy2.Equals("1") ? "1" : "2");
chkPrtDishSeper2.Checked = deptCode.PrtDishSeper2.Equals("Y");
}
}
private void FrmSysCtl_Load(object sender, EventArgs e)
{
OnLoadSystemCommonData onLoadSystemCommonData = new OnLoadSystemCommonData();
onLoadSystemCommonData.GetSysControlList();
if (CommonData.SysControlList.Count > 0)
{
var qList = CommonData.SysControlList.FirstOrDefault();
sysGuid = qList.SystemKey.ToString();
chkTakeaway.Checked = qList.IsTakeaway.Equals("Y");
chkEatIn.Checked = qList.IsEatIn.Equals("Y");
chkQuickFood.Checked = qList.IsQuickFood.Equals("Y");
txtShopName.Text = qList.ShopName;
txtAddress.Text = qList.Address;
chkShopDetailReadOnly.Checked = qList.IsShopDetailReadOnly.Equals("Y");
chkNotAccountFor.Checked = qList.IsNotAccountFor.Equals("Y");
txtKey1.Text = qList.Key1;
txtKey2.Text = qList.Key2;
txtAccessCode.Text = qList.AccessCode;
txtImg1.Text = qList.ImgPath1;
txtImg2.Text = qList.ImgPath2;
txtImg3.Text = qList.ImgPath3;
txtImg4.Text = qList.ImgPath4;
txtImg5.Text = qList.ImgPath5;
}
else
{
//sysGuid = Guid.NewGuid().ToString().ToUpper();
chkTakeaway.Checked = false;
chkEatIn.Checked = false;
chkQuickFood.Checked = false;
txtShopName.Text = "";
txtAddress.Text = "";
chkShopDetailReadOnly.Checked = false;
chkNotAccountFor.Checked = false;
txtKey1.Text = "";
txtKey2.Text = "";
txtAccessCode.Text = "";
txtImg1.Text = "";
txtImg2.Text = "";
txtImg3.Text = "";
txtImg4.Text = "";
txtImg5.Text = "";
}
}
private void txtPay1_TextChanged(object sender, EventArgs e)
{
GetPayType();
txtTendered.Text = (Pay1 + Pay2 + Pay3 + Pay4).ToString();
OnLoadSystemCommonData onLoadSystemCommonData = new OnLoadSystemCommonData();
onLoadSystemCommonData.GetTAPayType();
if (CommonData.TaPayTypeList.Any(s => s.PaymentType.Equals(lblPayType1.Text)))
{
TAPayTypeInfo taPayType = CommonData.TaPayTypeList.FirstOrDefault(s => s.PaymentType.Equals(lblPayType1.Text));
try
{
decimal d1 = 0.00m;
decimal d2 = 0.00m;
decimal d3 = 0.00m;
d1 = Convert.ToDecimal(taPayType.SurchargeThreshold);
d2 = Convert.ToDecimal(taPayType.SurchargeAmount);
d3 = Convert.ToDecimal(taPayType.SurchargePercent);
//if (d1 > 0)
//{
// if (Pay1 > d1)
// {
// lblSurcharge1.Text = d2 > 0 ? d2.ToString() : ((d3 / 100) * Pay1).ToString();
// }
//}
//else
//{
// lblSurcharge1.Text = d2 > 0 ? d2.ToString() : ((d3/100) * Pay1).ToString();
//}
lblSurcharge1.Text = d1 > 0 ? (Pay1 <= d1 ? (d2 > 0 ? d2.ToString() : "0.00") : "0.00") : "0.00";
}
catch (Exception)
{
lblSurcharge1.Text = "0.00";
throw;
}
}
GetAmount();
}
private decimal GetVAT()
{
OnLoadSystemCommonData _onload = new OnLoadSystemCommonData();
_onload.GetSysConfigList();
_onload.GetTAOrderItem();
var lstOI = CommonData.TaOrderItemList.Where(s => s.CheckCode.Equals(chkNum));
if (CommonData.SysConfigList.Any())
{
var lstVAT = from o in lstOI
join m in CommonData.TaMenuItemList on o.ItemCode equals m.DishCode
where !string.IsNullOrEmpty(m.IsWithoutVAT) && m.IsWithoutVAT.Equals("Y") && m.MenuSetID.Equals(strMenuID)
select new
{
itemTotalPrice = o.ItemTotalPrice
};
decimal dTotal = 0;
decimal dVat = 0;
decimal dVatTmp = 0;
if (lstVAT.Any())
{
dTotal = lstVAT.ToList().Sum(vat => Convert.ToDecimal(vat.itemTotalPrice));
//交税
dVatTmp = (Convert.ToDecimal(CommonData.SysConfigList.FirstOrDefault().VATPerct) / 100) * dTotal;
dVat = Math.Round(dVatTmp, 2, MidpointRounding.AwayFromZero);
return(dVat);
}
else
{
return(0);
}
}
else
{
return(0);
}
}
private void FrmSelectMenu_Load(object sender, EventArgs e)
{
txtDate.Text = DateTime.Now.ToShortDateString();
txtTime.Text = DateTime.Now.ToLongTimeString();
new OnLoadSystemCommonData().GetShiftCodeList();
ShiftCodeInfo scInfo = new ShiftCodeInfo();
scInfo = CommonData.ShiftCodeList.FirstOrDefault(sc =>
DateTime.Compare(Convert.ToDateTime(DateTime.Now.ToShortTimeString()), Convert.ToDateTime(sc.DtFrom)) >= 0
&&
DateTime.Compare(Convert.ToDateTime(DateTime.Now.ToShortTimeString()), Convert.ToDateTime(sc.DtTo)) <= 0);
if (scInfo != null)
{
txtSession.Text = scInfo.ShiftName;
}
txtStaff.Text = userInfo.UsrName;
OnLoadSystemCommonData onLoadSystemCommonData = new OnLoadSystemCommonData();
onLoadSystemCommonData.GetSysControlList();
string strImg = "";
if (CommonData.SysControlList.Any())
{
sysControlInfo = CommonData.SysControlList.FirstOrDefault();
}
else
{
MessageBox.Show("S001:System data error,Please contact system Administrator!");
Close();
}
}
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 btnNotPaid_Click(object sender, EventArgs e)
{
htPay["Tendered"] = txtTendered.Text;
htPay["Change"] = txtChange.Text;
OnLoadSystemCommonData onLoadSystemCommonData = new OnLoadSystemCommonData();
onLoadSystemCommonData.GetTAOrderItem();
onLoadSystemCommonData.GetSysConfigList();
onLoadSystemCommonData.GetTAMenuItemList();
var lstOrderItem = CommonData.TaOrderItemList.Where(s => s.CheckCode.Equals(chkNum));
var lstOI = lstOrderItem.ToList();
#region VAT计算
if (CommonData.SysConfigList.Any())
{
//税率
htPay["Rate1"] = CommonData.SysConfigList.FirstOrDefault().VATPerct + "%";
var lstVAT = from o in lstOI
join m in CommonData.TaMenuItemList on o.ItemCode equals m.DishCode
where !string.IsNullOrEmpty(m.IsWithoutVAT) && m.IsWithoutVAT.Equals("Y")
select new
{
itemTotalPrice = o.ItemTotalPrice
};
decimal dTotal = 0;
decimal dVatTmp = 0;
decimal dVat = 0;
if (lstVAT.Any())
{
dTotal = lstVAT.ToList().Sum(vat => Convert.ToDecimal(vat.itemTotalPrice));
//交税
dVatTmp = (Convert.ToDecimal(CommonData.SysConfigList.FirstOrDefault().VATPerct) / 100) * dTotal;
dVat = Math.Round(dVatTmp, 2, MidpointRounding.AwayFromZero);
}
htPay["VAT-A"] = dVat.ToString();
//税前
htPay["Net1"] = (dTotal - dVat).ToString();
//总价
htPay["Gross1"] = dTotal.ToString();
htPay["Rate2"] = "0.00%";
htPay["Net2"] = (Convert.ToDecimal(txtTotal.Text) - dTotal).ToString();
htPay["VAT-B"] = "0.00";
htPay["Gross2"] = (Convert.ToDecimal(txtTotal.Text) - dTotal).ToString();
}
else
{
htPay["Rate1"] = "0.00%";
htPay["Net1"] = "0.00";
htPay["VAT-A"] = "0.00";
htPay["Gross1"] = "0.00";
htPay["Rate2"] = "0.00%";
htPay["Net2"] = "0.00";
htPay["VAT-B"] = "0.00";
htPay["Gross2"] = "0.00";
}
#endregion
PrtPrint.PrtReceipt(lstOI, htPay);
}
private void FrmTAConfig_Load(object sender, EventArgs e)
{
txtFreeItem[0] = txtFreeItem1;
txtFreeItem[1] = txtFreeItem2;
txtFreeItem[2] = txtFreeItem3;
txtFreeItem[3] = txtFreeItem4;
OnLoadSystemCommonData onLoad = new OnLoadSystemCommonData();
onLoad.GetTAPayType();
onLoad.GetTAPayTypeDisc();
onLoad.GetTADistCharge();
onLoad.GetTADistChargeRemark();
onLoad.GetTAPostCode();
onLoad.GetTAPostCodeRemark();
onLoad.GetTAPreDefined();
onLoad.GetTAFreeFoodItemsList();
#region 绑定General Setting的Payment Type
payTypeList = CommonData.TaPayTypeList.ToList();
dgvTAPayType.DataSource = payTypeList;
dgvTAPayType.Columns[0].Visible = false;
dgvTAPayType.Columns[4].Visible = false;
dgvTAPayType.Columns[5].Visible = false;
dgvTAPayType.Columns[1].HeaderCell.Value = "Payment Type";
dgvTAPayType.Columns[2].HeaderCell.Value = "Surcharge Threshold";
dgvTAPayType.Columns[3].HeaderCell.Value = "Surcharge Amount";
//dgvTAPayType.Columns[4].HeaderCell.Value = "Surcharge %";
#endregion
#region General Setting Auto Discount Settings
if (CommonData.TaPayTypeDiscList == null || CommonData.TaPayTypeDiscList.Count <= 0)
{
txtDeliveryDis.Text = "";
txtDeliveryDisThres.Text = "";
txtCollDis.Text = "";
txtCollDisThres.Text = "";
txtShopDis.Text = "";
txtShopDisThres.Text = "";
}
else
{
var qList = CommonData.TaPayTypeDiscList.FirstOrDefault();
TaPayTypeDiscSysKey = qList.SystemKey;
txtDeliveryDis.Text = qList.DeliveryDisc;
txtDeliveryDisThres.Text = qList.DeliveryDiscThres;
txtCollDis.Text = qList.CollectionDisc;
txtCollDisThres.Text = qList.CollectionDiscThres;
txtShopDis.Text = qList.ShopDisc;
txtShopDisThres.Text = qList.ShopDiscThres;
}
//Pre-defined Delivery Notes
#region Pre-defined Delivery Notes
if (CommonData.TaPreDefinedList.Any())
{
if (CommonData.TaPreDefinedList.Count == 0)
{
txtPd1.Text = "";
txtPd2.Text = "";
txtPd3.Text = "";
txtPd4.Text = "";
}
else if (CommonData.TaPreDefinedList.Count == 1)
{
txtPd1.Text = CommonData.TaPreDefinedList[0].PreTxtValue;
txtPd2.Text = "";
txtPd3.Text = "";
txtPd4.Text = "";
}
else if (CommonData.TaPreDefinedList.Count == 2)
{
txtPd1.Text = CommonData.TaPreDefinedList[0].PreTxtValue;
txtPd2.Text = CommonData.TaPreDefinedList[1].PreTxtValue;
txtPd3.Text = "";
txtPd4.Text = "";
}
else if (CommonData.TaPreDefinedList.Count == 3)
{
txtPd1.Text = CommonData.TaPreDefinedList[0].PreTxtValue;
txtPd2.Text = CommonData.TaPreDefinedList[1].PreTxtValue;
txtPd3.Text = CommonData.TaPreDefinedList[2].PreTxtValue;
txtPd4.Text = "";
}
else if (CommonData.TaPreDefinedList.Count == 4)
{
txtPd1.Text = CommonData.TaPreDefinedList[0].PreTxtValue;
txtPd2.Text = CommonData.TaPreDefinedList[1].PreTxtValue;
txtPd3.Text = CommonData.TaPreDefinedList[2].PreTxtValue;
txtPd4.Text = CommonData.TaPreDefinedList[3].PreTxtValue;
}
}
else
{
txtPd1.Text = "";
txtPd2.Text = "";
txtPd3.Text = "";
txtPd4.Text = "";
}
#endregion
#endregion
#region Delivery Setting Distance Charge
distChrgList = CommonData.TaDistChargeList.ToList();
dgvDSDist.DataSource = distChrgList;
dgvDSDist.Columns[0].Visible = false;
dgvDSDist.Columns[4].Visible = false;
dgvDSDist.Columns[1].HeaderCell.Value = "Distance From";
dgvDSDist.Columns[2].HeaderCell.Value = "Distance To";
dgvDSDist.Columns[3].HeaderCell.Value = "Amount To Pay";
if (CommonData.TaDistChargeRemarkList == null || CommonData.TaDistChargeRemarkList.Count <= 0)
{
txtPerMileThereafter.Text = "";
txtOrderThreshold.Text = "";
txtSurchargeAmount.Text = "";
chkDiliveryChargeIncludeInOrder.Checked = false;
chkIgnoreCharge.Checked = false;
}
else
{
var qList = CommonData.TaDistChargeRemarkList.FirstOrDefault();
DisChrgRmkSyskey = qList.SystemKey;
txtPerMileThereafter.Text = qList.PerMileThereafter;
chkDiliveryChargeIncludeInOrder.Checked = qList.DeliveryChargeIncludesInOrder.Equals("Y");
txtIgnoreMiles.Text = qList.IgnoreDeliverySurchargeWhenDistExceeds;
chkIgnoreCharge.Checked = qList.IgnoreDeliveryDistChargeIfSurchargeAppl.Equals("Y");
txtOrderThreshold.Text = qList.OrderThreshold;
txtSurchargeAmount.Text = qList.SurchargeAmount;
}
#endregion
#region Post Code Setting
dgvPostCode.DataSource = CommonData.TaPostCodeList;
dgvPostCode.Columns[0].Visible = false;
dgvPostCode.Columns[5].Visible = false;
dgvPostCode.Columns[1].HeaderCell.Value = "Post Code";
dgvPostCode.Columns[2].HeaderCell.Value = "Address";
dgvPostCode.Columns[3].HeaderCell.Value = "Map";
dgvPostCode.Columns[4].HeaderCell.Value = "Distance";
if (CommonData.TaPostCodeRemarkList == null || CommonData.TaPostCodeRemarkList.Count <= 0)
{
txtYourStd.Text = "";
txtPostCode.Text = "";
txtYourX.Text = "";
txtYourY.Text = "";
}
else
{
var qList = CommonData.TaPostCodeRemarkList.FirstOrDefault();
txtYourStd.Text = qList.UrSTD;
txtPostCode.Text = qList.UrPostCode;
txtYourX.Text = qList.UrX;
txtYourY.Text = qList.UrY;
}
#endregion
#region 获得FreeItemCode
if (CommonData.TAFreeFoodItems.Any())
{
txtTotalAmountThreshold.Text = CommonData.TAFreeFoodItems.FirstOrDefault().FreeAmount;
int i = 0;
foreach (var taFreeFoodItemsInfo in CommonData.TAFreeFoodItems.TakeWhile(taFreeFoodItemsInfo => i < 4))
{
txtFreeItem[i].Text = taFreeFoodItemsInfo.FreeCode;
i++;
}
}
#endregion
}
private void FrmTAMenuCategory_Load(object sender, EventArgs e)
{
OnLoadSystemCommonData onLoad = new OnLoadSystemCommonData();
onLoad.GetTAMenuCategory();
onLoad.GetTADeptCode();
#region btnMenuSet赋值
Button[] btnMenuSet = new Button[4];
btnMenuSet[0] = btnMenuSet1;
btnMenuSet[1] = btnMenuSet2;
btnMenuSet[2] = btnMenuSet3;
btnMenuSet[3] = btnMenuSet4;
btnMenuSet1.Click += BtnMenuSet_Click;
btnMenuSet2.Click += BtnMenuSet_Click;
btnMenuSet3.Click += BtnMenuSet_Click;
btnMenuSet4.Click += BtnMenuSet_Click;
new OnLoadSystemCommonData().GetTAMenuSet();
int i = 0;
foreach (var taMenuSet in CommonData.TaMenuSetList)
{
if (i >= 4)
{
break;
}
btnMenuSet[i].Text = taMenuSet.EnglishName;
MenuSetKey[i] = taMenuSet.SystemKey.ToString();
if (i == 0)
{
strMenuSetKey = MenuSetKey[i];
}
i++;
}
#endregion
btnMenuSet1.BackColor = Color.CornflowerBlue;
btnMenuSet1.Select();
btnMenuSet2.BackColor = Color.Gray;
btnMenuSet3.BackColor = Color.Gray;
btnMenuSet4.BackColor = Color.Gray;
//dgvCategory.DataSource = CommonData.TaMenuCategoryList.Where(s => s.MenuSetID.Equals(strMenuSetKey));
dgvCategory.DataSource = CommonData.TaMenuCategoryList.Where(s => s.MenuSetID.Equals(strMenuSetKey)).ToList();
dgvCategory.Columns[0].Visible = false;
dgvCategory.Columns[4].Visible = false;
dgvCategory.Columns[5].Visible = false;
dgvCategory.Columns[6].Visible = false;
dgvCategory.Columns[7].Visible = false;
dgvCategory.Columns[8].Visible = false;
dgvCategory.Columns[9].Visible = false;
dgvCategory.Columns[1].HeaderText = @"Category Name";
dgvCategory.Columns[2].HeaderText = @"Category 2nd Name";
dgvCategory.Columns[3].HeaderText = @"Position";
//if (string.IsNullOrEmpty(strMenuSetKey)) return;
BindCmbData();
txtDishCode.Enabled = false;
//comboBox1.SelectedValue;
}
private void btnPrtReceipt_Click(object sender, EventArgs e)
{
string sChkNum = dgvPendOrder.CurrentRow.Cells[1].Value.ToString();
string sTotal = dgvPendOrder.CurrentRow.Cells[9].Value.ToString();
Hashtable htPay = new Hashtable();
htPay["Staff"] = userInfo.UsrName;
htPay["ItemQty"] = GetOrderItemCount(sChkNum);
htPay["SubTotal"] = GetDgvItemTotalPrice(sChkNum);
htPay["Total"] = GetDgvItemTotalPrice(sChkNum);
htPay["PayType"] = "CASH";
htPay["OrderNo"] = sChkNum;
htPay["Tendered"] = "0.00";
htPay["Change"] = "0.00";
OnLoadSystemCommonData onLoadSystemCommonData = new OnLoadSystemCommonData();
onLoadSystemCommonData.GetTAOrderItem();
onLoadSystemCommonData.GetSysConfigList();
onLoadSystemCommonData.GetTAMenuItemList();
var lstOrderItem = CommonData.TaOrderItemList.Where(s => s.CheckCode.Equals(sChkNum));
var lstOI = lstOrderItem.ToList();
#region VAT计算
if (CommonData.SysConfigList.Any())
{
//税率
htPay["Rate1"] = CommonData.SysConfigList.FirstOrDefault().VATPerct + "%";
var lstVAT = from o in lstOI
join m in CommonData.TaMenuItemList on o.ItemCode equals m.DishCode
where !string.IsNullOrEmpty(m.IsWithoutVAT) && m.IsWithoutVAT.Equals("Y")
select new
{
itemTotalPrice = o.ItemTotalPrice
};
decimal dTotal = 0;
decimal dVatTmp = 0;
decimal dVat = 0;
if (lstVAT.Any())
{
dTotal = lstVAT.ToList().Sum(vat => Convert.ToDecimal(vat.itemTotalPrice));
//交税
dVatTmp = (Convert.ToDecimal(CommonData.SysConfigList.FirstOrDefault().VATPerct) / 100) * dTotal;
dVat = Math.Round(dVatTmp, 2, MidpointRounding.AwayFromZero);
}
htPay["VAT-A"] = dVat.ToString();
//税前
htPay["Net1"] = (dTotal - dVat).ToString();
//总价
htPay["Gross1"] = dTotal.ToString();
htPay["Rate2"] = "0.00%";
htPay["Net2"] = (Convert.ToDecimal(sTotal) - dTotal).ToString();
htPay["VAT-B"] = "0.00";
htPay["Gross2"] = (Convert.ToDecimal(sTotal) - dTotal).ToString();
}
else
{
htPay["Rate1"] = "0.00%";
htPay["Net1"] = "0.00";
htPay["VAT-A"] = "0.00";
htPay["Gross1"] = "0.00";
htPay["Rate2"] = "0.00%";
htPay["Net2"] = "0.00";
htPay["VAT-B"] = "0.00";
htPay["Gross2"] = "0.00";
}
#endregion
PrtPrint.PrtReceipt(lstOI, htPay);
}
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
}
