jsx_dzc.js

var __extends = (this && this.__extends) || (function () {
    var extendStatics = function (d, b) {
        extendStatics = Object.setPrototypeOf ||
            ({ __proto__: [] } instanceof Array && function (d, b) { d.__proto__ = b; }) ||
            function (d, b) { for (var p in b) if (b.hasOwnProperty(p)) d[p] = b[p]; };
        return extendStatics(d, b);
    };
    return function (d, b) {
        extendStatics(d, b);
        function __() { this.constructor = d; }
        d.prototype = b === null ? Object.create(b) : (__.prototype = b.prototype, new __());
    };
})();
var DZC;
(function (DZC) {
    var Call = using('jsx_call.js');
    var JSXDZC = (function (_super) {
        __extends(JSXDZC, _super);
        function JSXDZC() {
            var _this = _super.call(this) || this;
            _this.addRPC('executeNonQuery', _this.executeNonQuery, true);
            _this.addRPC('executeRows', _this.executeRows, true);
            _this.addRPC('importOrder', _this.importOrder, true);
            _this.addRPC('importMaterialApp', _this.importMaterialApp, true);
            _this.addRPC('text', _this.text, false);
            return _this;
        }
        JSXDZC.prototype.text = function () {
            var config = using('config.json');
            var db = database.createScope(config.db, false, true);
            try {
                return db.executeRows("select ccode_name from code where ccode='xxxx'");
            }
            finally {
                db.dispose();
            }
        };
        JSXDZC.prototype.executeNonQuery = function (querys, argument) {
            var config = using('config.json');
            var db = database.createScope(config.db, false, true);
            try {
                return db.executeNonQuery(argument.sql, argument.args);
            }
            finally {
                db.dispose();
            }
        };
        JSXDZC.prototype.executeRows = function (querys, argument) {
            var config = using('config.json');
            var db = database.createScope(config.db, false, true);
            try {
                return db.executeRows(argument.sql, argument.args);
            }
            finally {
                db.dispose();
            }
        };
        JSXDZC.prototype.Round = function (x, length) {
            var pow = Math.pow(10, length);
            return Math.round(x * pow) / pow;
        };
        JSXDZC.prototype.check_code = function (db, codeField, tbName, code, errMsg) {
            if (code != null) {
                if (db.executeScalar("select count(*) from {0} where {1}=@code".format(tbName, codeField), { code: code }) == 0)
                    throw new Error(errMsg);
            }
        };
        JSXDZC.prototype.checkInventory = function (db, code) {
            this.check_code(db, "cinvcode", "inventory", code, '商品代码"{0}"无效'.format(code));
        };
        JSXDZC.prototype.checkWarehouse = function (db, code) {
            this.check_code(db, "cwhcode", "warehouse", code, '仓库代码"{0}"无效'.format(code));
        };
        JSXDZC.prototype.checkDepartment = function (db, code) {
            this.check_code(db, "cdepcode", "department", code, '部门代码"{0}"无效'.format(code));
        };
        JSXDZC.prototype.checkVendor = function (db, code) {
            this.check_code(db, "cvencode", "vendor", code, '供货商代码"{0}"无效'.format(code));
        };
        JSXDZC.prototype.checkCustomer = function (db, code) {
            this.check_code(db, "ccuscode", "customer", code, '客户代码"{0}"无效'.format(code));
        };
        JSXDZC.prototype.checkPT = function (db, code) {
            this.check_code(db, "cPTCode", "purchasetype", code, '采购类型代码"{0}"无效'.format(code));
        };
        JSXDZC.prototype.checkPerson = function (db, code) {
            this.check_code(db, "cPersonCode", "Person", code, '职员类型代码"{0}"无效'.format(code));
        };
        JSXDZC.prototype.checkRd_Style = function (db, code) {
            this.check_code(db, "crdcode", "rd_style", code, '收发类别代码"{0}"无效'.format(code));
        };
        JSXDZC.prototype.GetVTID = function (db, name) {
            return db.executeScalar("select def_id from vouchers where name=@name", { name: name });
        };
        JSXDZC.prototype.GetID = function (db, acctid, voucherType, amount) {
            if (amount === void 0) { amount = 0; }
            var rs = db.executeRows("declare @iFatherId bigint,@iChildId bigint;\n            exec sp_getid @cAcc_Id=@cacc_id,@cVouchType=@cVouchType,@iAmount=@iAmount ,@iFatherId=@iFatherId output,@iChildId=@iChildId output\n            select cast(@ifatherid as nvarchar(20)) fatherid,cast(@ichildid as nvarchar(20)) childid", { cacc_id: acctid, cvouchtype: voucherType, iamount: amount });
            return rs[0];
        };
        JSXDZC.prototype.check_current = function (db, name) {
            if (db.executeScalar("select count(*) from foreigncurrency where cexch_name=@name", { name: name }) == 0)
                throw new Error('无效的币种"{0}"'.format(name));
        };
        JSXDZC.prototype.SetUnit = function (db, cinvcode, unitcode, iquantity, inum) {
            var r = {};
            var ug;
            {
                var rs = db.executeRows("select iGroupType,cGroupCode from Inventory where cInvCode=@invcode ", { invcode: cinvcode });
                if (rs.length == 0)
                    throw new Error('物料代码"{0}"不存在'.format(cinvcode));
                ug = rs[0];
            }
            if (ug.igrouptype == 0) {
                if (iquantity == null)
                    throw new Error('iquantity必须被设置');
                r.iquantity = iquantity;
                r.cunitid = null;
                r.inum = null;
                r.rate = null;
            }
            else if (ug.igrouptype == 1) {
                if (unitcode == null)
                    throw new Error('根据相关计量单位设置,属性 cunitid(计量单位代码)必须被设置');
                var changeRate = db.executeScalar("select iChangRate from ComputationUnit where cGroupCode=@groupcode and cComunitCode=@unitcode", { groupcode: ug.cgroupcode, unitcode: unitcode });
                if (typeof changeRate == 'undefined')
                    throw new Error('相关计量单位代码"{0}"无效'.format(unitcode));
                if (changeRate == null || changeRate == 0)
                    throw new Error('相关计量单位代码"{0}"的换算率的值为无效值（0或null）'.format(unitcode));
                r.cunitid = unitcode;
                r.rate = changeRate;
                if (iquantity != null) {
                    r.inum = this.Round(iquantity / changeRate, 2);
                    r.iquantity = iquantity;
                }
                else if (inum != null) {
                    r.iquantity = this.Round(inum * changeRate, 2);
                    r.inum = inum;
                }
                else
                    throw new Error('计量单位要求 iquantity或inum必须设置一个');
            }
            else if (ug.igrouptype == 2) {
                if (unitcode == null)
                    throw new Error('根据相关设置,属性 cunitid(计量单位代码)必须被设置');
                var unit = void 0;
                {
                    var rs = db.executeRows("select iChangRate,bMainUnit from ComputationUnit where cGroupCode=@groupcode and cComunitCode=@unitcode", { groupcode: ug.cgroupcode, unitcode: unitcode });
                    if (rs.length == 0)
                        throw new Error('相关计量单位代码"{0}"无效'.format(unitcode));
                    unit = rs[0];
                }
                if (unit.bmainunit)
                    throw new Error('cunitid属性不能被设置为主计量单位');
                r.cunitid = unitcode;
                if (iquantity != null) {
                    if (inum == null) {
                        if (unit.ichangrate == null)
                            throw Error('因计量单位限制inum属性必须被设置');
                        r.iquantity = iquantity;
                        r.inum = this.Round(iquantity / unit.ichangrate, 2);
                        r.rate = unit.ichangrate;
                    }
                    else {
                        r.iquantity = iquantity;
                        r.inum = inum;
                        if (inum == 0)
                            r.rate = null;
                        else
                            r.rate = iquantity / inum;
                    }
                }
                else {
                    if (unit.ichangrate == null)
                        throw new Error('因计量单位限制iquantity属性必须被设置');
                    if (inum == null)
                        throw new Error('iquantity属性和inum属性至少应该被设置一个');
                    r.iquantity = this.Round(inum * unit.ichangrate, 2);
                    r.inum = inum;
                    r.rate = unit.ichangrate;
                }
            }
            else
                throw new Error('相关计量单位的属性 igrouptype 被设置为无效的值:{0}'.format(ug.igrouptype));
            return r;
        };
        JSXDZC.prototype.toNumber = function (value) {
            switch (typeof value) {
                case 'undefined':
                    return undefined;
                case 'number':
                    return value;
                case 'string':
                    return parseFloat(value);
                default:
                    return null;
            }
        };
        JSXDZC.prototype.toDate = function (value) {
            function str2Date(date) {
                var reg_date = /^(\d{4})\-(\d{1,2})\-(\d{1,2})(\s+(\d{1,2}):(\d{1,2}):(\d{1,2})(\.(\d{3}))?)?$/i;
                if (!reg_date.test(date))
                    return null;
                var ds = reg_date.exec(date);
                var year = parseFloat(ds[1]);
                var month = parseFloat(ds[2]);
                var day = parseFloat(ds[3]);
                var hour = parseFloat(ds[5]);
                var min = parseFloat(ds[6]);
                var sec = parseFloat(ds[7]);
                var ms = parseFloat(ds[9]);
                try {
                    if (ds[4] == undefined)
                        return new Date(year, month - 1, day);
                    else if (ds[8] == null)
                        return new Date(year, month - 1, day, hour, min, sec);
                    return new Date(year, month - 1, day, hour, min, sec, ms);
                }
                catch (_a) {
                    return null;
                }
            }
            if (typeof value == 'undefined')
                return undefined;
            if (value == null)
                return null;
            if (typeof value == 'string')
                return str2Date(value);
            if (typeof value == 'object' && value.constructor == Date)
                return value;
            if (typeof value == 'number')
                return new Date(value);
        };
        JSXDZC.prototype.In = function (check) {
            var args = [];
            for (var _i = 1; _i < arguments.length; _i++) {
                args[_i - 1] = arguments[_i];
            }
            for (var i = 0; i < args.length; i++) {
                if (check(args[i], i) == true)
                    return true;
            }
            return false;
        };
        JSXDZC.prototype.Between = function (v, min, max) {
            return v >= min && v <= max;
        };
        JSXDZC.prototype.setTaxPrice = function (db, idiscounttaxtype, nFlat, cinvcode, ipertaxrate, headTaxRate, iunitprice, itaxprice, iquantity) {
            var taxRate = ipertaxrate;
            if (taxRate == null) {
                if (headTaxRate != null)
                    taxRate = headTaxRate;
                else {
                    taxRate = db.executeScalar("select iTaxRate from Inventory where cinvcode=@code", { code: cinvcode });
                    if (typeof taxRate == 'undefined')
                        throw new Error('存货"{0}"无效'.format(cinvcode));
                    if (taxRate == null)
                        taxRate = 0;
                }
            }
            taxRate = this.toNumber(taxRate);
            if (taxRate == null || taxRate < 0)
                throw new Error('税率的值不合法');
            taxRate = taxRate / 100;
            var money, sum, tax;
            if (iunitprice != null) {
                if (idiscounttaxtype == 0) {
                    itaxprice = this.Round((1 + taxRate) * iunitprice, 4);
                }
                else if (idiscounttaxtype == 1) {
                    itaxprice = this.Round(iunitprice / (1 - taxRate), 4);
                }
            }
            else if (itaxprice != null) {
                if (idiscounttaxtype == 0)
                    iunitprice = this.Round(itaxprice / (1 + taxRate), 4);
                else if (idiscounttaxtype == 1)
                    iunitprice = this.Round(itaxprice * (1 - taxRate), 4);
            }
            money = this.Round(iunitprice * iquantity, 2);
            sum = this.Round(itaxprice * iquantity, 2);
            tax = this.Round(sum - money, 2);
            var nPrice = iunitprice * nFlat;
            var nMoney = this.Round(money * nFlat, 2);
            var nTax = this.Round(tax * nFlat, 2);
            var nSum = this.Round(sum * nFlat, 2);
            return { iunitprice: iunitprice, itaxprice: itaxprice, itax: tax, imoney: money, isum: sum, nPrice: nPrice, nMoney: nMoney, nSum: nSum, nTax: nTax };
        };
        JSXDZC.prototype.checkItem = function (db, itemclass, item) {
            var NULL = { className: null, itemName: null };
            if (itemclass == null)
                return NULL;
            var className = db.executeScalar("select citem_name from fitemclass where citem_class=@class", { class: itemclass });
            if (className == undefined)
                throw new Error('citem_class的值"{0}"不存在'.format(itemclass));
            if (item == null)
                return NULL;
            var v = db.executeScalar("select citemname from fitemss{0} where citemcode=@code".format(itemclass), { code: item });
            if (v == null)
                throw new Error('无效的核算项目大类"{0}"不存在代码"{1}"'.format(className, item));
            return { className: className, itemName: v };
        };
        JSXDZC.prototype.GetNO = function (db, tbname, field, date) {
            function DateOrder() {
                var syear = ('0000' + date.getFullYear().toString());
                syear = syear.substr(syear.length - 4, 4);
                var smonth = ('00' + (date.getMonth() + 1).toString());
                smonth = smonth.substr(smonth.length - 2, 2);
                var prifx = syear.substr(2, 2) + smonth;
                var mx = db.executeScalar("select max(substring({1},5,4)) from {0} where {1} like @prifx+'[0-9][0-9][0-9][0-9]'".format(tbname, field), { prifx: prifx });
                if (mx == null)
                    return prifx + '0001';
                var sx = '0000' + (parseFloat(mx) + 1).toString();
                return prifx + sx.substr(sx.length - 4, 4);
            }
            function BigOrder() {
                var mx = db.executeScalar("select max({1}) from {0} where {1} like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'".format(tbname, field));
                if (mx == null)
                    return '00000001';
                var sx = '00000000' + (parseFloat(mx) + 1).toString();
                return sx.substr(sx.length - 8, 8);
            }
            if (date)
                return DateOrder();
            else
                return BigOrder();
        };
        JSXDZC.prototype.insert2DB = function (db, table, obj) {
            var fd = [];
            for (var k in obj) {
                fd.push(k);
            }
            var sfn = '';
            var sfd = '';
            for (var i = 0; i < fd.length; i++) {
                if (i > 0) {
                    sfn += ',';
                    sfd += ',';
                }
                sfn += fd[i];
                sfd += '@' + fd[i];
            }
            var sql = 'insert into ' + table + "(" + sfn + ")values(" + sfd + ")";
            db.executeNonQuery(sql, obj);
        };
        JSXDZC.prototype.cloneObj = function (obj) {
            var no = {};
            for (var k in obj) {
                no[k.toLowerCase()] = obj[k];
            }
            return no;
        };
        JSXDZC.prototype.setObj = function (fields, srcObj, destObj) {
            for (var i = 0; i < fields.length; i++) {
                var s = srcObj[fields[i]];
                if (typeof s != 'undefined')
                    destObj[fields[i]] = srcObj[fields[i]];
            }
        };
        JSXDZC.prototype._importOrder = function (argument) {
            var std_main = {
                cbustype: '普通采购',
                cexch_name: '人民币',
                nflat: 1,
                icost: 0,
                ibargain: 0,
                cstate: 0,
                idiscounttaxtype: 0,
            };
            var std_detail = {};
            var mfs = ['dpodate', 'cpoid', 'idiscounttaxtype', 'cvencode', 'cdepcode', 'cpersoncode', 'cptcode', 'carrivalplace', 'cexch_name', 'nflat',
                'itaxrate', 'icost', 'ibargain', 'cmemo', 'cmaker', 'cverifier', 'cdefine1', 'cdefine2', 'cdefine3', 'cdefine4', 'cdefine5', 'cdefine6',
                'cdefine7', 'cdefine8', 'cdefine9', 'cdefine10', 'cdefine11', 'cdefine12', 'cdefine13', 'cdefine14', 'cdefine15', 'cdefine16',
                'ccontactcode', 'cvenperson', 'cvenbank', 'cvenaccount',
            ];
            var dfs = ['cinvcode', 'iquantity', 'inum', 'iunitprice', 'itaxprice', 'ipertaxrate', 'bgsp', 'cunitid', 'btaxcost',
                'darrivedate', 'citemcode', 'citem_class', 'citemname', 'cbmemo', 'cfree1', 'cfree2', 'cfree3', 'cfree4', 'cfree5', 'cfree6',
                'cfree7', 'cfree8', 'cfree9', 'cfree10', 'cdefine22', 'cdefine23', 'cdefine24', 'cdefine25', 'cdefine26', 'cdefine27',
                'cdefine28', 'cdefine29', 'cdefine30', 'cdefine31', 'cdefine32', 'cdefine33', 'cdefine34', 'cdefine35', 'cdefine36', 'cdefine37',
            ];
            var head = argument.head;
            if (head.cexch_name != null) {
                if (head.nflat == null)
                    throw new Error('在设置了 cexch_name 属性时 nflat属性也必须被设置');
                if (head.nflat <= 0) {
                    throw new Error('在设置了 cexch_name 属性时 nflat属性必须大于零');
                }
            }
            var mainObj = this.cloneObj(std_main);
            this.setObj(mfs, head, mainObj);
            if (mainObj.dpodate == undefined)
                throw new Error('dpodate字段必须被设置');
            if (mainObj.cmaker == undefined)
                throw new Error('cmaker 字段必须被设置');
            var date = this.toDate(mainObj.dpodate);
            if (date == null)
                throw new Error('dpodate字段格式错误,期待 类似于 2020-4-5 格式');
            mainObj.dpodate = date.date;
            if (!this.Between(mainObj.idiscounttaxtype, 0, 1))
                throw new Error('属性 idiscounttaxtype 值只能是 0,1');
            var config = using('config.json');
            var db = database.createScope(config.db, true, true);
            try {
                var acctid = db.executeScalar("select cacc_id from  ufsystem..UA_AccountDatabase where cdatabase=db_name()");
                this.check_current(db, mainObj.cexch_name);
                mainObj.ivtid = this.GetVTID(db, 'PO');
                this.checkVendor(db, mainObj.cvencode);
                this.checkDepartment(db, mainObj.cdepcode);
                this.checkPerson(db, mainObj.cpersoncode);
                this.checkPT(db, mainObj.cptcode);
                var body = argument.body;
                var entrys = [];
                for (var ir = 0; ir < body.length; ir++) {
                    var rd = body[ir];
                    var detailObj = this.cloneObj(std_detail);
                    this.setObj(dfs, rd, detailObj);
                    this.checkInventory(db, detailObj.cinvcode);
                    if (detailObj.iunitprice != null && detailObj.iunitprice < 0)
                        throw new Error('iunitprice 属性不能小于零');
                    if (detailObj.itaxprice != null && detailObj.itaxprice < 0)
                        throw new Error('itaxprice 属性不能小于零');
                    detailObj.citemname = this.checkItem(db, detailObj.citem_class, detailObj.citemcode).itemName;
                    var uts = this.SetUnit(db, detailObj.cinvcode, detailObj.cunitid, detailObj.iquantity, detailObj.inum);
                    detailObj.ivouchrowno = ir + 1;
                    detailObj.cunitid = uts.cunitid;
                    detailObj.iquantity = uts.iquantity;
                    detailObj.inum = uts.inum;
                    var price = this.setTaxPrice(db, mainObj.idiscounttaxtype, mainObj.nflat, detailObj.cinvcode, detailObj.ipertaxrate, mainObj.itaxrate, detailObj.iunitprice, detailObj.itaxprice, detailObj.iquantity);
                    detailObj.iunitprice = price.iunitprice;
                    detailObj.itaxprice = price.itaxprice;
                    detailObj.imoney = price.imoney;
                    detailObj.itax = price.itax;
                    detailObj.isum = price.isum;
                    detailObj.itaxprice = price.itaxprice;
                    detailObj.inatunitprice = price.nPrice;
                    detailObj.inatmoney = price.nMoney;
                    detailObj.inattax = price.nTax;
                    detailObj.inatsum = price.nSum;
                    entrys.push(detailObj);
                }
                var ids = this.GetID(db, acctid, 'POMain', entrys.length);
                var id_childs = parseFloat(ids.childid) - entrys.length + 1;
                if (mainObj.cpoid == null)
                    mainObj.cpoid = this.GetNO(db, "po_pomain", "cpoid", mainObj.dpodate);
                mainObj.poid = ids.fatherid;
                mainObj.csysbarcode = '||pupo|{0}'.format(mainObj.cpoid);
                for (var i = 0; i < entrys.length; i++) {
                    entrys[i].id = id_childs++;
                    entrys[i].poid = ids.fatherid;
                    entrys[i].cbsysbarcode = '||pupo|{0}|{1}'.format(mainObj.cpoid, i + 1);
                }
                if (mainObj.cverifier != null) {
                    mainObj.caudittime = new Date();
                    mainObj.cauditdate = (new Date()).toYMD(0);
                    mainObj.cstate = 1;
                    mainObj.iverifystateex = 2;
                }
                this.insert2DB(db, "po_pomain", mainObj);
                for (var i = 0; i < entrys.length; i++) {
                    this.insert2DB(db, "po_podetails", entrys[i]);
                }
                db.completeTrans();
                mainObj['entrys'] = entrys;
                return mainObj;
            }
            finally {
                db.dispose();
            }
        };
        JSXDZC.prototype.importOrder = function (querys, argument) {
            try {
                return this._importOrder(argument);
            }
            catch (ex) {
                console.log(ex.stack);
                throw ex;
            }
        };
        JSXDZC.prototype.SetBatch = function (db, cinvcode, cbatch) {
            var bInvBatch = db.executeScalar("select bInvBatch from inventory i left join Inventory_Sub isub on i.cInvCode=cInvSubCode where i.cinvcode=@code and i.bInvBatch=1", { code: cinvcode });
            if (typeof bInvBatch == 'undefined')
                throw new Error('无效的存货代码"{0}"'.format(cinvcode));
            if (bInvBatch)
                return cbatch;
            return null;
        };
        JSXDZC.prototype.MassDate = function (db, allow_null, cinvcode, pdate, vdate) {
            if (pdate != null)
                pdate = this.toDate(pdate);
            if (vdate != null)
                vdate = this.toDate(vdate);
            var rows = db.executeRows("select i.imassdate,isnull(i.cmassunit,0) cmassunit,isnull(isub.iexpiratdatecalcu,0) iexpiratdatecalcu,binvquality from inventory i left join Inventory_Sub isub on i.cInvCode=cInvSubCode where i.cinvcode=@code", { code: cinvcode });
            if (rows.length == 0)
                throw new Error('无效的物料码:{0}'.format(cinvcode));
            var mass = rows[0];
            if (!mass.binvquality)
                return { pdate: null, vdate: null, imassdate: null, cmassunit: null, iexpiratdatecalcu: null, dexpirationdate: null, cexpirationdate: null };
            if (mass.iexpiratdatecalcu == 0)
                return { pdate: null, vdate: null, imassdate: null, cmassunit: null, iexpiratdatecalcu: 0, dexpirationdate: null, cexpirationdate: null };
            if (pdate == null) {
                if (allow_null)
                    return { pdate: null, vdate: null, imassdate: null, cmassunit: null, iexpiratdatecalcu: null, dexpirationdate: null, cexpirationdate: null };
                throw new Error('生产日期必须被设置');
            }
            var imassdate;
            if (vdate == null) {
                imassdate = mass.imassdate;
                if (mass.cmassunit == 2)
                    vdate = pdate.add('m', imassdate);
                else if (mass.cmassunit == 3)
                    vdate = pdate.add('d', imassdate);
                else if (mass.cmassunit == 1)
                    vdate = pdate.add('y', imassdate);
                else
                    throw new Error('无效的 cmassuint 值"{0}"'.format(mass.cmassunit));
            }
            else {
                if (mass.cmassunit == 2)
                    imassdate = pdate.diff('m', vdate);
                else if (mass.cmassunit == 3)
                    imassdate = pdate.diff('d', vdate);
                else if (mass.cmassunit == 1)
                    imassdate = pdate.diff('y', vdate);
                else
                    throw new Error('无效的 cmassuint 值"{0}"'.format(mass.cmassunit));
            }
            var dexpirationdate;
            var cexpirationdate;
            if (mass.iexpiratdatecalcu == 2)
                dexpirationdate = vdate.add('d', -1);
            else if (mass.iexpiratdatecalcu == 1) {
                var y = vdate.getFullYear();
                var m = vdate.getMonth();
                var d = new Date(y, m, 1);
                dexpirationdate = d.add('d', -1);
            }
            else
                throw new Error('无效的 iexpiratdatecalcu 值"{0}"'.format(mass.iexpiratdatecalcu));
            if (mass.cmassunit == 1)
                cexpirationdate = dexpirationdate.toYMD(0).substr(0, 4);
            else if (mass.cmassunit == 2)
                cexpirationdate = dexpirationdate.toYMD(0).substr(0, 7);
            else if (mass.cmassunit == 3)
                cexpirationdate = dexpirationdate.toYMD(0);
            return {
                pdate: pdate, vdate: vdate, imassdate: imassdate, cmassunit: mass.cmassunit, iexpiratdatecalcu: mass.iexpiratdatecalcu,
                dexpirationdate: dexpirationdate, cexpirationdate: cexpirationdate
            };
        };
        JSXDZC.prototype.importMaterialApp = function (querys, argument) {
            try {
                return this._importMaterialApp(argument);
            }
            catch (ex) {
                console.log(ex.stack);
                throw ex;
            }
        };
        JSXDZC.prototype._importMaterialApp = function (argument) {
            var main_allow_fields = ['ddate', 'ccode', 'crdcode', 'cvencode', 'cdepcode', 'cpersoncode', 'citem_class', 'citemcode', 'chandler', 'cmemo',
                'cmaker', 'cdefine1', 'cdefine2', 'cdefine3', 'cdefine4', 'cdefine5', 'cdefine6', 'cdefine7', 'cdefine8', 'cdefine9', 'cdefine10',
                'cdefine11', 'cdefine12', 'cdefine13', 'cdefine14', 'cdefine15', 'cdefine16', 'csource'];
            var detail_allow_fields = ["cwhcode", "cinvcode", "inum", "iquantity", "cbatch", "foutquantity", "cassunit", "foutnum", "dvdate", "dmadedate",
                "imassdate", "iexpiratdatecalcu", "cmassunit", "cexpirationdate", "dexpirationdate", "dduedate", "citem_class", "citemcode", "cbmemo",
                "cfree1", "cfree2", "cfree3", "cfree4", "cfree5", "cfree6", "cfree7", "cfree8", "cfree9", "cfree10", "cdefine22", "cdefine23", "cdefine24",
                "cdefine25", "cdefine26", "cdefine27", "cdefine28", "cdefine29", "cdefine30", "cdefine31", "cdefine32", "cdefine33", "cdefine34", "cdefine35",
                "cdefine36", "cdefine37", "cbatchproperty1", "cbatchproperty2", "cbatchproperty3", "cbatchproperty4", "cbatchproperty5", "cbatchproperty6",
                "cbatchproperty7", "cbatchproperty8", "cbatchproperty9", "cbatchproperty10", "impoids", "cmolotcode", "cmworkcentercode", "cmocode", "imoseq",
                "iopseq", "copdesc", "iomodid", "iomomid", "comcode", "invcode", "cciqbookcode", "cservicecode", "iordertype", "iorderdid", "iordercode", "iorderseq",
                "isotype", "isodid", "csocode", "isoseq", "crejectcode", "ipesodid", "ipesotype", "cpesocode", "ipesoseq", "cbsysbarcode", "ipickedquantity", "ipickednum"];
            var std_main = {
                iprintcount: 0,
                iswfcontrolled: 0
            };
            var std_detail = {
                iordertype: 0, isotype: 0, ipesotype: 0
            };
            var head = argument.head;
            var mainObj = this.cloneObj(std_main);
            this.setObj(main_allow_fields, head, mainObj);
            if (mainObj.ddate == null)
                throw new Error('属性 ddate（制单日期）必须被设置');
            if (mainObj.cmaker == null)
                throw new Error('属性 cmarker（制单人）必须被设置');
            var date = this.toDate(mainObj.ddate);
            if (date == null)
                throw new Error('ddate字段格式错误,期待 类似于 2020-4-5 格式');
            mainObj.ddate = date.date;
            var config = using('config.json');
            var db = database.createScope(config.db, true, true);
            try {
                var acctid = db.executeScalar("select cacc_id from  ufsystem..UA_AccountDatabase where cdatabase=db_name()");
                mainObj.vt_id = this.GetVTID(db, 'kcmaterialappvouch');
                this.checkRd_Style(db, mainObj.crdcode);
                this.checkDepartment(db, mainObj.cdepcode);
                this.checkPerson(db, mainObj.cpersoncode);
                this.checkItem(db, mainObj.citem_class, mainObj.citemcode);
                this.checkVendor(db, mainObj.cvencode);
                var item = this.checkItem(db, mainObj.citem_class, mainObj.citemcode);
                mainObj.citemcname = item.className;
                mainObj.cname = item.itemName;
                if (mainObj.chandler != null) {
                    mainObj.dveriDate = mainObj.ddate;
                    mainObj.dnverifytime = new Date();
                }
                var body = argument.body;
                var entrys = [];
                for (var ir = 0; ir < body.length; ir++) {
                    var rd = body[ir];
                    var detailObj = this.cloneObj(std_detail);
                    this.setObj(detail_allow_fields, rd, detailObj);
                    this.checkInventory(db, detailObj.cinvcode);
                    this.checkWarehouse(db, detailObj.cwhcode);
                    var item = this.checkItem(db, detailObj.citem_class, detailObj.citemcode);
                    detailObj.citemcname = item.className;
                    detailObj.cname = item.itemName;
                    var uts = this.SetUnit(db, detailObj.cinvcode, detailObj.cassunit, detailObj.iquantity, detailObj.inum);
                    detailObj.irowno = ir + 1;
                    detailObj.cassunit = uts.cunitid;
                    detailObj.iquantity = uts.iquantity;
                    detailObj.inum = uts.inum;
                    var mass = this.MassDate(db, true, detailObj.cinvcode, detailObj.dmadedate, detailObj.dvdate);
                    detailObj.dmadedate = mass.pdate;
                    detailObj.dvdate = mass.vdate;
                    detailObj.imassdate = mass.imassdate;
                    detailObj.cmassunit = mass.cmassunit;
                    detailObj.iexpiratdatecalcu = mass.iexpiratdatecalcu;
                    detailObj.cexpirationdate = mass.cexpirationdate;
                    detailObj.dexpirationdate = mass.dexpirationdate;
                    detailObj.cbatch = this.SetBatch(db, detailObj.cinvcode, detailObj.cbatch);
                    entrys.push(detailObj);
                }
                var ids = this.GetID(db, acctid, 'mv', entrys.length);
                var id_childs = parseFloat(ids.childid) - entrys.length + 1;
                if (mainObj.ccode == null)
                    mainObj.ccode = this.GetNO(db, "MaterialAppVouch", "ccode", mainObj.ddate);
                mainObj.id = ids.fatherid;
                mainObj.csysbarcode = '||st64|{0}'.format(mainObj.ccode);
                for (var i = 0; i < entrys.length; i++) {
                    entrys[i].id = ids.fatherid;
                    entrys[i].autoid = id_childs++;
                    entrys[i].cbsysbarcode = '||st64|{0}|{1}'.format(mainObj.ccode, i + 1);
                }
                this.insert2DB(db, "MaterialAppVouch", mainObj);
                for (var i = 0; i < entrys.length; i++) {
                    this.insert2DB(db, "MaterialAppVouchs", entrys[i]);
                }
                db.completeTrans();
                mainObj['entrys'] = entrys;
                return mainObj;
            }
            finally {
                db.dispose();
            }
        };
        return JSXDZC;
    }(Call));
    exports = function (querys) {
        var s = new JSXDZC();
        return s.CallRPC(querys);
    };
})(DZC || (DZC = {}));