private bool Populate_Inventory_Fields(ref PickingSlipLine qlQouteLine, bool bFocusDescription, string sDelNotes) { string sInventoryGroup = ""; bool bExist = false; if (sDelNotes == "") { if (qlQouteLine.txtCode.Text == "'") { //qlQouteLine.txtMultiplier.ReadOnly = true; qlQouteLine.txtDescription.ReadOnly = false; qlQouteLine.txtDiscount.ReadOnly = true; qlQouteLine.txtExcPrice.ReadOnly = true; qlQouteLine.txtLastInvoiceDate.Text = ""; qlQouteLine.txtNet.ReadOnly = true; //qlQouteLine.txtQuantity.ReadOnly = true; //qlQouteLine.txtQuantity.Text = "0.00"; qlQouteLine.txtUnit.ReadOnly = true; qlQouteLine.txtDescription.Focus(); qlQouteLine.bDoCalculation = false; bAllowDuplicateLines = false; return true; } else { //qlQouteLine.txtMultiplier.ReadOnly = false; qlQouteLine.txtDiscount.ReadOnly = false; qlQouteLine.txtExcPrice.ReadOnly = false; //qlQouteLine.txtQuantity.ReadOnly = false; qlQouteLine.txtDescription.ReadOnly = false; qlQouteLine.bDoCalculation = true; using (PsqlConnection oConn = new PsqlConnection(Solsage_Process_Management_System.Classes.Connect.sPastelConnStr)) { oConn.Open(); string sSql = "SELECT distinct Inventory.*, MultiStoreTrn.SellExcl01 from Inventory left join MultiStoreTrn on Inventory.ItemCode = MultiStoreTrn.ItemCode"; sSql += " where Inventory.ItemCode = '" + qlQouteLine.txtCode.Text.Trim() + "'"; sSql += " AND MultiStoreTrn.StoreCode <> ''"; PsqlDataReader rdReader = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql, oConn).ExecuteReader(); while (rdReader.Read()) { if (!bNextLine) { bNextLine = true; PickingSlipLine qlNewline = new PickingSlipLine(); ((Forms.Project.PickingSlip)(Parent.Parent.Parent.Parent)).AddSalesLine(qlNewline,false); } qlQouteLine.txtDescription.Text = rdReader["Description"].ToString().Trim(); try { qlQouteLine.txtExcPrice.Text = Convert.ToDecimal(rdReader["SellExcl01"].ToString()).ToString("N2"); dOriginalUnitPrice = Convert.ToDecimal(rdReader["SellExcl01"].ToString()); } catch { MessageBox.Show("Error calculating Excluding Price of item."); qlQouteLine.txtExcPrice.Text = "0.00"; } qlQouteLine.txtTaxType.Text = rdReader["SalesTaxType"].ToString().Trim(); qlQouteLine.txtDiscountType.Text = rdReader["DiscountType"].ToString().Trim(); qlQouteLine.sLineType = Functions.getLineInventoryType(qlQouteLine.txtCode.Text.Trim()); if (qlQouteLine.txtTaxType.Text == "0" || qlQouteLine.txtTaxType.Text == "2") { qlQouteLine.txtNet.BackColor = Color.Yellow; } else { qlQouteLine.txtNet.BackColor = Color.White; } if (rdReader["DiscountType"].ToString() == "0" || rdReader["DiscountType"].ToString() == "1")//AJD 20-08-2009 { qlQouteLine.txtDiscount.ReadOnly = true; } qlQouteLine.txtUnit.Text = rdReader["UnitSize"].ToString(); qlQouteLine.txtDescription.Focus(); bExist = true; }//end while rdReader.Close(); oConn.Dispose(); //get on hand qty of itemcode using (PsqlConnection oConn2 = new PsqlConnection(Solsage_Process_Management_System.Classes.Connect.sConnStr)) { //get del note qty decimal dDelNoteQty = 0; oConn2.Open(); string sSql2 = "select Itemcode,SUM(Qty) as Qty from SOLPDL where DocNumber in " + sDelNotes; sSql2 += " AND ItemCode = '" + qlQouteLine.txtCode.Text + "' group by ItemCode"; PsqlDataReader rdReader2 = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql2, oConn2).ExecuteReader(); while (rdReader2.Read()) { dDelNoteQty = Convert.ToDecimal(rdReader2["Qty"].ToString()); } rdReader2.Close(); //get ret note qty decimal dRetNoteQty = 0; string sSql3 = "select SOLPRL.ItemCode, SUM(SOLPRL.Qty) as Qty from SOLPRH "; sSql3 += "inner join SOLPRL on SOLPRL.DocNumber = SOLPRH.DocNumber "; sSql3 += "where LinkedDeliveryNote in " + sDelNotes + " And ItemCode = '" + qlQouteLine.txtCode.Text.Trim() + "' group by ItemCode"; PsqlDataReader rdReader3 = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql3, oConn2).ExecuteReader(); while (rdReader3.Read()) { dRetNoteQty = Convert.ToDecimal(rdReader3["Qty"].ToString()); } rdReader3.Close(); oConn2.Dispose(); decimal dOnHandQty = dDelNoteQty - dRetNoteQty; if (dOnHandQty < 0) qlQouteLine.txtQtyOnHand.Text = "0"; else qlQouteLine.txtQtyOnHand.Text = dOnHandQty.ToString("N2"); } if (!bExist) { MessageBox.Show("Code does not exist.", "Inventory Not Found", MessageBoxButtons.OK, MessageBoxIcon.Warning); qlQouteLine.txtDescription.ReadOnly = true; return false; } else { } return true; } } } else { if (qlQouteLine.txtCode.Text == "'") { qlQouteLine.txtDescription.ReadOnly = false; qlQouteLine.txtLastInvoiceDate.Text = ""; //qlQouteLine.txtQuantity.ReadOnly = true; //qlQouteLine.txtQuantity.Text = "0.00"; qlQouteLine.txtUnit.ReadOnly = true; qlQouteLine.txtDescription.Focus(); qlQouteLine.bDoCalculation = false; bAllowDuplicateLines = false; return true; } else if (!bNextLine) { if (bFocusDescription) { bNextLine = true; using (PsqlConnection oConn = new PsqlConnection(Solsage_Process_Management_System.Classes.Connect.sPastelConnStr)) { oConn.Open(); string sSql = "SELECT MultiStoreTrn.SellExcl01 from Inventory left join MultiStoreTrn on Inventory.ItemCode = MultiStoreTrn.ItemCode"; sSql += " where Inventory.ItemCode = '" + qlQouteLine.txtCode.Text.Trim() + "'"; sSql += " AND MultiStoreTrn.StoreCode <> ''"; PsqlDataReader rdReader = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql, oConn).ExecuteReader(); while (rdReader.Read()) { qlQouteLine.txtExcPrice.Text = Convert.ToDecimal(rdReader["SellExcl01"].ToString()).ToString("N2"); } rdReader.Close(); oConn.Dispose(); } PickingSlipLine qlNewline = new PickingSlipLine(); ((Forms.Project.PickingSlip)(Parent.Parent.Parent.Parent)).AddSalesLine(qlNewline,false); } else { using (PsqlConnection oConn = new PsqlConnection(Solsage_Process_Management_System.Classes.Connect.sPastelConnStr)) { oConn.Open(); string sSql = "SELECT MultiStoreTrn.SellExcl01 from Inventory left join MultiStoreTrn on Inventory.ItemCode = MultiStoreTrn.ItemCode"; sSql += " where Inventory.ItemCode = '" + qlQouteLine.txtCode.Text.Trim() + "'"; sSql += " AND MultiStoreTrn.StoreCode <> ''"; PsqlDataReader rdReader = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql, oConn).ExecuteReader(); while (rdReader.Read()) { qlQouteLine.txtExcPrice.Text = Convert.ToDecimal(rdReader["SellExcl01"].ToString()).ToString("N2"); } rdReader.Close(); oConn.Dispose(); } } } return true; } }
public void AddQouteLine(PickingSlipLine qlNewLine) { Array.Resize<Control>(ref aSaleslines, aSaleslines.Length + 1); aSaleslines[aSaleslines.Length - 1] = qlNewLine; if (iLineRowIndex < 14) qlNewLine.Top = 17 + ((iLineRowIndex) * 20); else qlNewLine.Top = 268; //16 + ((iLineRowIndex) * 18); qlNewLine.Left = 4; qlNewLine.TabIndex = 50 + aSaleslines.Length; qlNewLine.TabStop = true; qlNewLine.iLineIndex = aSaleslines.Length - 1; qlNewLine.Name = "qlNewLine_" + (aSaleslines.Length - 1).ToString(); this.pnlDetails.Controls.Add(qlNewLine); qlNewLine.BringToFront(); iLineRowIndex++; }
private void cmdCodeSearch_Click(object sender, EventArgs e) { bool bDelNotes = false; Cursor = System.Windows.Forms.Cursors.WaitCursor; string sDelNotes = "("; //create del note string list foreach (DataGridViewRow dgRow in ((Forms.Project.PickingSlip)(Parent.Parent.Parent.Parent)).dgDeliveryNotes.Rows) { sDelNotes += ",'" + dgRow.Cells[0].Value.ToString() + "'"; bDelNotes = true; } try { sDelNotes = sDelNotes.Remove(1, 1); sDelNotes = sDelNotes + ")"; } catch { } if (!bDelNotes) { using (Finder.Inventory frmInventory = new Solsage_Process_Management_System.Finder.Inventory()) { //Sending "None" to inventory ShowDialog to identify that no workshop action should be taken if (frmInventory.ShowDialog("", "", sDelNotes) == DialogResult.OK) { if (frmInventory.sResult != "") { //check if this item has been selected... if (((Forms.Project.PickingSlip)(Parent.Parent.Parent.Parent)).CheckDuplicateSalesLine(frmInventory.sResult)) { MessageBox.Show("No duplicate items are allowed in a sales order. Please select another inventory item.", "Duplicates", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { txtCode.Text = frmInventory.sResult.Trim(); PickingSlipLine pdlDeliveryNote = this; bool bValid = Populate_Inventory_Fields(ref pdlDeliveryNote, true, sDelNotes); txtCode.Focus(); txtCode.SelectionStart = 0; txtCode.SelectionLength = txtCode.Text.Length; } } } } } else { using (Finder.PickingSlipItemZoom frmPickSlipItemZoom = new Finder.PickingSlipItemZoom()) { if (frmPickSlipItemZoom.ShowDialog(sDelNotes) == DialogResult.OK) { if (frmPickSlipItemZoom.ItemList.Count != 0) { ItemList = frmPickSlipItemZoom.ItemList; if (ItemList.Count == 1) { foreach (string sItem in ItemList) { string[] aItemDetails = sItem.Split("|".ToCharArray()); txtCode.Text = aItemDetails[0].ToString(); txtDescription.Text = aItemDetails[1].ToString(); txtUnit.Text = aItemDetails[3].ToString(); //get on hand qty of itemcode using (PsqlConnection oConn2 = new PsqlConnection(Solsage_Process_Management_System.Classes.Connect.sConnStr)) { //get del note qty decimal dDelNoteQty = 0; oConn2.Open(); //sDelNotes = sDelNotes.Remove(0, 2); //sDelNotes = sDelNotes.Remove(1, 1) + ")"; string sSql2 = "select Itemcode,SUM(Qty) as Qty from SOLPDL where DocNumber in " + sDelNotes; sSql2 += " AND ItemCode = '" + txtCode.Text + "' group by ItemCode"; PsqlDataReader rdReader2 = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql2, oConn2).ExecuteReader(); while (rdReader2.Read()) { dDelNoteQty = Convert.ToDecimal(rdReader2["Qty"].ToString()); } rdReader2.Close(); //get ret note qty decimal dRetNoteQty = 0; string sSql3 = "select SOLPRL.ItemCode, SUM(SOLPRL.Qty) as Qty from SOLPRH "; sSql3 += "inner join SOLPRL on SOLPRL.DocNumber = SOLPRH.DocNumber "; sSql3 += "where LinkedDeliveryNote in " + sDelNotes + " And ItemCode = '" + txtCode.Text.Trim() + "' group by ItemCode"; PsqlDataReader rdReader3 = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql3, oConn2).ExecuteReader(); while (rdReader3.Read()) { dRetNoteQty = Convert.ToDecimal(rdReader3["Qty"].ToString()); } rdReader3.Close(); decimal dOnHandQty = dDelNoteQty - dRetNoteQty; if (dOnHandQty < 0) txtQtyOnHand.Text = "0"; else txtQtyOnHand.Text = dOnHandQty.ToString("N2"); oConn2.Dispose(); } } PickingSlipLine pdlDeliveryNote = this; PickingSlipLine pdlLastControl = this; bool bValid = Populate_Inventory_Fields(ref pdlDeliveryNote, true,sDelNotes); } else { foreach (string sItem in ItemList) { string[] aItemDetails = sItem.Split("|".ToCharArray()); //txtCode.Text = aItemDetails[0].ToString(); //txtDescription.Text = aItemDetails[1].ToString(); //txtQuoteQty.Text = aItemDetails[2].ToString(); //txtUnit.Text = aItemDetails[3].ToString(); //ProjectDeliveryNote pdlDeliveryNote = this; PickingSlipLine pdlDelNote = new PickingSlipLine(); pdlDelNote.txtCode.Text = aItemDetails[0].ToString(); pdlDelNote.txtDescription.Text = aItemDetails[1].ToString(); pdlDelNote.txtUnit.Text = aItemDetails[3].ToString(); using (PsqlConnection oConn = new PsqlConnection(Solsage_Process_Management_System.Classes.Connect.sPastelConnStr)) { oConn.Open(); string sSql = "SELECT MultiStoreTrn.SellExcl01 from Inventory left join MultiStoreTrn on Inventory.ItemCode = MultiStoreTrn.ItemCode"; sSql += " where Inventory.ItemCode = '" + pdlDelNote.txtCode.Text.Trim() + "'"; sSql += " AND MultiStoreTrn.StoreCode <> ''"; PsqlDataReader rdReader = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql, oConn).ExecuteReader(); while (rdReader.Read()) { pdlDelNote.txtExcPrice.Text = Convert.ToDecimal(rdReader["SellExcl01"].ToString()).ToString("N2"); } rdReader.Close(); oConn.Dispose(); } //bool bValid = Populate_Inventory_Fields(ref pdlDelNote, false, sDelNotes); //get on hand qty of itemcode using (PsqlConnection oConn2 = new PsqlConnection(Solsage_Process_Management_System.Classes.Connect.sConnStr)) { //get del note qty decimal dDelNoteQty = 0; oConn2.Open(); this.removeLine(null, null); string sSql2 = "select Itemcode,SUM(Qty) as Qty from SOLPDL where DocNumber in " + sDelNotes; sSql2 += " AND ItemCode = '" + pdlDelNote.txtCode.Text + "' group by ItemCode"; PsqlDataReader rdReader2 = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql2, oConn2).ExecuteReader(); while (rdReader2.Read()) { dDelNoteQty = Convert.ToDecimal(rdReader2["Qty"].ToString()); } rdReader2.Close(); //get ret note qty decimal dRetNoteQty = 0; string sSql3 = "select SOLPRL.ItemCode, SUM(SOLPRL.Qty) as Qty from SOLPRH "; sSql3 += "inner join SOLPRL on SOLPRL.DocNumber = SOLPRH.DocNumber "; sSql3 += "where LinkedDeliveryNote in " + sDelNotes + " And ItemCode = '" + pdlDelNote.txtCode.Text.Trim() + "' group by ItemCode"; PsqlDataReader rdReader3 = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql3, oConn2).ExecuteReader(); while (rdReader3.Read()) { dRetNoteQty = Convert.ToDecimal(rdReader3["Qty"].ToString()); } rdReader3.Close(); decimal dOnHandQty = dDelNoteQty - dRetNoteQty; if (dOnHandQty < 0) pdlDelNote.txtQtyOnHand.Text = "0"; else pdlDelNote.txtQtyOnHand.Text = dOnHandQty.ToString("N2"); oConn2.Dispose(); } //ProjectDeliveryNote pdlLastControl = this; //bool bValid = Populate_Inventory_Fields(ref pdlDeliveryNote, false, iLineIndex); ((Forms.Project.PickingSlip)(Parent.Parent.Parent.Parent)).AddSalesLine(pdlDelNote,true); } PickingSlipLine pdlDelNoteNew = new PickingSlipLine(); ((Forms.Project.PickingSlip)(Parent.Parent.Parent.Parent)).AddSalesLine(pdlDelNoteNew,true); ((Forms.Project.PickingSlip)(Parent.Parent.Parent.Parent)).deleteSalesLine(this, true); } } } } } //((Forms.Project.PickingSlip)(Parent.Parent.Parent.Parent)).addTotals(); Cursor = System.Windows.Forms.Cursors.Default; }
public void InsertSalesLine(int iLineIndex, PickingSlipLine slNewLine) { for (int iLines = 0; iLines < aSaleslines.Length; iLines++) { PickingSlipLine slThisline = (((PickingSlipLine)aSaleslines[iLines])); if (slThisline.iLineIndex == iLineIndex)//start line { //Array.Resize<Control>(ref aSaleslines, aSaleslines.Length + 1);//Add new row iLineRowIndex++; for (int iShiftLines = aSaleslines.Length-1; iShiftLines > iLines+1; iShiftLines--) { aSaleslines[iShiftLines] = aSaleslines[iShiftLines - 1]; (((PickingSlipLine)aSaleslines[iShiftLines])).Location = new Point((((PickingSlipLine)aSaleslines[iShiftLines - 1])).Location.X, (((PickingSlipLine)aSaleslines[iShiftLines - 1])).Location.Y + 20); // move location of control to new position (((PickingSlipLine)aSaleslines[iShiftLines])).iLineIndex++;//sync the lineindex of the control array } aSaleslines[iLines + 1] = slNewLine; slNewLine.Top = 17 + ((iLineIndex+1) * 20); slNewLine.Left = 4; if (slNewLine.txtStore.Text == "") { slNewLine.txtStore.Text = Global.sDefaultStore; } slNewLine.TabIndex = 50 + aSaleslines.Length; slNewLine.TabStop = true; slNewLine.iLineIndex = iLines + 1; slNewLine.Name = "slNewLine_" + (aSaleslines.Length - 1).ToString(); this.pnlDetails.Controls.Add(slNewLine); slNewLine.BringToFront(); return; } } }
public void loadLines(string sSalesCode, string sStore, string sCode, string sDescription, string sUnit, string sQty, string sExcPrice, string sDiscount, string sTaxType, string sLinkNum, string sDiscountType, string sLineType) { bool bLeaseItem = false; bool bInsert = false; int iInsertPos = 0; //LL Discount displyed incorrectly 18/09/2009 double dDiscount = Convert.ToDouble(sDiscount.Trim()) / 100; PickingSlipLine slNewLine = new PickingSlipLine(); slNewLine.bDoCalculation = false; //Do totals only after the control has been loaded. slNewLine.txtStore.Text = sStore.Trim(); slNewLine.txtCode.Text = sCode.Trim(); slNewLine.txtDescription.Text = sDescription.Trim(); slNewLine.txtUnit.Text = sUnit.Trim(); slNewLine.txtQuantity.Text = (Convert.ToDouble(sQty.Trim())).ToString("N2"); slNewLine.txtExcPrice.Text = (Convert.ToDouble(sExcPrice.Trim())).ToString("N2"); slNewLine.txtDiscount.Text = dDiscount.ToString("N2"); slNewLine.txtDiscountType.Text = sDiscountType; slNewLine.bNextLine = true; //Don't allow new rows if code field loose focus() double dTotalExDiscount = Convert.ToDouble(slNewLine.txtQuantity.Text.Replace(",", "")) * Convert.ToDouble(slNewLine.txtExcPrice.Text.Replace(",", "")); slNewLine.txtNet.Text = (dTotalExDiscount - (dTotalExDiscount * (Convert.ToDouble(slNewLine.txtDiscount.Text.Replace(",", "")) / 100))).ToString("N2"); slNewLine.sPastelLineLink = sLinkNum; slNewLine.txtTaxType.Text = sTaxType; if (sTaxType == "0" || sTaxType == "2") { slNewLine.txtNet.BackColor = Color.Yellow; } if (slNewLine.txtCode.Text == "'") { slNewLine.txtQuantity.Visible = false; slNewLine.txtDiscount.Visible = false; slNewLine.txtExcPrice.Visible = false; slNewLine.txtNet.Visible = false; } //get on hand qty of itemcode string sDelNotes = "("; foreach (DataGridViewRow dgRow in dgDeliveryNotes.Rows) { sDelNotes += ",'" + dgRow.Cells[0].Value.ToString() + "'"; } using (PsqlConnection oConn2 = new PsqlConnection(Solsage_Process_Management_System.Classes.Connect.sConnStr)) { if (slNewLine.txtCode.Text != "'") { //get del note qty decimal dDelNoteQty = 0; oConn2.Open(); try { sDelNotes = sDelNotes.Remove(1, 1) + ")"; } catch { sDelNotes = "('')"; } string sSql2 = "select Itemcode,SUM(Qty) as Qty from SOLPDL where DocNumber in " + sDelNotes; sSql2 += " AND ItemCode = '" + slNewLine.txtCode.Text + "' group by ItemCode"; PsqlDataReader rdReader2 = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql2, oConn2).ExecuteReader(); while (rdReader2.Read()) { dDelNoteQty = Convert.ToDecimal(rdReader2["Qty"].ToString()); } rdReader2.Close(); //get ret note qty decimal dRetNoteQty = 0; string sSql3 = "select SOLPRL.ItemCode, SUM(SOLPRL.Qty) as Qty from SOLPRH "; sSql3 += "inner join SOLPRL on SOLPRL.DocNumber = SOLPRH.DocNumber "; sSql3 += "where LinkedDeliveryNote in " + sDelNotes + " And ItemCode = '" + slNewLine.txtCode.Text.Trim() + "' group by ItemCode"; PsqlDataReader rdReader3 = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql3, oConn2).ExecuteReader(); while (rdReader3.Read()) { dRetNoteQty = Convert.ToDecimal(rdReader3["Qty"].ToString()); } rdReader3.Close(); oConn2.Dispose(); decimal dOnHandQty = dDelNoteQty - dRetNoteQty; if (dOnHandQty < 0) slNewLine.txtQtyOnHand.Text = "0"; else slNewLine.txtQtyOnHand.Text = dOnHandQty.ToString("N2"); } } AddSalesLine(slNewLine); }
public void deleteSalesLine(PickingSlipLine slDeletedLine, bool bDeleteLastLine) { bool bDeleteControl = false; for (int iLines = 0; iLines < aSaleslines.Length; iLines++) { PickingSlipLine slThisline = (((PickingSlipLine)aSaleslines[iLines])); if (iLines != aSaleslines.Length - 1 || bDeleteLastLine) //Never delete the last row { if (slDeletedLine.Name == slThisline.Name) { bDeleteControl = true; this.pnlDetails.Controls.Remove(slDeletedLine); if (iLines != aSaleslines.Length - 1) { (((PickingSlipLine)aSaleslines[iLines + 1])).txtCode.Focus(); // focus on the next line } } if (bDeleteControl && iLines != aSaleslines.Length - 1) //resize the line array { aSaleslines[iLines] = aSaleslines[iLines + 1]; //Move all the controls one up in the list (((PickingSlipLine)aSaleslines[iLines + 1])).Location = new Point((((PickingSlipLine)aSaleslines[iLines + 1])).Location.X, (((PickingSlipLine)aSaleslines[iLines + 1])).Location.Y - 20); // move location of control to new position (((PickingSlipLine)aSaleslines[iLines + 1])).iLineIndex--;//sync the lineindex of the control array } } } if (bDeleteControl)//update the line array { //Array.Resize<Control>(ref aSaleslines, aSaleslines.Length - 1); iLineRowIndex--; } addTotals(); //Check if you want to close the order if (aSaleslines.Length == 0) { if (MessageBox.Show("There are no more lines in this order. Do you want to close this order?", "Close Order?", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question) == DialogResult.Yes) { Functions.CloseOrder(txtNumber.Text.Trim()); } } }
public void focusNextLine(int iLineIndex) { //LL 17/09/2009 - start if ((iLineIndex >= aSaleslines.Length && txtNumber.Text == "*NEW*") || (iLineIndex >= aSaleslines.Length && txtNumber.Text == "")) { if (txtNumber.Text == "") txtNumber.Text = "*NEW*"; //LL 17/09/2009 - end PickingSlipLine slNewline = new PickingSlipLine(); AddSalesLine(slNewline); } if (iLineIndex < aSaleslines.Length) { PickingSlipLine slNewLine = (PickingSlipLine)aSaleslines[iLineIndex]; slNewLine.txtCode.Focus(); } }
private void insertSolHistoryLine(PickingSlipLine slThisLine, Pervasive.Data.SqlClient.PsqlConnection oConn, string sHeaderDocumentNumber) { string sSql = ""; string sStatus = slThisLine.txtStatus.Text; if (sStatus == "") { sStatus = "0"; } if (slThisLine.txtCode.Text != "" && slThisLine.txtCode.Text != "'") { sSql = "INSERT into SOLHL"; sSql += " (Header, ItemCode, Status,LinkNum, Qty, Description) "; sSql += " VALUES "; sSql += "("; sSql += "'" + sHeaderDocumentNumber.Trim() + "'"; sSql += ",'" + slThisLine.txtCode.Text + "'"; sSql += "," + sStatus; sSql += "," + (slThisLine.iLineIndex + 1).ToString(); sSql += "," + slThisLine.txtQuantity.Text.Replace(",", "").Trim(); sSql += ",'" + slThisLine.txtDescription.Text.Replace("'","''") + "'"; sSql += ")"; int Ret = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql, oConn).ExecuteNonQuery(); slThisLine.sPastelLineLink = (slThisLine.iLineIndex + 1).ToString(); } else if (slThisLine.txtCode.Text != "") { sSql = "INSERT into SOLHL"; sSql += " (Header, ItemCode,Status,LinkNum,Qty, Description) "; sSql += " VALUES "; sSql += "("; sSql += "'" + sHeaderDocumentNumber.Trim() + "'"; sSql += ",'C'"; sSql += "," + sStatus; sSql += "," + (slThisLine.iLineIndex + 1).ToString(); sSql += "," + slThisLine.txtQuantity.Text.Replace(",", "").Trim(); sSql += ",'" + slThisLine.txtDescription.Text.Replace("'", "''") + "'"; sSql += ")"; int Ret = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql, oConn).ExecuteNonQuery(); slThisLine.sPastelLineLink = (slThisLine.iLineIndex + 1).ToString(); } }
private string getPastelLine(PickingSlipLine slThisLine) { string sLine = ""; string sLineType = "4"; if (slThisLine.txtCode.Text == "'") { sLine += "|"; //Cost Price sLine += "|"; //Line Quantity sLine += "|"; //Exclusive Price Per Unit sLine += "|"; //Inclusive Price Per Unit sLine += "|"; //Unit sLine += "|"; //Tax Type sLine += "|"; //Discount Type sLine += "|"; //Discount % sLine += "|"; //Code sLine += slThisLine.txtDescription.Text.Trim() + "|"; //Description sLine += "7|"; //Line Type sLine += "|"; //Multistore sLine += "|"; //CostCode } else if (slThisLine.txtCode.Text != "" )//line defined by Code { string sQuantity = slThisLine.txtQuantity.Text.Replace(",", "").Trim(); sLine += "|"; //Cost Price sLine += sQuantity + "|"; //Line Quantity sLine += slThisLine.txtExcPrice.Text.Replace(",", "").Trim() + "|"; //Exclusive Price Per Unit //LL 16/09/2009 -- start if (slThisLine.txtTaxType.Text == "0") sLine += (Convert.ToDouble(slThisLine.txtExcPrice.Text)).ToString().Replace(",", "") + "|"; //Inclusive Price Per Unit else if (slThisLine.txtTaxType.Text == "1") sLine += (Convert.ToDouble(slThisLine.txtExcPrice.Text) * 1.14).ToString().Replace(",", "") + "|"; //Inclusive Price Per Unit else if (slThisLine.txtTaxType.Text == "2") sLine += (Convert.ToDouble(slThisLine.txtExcPrice.Text)).ToString().Replace(",", "") + "|"; //Inclusive Price Per Unit //LL 16/09/2009 -- end sLine += slThisLine.txtUnit.Text.Trim() + "|"; //Unit sLine += slThisLine.txtTaxType.Text.PadLeft(2,"0".ToCharArray()[0]) + "|"; //Tax Type sLine += "0|"; //Discount Type sLine += slThisLine.txtDiscount.Text.Replace(".", "").Replace(",", "") + "|"; //Discount % sLine += slThisLine.txtCode.Text.Trim() + "|"; //Code sLine += slThisLine.txtDescription.Text.Trim() + "|"; //Description sLine += sLineType + "|"; //Line Type sLine += slThisLine.txtStore.Text.Trim() + "|"; //Multistore sLine += "|"; //CostCode } return (sLine); }
private string CreateDocLineFromSalesline(PickingSlipLine slThisLine, int iLines) { string sLine = ""; if (slThisLine.sLineType != "Comment" && slThisLine.txtCode.Text.Trim() != "'") { string sQuantity = Convert.ToDecimal(slThisLine.txtQuantity.Text.Replace(",", "").Trim()).ToString(); sLine += "|"; //Cost Price sLine += sQuantity + "|"; //Line Quantity sLine += slThisLine.txtExcPrice.Text.Replace(",", "").Trim() + "|"; //Exclusive Price Per Unit if (slThisLine.txtTaxType.Text == "0") sLine += (Convert.ToDouble(slThisLine.txtExcPrice.Text)).ToString().Replace(",", "") + "|"; //Inclusive Price Per Unit else if (slThisLine.txtTaxType.Text == "1") sLine += (Convert.ToDouble(slThisLine.txtExcPrice.Text) * 1.14).ToString().Replace(",", "") + "|"; //Inclusive Price Per Unit else sLine += (Convert.ToDouble(slThisLine.txtExcPrice.Text)).ToString().Replace(",", "") + "|"; //All other tax type will send a 0 tax value through sLine += slThisLine.txtUnit.Text.Trim() + "|"; //Unit sLine += slThisLine.txtTaxType.Text.PadLeft(2, "0".ToCharArray()[0]) + "|"; //Tax Type sLine += "0|"; //Discount Type sLine += slThisLine.txtDiscount.Text.Replace(".", "").Replace(",", "") + "|"; //Discount % sLine += slThisLine.txtCode.Text.Trim() + "|"; //Code sLine += slThisLine.txtDescription.Text.Trim() + "~" + iLines + "|"; //Description sLine += "4|"; //Line Type //sLine += slThisLine.txtStore.Text.Trim() + "|"; //Line Type sLine += "|"; //Multistore sLine += "|"; // CostCode //sLine += "^" + slThisLine.sPastelLineLink;//Add linknum at end of string in order to delete line from SOLHL //string sReturned = "0"; //sLine += "^" + sReturned;//Add linknum at end of string in order to delete line from SOLHL } else { string sDescription = slThisLine.txtDescription.Text; // if (slThisLine.txtDescription.Text.StartsWith("*D")) // { // // } sLine = "|"; //Cost Price sLine += "|"; //Line Quantity sLine += "|"; //Exclusive Price Per Unit sLine += "|"; //Inclusive Price Per Unit sLine += "|"; //Unit sLine += "|"; //Tax Type sLine += "|"; //Discount Type sLine += "|"; //Discount % sLine += "'|"; //Code sLine += sDescription + "|"; //Description sLine += "7|"; //Line Type sLine += "|"; //Line Type sLine += "|"; //CostCode //sLine += "^*C"; } return sLine; }
public void AddSalesLine(PickingSlipLine slNewLine) { Array.Resize<Control>(ref aSaleslines, aSaleslines.Length + 1); aSaleslines[aSaleslines.Length-1] = slNewLine; if (iLineRowIndex < 13) slNewLine.Top = 17 + ((iLineRowIndex) * 21); else slNewLine.Top = 270; //16 + ((iLineRowIndex) * 18); slNewLine.Left = 4; if (slNewLine.txtStore.Text == "") { slNewLine.txtStore.Text = Global.sDefaultStore; } slNewLine.TabIndex = 50 + aSaleslines.Length; slNewLine.TabStop = true; slNewLine.iLineIndex = aSaleslines.Length - 1; slNewLine.Name = "slNewLine_" + (aSaleslines.Length - 1).ToString(); this.pnlDetails.Controls.Add(slNewLine); slNewLine.BringToFront(); iLineRowIndex++; }
private void cmdNewLine_Click(object sender, EventArgs e) { PickingSlipLine slNewline = new PickingSlipLine(); AddSalesLine(slNewline); slNewline.bNextLine = true; slNewline.txtCode.Focus(); slNewline.bFocusOnNextLine = false; addUpdateInstruction(slNewline.Name, 1, slNewline,slNewline.txtQuantity.Text,"1.00"); }