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 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 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(); }
//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); }
public static void PrtHtmlAs(string strBusDate) { WbPrtPrint.PrintHtmlAccountSummary(strBusDate); }