internal Pasport GetResult() { int pspId = QM.Nextval(connection, "n_pasport_seq"); QM.DML(connection, "insert into pasport(pasport_id,nc,npart,nplav,bsh_id, vid_proizv_id,date_zap) values (:0,:1,:2,:3,:4, :5, sysdate)", new object[] { pspId, Nc, NPart, NPlav, BshId, VidProizvId }); QM.DML(connection, "insert into n_pasport(n_pasport_id,pasport_id) values (:0,:0)", new object[] { pspId }); if (ShifrId != 0) { QM.DML(connection, "insert into n_pasport_shifr(n_pasport_id,uslov_shifr_id) values (:0,:1)", new object[] { pspId, ShifrId }); } var psp = new Pasport(connection, pspId); for (var i = 0; i < ZagotCount; i++) { psp.AddZagot($"T{i}"); } psp.LinkTek(TekId); psp.GenerateOpers(); psp.Document.TransTo("22P_EL_PASP"); psp.Document.Denorm(); return(psp); }
private int NewPdrId() { var id = QM.Nextval(Connection, "seq1"); QM.DML(GRPOConnection, "insert into lns_pdr_vinov(lns_pdr_vinov_id, nc, naim) values(:0,:1,:2)", new object[] { id, "22", RandomString(20) }); return(id); }
public void AddZagot(string number) { var zagotid = QM.Nextval(connection, "seq1"); QM.DML(connection, "insert into zagot(ZAGOT_ID, PASPORT_ID, ZAG, START_VV_ZAG_STATUS_ID, VV_ZAG_STATUS_ID) values(:0, :1, :2, :3, :3)", new object[] { zagotid, Id, number, ZagotType.PRODUCT } ); Ed04Pak.CreateDoc(connection, zagotid); }