private void insertSolHistoryLine(SalesLine slThisLine, Pervasive.Data.SqlClient.PsqlConnection oConn, string sHeaderDocumentNumber)
{
string sDelivery = "", sReturn = "", sType = "", sSql = "";
if (slThisLine.dtReturnDate.Visible && slThisLine.txtCode.Text != "" && slThisLine.txtQuantity.Text != "0")//line defined by Code and must be a lease item
{
sType = "1"; //Lease Item
}
string sStatus = slThisLine.txtStatus.Text;
if (sStatus == "")
{
sStatus = "0";
}
if (slThisLine.dtReturnDate.Visible == false)//not a lease item
{
sDelivery = "null";
sReturn = "null";
}
else
{
DateTime dtNow = DateTime.Now;
if (dtNow.Day != slThisLine.dtDelivery.Value.Day)
{
sDelivery = "'" + slThisLine.dtDelivery.Value.ToString("dd-MM-yyyy 08:00") + "'";
}
else
{
sDelivery = "'" + slThisLine.dtDelivery.Value.ToString("dd-MM-yyyy HH:mm") + "'";
}
DateTime dtNow2 = DateTime.Now;
if (dtNow.Day != slThisLine.dtReturnDate.Value.Day)
{
sReturn = "'" + slThisLine.dtDelivery.Value.ToString("dd-MM-yyyy HH:mm") + "'";
}
else
{
sReturn = "'" + slThisLine.dtDelivery.Value.ToString("dd-MM-yyyy 08:00") + "'";
}
}
if (slThisLine.txtCode.Text != "" && slThisLine.txtCode.Text != "'")
{
sSql = "INSERT into SOLHL";
sSql += " (Header, ItemCode, DeliveryDate, ReturnDate, Status,LinkNum, Multiplier, Qty, OrigDeliveryDate,sCalculationRule, Description) ";
sSql += " VALUES ";
sSql += "(";
sSql += "'" + sHeaderDocumentNumber.Trim() + "'";
sSql += ",'" + slThisLine.txtCode.Text + "'";
sSql += "," + sDelivery;
sSql += "," + sReturn;
sSql += "," + sStatus;
sSql += "," + (slThisLine.iLineIndex + 1).ToString();
sSql += "," + slThisLine.txtMultiplier.Text.Replace(",", "").Trim();
sSql += "," + slThisLine.txtQuantity.Text.Replace(",", "").Trim();
sSql += "," + sDelivery;
sSql += ",'" + slThisLine.txtUnitFormula.Text + "'";
sSql += ",'" + slThisLine.txtDescription.Text + "'";
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, DeliveryDate, ReturnDate, Status,LinkNum, Multiplier, Qty, OrigDeliveryDate,sCalculationRule, Description) ";
sSql += " VALUES ";
sSql += "(";
sSql += "'" + sHeaderDocumentNumber.Trim() + "'";
sSql += ",'C'";
sSql += "," + sDelivery;
sSql += "," + sReturn;
sSql += "," + sStatus;
sSql += "," + (slThisLine.iLineIndex + 1).ToString();
sSql += "," + slThisLine.txtMultiplier.Text.Replace(",", "").Trim();
sSql += "," + slThisLine.txtQuantity.Text.Replace(",", "").Trim();
sSql += "," + sDelivery;
sSql += ",'" + slThisLine.txtUnitFormula.Text + "'";
sSql += ",'" + slThisLine.txtDescription.Text + "'";
sSql += ")";
int Ret = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql, oConn).ExecuteNonQuery();
slThisLine.sPastelLineLink = (slThisLine.iLineIndex + 1).ToString();
}
//if (slThisLine.txtCode.Text == "'")
//{
// slThisLine.sPastelLineLink = (slThisLine.iLineIndex + 1).ToString();
//}
}
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();
}
}
