public void AddStockIssueLine(StockIssueLine siNewLine)
{
Array.Resize<Control>(ref aStockIssueLines, aStockIssueLines.Length + 1);
aStockIssueLines[aStockIssueLines.Length - 1] = siNewLine;
//JR13
if (iLineRowIndex < 14)
siNewLine.Top = 22 + ((iLineRowIndex) * 20);
else
siNewLine.Top = 268; //16 + ((iLineRowIndex) * 18);
siNewLine.Left = 1;
siNewLine.TabIndex = 50 + aStockIssueLines.Length;
siNewLine.TabStop = true;
siNewLine.iLineIndex = aStockIssueLines.Length - 1;
siNewLine.Name = "siNewLine_" + (aStockIssueLines.Length - 1).ToString();
this.pnlDetails.Controls.Add(siNewLine);
siNewLine.BringToFront();
iLineRowIndex++;
}
private void HandleDescription(ref StockIssueLine slStockIssueLine)
{
if (slStockIssueLine.txtBatchNum.Text == "'")
{
slStockIssueLine.txtCode.ReadOnly = true;
slStockIssueLine.txtDescription.ReadOnly = false;
slStockIssueLine.txtQuantity.ReadOnly = true;
slStockIssueLine.txtQuantity.Text = "0.00";
slStockIssueLine.txtUnit.ReadOnly = true;
slStockIssueLine.txtDescription.Focus();
bAllowDuplicateLines = false;
}
}
public void DBLoadStockIssueDetails(string sSINumber)
{
//Clear All Current Lines
for (int iLines = 0; iLines < aStockIssueLines.Length; iLines++)
{
StockIssueLine silThisline = (((StockIssueLine)aStockIssueLines[iLines]));
this.pnlDetails.Controls.Remove(silThisline);
}
//Reset Control
iLineRowIndex = 0;
aStockIssueLines = new Control[0];
string sLineBatchNum = "";
string sLineItemCode = "";
string sLineDesc = "";
string sLineUnit = "";
decimal dLineQty = 0;
if (txtNumber.Text != "*NEW*")
{
string sSql = "";
using (PsqlConnection liqConn = new PsqlConnection(Connect.sConnStr))
{
liqConn.Open();
sSql = "SELECT * FROM SOLSIL";
sSql += " WHERE DocNumber = '" + txtNumber.Text.Trim() + "'";
PsqlDataReader rdLineReader = Connect.getDataCommand(sSql, liqConn).ExecuteReader();
if (rdLineReader.HasRows)
{
while (rdLineReader.Read())
{
//Assign Values
sLineBatchNum = rdLineReader["BatchNumber"].ToString();
sLineItemCode = rdLineReader["ItemCode"].ToString();
sLineDesc = rdLineReader["Description"].ToString();
sLineUnit = rdLineReader["Unit"].ToString();
dLineQty = Convert.ToDecimal(rdLineReader["Qty"].ToString());
StockIssueLine silNewLine = new StockIssueLine();
silNewLine.txtBatchNum.Text = sLineBatchNum;
silNewLine.txtCode.Text = sLineItemCode;
silNewLine.txtDescription.Text = sLineDesc;
silNewLine.txtUnit.Text = sLineUnit;
silNewLine.txtQuantity.Text = dLineQty.ToString("N2");
silNewLine.txtQtyOnHand.Text = "N/A";
AddStockIssueLine(silNewLine);
}
rdLineReader.Close();
}
liqConn.Close();
}
}
}
public void focusNextLine(int iLineIndex)
{
//LL 17/09/2009 - start
if ((iLineIndex >= aStockIssueLines.Length && txtNumber.Text == "*NEW*") || (iLineIndex >= aStockIssueLines.Length && txtNumber.Text == ""))
{
if (txtNumber.Text == "")
txtNumber.Text = "*NEW*";
//LL 17/09/2009 - end
StockIssueLine siNewLine = new StockIssueLine();
AddStockIssueLine(siNewLine);
}
if (iLineIndex < aStockIssueLines.Length)
{
StockIssueLine siNewLine = (StockIssueLine)aStockIssueLines[iLineIndex];
siNewLine.txtBatchNum.Focus();
}
}
public void DeleteStockIssueLine(StockIssueLine slDeletedLine, bool bDeleteLastLine)
{
bool bDeleteControl = false;
for (int iLines = 0; iLines < aStockIssueLines.Length; iLines++)
{
StockIssueLine silThisline = (((StockIssueLine)aStockIssueLines[iLines]));
if (iLines != aStockIssueLines.Length - 1 || bDeleteLastLine) //Never delete the last row
{
if (slDeletedLine.Name == silThisline.Name)
{
bDeleteControl = true;
this.pnlDetails.Controls.Remove(slDeletedLine);
if (iLines != aStockIssueLines.Length - 1)
{
(((StockIssueLine)aStockIssueLines[iLines + 1])).txtCode.Focus(); // focus on the next line
}
}
if (bDeleteControl && iLines != aStockIssueLines.Length - 1) //resize the line array
{
aStockIssueLines[iLines] = aStockIssueLines[iLines + 1]; //Move all the controls one up in the list
(((StockIssueLine)aStockIssueLines[iLines + 1])).Location = new Point((((StockIssueLine)aStockIssueLines[iLines + 1])).Location.X, (((StockIssueLine)aStockIssueLines[iLines + 1])).Location.Y - 20); // move location of control to new position
(((StockIssueLine)aStockIssueLines[iLines + 1])).iLineIndex--;//sync the lineindex of the control array
}
}
}
if (bDeleteControl)//update the line array
{
Array.Resize<Control>(ref aStockIssueLines, aStockIssueLines.Length - 1);
iLineRowIndex--;
}
}
