private void FrmPrintSetup_Load(object sender, EventArgs e)
{
new SystemData().GetTaSysPrtSetGeneral();
var lstGen = CommonData.TaSysPrtSetGeneral;
if (lstGen.Any())
{
TaSysPrtSetGeneralInfo generalInfo = lstGen.FirstOrDefault();
chkPrtLogo.Checked = generalInfo.IsPrtLogo.Equals("Y");
if (chkPrtLogo.Checked)
{
lblFilePath.Visible = true;
lblFileUpload.Visible = true;
btnFileUpload.Visible = true;
}
else
{
lblFilePath.Visible = false;
lblFileUpload.Visible = false;
btnFileUpload.Visible = false;
}
chkPrtStaff.Checked = generalInfo.IsPrtStaff.Equals("Y");
chkPrtTel.Checked = generalInfo.IsPrtTel.Equals("Y");
chkPrtAddr.Checked = generalInfo.IsPrtAddr.Equals("Y");
txtTelNo.Text = generalInfo.TelNo;
txtVatNo.Text = generalInfo.VATNo;
txtMsg1.Text = generalInfo.Msg1;
txtMsg2.Text = generalInfo.Msg2;
txtMsg3.Text = generalInfo.Msg3;
txtMsg4.Text = generalInfo.Msg4;
txtMsg5.Text = generalInfo.Msg5;
}
else
{
chkPrtLogo.Checked = false;
lblFilePath.Visible = false;
lblFileUpload.Visible = false;
btnFileUpload.Visible = false;
chkPrtStaff.Checked = false;
chkPrtTel.Checked = false;
chkPrtAddr.Checked = false;
txtTelNo.Text = @"";
txtVatNo.Text = @"";
txtMsg1.Text = @"";
txtMsg2.Text = @"";
txtMsg3.Text = @"";
txtMsg4.Text = @"";
txtMsg5.Text = @"";
}
asfc.controllInitializeSize(this);
}
private void btnGenSave_Click(object sender, EventArgs e)
{
TaSysPrtSetGeneralInfo generalInfo = new TaSysPrtSetGeneralInfo();
generalInfo.IsPrtLogo = chkPrtLogo.Checked ? "Y" : "N";
generalInfo.LogoFilePath = lblFilePath.Text;
generalInfo.IsPrtStaff = chkPrtStaff.Checked ? "Y" : "N";
generalInfo.IsPrtTel = chkPrtTel.Checked ? "Y" : "N";
generalInfo.IsPrtAddr = chkPrtAddr.Checked ? "Y" : "N";
generalInfo.TelNo = txtTelNo.Text;
generalInfo.VATNo = txtVatNo.Text;
generalInfo.Msg1 = txtMsg1.Text;
generalInfo.Msg2 = txtMsg2.Text;
generalInfo.Msg3 = txtMsg3.Text;
generalInfo.Msg4 = txtMsg4.Text;
generalInfo.Msg5 = txtMsg5.Text;
try
{
new SystemData().GetTaSysPrtSetGeneral();
var lstGen = CommonData.TaSysPrtSetGeneral;
if (lstGen.Any())
{
generalInfo.ID = lstGen.FirstOrDefault().ID;
_control.UpdateEntity(generalInfo);
}
else
{
_control.AddEntity(generalInfo);
}
}
catch (Exception ex) { LogHelper.Error(this.Name, ex); }
CommonTool.ShowMessage("Save successful!");
}
private WbPrtTemplataTa GetAllPrtInfo()
{
WbPrtTemplataTa wbPrtTemplataTa = new WbPrtTemplataTa();
new SystemData().GetTaSysPrtSetGeneral();
var lstGen = CommonData.TaSysPrtSetGeneral;
if (lstGen.Any())
{
TaSysPrtSetGeneralInfo taSysPrtSetGeneralInfo = lstGen.FirstOrDefault();
//wbPrtTemplataTa.PrintAddress = taSysPrtSetGeneralInfo.IsPrtAddr;
new SystemData().GetTaSysCtrl();
var lstTaSysCtrl = CommonData.TaSysCtrl;
if (lstTaSysCtrl.Any())
{
wbPrtTemplataTa.PrintAddress = lstTaSysCtrl.FirstOrDefault().ShopAddress;
}
wbPrtTemplataTa.PrintTel = taSysPrtSetGeneralInfo.TelNo;
wbPrtTemplataTa.VATNo = taSysPrtSetGeneralInfo.VATNo;
wbPrtTemplataTa.Msg1 = taSysPrtSetGeneralInfo.Msg1;
wbPrtTemplataTa.Msg2 = taSysPrtSetGeneralInfo.Msg2;
wbPrtTemplataTa.Msg3 = taSysPrtSetGeneralInfo.Msg3;
wbPrtTemplataTa.Msg4 = taSysPrtSetGeneralInfo.Msg4;
wbPrtTemplataTa.Msg5 = taSysPrtSetGeneralInfo.Msg5;
}
if (!string.IsNullOrEmpty(intCusID.ToString()))
{
new SystemData().GetTaCustomer();
var lstCust = CommonData.TaCustomer.Where(s => s.ID == intCusID);
if (lstCust.Any())
{
TaCustomerInfo taCustomerInfo = lstCust.FirstOrDefault();
wbPrtTemplataTa.CustName = taCustomerInfo.cusName;
wbPrtTemplataTa.CustPhone = taCustomerInfo.cusPhone;
wbPrtTemplataTa.CustDist = taCustomerInfo.cusDistance;
wbPrtTemplataTa.CustMapRef = taCustomerInfo.cusPcZone;
wbPrtTemplataTa.CustHouseNo = taCustomerInfo.cusHouseNo;
wbPrtTemplataTa.CustAddr = taCustomerInfo.cusAddr;
wbPrtTemplataTa.CustPostCode = taCustomerInfo.cusPostcode;
wbPrtTemplataTa.ShopTime = taCustomerInfo.cusReadyTime;
}
}
wbPrtTemplataTa.OrderDate = DateTime.Now.ToShortDateString();
wbPrtTemplataTa.OrderTime = DateTime.Now.ToShortTimeString();
wbPrtTemplataTa.Staff = string.IsNullOrEmpty(sStaff) ? CommonData.UsrBase.FirstOrDefault(s => s.ID == intStaffID).UsrName : sStaff;
wbPrtTemplataTa.OrderNo = strChkOrder;
wbPrtTemplataTa.ItemCount = sItemCount >= 1 ? sItemCount.ToString() : "0";
wbPrtTemplataTa.SubTotal = sSubTotal;
wbPrtTemplataTa.Total = sTotalAmount;
wbPrtTemplataTa.PayType = GetPayType(strChkOrder, deDay.Text);
wbPrtTemplataTa.Tendered = sTendered;
wbPrtTemplataTa.Change = string.IsNullOrEmpty(sChange) ? @"0.00" : (Convert.ToDecimal(sChange)).ToString("0.00");
wbPrtTemplataTa.OrderType = sOrderType;
wbPrtTemplataTa.RefNo = sRefNo;
wbPrtTemplataTa.DeliveryFee = sDeliveryFee;
wbPrtTemplataTa.Discount = sDiscount;
wbPrtTemplataTa.Surcharge = sSurcharge;
#region VAT计算
if (CommonData.GenSet.Any())
{
wbPrtTemplataTa.Rate1 = CommonData.GenSet.FirstOrDefault().VATPer + @"%";
//var lstVAT = from oi in CommonData.TaOrderItem.Where(s => s.CheckCode.Equals(strChkOrder) && s.BusDate.Equals(checkBusDate))
// join mi in CommonData.TaMenuItem on oi.ItemCode equals mi.MiDishCode
// where !string.IsNullOrEmpty(mi.MiRmk) && mi.MiRmk.Contains(@"Without VAT")
// select new
// {
// itemTotalPrice = oi.ItemTotalPrice
// };
string strSqlWhere = "";
DynamicParameters dynamicParams = new DynamicParameters();
strSqlWhere = "CheckCode=@CheckCode AND BusDate=@BusDate";
dynamicParams.Add("CheckCode", strChkOrder);
dynamicParams.Add("BusDate", checkBusDate);
var lstOI = new SQLiteDbHelper().QueryMultiByWhere <TaOrderItemInfo>("Ta_OrderItem", strSqlWhere, dynamicParams);
var lstVAT = from oi in lstOI
join mi in CommonData.TaMenuItem on oi.ItemCode equals mi.MiDishCode
where !string.IsNullOrEmpty(mi.MiRmk) && mi.MiRmk.Contains(@"Without VAT")
select new
{
itemTotalPrice = oi.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.GenSet.FirstOrDefault().VATPer) / 100) * dTotal;
dVat = Math.Round(dVatTmp, 2, MidpointRounding.AwayFromZero);
}
wbPrtTemplataTa.VatA = dVat.ToString();
//税前
wbPrtTemplataTa.Net1 = dTotal.ToString();
//总价
wbPrtTemplataTa.Gross1 = (dTotal - dVat).ToString();
wbPrtTemplataTa.Rate2 = "0.00%";
wbPrtTemplataTa.Net2 = (Convert.ToDecimal(sSubTotal) - dTotal).ToString();
wbPrtTemplataTa.VatB = "0.00";
wbPrtTemplataTa.Gross2 = (Convert.ToDecimal(sSubTotal) - dTotal).ToString();
}
else
{
wbPrtTemplataTa.Rate1 = "0.00%";
wbPrtTemplataTa.Net1 = "0.00";
wbPrtTemplataTa.VatA = "0.00";
wbPrtTemplataTa.Gross1 = "0.00";
wbPrtTemplataTa.Rate2 = "0.00%";
wbPrtTemplataTa.Net2 = "0.00";
wbPrtTemplataTa.VatB = "0.00";
wbPrtTemplataTa.Gross2 = "0.00";
}
#endregion
return(wbPrtTemplataTa);
}
private WbPrtTemplataTa GetAllPrtInfo(string strPrintType)
{
WbPrtTemplataTa wbPrtTemplataTa = new WbPrtTemplataTa();
//new SystemData().GetTaSysPrtSetGeneral();
TaSysPrtSetGeneralInfo taSysPrtSetGeneralInfo = CommonData.TaSysPrtSetGeneral.FirstOrDefault();;
if (taSysPrtSetGeneralInfo != null)
{
//wbPrtTemplataTa.PrintAddress = taSysPrtSetGeneralInfo.IsPrtAddr;
//new SystemData().GetTaSysCtrl();
var lstTaSysCtrl = CommonData.TaSysCtrl;
if (lstTaSysCtrl.Any())
{
wbPrtTemplataTa.PrintAddress = lstTaSysCtrl.FirstOrDefault().ShopAddress;
}
wbPrtTemplataTa.PrintTel = taSysPrtSetGeneralInfo.TelNo;
wbPrtTemplataTa.VATNo = taSysPrtSetGeneralInfo.VATNo;
wbPrtTemplataTa.Msg1 = taSysPrtSetGeneralInfo.Msg1;
wbPrtTemplataTa.Msg2 = taSysPrtSetGeneralInfo.Msg2;
wbPrtTemplataTa.Msg3 = taSysPrtSetGeneralInfo.Msg3;
wbPrtTemplataTa.Msg4 = taSysPrtSetGeneralInfo.Msg4;
wbPrtTemplataTa.Msg5 = taSysPrtSetGeneralInfo.Msg5;
}
if (!string.IsNullOrEmpty(callerID))
{
//new SystemData().GetTaCustomer();
var lstCust = CommonData.TaCustomer.Where(s => s.ID.ToString().Equals(callerID));
if (lstCust.Any())
{
TaCustomerInfo taCustomerInfo = lstCust.FirstOrDefault();
wbPrtTemplataTa.CustName = taCustomerInfo.cusName;
wbPrtTemplataTa.CustPhone = taCustomerInfo.cusPhone;
wbPrtTemplataTa.CustDist = taCustomerInfo.cusDistance;
wbPrtTemplataTa.CustMapRef = taCustomerInfo.cusPcZone;
wbPrtTemplataTa.CustHouseNo = taCustomerInfo.cusHouseNo;
wbPrtTemplataTa.CustAddr = taCustomerInfo.cusAddr;
wbPrtTemplataTa.CustPostCode = taCustomerInfo.cusPostcode;
//wbPrtTemplataTa.ShopTime = taCustomerInfo.cusReadyTime;
}
}
wbPrtTemplataTa.ShopTime = string.IsNullOrEmpty(txtReadyTime.Text) ? "ASAP" : txtReadyTime.Text;
wbPrtTemplataTa.OrderDate = DateTime.Now.ToShortDateString();
wbPrtTemplataTa.OrderTime = DateTime.Now.ToShortTimeString();
wbPrtTemplataTa.Staff = htDetail["Staff"].ToString();
wbPrtTemplataTa.OrderNo = checkID;
wbPrtTemplataTa.ItemCount = htDetail["ItemQty"].ToString();
wbPrtTemplataTa.SubTotal = htDetail["SubTotal"].ToString();
wbPrtTemplataTa.Total = txtToPay.Text;
wbPrtTemplataTa.PayType = IsNotPaid ? @"NOT PAID" : CommonDAL.GetPayType(saveTaCheckOrderInfo);
wbPrtTemplataTa.Tendered = txtTendered.Text;
wbPrtTemplataTa.Change = string.IsNullOrEmpty(txtChange.Text) ? "0.00" : (Convert.ToDecimal(txtChange.Text)).ToString("0.00");
wbPrtTemplataTa.OrderType = orderType;
wbPrtTemplataTa.RefNo = RefNum;
wbPrtTemplataTa.DeliveryFee = @"0.00";
wbPrtTemplataTa.Discount = txtDiscount.Text;
wbPrtTemplataTa.Surcharge = txtSurcharge.Text;
#region VAT计算
if (strPrintType.Equals(WbPrtStatic.PRT_CLASS_ALL_AND_RECEIPT))
{
GenSetInfo gsi = CommonData.GenSet.FirstOrDefault();
if (gsi != null)
{
var lstVAT = from oi in lstOrderItemInfos
join mi in CommonData.TaMenuItem on oi.ItemCode equals mi.MiDishCode
select new
{
VatInfo = mi.MiRmk,
ItemTotalPrice = oi.ItemTotalPrice
};
//new SystemData().GetOrderItemMatchVat(checkID, strBusDate);
//var lstVAT = CommonData.GetOrderItemMatchVat;
decimal dTotal = 0;
decimal dVatTmp = 0;
decimal dVat = 0;
if (lstVAT.Any())
{
//VAT1
wbPrtTemplataTa.Rate1 = gsi.VATPer + @"%";
dTotal = lstVAT.Where(s => !s.VatInfo.Contains("Without VAT")).ToList().Sum(vat => Convert.ToDecimal(vat.ItemTotalPrice));
//交税
dVatTmp = dTotal / ((100 + Convert.ToDecimal(gsi.VATPer)) / 100);
dVat = Math.Round(dVatTmp, 2, MidpointRounding.AwayFromZero);
//
wbPrtTemplataTa.Net1 = dVat.ToString("0.00");
wbPrtTemplataTa.VatA = (dTotal - dVat).ToString("0.00");
wbPrtTemplataTa.Gross1 = dTotal.ToString("0.00");
//VAT2
dTotal = lstVAT.Where(s => s.VatInfo.Contains("Without VAT")).ToList().Sum(vat => Convert.ToDecimal(vat.ItemTotalPrice));
wbPrtTemplataTa.Rate2 = @"0.0%";
wbPrtTemplataTa.Net2 = dTotal.ToString("0.00");
wbPrtTemplataTa.VatB = @"0.00";
wbPrtTemplataTa.Gross2 = dTotal.ToString("0.00");
}
}
else
{
wbPrtTemplataTa.Rate1 = "0.00%";
wbPrtTemplataTa.Net1 = "0.00";
wbPrtTemplataTa.VatA = "0.00";
wbPrtTemplataTa.Gross1 = "0.00";
wbPrtTemplataTa.Rate2 = "0.00%";
wbPrtTemplataTa.Net2 = "0.00";
wbPrtTemplataTa.VatB = "0.00";
wbPrtTemplataTa.Gross2 = "0.00";
}
}
#endregion
return(wbPrtTemplataTa);
}
private WbPrtTemplataTa GetAllPrtInfo()
{
WbPrtTemplataTa wbPrtTemplataTa = new WbPrtTemplataTa();
new SystemData().GetTaSysPrtSetGeneral();
var lstGen = CommonData.TaSysPrtSetGeneral;
if (lstGen.Any())
{
TaSysPrtSetGeneralInfo taSysPrtSetGeneralInfo = lstGen.FirstOrDefault();
//wbPrtTemplataTa.PrintAddress = taSysPrtSetGeneralInfo.IsPrtAddr;
new SystemData().GetTaSysCtrl();
var lstTaSysCtrl = CommonData.TaSysCtrl;
if (lstTaSysCtrl.Any())
{
wbPrtTemplataTa.PrintAddress = lstTaSysCtrl.FirstOrDefault().ShopAddress;
}
wbPrtTemplataTa.PrintTel = taSysPrtSetGeneralInfo.TelNo;
wbPrtTemplataTa.VATNo = taSysPrtSetGeneralInfo.VATNo;
wbPrtTemplataTa.Msg1 = taSysPrtSetGeneralInfo.Msg1;
wbPrtTemplataTa.Msg2 = taSysPrtSetGeneralInfo.Msg2;
wbPrtTemplataTa.Msg3 = taSysPrtSetGeneralInfo.Msg3;
wbPrtTemplataTa.Msg4 = taSysPrtSetGeneralInfo.Msg4;
wbPrtTemplataTa.Msg5 = taSysPrtSetGeneralInfo.Msg5;
}
if (!string.IsNullOrEmpty(intCusID.ToString()))
{
//new SystemData().GetTaCustomer();
var lstCust = CommonData.TaCustomer.Where(s => s.ID == intCusID);
if (lstCust.Any())
{
TaCustomerInfo taCustomerInfo = lstCust.FirstOrDefault();
wbPrtTemplataTa.CustName = taCustomerInfo.cusName;
wbPrtTemplataTa.CustPhone = taCustomerInfo.cusPhone;
wbPrtTemplataTa.CustDist = taCustomerInfo.cusDistance;
wbPrtTemplataTa.CustMapRef = taCustomerInfo.cusPcZone;
wbPrtTemplataTa.CustHouseNo = taCustomerInfo.cusHouseNo;
wbPrtTemplataTa.CustAddr = taCustomerInfo.cusAddr;
wbPrtTemplataTa.CustPostCode = taCustomerInfo.cusPostcode;
wbPrtTemplataTa.ShopTime = taCustomerInfo.cusReadyTime;
}
}
wbPrtTemplataTa.OrderDate = DateTime.Now.ToShortDateString();
wbPrtTemplataTa.OrderTime = DateTime.Now.ToShortTimeString();
wbPrtTemplataTa.Staff = sStaff;
wbPrtTemplataTa.OrderNo = strChkOrder;
wbPrtTemplataTa.ItemCount = sItemCount >= 1 ? sItemCount.ToString() : "0";
wbPrtTemplataTa.SubTotal = sSubTotal;
wbPrtTemplataTa.Total = sTotalAmount;
wbPrtTemplataTa.PayType = sPayType;
wbPrtTemplataTa.Tendered = sTendered;
wbPrtTemplataTa.Change = string.IsNullOrEmpty(sChange) ? @"0.00" : (Convert.ToDecimal(sChange)).ToString("0.00");
wbPrtTemplataTa.OrderType = sOrderType;
wbPrtTemplataTa.RefNo = sRefNo;
wbPrtTemplataTa.DeliveryFee = sDeliveryFee;
wbPrtTemplataTa.Discount = sDiscount;
wbPrtTemplataTa.Surcharge = sSurcharge;
return(wbPrtTemplataTa);
}
