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