public static string buildQueuePO(POInformation p)
{
string QA, QB;
QA = "INSERT INTO PurchaseOrder (";
QB = "VALUES('";
QA = QA + "PO_NUMBER,";
QB = QB + p.OrderNumber + "','";
QA = QA + "PURCHASER,";
QB = QB + p.Purchaser + "','";
QA = QA + "VENDOR,";
QB = QB + p.Vendor + "','";
QA = QA + "PROJECT_NUMBER,";
QB = QB + p.JobNumber + "','";
QA = QA + "PO_DATE,";
QB = QB + p.OrderDate + "','";
QA = QA + "TOTAL,";
QB = QB + p.Total + "','";
QA = QA + "FILE,";
QB = QB + " " + "','";
QA = QA + "NOTES";
QB = QB + p.Note;
QA = QA + ")";
QB = QB + "')";
QB.Replace("''", "' '");
return(QA + " " + QB);
}
