コード例 #1
0
ファイル: mySQLClass.cs プロジェクト: haoas/ETechPOS
        public int create_invoice(cls_POSTransaction trans)
        {
            string datetime_d = trans.getdatetime().ToString("yyyy-MM-dd HH:mm:ss");
            string branchid   = cls_globalvariables.BranchCode;
            string terminalno = cls_globalvariables.terminalno_v;

            long userwid = trans.getclerk().getsyncid();

            long next_ornumber = get_nextornumber();

            long   next_SyncId = GetAndInsertNextSyncId("saleshead");
            string sSQL        = @"UPDATE `saleshead` SET
                                `branchid` = '" + branchid + @"', 
                                `date` = '" + datetime_d + @"', 
                                `userid` = '" + userwid + @"', 
                                `lastmodifiedby` = '" + userwid + @"', 
                                `lastmodifieddate` = NOW(), 
                                `datecreated` = NOW(),  
                                `ornumber` = '" + next_ornumber + @"',  
                                `terminalno` = '" + terminalno + @"'
                            WHERE `SyncId` = '" + next_SyncId + @"'";

            setdb(sSQL);

            trans.setORnumber(next_ornumber);
            trans.setSyncId(next_SyncId);
            return(0);
        }