private void RefreshPrtInfo() { if (string.IsNullOrEmpty(strChkOrder)) return; if (doc == null) doc = new HtmlWeb().Load(WbPrtStatic.PRT_TEMPLATE_FILE_PATH + @"so" + WbPrtStatic.PRT_TEMPLATE_FILE_NAME_SUFFIX); string strSqlWhere = ""; DynamicParameters dynamicParams = new DynamicParameters(); strSqlWhere = "CheckCode=@CheckCode AND BusDate=@BusDate"; dynamicParams.Add("CheckCode", strChkOrder); dynamicParams.Add("BusDate", strBusDate); var lstOI = new SQLiteDbHelper().QueryMultiByWhere<TaOrderItemInfo>("Ta_OrderItem", strSqlWhere, dynamicParams); //new SystemData().GetTaOrderItem(); //var lstOI = CommonData.TaOrderItem.Where(s => s.CheckCode.Equals(strChkOrder) && s.BusDate.Equals(strBusDate)).ToList(); WbPrtTemplataTa wbPrtTemplataTa = new WbPrtTemplataTa(); wbPrtTemplataTa = GetAllPrtInfo(); string htmlText = doc.Text; if (string.IsNullOrEmpty(htmlText)) webBrowser1.DocumentText = ""; htmlText = WbPrtPrint.ReplaceHtmlPrtKeysShop(htmlText, wbPrtTemplataTa); htmlText = WbPrtPrint.GetOrderItemInfo(doc, htmlText, lstOI, false); webBrowser1.DocumentText = htmlText; //webBrowser2.Refresh(); }
private void btnPrtKit_Click(object sender, EventArgs e) { #region 原打印方式 //new SystemData().GetTaOrderItem(); //var lstOI = CommonData.TaOrderItem.Where(s => s.CheckCode.Equals(strChkOrder) && s.BusDate.Equals(deDay.Text)).ToList(); //PrtTemplataTa prtTemplataTa = new PrtTemplataTa(); //prtTemplataTa.RestaurantName = PrtCommon.GetRestName(); //prtTemplataTa.Addr = PrtCommon.GetRestAddr(); //prtTemplataTa.Telephone = PrtCommon.GetRestTel(); //prtTemplataTa.VatNo = PrtCommon.GetRestVATNo(); //prtTemplataTa.OrderTime = PrtCommon.GetPrtTime(); //prtTemplataTa.OrderDate = PrtCommon.GetPrtDateTime(); //prtTemplataTa.OrderNo = strChkOrder; //prtTemplataTa.PayType = GetPayType(strChkOrder); //prtTemplataTa.TotalAmount = sTotalAmount; //prtTemplataTa.SubTotal = sSubTotal; //prtTemplataTa.StaffName = sStaff; //prtTemplataTa.ItemCount = sItemCount >= 1 ? sItemCount.ToString() : "0"; //prtTemplataTa.Discount = sDiscount + sDiscountPer; //PrtTemplate.PrtTa(prtTemplataTa, lstOI, PrtStatic.PRT_TEMPLATE_TA_KITCHEN_TYPE); #endregion Stopwatch sw = new Stopwatch(); sw.Start(); //new SystemData().GetTaOrderItem(); //var lstOI = CommonData.TaOrderItem.Where(s => s.CheckCode.Equals(strChkOrder) && s.BusDate.Equals(checkBusDate)).ToList(); 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); WbPrtTemplataTa wbPrtTemplataTa = new WbPrtTemplataTa(); wbPrtTemplataTa = GetAllPrtInfo(); //WbPrtPrint.PrintHtml( WbPrtStatic.PRT_CLASS_KITCHEN, lstOI, wbPrtTemplataTa, sOrderType); DelegatePrtHtml handler = DelegateMy.PrtHtml; IAsyncResult result = handler.BeginInvoke(WbPrtStatic.PRT_CLASS_KITCHEN, lstOI, wbPrtTemplataTa, sOrderType, null, null); sw.Stop(); TimeSpan ts = sw.Elapsed; Console.WriteLine(@"#btnPrtKit_Click# Time:{0}", ts.TotalMilliseconds); }
private void RefreshPrtInfo(string sBusDate, string sCheckCode) { Stopwatch sw = new Stopwatch(); sw.Start(); if (string.IsNullOrEmpty(sCheckCode)) { return; } if (doc == null) { doc = new HtmlWeb().Load(WbPrtStatic.PRT_TEMPLATE_FILE_PATH + @"so" + WbPrtStatic.PRT_TEMPLATE_FILE_NAME_SUFFIX); } string strSqlWhere = ""; DynamicParameters dynamicParams = new DynamicParameters(); strSqlWhere = "CheckCode=@CheckCode AND BusDate=@BusDate"; dynamicParams.Add("BusDate", sBusDate); dynamicParams.Add("CheckCode", sCheckCode); //var lstOI = CommonData.TaOrderItem.Where(s => s.CheckCode.Equals(strChkOrder) && s.BusDate.Equals(checkBusDate)).ToList(); var lstOI = new SQLiteDbHelper().QueryMultiByWhere <TaOrderItemInfo>("Ta_OrderItem", strSqlWhere, dynamicParams); string htmlText = doc.Text; wbPtl = GetAllPrtInfo(); if (string.IsNullOrEmpty(htmlText)) { webBrowser2.DocumentText = ""; } htmlText = WbPrtPrint.ReplaceHtmlPrtKeysShop(htmlText, wbPtl); htmlText = WbPrtPrint.GetOrderItemInfo(doc, htmlText, lstOI, false); webBrowser2.DocumentText = htmlText; sw.Stop(); TimeSpan ts = sw.Elapsed; Console.WriteLine(@"FrmTaShowOrder/RefreshPrtInfo Time:{0}", ts.TotalMilliseconds); //webBrowser2.Refresh(); }
private void btnPrtKit_Click(object sender, EventArgs e) { 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); //new SystemData().GetTaOrderItem(); //var lstOI = CommonData.TaOrderItem.Where(s => s.CheckCode.Equals(strChkOrder) && s.BusDate.Equals(checkBusDate)).ToList(); WbPrtTemplataTa wbPrtTemplataTa = new WbPrtTemplataTa(); wbPrtTemplataTa = GetAllPrtInfo(); //WbPrtPrint.PrintHtml( WbPrtStatic.PRT_CLASS_KITCHEN, lstOI, wbPrtTemplataTa, sOrderType); DelegatePrtHtml handler = DelegateMy.PrtHtml; IAsyncResult result = handler.BeginInvoke(WbPrtStatic.PRT_CLASS_KITCHEN, lstOI, wbPrtTemplataTa, sOrderType, null, null); }
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 void btnPrtReceipt_Click(object sender, EventArgs e) { #region 原打印方式 //new SystemData().GetTaOrderItem(); //var lstOI = CommonData.TaOrderItem.Where(s => s.CheckCode.Equals(strChkOrder) && s.BusDate.Equals(deDay.Text)).ToList(); //PrtTemplataTa prtTemplataTa = new PrtTemplataTa(); //prtTemplataTa.RestaurantName = PrtCommon.GetRestName(); //prtTemplataTa.Addr = PrtCommon.GetRestAddr(); //prtTemplataTa.Telephone = PrtCommon.GetRestTel(); //prtTemplataTa.VatNo = PrtCommon.GetRestVATNo(); //prtTemplataTa.OrderTime = PrtCommon.GetPrtTime(); //prtTemplataTa.OrderDate = PrtCommon.GetPrtDateTime(); //prtTemplataTa.OrderNo = strChkOrder; //prtTemplataTa.PayType = GetPayType(strChkOrder); //prtTemplataTa.TotalAmount = sTotalAmount; //prtTemplataTa.SubTotal = sSubTotal; //prtTemplataTa.StaffName = sStaff; //prtTemplataTa.ItemCount = sItemCount >= 1 ? sItemCount.ToString() : "0"; //prtTemplataTa.Discount = sDiscount + sDiscountPer; //#region VAT计算 //if (CommonData.GenSet.Any()) //{ // prtTemplataTa.Rete1 = CommonData.GenSet.FirstOrDefault().VATPer + @"%"; // var lstVAT = from oi in CommonData.TaOrderItem.Where(s => s.CheckCode.Equals(strChkOrder) && s.BusDate.Equals(deDay.Text)) // 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); // } // prtTemplataTa.VatA = dVat.ToString(); // //税前 // prtTemplataTa.Net1 = dTotal.ToString(); // //总价 // prtTemplataTa.Gross1 = (dTotal - dVat).ToString(); // prtTemplataTa.Rate2 = "0.00%"; // prtTemplataTa.Net2 = (Convert.ToDecimal(sSubTotal) - dTotal).ToString(); // prtTemplataTa.VatB = "0.00"; // prtTemplataTa.Gross2 = (Convert.ToDecimal(sSubTotal) - dTotal).ToString(); //} //else //{ // prtTemplataTa.Rete1 = "0.00%"; // prtTemplataTa.Net1 = "0.00"; // prtTemplataTa.VatA = "0.00"; // prtTemplataTa.Gross1 = "0.00"; // prtTemplataTa.Rate2 = "0.00%"; // prtTemplataTa.Net2 = "0.00"; // prtTemplataTa.VatB = "0.00"; // prtTemplataTa.Gross2 = "0.00"; //} //#endregion //PrtTemplate.PrtTa(prtTemplataTa, lstOI, PrtStatic.PRT_TEMPLATE_TA_RECEIPT_TYPE); #endregion Stopwatch sw = new Stopwatch(); sw.Start(); 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); //new SystemData().GetTaOrderItem(); //var lstOI = CommonData.TaOrderItem.Where(s => s.CheckCode.Equals(strChkOrder) && s.BusDate.Equals(checkBusDate)).ToList(); WbPrtTemplataTa wbPrtTemplataTa = new WbPrtTemplataTa(); wbPrtTemplataTa = GetAllPrtInfo(); //WbPrtPrint.PrintHtml( WbPrtStatic.PRT_CLASS_RECEIPT, lstOI, wbPrtTemplataTa, sOrderType); DelegatePrtHtml handler = DelegateMy.PrtHtml; IAsyncResult result = handler.BeginInvoke(WbPrtStatic.PRT_CLASS_RECEIPT, lstOI, wbPrtTemplataTa, sOrderType, null, null); sw.Stop(); TimeSpan ts = sw.Elapsed; Console.WriteLine(@"#btnPrtReceipt_Click# Time:{0}", ts.TotalMilliseconds); }
private void RefreshPrtInfo(string sCheckOrder, string sBusDate) { System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch(); sw.Start(); if (string.IsNullOrEmpty(sCheckOrder)) { return; } if (doc == null) { doc = new HtmlWeb().Load(WbPrtStatic.PRT_TEMPLATE_FILE_PATH + @"so" + WbPrtStatic.PRT_TEMPLATE_FILE_NAME_SUFFIX); } string strSqlWhere = ""; DynamicParameters dynamicParams = new DynamicParameters(); strSqlWhere = "CheckCode=@CheckCode AND BusDate=@BusDate"; dynamicParams.Add("CheckCode", sCheckOrder); dynamicParams.Add("BusDate", sBusDate); var lstOI = new SQLiteDbHelper().QueryMultiByWhere <TaOrderItemInfo>("Ta_OrderItem", strSqlWhere, dynamicParams); //var lstOI = CommonData.TaOrderItem.Where(s => s.CheckCode.Equals(strChkOrder) && s.BusDate.Equals(checkBusDate)).ToList(); WbPrtTemplataTa wbPrtTemplataTa = new WbPrtTemplataTa(); wbPrtTemplataTa = CommonDAL.GetAllPrtInfo(intCusID <= 0 ? "" : intCusID.ToString(), sStaff, intStaffID.ToString(), sCheckOrder, sItemCount, sSubTotal, sTotalAmount, sTendered, sChange, sRefNo, sDeliveryFee, sDiscount, sSurcharge, sBusDate, sOrderType); string htmlText = doc.Text; if (string.IsNullOrEmpty(htmlText)) { webBrowser2.DocumentText = ""; } htmlText = WbPrtPrint.ReplaceHtmlPrtKeysShop(htmlText, wbPrtTemplataTa); htmlText = WbPrtPrint.GetOrderItemInfo(doc, htmlText, lstOI, false); webBrowser2.DocumentText = htmlText; sw.Stop(); TimeSpan ts = sw.Elapsed; Console.WriteLine(@"FrmAccountSummary RefreshPrtInfo Time:{0}", ts.TotalMilliseconds); LogHelper.Info(@"FrmAccountSummary RefreshPrtInfo Time:" + ts.TotalMilliseconds); //webBrowser2.Refresh(); }
private void SaveOrderAndPrint(string strPrintType) { if (txtReadyTime.Text.Length > 0) { if (txtReadyTime.Text.Length != 5) { MessageBox.Show("Ready Time INPUT Error", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } if (saveTaCheckOrderInfo != null) { TaCheckOrderInfo taCheckOrder = saveTaCheckOrderInfo; taCheckOrder.PayTime = DateTime.Now.ToString(); taCheckOrder.PayPerDiscount = txtPercentDiscount.Text; taCheckOrder.PayDiscount = Math.Round(Convert.ToDecimal(txtDiscount.Text), 2).ToString(@"0.00"); taCheckOrder.PayPerSurcharge = txtPercentSurcharge.Text; taCheckOrder.PaySurcharge = Math.Round(Convert.ToDecimal(txtSurcharge.Text), 2).ToString(@"0.00"); taCheckOrder.PayType1 = lblPayType1.Text; taCheckOrder.PayTypePay1 = Math.Round(Convert.ToDecimal(txtPayTypePay1.Text), 2).ToString(@"0.00"); taCheckOrder.PayType2 = lblPayType2.Text; taCheckOrder.PayTypePay2 = Math.Round(Convert.ToDecimal(txtPayTypePay2.Text), 2).ToString(@"0.00"); taCheckOrder.PayType3 = lblPayType3.Text; taCheckOrder.PayTypePay3 = Math.Round(Convert.ToDecimal(txtPayTypePay3.Text), 2).ToString(@"0.00"); taCheckOrder.PayType4 = lblPayType4.Text; taCheckOrder.PayTypePay4 = Math.Round(Convert.ToDecimal(txtPayTypePay4.Text), 2).ToString(@"0.00"); taCheckOrder.PayType5 = lblPayType5.Text; taCheckOrder.PayTypePay5 = Math.Round(Convert.ToDecimal(txtPayTypePay5.Text), 2).ToString(@"0.00"); taCheckOrder.TotalAmount = Math.Round(Convert.ToDecimal(txtToPay.Text), 2).ToString(@"0.00"); taCheckOrder.Paid = Math.Round(Convert.ToDecimal(txtTendered.Text), 2).ToString(@"0.00"); taCheckOrder.IsPaid = IsPaid ? @"Y" : @"N"; taCheckOrder.BusDate = strBusDate; taCheckOrder.RefNum = RefNum; taCheckOrder.DeliveryFee = @"0.00"; WbPrtTemplataTa wbPrtTemplataTa = new WbPrtTemplataTa(); if (lstOrderItemInfos.Count < 1) { lstOrderItemInfos = CommonData.TaOrderItem.Where(s => s.CheckCode.Equals(checkID) && s.BusDate.Equals(strBusDate)).ToList(); } wbPrtTemplataTa = GetAllPrtInfo(strPrintType); //_control.UpdateEntity(taCheckOrder); DelegateSaveCheckOrderAndPrint handler = DelegateMy.CheckOrderSaveAndPrint; IAsyncResult result = handler.BeginInvoke(taCheckOrder, strPrintType, lstOrderItemInfos, wbPrtTemplataTa, taCheckOrder.PayOrderType, null, null); } bool isOpenCashDrawSuccess = CommonDAL.OpenCashDraw(false, ""); if (!isOpenCashDrawSuccess) { MessageBox.Show(PubComm.CASH_DRAW_INFO, PubComm.CASH_DRAW_TEXT_TITLE, MessageBoxButtons.OK); } if (IsPaid) { returnPaid = true; this.DialogResult = DialogResult.OK; Hide(); } else { if (IsNotPaid) { returnPaid = true; this.DialogResult = DialogResult.OK; Hide(); } } }
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); }
//public static void SaveShowOrderModelPreview() //{ // try // {string content = @""; // TaPreviewInfo taPreview = new TaPreviewInfo(); // foreach (var f in new DirectoryInfo(PrtStatic.PRT_TEMPLATE_FILE_PATH).GetFiles().Where(s => s.Name.Equals(@"showorder.txt"))) // { // if (f.Length > 0) // { // //switch (f.Name) // //{ // // case @"taKitchen.txt": // // taPreview.PreviewType = PrtStatic.PRT_TEMPLATE_TA_KITCHEN_PRE; // // break; // // case @"taReceipt.txt": // // taPreview.PreviewType = PrtStatic.PRT_TEMPLATE_TA_RECEIPT_PRE; // // break; // // case @"taBill.txt": // // taPreview.PreviewType = PrtStatic.PRT_TEMPLATE_TA_BILL_PRE; // // break; // // case @"ta.txt": // // taPreview.PreviewType = PrtStatic.PRT_TEMPLATE_ALL_PRE; // // break; // // case @"showorder.txt": // // taPreview.PreviewType = PrtStatic.PRT_TEMPLATE_SHOWORDER_PRE; // // break; // //} // taPreview.PreviewType = PrtStatic.PRT_TEMPLATE_SHOWORDER_PRE; // taPreview.PreviewFileName = f.Name; // StreamReader objReader = new StreamReader(PrtStatic.PRT_TEMPLATE_FILE_PATH + f.Name, Encoding.UTF8); // taPreview.PreviewContent = objReader.ReadToEnd(); // taPreview.PreviewContent = PrtTemplate.ReplacePrtKeysPreviewDefaultContent(taPreview.PreviewContent); // var lstTaPreview = CommonData.TaPreview.Where(s => s.PreviewType.Equals(taPreview.PreviewType)); // if (lstTaPreview.Any()) // { // taPreview.ID = lstTaPreview.FirstOrDefault(s => s.PreviewType.Equals(taPreview.PreviewType)).ID; // _control.UpdateEntity(taPreview); // } // else // { // _control.AddEntity(taPreview); // } // } // } // } // catch (Exception ex) { LogHelper.Error(@"CommonDAL", ex); } //} #endregion #region 打印 //public static void PrtHtml(string checkID, string strBusDate, List<TaOrderItemInfo> lstOI, string strPrintType, WbPrtTemplataTa wbPrtTemplataTa, string strOrderType) //{ // WbPrtPrint.PrintHtml(strPrintType, lstOI, wbPrtTemplataTa, strOrderType); //} public static void PrtHtml(string strPrintType, List <TaOrderItemInfo> lstOI, WbPrtTemplataTa wbPrtTemplataTa, string strOrderType) { WbPrtPrint.PrintHtml(strPrintType, lstOI, wbPrtTemplataTa, strOrderType); }
public static void CheckOrderSaveAndPrint(TaCheckOrderInfo taCheckOrderInfo, string strPrintType, List <TaOrderItemInfo> lstOI, WbPrtTemplataTa wbPrtTemplataTa, string strOrderType) { SaveCheckOrder(taCheckOrderInfo, false); WbPrtPrint.PrintHtml(strPrintType, lstOI, wbPrtTemplataTa, strOrderType); }
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); }