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(); } }