コード例 #1
0
ファイル: BuildQueue.cs プロジェクト: brandann/NorthshorePO
        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);
        }