protected void chkOrderSlipPrinter_CheckedChanged(Object sender, EventArgs e) { CheckBox chkOrderSlipPrinter = (CheckBox)sender; DataListItem item = (DataListItem)chkOrderSlipPrinter.NamingContainer; HtmlInputCheckBox chkList = (HtmlInputCheckBox)item.FindControl("chkList"); Int64 iProductID = Int64.Parse(chkList.Value); OrderSlipPrinter orderSlipPrinter = OrderSlipPrinter.NotApplicable; switch (chkOrderSlipPrinter.ID) { case "chkOrderSlipPrinter1": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter1; break; case "chkOrderSlipPrinter2": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter2; break; case "chkOrderSlipPrinter3": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter3; break; case "chkOrderSlipPrinter4": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter4; break; case "chkOrderSlipPrinter5": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter5; break; } Products clsProducts = new Products(); clsProducts.UpdateOrderSlipPrinter(iProductID, orderSlipPrinter, chkOrderSlipPrinter.Checked); clsProducts.CommitAndDispose(); }
protected void chkOrderSlipPrinterAll_CheckedChanged(Object sender, EventArgs e) { HtmlInputCheckBox chkList = null; CheckBox chkOrderSlipPrinterAll = (CheckBox)sender; CheckBox chkOrderSlipPrinter = null; Int64 iProductID = 0; Products clsProducts = new Products(); OrderSlipPrinter orderSlipPrinter = OrderSlipPrinter.NotApplicable; foreach (DataListItem item in lstItem.Items) { chkList = (HtmlInputCheckBox)item.FindControl("chkList"); iProductID = Int64.Parse(chkList.Value); switch (chkOrderSlipPrinterAll.ID) { case "chkOrderSlipPrinter1All": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter1; chkOrderSlipPrinter = (CheckBox)item.FindControl("chkOrderSlipPrinter1"); break; case "chkOrderSlipPrinter2All": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter2; chkOrderSlipPrinter = (CheckBox)item.FindControl("chkOrderSlipPrinter2"); break; case "chkOrderSlipPrinter3All": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter3; chkOrderSlipPrinter = (CheckBox)item.FindControl("chkOrderSlipPrinter3"); break; case "chkOrderSlipPrinter4All": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter4; chkOrderSlipPrinter = (CheckBox)item.FindControl("chkOrderSlipPrinter4"); break; case "chkOrderSlipPrinter5All": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter5; chkOrderSlipPrinter = (CheckBox)item.FindControl("chkOrderSlipPrinter5"); break; } clsProducts.UpdateOrderSlipPrinter(iProductID, orderSlipPrinter, chkOrderSlipPrinterAll.Checked); chkOrderSlipPrinter.Checked = chkOrderSlipPrinterAll.Checked; } clsProducts.CommitAndDispose(); }
public void PrintPLUReportPerOrderSlipPrinter(System.Data.DataTable dtPLUReport, Data.CashierReportDetails clsCashierReportDetails, DateTime StartDate, DateTime EndDate, OrderSlipPrinter blockOrderSlipPrinter) { Cursor.Current = Cursors.WaitCursor; try { PrintingPreference oldCONFIG_AutoPrint = mclsTerminalDetails.AutoPrint; mclsTerminalDetails.AutoPrint = PrintingPreference.Normal; PrintReportHeadersSection(false); decimal TotalQuantity = 0; decimal TotalAmount = 0; msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine); msbToPrint.Append(CenterString("PLU REPORT", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine); msbToPrint.Append(CenterString(blockOrderSlipPrinter.ToString("G"), mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine); msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine); msbToPrint.Append(CenterString("Start Date: " + StartDate.ToString("MM/dd/yyyy hh:mm:ss tt"), mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine); msbToPrint.Append(CenterString("End Date : " + EndDate.ToString("MM/dd/yyyy hh:mm:ss tt"), mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine + Environment.NewLine); msbToPrint.Append("Item Quantity Amount" + Environment.NewLine); msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine); foreach (System.Data.DataRow dr in dtPLUReport.Rows) { OrderSlipPrinter enumOrderSlipPrinter = (OrderSlipPrinter)Enum.Parse(typeof(OrderSlipPrinter), dr["OrderSlipPrinter"].ToString()); if (blockOrderSlipPrinter == enumOrderSlipPrinter) { string stProductCode = dr["ProductCode"].ToString(); string stQuantity = Convert.ToDecimal(dr["Quantity"].ToString()).ToString("#,##0.#0"); string stAmount = Convert.ToDecimal(dr["Amount"].ToString()).ToString("#,##0.#0"); if (stProductCode.Length <= 11) { msbToPrint.Append(stProductCode.PadRight(11)); msbToPrint.Append(stQuantity.PadLeft(12)); msbToPrint.Append(stAmount.PadLeft(17)); msbToPrint.Append(Environment.NewLine); } else { msbToPrint.Append(stProductCode + Environment.NewLine); msbToPrint.Append(stQuantity.PadLeft(23)); msbToPrint.Append(stAmount.PadLeft(17)); msbToPrint.Append(Environment.NewLine); } TotalQuantity += Convert.ToDecimal(dr["Quantity"]); TotalAmount += Convert.ToDecimal(dr["Amount"]); } } msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine); msbToPrint.Append("Total:".PadRight(6)); msbToPrint.Append(TotalQuantity.ToString("#,##0.#0").PadLeft(17)); msbToPrint.Append(TotalAmount.ToString("#,##0.#0").PadLeft(17)); msbToPrint.Append(Environment.NewLine); msbToPrint.Append("Grand Total :".PadRight(16)); msbToPrint.Append(TotalAmount.ToString("#,##0.#0").PadLeft(24)); msbToPrint.Append(Environment.NewLine); msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine); PrintPageAndReportFooterSection(false, DateTime.MinValue); mclsTerminalDetails.AutoPrint = oldCONFIG_AutoPrint; InsertAuditLog(AccessTypes.PrintPLUReport, "Print PLU report per OrderSlipprinter: " + blockOrderSlipPrinter.ToString("G") + " TerminalNo=" + mclsTerminalDetails.TerminalNo + " @ Branch: " + mclsTerminalDetails.BranchDetails.BranchCode); } catch (Exception ex) { InsertErrorLogToFile(ex, "ERROR!!! Printing PLU report. Err Description: "); } Cursor.Current = Cursors.Default; }
public void PrintItemToOSPrinter(string Description, string stProductUnitCode, decimal Quantity, OrderSlipPrinter OrderSlipPrinter, bool bolBIG, string Remarks) { // return if no OrderSlipPrinter if (OrderSlipPrinter == RetailPlus.OrderSlipPrinter.NotApplicable) return; // description string stDescription = Description; if (stDescription.IndexOf(Environment.NewLine) > -1) { try { stDescription = Description.Split(Convert.ToChar(Environment.NewLine)).GetValue(0).ToString(); } catch { } } if (stDescription.Length > mclsTerminalDetails.MaxReceiptWidth) { try { stDescription = stDescription.Substring(0, mclsTerminalDetails.MaxReceiptWidth); } catch { } } string stQuantity = Quantity.ToString("#,##0.#0"); if (Quantity == 1 || Quantity == -1) stQuantity = "1"; else if (Decimal.Compare(Quantity, Decimal.Floor(Quantity)) == 0) { stQuantity = Quantity.ToString("#,##0"); } if (bolBIG) { if (mclsTerminalDetails.IsPrinterDotMatrix) SendOrderSlipToPrinter(stQuantity + "x" + stProductUnitCode + " " + stDescription.PadRight(mclsTerminalDetails.MaxReceiptWidth - 12), OrderSlipPrinter); else SendOrderSlipToPrinter(RawPrinterHelper.escFontHeightX2On + stQuantity + "x" + stProductUnitCode + " " + stDescription.PadRight(mclsTerminalDetails.MaxReceiptWidth - 12) + RawPrinterHelper.escFontHeightX2Off, OrderSlipPrinter); } else { SendOrderSlipToPrinter(stDescription.PadRight(mclsTerminalDetails.MaxReceiptWidth - 12), OrderSlipPrinter); SendOrderSlipToPrinter(stProductUnitCode.PadRight(6), OrderSlipPrinter); SendOrderSlipToPrinter(stQuantity.PadLeft(6), OrderSlipPrinter); } SendOrderSlipToPrinter(Environment.NewLine, OrderSlipPrinter); if (!string.IsNullOrEmpty(Remarks)) SendOrderSlipToPrinter(" * " + Remarks + Environment.NewLine, OrderSlipPrinter); }
public void PrintItemCompositionToOSPrinter(string Description, string stProductUnitCode, decimal Quantity, OrderSlipPrinter OrderSlipPrinter) { // return if no OrderSlipPrinter if (OrderSlipPrinter == RetailPlus.OrderSlipPrinter.NotApplicable) return; // description string stDescription = Description; try { stDescription = Description.Split(Convert.ToChar(Environment.NewLine)).GetValue(0).ToString(); } catch { } try { stDescription = stDescription.Substring(0, mclsTerminalDetails.MaxReceiptWidth); } catch { } SendOrderSlipToPrinter(stDescription.PadRight(mclsTerminalDetails.MaxReceiptWidth - 12), OrderSlipPrinter); SendOrderSlipToPrinter(stProductUnitCode.PadRight(6), OrderSlipPrinter); string stQuantity = Quantity.ToString("#,##0.#0"); if (Quantity == 1 || Quantity == -1) stQuantity = "1"; else if (Decimal.Compare(Quantity, Decimal.Floor(Quantity)) == 0) { stQuantity = Quantity.ToString("#,##0"); } SendOrderSlipToPrinter(stQuantity.PadLeft(6), OrderSlipPrinter); SendOrderSlipToPrinter(Environment.NewLine, OrderSlipPrinter); }
public bool PrintOrderSlipFooter(OrderSlipPrinter orderSlipPrinter) { // no need if it's a non-applicable if (orderSlipPrinter == RetailPlus.OrderSlipPrinter.NotApplicable) return false; bool boSuccess = false; SendOrderSlipToPrinter("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine, orderSlipPrinter); SendOrderSlipToPrinter("Served by: " + mclsSalesTransactionDetails.WaiterName + Environment.NewLine, orderSlipPrinter); SendOrderSlipToPrinter("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine, orderSlipPrinter); // print page footer spacer for (int i = 0; i < 6; i++) { SendOrderSlipToPrinter(Environment.NewLine, orderSlipPrinter); } switch (orderSlipPrinter) { case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter1: mclsFPRetailPlusOSPrinter1.Write(msbToPrintFP1); boSuccess = RawPrinterHelper.SendFileToPrinter(orderSlipPrinter.ToString("G"), mclsFPRetailPlusOSPrinter1.FileName, "RetailPlus " + mclsFPRetailPlusOSPrinter1.FileName); //mclsFPRetailPlusOSPrinter1.DeleteFile(); break; case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter2: mclsFPRetailPlusOSPrinter2.Write(msbToPrintFP2); boSuccess = RawPrinterHelper.SendFileToPrinter(orderSlipPrinter.ToString("G"), mclsFPRetailPlusOSPrinter2.FileName, "RetailPlus " + mclsFPRetailPlusOSPrinter2.FileName); //mclsFPRetailPlusOSPrinter2.DeleteFile(); break; case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter3: mclsFPRetailPlusOSPrinter3.Write(msbToPrintFP3); boSuccess = RawPrinterHelper.SendFileToPrinter(orderSlipPrinter.ToString("G"), mclsFPRetailPlusOSPrinter3.FileName, "RetailPlus " + mclsFPRetailPlusOSPrinter3.FileName); //mclsFPRetailPlusOSPrinter3.DeleteFile(); break; case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter4: mclsFPRetailPlusOSPrinter4.Write(msbToPrintFP4); boSuccess = RawPrinterHelper.SendFileToPrinter(orderSlipPrinter.ToString("G"), mclsFPRetailPlusOSPrinter4.FileName, "RetailPlus " + mclsFPRetailPlusOSPrinter4.FileName); //mclsFPRetailPlusOSPrinter4.DeleteFile(); break; case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter5: mclsFPRetailPlusOSPrinter5.Write(msbToPrintFP5); boSuccess = RawPrinterHelper.SendFileToPrinter(orderSlipPrinter.ToString("G"), mclsFPRetailPlusOSPrinter2.FileName, "RetailPlus " + mclsFPRetailPlusOSPrinter5.FileName); //mclsFPRetailPlusOSPrinter5.DeleteFile(); break; } if (mclsTerminalDetails.IsPrinterAutoCutter) CutPrinterPaper(orderSlipPrinter.ToString("G")); return boSuccess; }
public void PrintOrderSlipHeader(OrderSlipPrinter OrderSlipPrinter, bool WillReprintAll) { // no need if it's a non-applicable if (OrderSlipPrinter == RetailPlus.OrderSlipPrinter.NotApplicable) return; switch (OrderSlipPrinter) { case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter1: mclsFPRetailPlusOSPrinter1 = new FilePrinter(); msbToPrintFP1.Clear(); msbToPrintFP1 = new StringBuilder(); if (string.IsNullOrEmpty(mclsSalesTransactionDetails.TransactionNo) || mclsSalesTransactionDetails.TransactionNo == "READY..." || mclsSalesTransactionDetails.TransactionNo == mclsFPRetailPlusOSPrinter1.FileName) mclsFPRetailPlusOSPrinter1.FileName = DateTime.Now.ToString("yyyyMMddhhmmss"); else mclsFPRetailPlusOSPrinter1.FileName = mclsSalesTransactionDetails.TransactionNo + "OS1"; break; case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter2: mclsFPRetailPlusOSPrinter2 = new FilePrinter(); msbToPrintFP2.Clear(); msbToPrintFP2 = new StringBuilder(); if (string.IsNullOrEmpty(mclsSalesTransactionDetails.TransactionNo) || mclsSalesTransactionDetails.TransactionNo == "READY..." || mclsSalesTransactionDetails.TransactionNo == mclsFPRetailPlusOSPrinter2.FileName) mclsFPRetailPlusOSPrinter2.FileName = DateTime.Now.ToString("yyyyMMddhhmmss"); else mclsFPRetailPlusOSPrinter2.FileName = mclsSalesTransactionDetails.TransactionNo + "OS2"; break; case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter3: mclsFPRetailPlusOSPrinter3 = new FilePrinter(); msbToPrintFP3.Clear(); msbToPrintFP3 = new StringBuilder(); if (string.IsNullOrEmpty(mclsSalesTransactionDetails.TransactionNo) || mclsSalesTransactionDetails.TransactionNo == "READY..." || mclsSalesTransactionDetails.TransactionNo == mclsFPRetailPlusOSPrinter3.FileName) mclsFPRetailPlusOSPrinter3.FileName = DateTime.Now.ToString("yyyyMMddhhmmss"); else mclsFPRetailPlusOSPrinter3.FileName = mclsSalesTransactionDetails.TransactionNo + "OS3"; break; case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter4: mclsFPRetailPlusOSPrinter4 = new FilePrinter(); msbToPrintFP4.Clear(); msbToPrintFP4 = new StringBuilder(); if (string.IsNullOrEmpty(mclsSalesTransactionDetails.TransactionNo) || mclsSalesTransactionDetails.TransactionNo == "READY..." || mclsSalesTransactionDetails.TransactionNo == mclsFPRetailPlusOSPrinter4.FileName) mclsFPRetailPlusOSPrinter4.FileName = DateTime.Now.ToString("yyyyMMddhhmmss"); else mclsFPRetailPlusOSPrinter4.FileName = mclsSalesTransactionDetails.TransactionNo + "OS4"; break; case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter5: mclsFPRetailPlusOSPrinter5 = new FilePrinter(); msbToPrintFP5.Clear(); msbToPrintFP5 = new StringBuilder(); if (string.IsNullOrEmpty(mclsSalesTransactionDetails.TransactionNo) || mclsSalesTransactionDetails.TransactionNo == "READY..." || mclsSalesTransactionDetails.TransactionNo == mclsFPRetailPlusOSPrinter5.FileName) mclsFPRetailPlusOSPrinter5.FileName = DateTime.Now.ToString("yyyyMMddhhmmss"); else mclsFPRetailPlusOSPrinter5.FileName = mclsSalesTransactionDetails.TransactionNo + "OS5"; break; } // print page header spacer for (int i = 0; i < 3; i++) { SendOrderSlipToPrinter(Environment.NewLine, OrderSlipPrinter); } SendOrderSlipToPrinter(CenterString("Trx #: " + mclsSalesTransactionDetails.TransactionNo, mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine, OrderSlipPrinter); SendOrderSlipToPrinter(CenterString(DateTime.Now.ToString("MM/dd/yyyy hh:mm tt"), mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine, OrderSlipPrinter); if (mclsTerminalDetails.IsPrinterDotMatrix) { SendOrderSlipToPrinter(CenterString("ORDER SLIP", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine, OrderSlipPrinter); } else { SendOrderSlipToPrinter(RawPrinterHelper.escFontHeightX2On + CenterString("ORDER SLIP", mclsTerminalDetails.MaxReceiptWidth) + RawPrinterHelper.escFontHeightX2Off + Environment.NewLine, OrderSlipPrinter); } // if (WillReprintAll) { SendOrderSlipToPrinter(CenterString("-reprinted: check if already prepared-", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine, OrderSlipPrinter); } SendOrderSlipToPrinter(Environment.NewLine, OrderSlipPrinter); SendOrderSlipToPrinter("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine, OrderSlipPrinter); SendOrderSlipToPrinter("Customer : " + mclsSalesTransactionDetails.CustomerName + Environment.NewLine, OrderSlipPrinter); SendOrderSlipToPrinter("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine, OrderSlipPrinter); SendOrderSlipToPrinter("DESC".PadRight(mclsTerminalDetails.MaxReceiptWidth - 12), OrderSlipPrinter); SendOrderSlipToPrinter("UNIT".PadRight(6), OrderSlipPrinter); SendOrderSlipToPrinter("QTY".PadLeft(6), OrderSlipPrinter); SendOrderSlipToPrinter(Environment.NewLine, OrderSlipPrinter); SendOrderSlipToPrinter("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine, OrderSlipPrinter); }
public void UpdateOrderSlipAsPrinted(OrderSlipPrinter OrderSlipPrinter) { Data.SalesTransactionItems clsSalesTransactionItems = new Data.SalesTransactionItems(mConnection, mTransaction); mConnection = clsSalesTransactionItems.Connection; mTransaction = clsSalesTransactionItems.Transaction; foreach (System.Data.DataRow dr in ItemDataTable.Rows) { bool orderSlipPrinter1 = bool.Parse(dr["OrderSlipPrinter1"].ToString()); bool orderSlipPrinter2 = bool.Parse(dr["OrderSlipPrinter2"].ToString()); bool orderSlipPrinter3 = bool.Parse(dr["OrderSlipPrinter3"].ToString()); bool orderSlipPrinter4 = bool.Parse(dr["OrderSlipPrinter4"].ToString()); bool orderSlipPrinter5 = bool.Parse(dr["OrderSlipPrinter5"].ToString()); if (orderSlipPrinter1 || orderSlipPrinter2 || orderSlipPrinter3 || orderSlipPrinter4 || orderSlipPrinter5) { /**************************************** * 05Dec2014 put this here, should only set to true if success printing ****************************************/ Int64 iTransactionItemsID = Convert.ToInt64(dr["TransactionItemsID"]); clsSalesTransactionItems.UpdateOrderSlipPrinted(true, iTransactionItemsID); } } clsSalesTransactionItems.CommitAndDispose(); }
public void ShowOrderSlipPrinterError(OrderSlipPrinter OrderSlipPrinter, bool isFromSuspendTransaction, bool PrinterOffline = false) { if (PrinterOffline) { if (isFromSuspendTransaction) MessageBox.Show("Printer is Offline: Error sending items to kitchen while suspending the transaction!!! Please double check the OrderSlipPrinter #" + (Int32.Parse(OrderSlipPrinter.ToString("d")) + 1).ToString() + " then RESEND this order for printing.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); else MessageBox.Show("Printer is Offline: Error sending items to kitchen!!! Please double check the OrderSlipPrinter #" + (Int32.Parse(OrderSlipPrinter.ToString("d")) + 1).ToString() + " then RESEND this order for printing.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } else { if (isFromSuspendTransaction) MessageBox.Show("Error sending items to kitchen while suspending the transaction!!! Please double check the OrderSlipPrinter #" + (Int32.Parse(OrderSlipPrinter.ToString("d")) + 1).ToString() + " then RESEND this order for printing.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); else MessageBox.Show("Error sending items to kitchen!!! Please double check the OrderSlipPrinter #" + (Int32.Parse(OrderSlipPrinter.ToString("d")) + 1).ToString() + " then RESEND this order for printing.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }
public bool SendOrderSlipToPrinter(string szString, OrderSlipPrinter orderSlipPrinter) { try { clsEvent.AddEventReceipt(szString); switch (orderSlipPrinter) { case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter1: msbToPrintFP1.Append(szString); break; case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter2: msbToPrintFP2.Append(szString); break; case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter3: msbToPrintFP3.Append(szString); break; case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter4: msbToPrintFP4.Append(szString); break; case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter5: msbToPrintFP5.Append(szString); break; } return true; } catch { return false; } }
public void UpdateOrderSlipPrinter(Int64 ProductID, OrderSlipPrinter OrderSlipPrinter, bool isChecked) { // Added August 2, 2009 to monitor if product still has/have variations try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = ""; switch (OrderSlipPrinter) { case OrderSlipPrinter.RetailPlusOSPrinter1: SQL = "UPDATE tblProducts SET OrderSlipPrinter1 = @isChecked WHERE ProductID=@ProductID;"; break; case OrderSlipPrinter.RetailPlusOSPrinter2: SQL = "UPDATE tblProducts SET OrderSlipPrinter2 = @isChecked WHERE ProductID=@ProductID;"; break; case OrderSlipPrinter.RetailPlusOSPrinter3: SQL = "UPDATE tblProducts SET OrderSlipPrinter3 = @isChecked WHERE ProductID=@ProductID;"; break; case OrderSlipPrinter.RetailPlusOSPrinter4: SQL = "UPDATE tblProducts SET OrderSlipPrinter4 = @isChecked WHERE ProductID=@ProductID;"; break; case OrderSlipPrinter.RetailPlusOSPrinter5: SQL = "UPDATE tblProducts SET OrderSlipPrinter5 = @isChecked WHERE ProductID=@ProductID;"; break; } cmd.Parameters.AddWithValue("@isChecked", isChecked); cmd.Parameters.AddWithValue("@ProductID", ProductID); cmd.CommandText = SQL; base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }