コード例 #1
0
        ///<summary></summary>
        public static void Insert(QuickPasteNote note)
        {
            if (PrefB.RandomKeys)
            {
                note.QuickPasteNoteNum = MiscData.GetKey("quickpastenote", "QuickPasteNoteNum");
            }
            string command = "INSERT INTO quickpastenote (";

            if (PrefB.RandomKeys)
            {
                command += "QuickPasteNoteNum,";
            }
            command += "QuickPasteCatNum,ItemOrder,Note,Abbreviation) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(note.QuickPasteNoteNum) + "', ";
            }
            command +=
                "'" + POut.PInt(note.QuickPasteCatNum) + "', "
                + "'" + POut.PInt(note.ItemOrder) + "', "
                + "'" + POut.PString(note.Note) + "', "
                + "'" + POut.PString(note.Abbreviation) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                note.QuickPasteNoteNum = General.NonQ(command, true);
            }
        }
コード例 #2
0
ファイル: Diseases.cs プロジェクト: luisurbinanet/gnudental
        ///<summary></summary>
        public static void Insert(Disease disease)
        {
            if (PrefB.RandomKeys)
            {
                disease.DiseaseNum = MiscData.GetKey("disease", "DiseaseNum");
            }
            string command = "INSERT INTO disease (";

            if (PrefB.RandomKeys)
            {
                command += "DiseaseNum,";
            }
            command += "PatNum,DiseaseDefNum,PatNote) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(disease.DiseaseNum) + "', ";
            }
            command +=
                "'" + POut.PInt(disease.PatNum) + "', "
                + "'" + POut.PInt(disease.DiseaseDefNum) + "', "
                + "'" + POut.PString(disease.PatNote) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                disease.DiseaseNum = General.NonQ(command, true);
            }
        }
コード例 #3
0
        ///<summary></summary>
        public static void Insert(CanadianNetwork network)
        {
            if (PrefB.RandomKeys)
            {
                network.CanadianNetworkNum = MiscData.GetKey("canadiannetwork", "CanadianNetworkNum");
            }
            string command = "INSERT INTO canadiannetwork (";

            if (PrefB.RandomKeys)
            {
                command += "CanadianNetworkNum,";
            }
            command += "Abbrev, Descript) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(network.CanadianNetworkNum) + "', ";
            }
            command +=
                "'" + POut.PString(network.Abbrev) + "', "
                + "'" + POut.PString(network.Descript) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                network.CanadianNetworkNum = General.NonQ(command, true);
            }
        }
コード例 #4
0
        ///<summary></summary>
        public static void Insert(QuickPasteCat cat)
        {
            if (PrefB.RandomKeys)
            {
                cat.QuickPasteCatNum = MiscData.GetKey("quickpastecat", "QuickPasteCatNum");
            }
            string command = "INSERT INTO quickpastecat (";

            if (PrefB.RandomKeys)
            {
                command += "QuickPasteCatNum,";
            }
            command += "Description,ItemOrder,DefaultForTypes) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(cat.QuickPasteCatNum) + "', ";
            }
            command +=
                "'" + POut.PString(cat.Description) + "', "
                + "'" + POut.PInt(cat.ItemOrder) + "', "
                + "'" + POut.PString(cat.DefaultForTypes) + "')";
            //MessageBox.Show(string command);
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                cat.QuickPasteCatNum = General.NonQ(command, true);
            }
        }
コード例 #5
0
        ///<summary></summary>
        private static void Insert(SchoolCourse sc)
        {
            if (PrefB.RandomKeys)
            {
                sc.SchoolCourseNum = MiscData.GetKey("schoolcourse", "SchoolCourseNum");
            }
            string command = "INSERT INTO schoolcourse (";

            if (PrefB.RandomKeys)
            {
                command += "SchoolCourseNum,";
            }
            command += "CourseID,Descript) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(sc.SchoolCourseNum) + "', ";
            }
            command +=
                "'" + POut.PString(sc.CourseID) + "', "
                + "'" + POut.PString(sc.Descript) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                sc.SchoolCourseNum = General.NonQ(command, true);
            }
        }
コード例 #6
0
        ///<summary></summary>
        public static void Insert(Question quest)
        {
            if (PrefB.RandomKeys)
            {
                quest.QuestionNum = MiscData.GetKey("question", "QuestionNum");
            }
            string command = "INSERT INTO question (";

            if (PrefB.RandomKeys)
            {
                command += "QuestionNum,";
            }
            command += "PatNum,ItemOrder,Description,Answer,FormPatNum) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(quest.QuestionNum) + "', ";
            }
            command +=
                "'" + POut.PInt(quest.PatNum) + "', "
                + "'" + POut.PInt(quest.ItemOrder) + "', "
                + "'" + POut.PString(quest.Description) + "', "
                + "'" + POut.PString(quest.Answer) + "', "
                + "'" + POut.PInt(quest.FormPatNum) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                quest.QuestionNum = General.NonQ(command, true);
            }
        }
コード例 #7
0
        ///<summary></summary>
        private static void Insert(PayPlanCharge charge)
        {
            if (PrefB.RandomKeys)
            {
                charge.PayPlanChargeNum = MiscData.GetKey("payplancharge", "PayPlanChargeNum");
            }
            string command = "INSERT INTO payplancharge (";

            if (PrefB.RandomKeys)
            {
                command += "PayPlanChargeNum,";
            }
            command += "PayPlanNum,Guarantor,PatNum,ChargeDate,Principal,Interest,Note) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(charge.PayPlanChargeNum) + "', ";
            }
            command +=
                "'" + POut.PInt(charge.PayPlanNum) + "', "
                + "'" + POut.PInt(charge.Guarantor) + "', "
                + "'" + POut.PInt(charge.PatNum) + "', "
                + POut.PDate(charge.ChargeDate) + ", "
                + "'" + POut.PDouble(charge.Principal) + "', "
                + "'" + POut.PDouble(charge.Interest) + "', "
                + "'" + POut.PString(charge.Note) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                charge.PayPlanChargeNum = General.NonQ(command, true);
            }
        }
コード例 #8
0
        ///<summary></summary>
        public static void InsertCur()
        {
            if (PrefB.RandomKeys)
            {
                Cur.ScreenGroupNum = MiscData.GetKey("screengroup", "ScreenGroupNum");
            }
            string command = "INSERT INTO screengroup (";

            if (PrefB.RandomKeys)
            {
                command += "ScreenGroupNum,";
            }
            command += "Description,SGDate) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(Cur.ScreenGroupNum) + "', ";
            }
            command +=
                "'" + POut.PString(Cur.Description) + "', "
                + "'" + POut.PDate(Cur.SGDate) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                Cur.ScreenGroupNum = General.NonQ(command, true);
            }
        }
コード例 #9
0
        ///<summary></summary>
        public static void Insert(Account acct)
        {
            if (PrefB.RandomKeys)
            {
                acct.AccountNum = MiscData.GetKey("account", "AccountNum");
            }
            string command = "INSERT INTO account (";

            if (PrefB.RandomKeys)
            {
                command += "AccountNum,";
            }
            command += "Description,AcctType,BankNumber,Inactive,AccountColor) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(acct.AccountNum) + "', ";
            }
            command +=
                "'" + POut.PString(acct.Description) + "', "
                + "'" + POut.PInt((int)acct.AcctType) + "', "
                + "'" + POut.PString(acct.BankNumber) + "', "
                + "'" + POut.PBool(acct.Inactive) + "', "
                + "'" + POut.PInt(acct.AccountColor.ToArgb()) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                acct.AccountNum = General.NonQ(command, true);
            }
        }
コード例 #10
0
        ///<summary></summary>
        public static void Insert(ToothInitial init)
        {
            if (PrefB.RandomKeys)
            {
                init.ToothInitialNum = MiscData.GetKey("toothinitial", "ToothInitialNum");
            }
            string command = "INSERT INTO toothinitial (";

            if (PrefB.RandomKeys)
            {
                command += "ToothInitialNum,";
            }
            command += "PatNum,ToothNum,InitialType,Movement) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(init.ToothInitialNum) + "', ";
            }
            command +=
                "'" + POut.PInt(init.PatNum) + "', "
                + "'" + POut.PString(init.ToothNum) + "', "
                + "'" + POut.PInt((int)init.InitialType) + "', "
                + "'" + POut.PFloat(init.Movement) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                init.ToothInitialNum = General.NonQ(command, true);
            }
        }
コード例 #11
0
ファイル: Commlogs.cs プロジェクト: luisurbinanet/apolloniax
        ///<summary></summary>
        public static void Insert(Commlog comm)
        {
            if (PrefB.RandomKeys)
            {
                comm.CommlogNum = MiscData.GetKey("commlog", "CommlogNum");
            }
            string command = "INSERT INTO commlog (";

            if (PrefB.RandomKeys)
            {
                command += "CommlogNum,";
            }
            command += "PatNum,CommDateTime,CommType,Note,Mode_,SentOrReceived,IsStatementSent) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(comm.CommlogNum) + "', ";
            }
            command +=
                "'" + POut.PInt(comm.PatNum) + "', "
                + POut.PDateT(comm.CommDateTime) + ", "
                + "'" + POut.PInt(comm.CommType) + "', "
                + "'" + POut.PString(comm.Note) + "', "
                + "'" + POut.PInt((int)comm.Mode_) + "', "
                + "'" + POut.PInt((int)comm.SentOrReceived) + "', "
                + "'" + POut.PBool(comm.IsStatementSent) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                comm.CommlogNum = General.NonQ(command, true);
            }
        }
コード例 #12
0
ファイル: ZipCodes.cs プロジェクト: steev90/opendental
        ///<summary></summary>
        public static void InsertCur()
        {
            if (PrefB.RandomKeys)
            {
                Cur.ZipCodeNum = MiscData.GetKey("zipcode", "ZipCodeNum");
            }
            string command = "INSERT INTO zipcode (";

            if (PrefB.RandomKeys)
            {
                command += "ZipCodeNum,";
            }
            command += "zipcodedigits,city,state,isfrequent) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(Cur.ZipCodeNum) + "', ";
            }
            command +=
                "'" + POut.PString(Cur.ZipCodeDigits) + "', "
                + "'" + POut.PString(Cur.City) + "', "
                + "'" + POut.PString(Cur.State) + "', "
                + "'" + POut.PBool(Cur.IsFrequent) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                Cur.ZipCodeNum = General.NonQ(command, true);
            }
        }
コード例 #13
0
        ///<summary></summary>
        public static void Insert(Medication Cur)
        {
            if (PrefB.RandomKeys)
            {
                Cur.MedicationNum = MiscData.GetKey("medication", "MedicationNum");
            }
            string command = "INSERT INTO medication (";

            if (PrefB.RandomKeys)
            {
                command += "MedicationNum,";
            }
            command += "medname,genericnum,notes"
                       + ") VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(Cur.MedicationNum) + "', ";
            }
            command +=
                "'" + POut.PString(Cur.MedName) + "', "
                + "'" + POut.PInt(Cur.GenericNum) + "', "
                + "'" + POut.PString(Cur.Notes) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                Cur.MedicationNum = General.NonQ(command, true);
            }
        }
コード例 #14
0
        ///<summary></summary>
        private static void Insert(TreatPlan tp)
        {
            if (PrefB.RandomKeys)
            {
                tp.TreatPlanNum = MiscData.GetKey("treatplan", "TreatPlanNum");
            }
            string command = "INSERT INTO treatplan (";

            if (PrefB.RandomKeys)
            {
                command += "TreatPlanNum,";
            }
            command += "PatNum,DateTP,Heading,Note) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(tp.TreatPlanNum) + "', ";
            }
            command +=
                "'" + POut.PInt(tp.PatNum) + "', "
                + POut.PDate(tp.DateTP) + ", "
                + "'" + POut.PString(tp.Heading) + "', "
                + "'" + POut.PString(tp.Note) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                tp.TreatPlanNum = General.NonQ(command, true);
            }
        }
コード例 #15
0
        ///<summary></summary>
        private static void Insert(Instructor instr)
        {
            if (PrefB.RandomKeys)
            {
                instr.InstructorNum = MiscData.GetKey("instructor", "InstructorNum");
            }
            string command = "INSERT INTO instructor (";

            if (PrefB.RandomKeys)
            {
                command += "InstructorNum,";
            }
            command += "LName,FName,Suffix) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(instr.InstructorNum) + "', ";
            }
            command +=
                "'" + POut.PString(instr.LName) + "', "
                + "'" + POut.PString(instr.FName) + "', "
                + "'" + POut.PString(instr.Suffix) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                instr.InstructorNum = General.NonQ(command, true);
            }
        }
コード例 #16
0
ファイル: PatFields.cs プロジェクト: luisurbinanet/apolloniax
        ///<summary></summary>
        public static void Insert(PatField pf)
        {
            if (PrefB.RandomKeys)
            {
                pf.PatFieldNum = MiscData.GetKey("patfield", "PatFieldNum");
            }
            string command = "INSERT INTO patfield (";

            if (PrefB.RandomKeys)
            {
                command += "PatFieldNum,";
            }
            command += "PatNum,FieldName,FieldValue) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(pf.PatFieldNum) + "', ";
            }
            command +=
                "'" + POut.PInt(pf.PatNum) + "', "
                + "'" + POut.PString(pf.FieldName) + "', "
                + "'" + POut.PString(pf.FieldValue) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                pf.PatFieldNum = General.NonQ(command, true);
            }
        }
コード例 #17
0
        ///<summary>Inserts the given preference and ensures that the primary key is properly set.</summary>
        public static void Insert(ComputerPref computerPref)
        {
            if (PrefB.RandomKeys)
            {
                computerPref.ComputerPrefNum = MiscData.GetKey("computerpref", "ComputerPrefNum");
            }
            string command = "INSERT INTO computerpref (";

            if (PrefB.RandomKeys)
            {
                command += "ComputerPrefNum,";
            }
            command += "ComputerName,GraphicsUseHardware,GraphicsSimple,SensorType,SensorPort,SensorExposure,SensorBinned,GraphicsDoubleBuffering,PreferredPixelFormatNum) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(computerPref.ComputerPrefNum) + "',";
            }
            command += "'" + POut.PString(computerPref.ComputerName) + "',"
                       + "'" + POut.PBool(computerPref.GraphicsUseHardware) + "',"
                       + "'" + POut.PBool(computerPref.GraphicsSimple) + "',"
                       + "'" + POut.PString(computerPref.SensorType) + "',"
                       + "'" + POut.PBool(computerPref.SensorBinned) + "',"
                       + "'" + POut.PInt(computerPref.SensorPort) + "',"
                       + "'" + POut.PInt(computerPref.SensorExposure) + "',"
                       + "'" + POut.PBool(computerPref.GraphicsDoubleBuffering) + "',"
                       + "'" + POut.PInt(computerPref.PreferredPixelFormatNum) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                computerPref.ComputerPrefNum = General.NonQ(command, true);
            }
        }
コード例 #18
0
        ///<summary></summary>
        public static void Insert(LabTurnaround lab)
        {
            if (PrefB.RandomKeys)
            {
                lab.LabTurnaroundNum = MiscData.GetKey("labturnaround", "LabTurnaroundNum");
            }
            string command = "INSERT INTO labturnaround (";

            if (PrefB.RandomKeys)
            {
                command += "LabTurnaroundNum,";
            }
            command += "LaboratoryNum,Description,DaysPublished,DaysActual) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(lab.LabTurnaroundNum) + "', ";
            }
            command +=
                "'" + POut.PInt(lab.LaboratoryNum) + "', "
                + "'" + POut.PString(lab.Description) + "', "
                + "'" + POut.PInt(lab.DaysPublished) + "', "
                + "'" + POut.PInt(lab.DaysActual) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                lab.LabTurnaroundNum = General.NonQ(command, true);
            }
        }
コード例 #19
0
ファイル: Contacts.cs プロジェクト: luisurbinanet/apolloniax
        ///<summary></summary>
        public static void Insert(Contact Cur)
        {
            if (PrefB.RandomKeys)
            {
                Cur.ContactNum = MiscData.GetKey("contact", "ContactNum");
            }
            string command = "INSERT INTO contact (";

            if (PrefB.RandomKeys)
            {
                command += "ContactNum,";
            }
            command += "LName,FName,WkPhone,Fax,Category,"
                       + "Notes) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(Cur.ContactNum) + "', ";
            }
            command +=
                "'" + POut.PString(Cur.LName) + "', "
                + "'" + POut.PString(Cur.FName) + "', "
                + "'" + POut.PString(Cur.WkPhone) + "', "
                + "'" + POut.PString(Cur.Fax) + "', "
                + "'" + POut.PInt(Cur.Category) + "', "
                + "'" + POut.PString(Cur.Notes) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                Cur.ContactNum = General.NonQ(command, true);
            }
        }
コード例 #20
0
ファイル: Employers.cs プロジェクト: luisurbinanet/apolloniax
        ///<summary></summary>
        public static void Insert(Employer Cur)
        {
            if (PrefB.RandomKeys)
            {
                Cur.EmployerNum = MiscData.GetKey("employer", "EmployerNum");
            }
            string command = "INSERT INTO employer (";

            if (PrefB.RandomKeys)
            {
                command += "EmployerNum,";
            }
            command += "EmpName,Address,Address2,City,State,Zip,Phone) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(Cur.EmployerNum) + "', ";
            }
            command +=
                "'" + POut.PString(Cur.EmpName) + "', "
                + "'" + POut.PString(Cur.Address) + "', "
                + "'" + POut.PString(Cur.Address2) + "', "
                + "'" + POut.PString(Cur.City) + "', "
                + "'" + POut.PString(Cur.State) + "', "
                + "'" + POut.PString(Cur.Zip) + "', "
                + "'" + POut.PString(Cur.Phone) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                Cur.EmployerNum = General.NonQ(command, true);
            }
        }
コード例 #21
0
ファイル: Printers.cs プロジェクト: luisurbinanet/apolloniax
        ///<summary></summary>
        private static void Insert(Printer cur)
        {
            if (PrefB.RandomKeys)
            {
                cur.PrinterNum = MiscData.GetKey("printer", "PrinterNum");
            }
            string command = "INSERT INTO printer (";

            if (PrefB.RandomKeys)
            {
                command += "PrinterNum,";
            }
            command += "ComputerNum,PrintSit,PrinterName,"
                       + "DisplayPrompt) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(cur.PrinterNum) + "', ";
            }
            command +=
                "'" + POut.PInt(cur.ComputerNum) + "', "
                + "'" + POut.PInt((int)cur.PrintSit) + "', "
                + "'" + POut.PString(cur.PrinterName) + "', "
                + "'" + POut.PBool(cur.DisplayPrompt) + "')";
            //MessageBox.Show(string command);
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                cur.PrinterNum = General.NonQ(command, true);
            }
        }
コード例 #22
0
        ///<summary></summary>
        public static void Insert(Deposit dep)
        {
            if (PrefB.RandomKeys)
            {
                dep.DepositNum = MiscData.GetKey("deposit", "DepositNum");
            }
            string command = "INSERT INTO deposit (";

            if (PrefB.RandomKeys)
            {
                command += "DepositNum,";
            }
            command += "DateDeposit,BankAccountInfo,Amount) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(dep.DepositNum) + "', ";
            }
            command +=
                POut.PDate(dep.DateDeposit) + ", "
                + "'" + POut.PString(dep.BankAccountInfo) + "', "
                + "'" + POut.PDouble(dep.Amount) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                dep.DepositNum = General.NonQ(command, true);
            }
        }
コード例 #23
0
        ///<summary>ONLY use this if compname is not already present</summary>
        public static void Insert(Computer comp)
        {
            if (PrefB.RandomKeys)
            {
                comp.ComputerNum = MiscData.GetKey("computer", "ComputerNum");
            }
            string command = "INSERT INTO computer (";

            if (PrefB.RandomKeys)
            {
                command += "ComputerNum,";
            }
            command += "CompName"
                       + ") VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(comp.ComputerNum) + "', ";
            }
            command +=
                "'" + POut.PString(comp.CompName) + "')";
            //+"'"+POut.PString(PrinterName)+"')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                comp.ComputerNum = General.NonQ(command, true);
            }
        }
コード例 #24
0
        ///<summary></summary>
        public static void Insert(ReqNeeded req)
        {
            if (PrefB.RandomKeys)
            {
                req.ReqNeededNum = MiscData.GetKey("reqneeded", "ReqNeededNum");
            }
            string command = "INSERT INTO reqneeded (";

            if (PrefB.RandomKeys)
            {
                command += "ReqNeededNum,";
            }
            command += "Descript,SchoolCourseNum,SchoolClassNum) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(req.ReqNeededNum) + "', ";
            }
            command +=
                "'" + POut.PString(req.Descript) + "', "
                + "'" + POut.PInt(req.SchoolCourseNum) + "', "
                + "'" + POut.PInt(req.SchoolClassNum) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                req.ReqNeededNum = General.NonQ(command, true);
            }
        }
コード例 #25
0
        ///<summary></summary>
        public static void Insert(PerioExam Cur)
        {
            if (PrefB.RandomKeys)
            {
                Cur.PerioExamNum = MiscData.GetKey("perioexam", "PerioExamNum");
            }
            string command = "INSERT INTO perioexam (";

            if (PrefB.RandomKeys)
            {
                command += "PerioExamNum,";
            }
            command += "PatNum,ExamDate,ProvNum"
                       + ") VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(Cur.PerioExamNum) + "', ";
            }
            command +=
                "'" + POut.PInt(Cur.PatNum) + "', "
                + POut.PDate(Cur.ExamDate) + ", "
                + "'" + POut.PInt(Cur.ProvNum) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                Cur.PerioExamNum = General.NonQ(command, true);
            }
        }
コード例 #26
0
        ///<summary></summary>
        private static void Insert(CanadianExtract cur)
        {
            if (PrefB.RandomKeys)
            {
                cur.CanadianExtractNum = MiscData.GetKey("canadianextract", "CanadianExtractNum");
            }
            string command = "INSERT INTO canadianextract (";

            if (PrefB.RandomKeys)
            {
                command += "CanadianExtractNum,";
            }
            command += "ClaimNum,ToothNum,DateExtraction) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(cur.CanadianExtractNum) + "', ";
            }
            command +=
                "'" + POut.PInt(cur.ClaimNum) + "', "
                + "'" + POut.PString(cur.ToothNum) + "', "
                + POut.PDate(cur.DateExtraction) + ")";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                cur.CanadianExtractNum = General.NonQ(command, true);
            }
        }
コード例 #27
0
        ///<summary></summary>
        public static void Insert(EmailTemplate template)
        {
            if (PrefB.RandomKeys)
            {
                template.EmailTemplateNum = MiscData.GetKey("emailtemplate", "EmailTemplateNum");
            }
            string command = "INSERT INTO emailtemplate (";

            if (PrefB.RandomKeys)
            {
                command += "EmailTemplateNum,";
            }
            command += "Subject,BodyText"
                       + ") VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(template.EmailTemplateNum) + "', ";
            }
            command +=
                "'" + POut.PString(template.Subject) + "', "
                + "'" + POut.PString(template.BodyText) + "')";
            //MessageBox.Show(string command);
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                template.EmailTemplateNum = General.NonQ(command, true);
            }
        }
コード例 #28
0
        ///<summary></summary>
        public static void Insert(ClockEvent ce)
        {
            if (PrefB.RandomKeys)
            {
                ce.ClockEventNum = MiscData.GetKey("clockevent", "ClockEventNum");
            }
            string command = "INSERT INTO clockevent (";

            if (PrefB.RandomKeys)
            {
                command += "ClockEventNum,";
            }
            command += "EmployeeNum,TimeEntered,TimeDisplayed,ClockIn"
                       + ",ClockStatus,Note) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(ce.ClockEventNum) + "', ";
            }
            command +=
                "'" + POut.PInt(ce.EmployeeNum) + "', "
                + POut.PDateT(ce.TimeEntered) + ", "
                + POut.PDateT(ce.TimeDisplayed) + ", "
                + "'" + POut.PBool(ce.ClockIn) + "', "
                + "'" + POut.PInt((int)ce.ClockStatus) + "', "
                + "'" + POut.PString(ce.Note) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                ce.ClockEventNum = General.NonQ(command, true);
            }
        }
コード例 #29
0
        ///<summary></summary>
        public static void Insert(TimeAdjust adj)
        {
            if (PrefB.RandomKeys)
            {
                adj.TimeAdjustNum = MiscData.GetKey("timeadjust", "TimeAdjustNum");
            }
            string command = "INSERT INTO timeadjust (";

            if (PrefB.RandomKeys)
            {
                command += "TimeAdjustNum,";
            }
            command += "EmployeeNum,TimeEntry,RegHours,OTimeHours,Note) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(adj.TimeAdjustNum) + "', ";
            }
            command +=
                "'" + POut.PInt(adj.EmployeeNum) + "', "
                + POut.PDateT(adj.TimeEntry) + ", "
                + "'" + POut.PDouble(adj.RegHours.TotalHours) + "', "
                + "'" + POut.PDouble(adj.OTimeHours.TotalHours) + "', "
                + "'" + POut.PString(adj.Note) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                adj.TimeAdjustNum = General.NonQ(command, true);
            }
        }
コード例 #30
0
ファイル: Letters.cs プロジェクト: luisurbinanet/gnudental
        ///<summary></summary>
        public static void Insert(Letter Cur)
        {
            if (PrefB.RandomKeys)
            {
                Cur.LetterNum = MiscData.GetKey("letter", "LetterNum");
            }
            string command = "INSERT INTO letter (";

            if (PrefB.RandomKeys)
            {
                command += "LetterNum,";
            }
            command += "Description,BodyText) VALUES(";
            if (PrefB.RandomKeys)
            {
                command += "'" + POut.PInt(Cur.LetterNum) + "', ";
            }
            command +=
                "'" + POut.PString(Cur.Description) + "', "
                + "'" + POut.PString(Cur.BodyText) + "')";
            if (PrefB.RandomKeys)
            {
                General.NonQ(command);
            }
            else
            {
                Cur.LetterNum = General.NonQ(command, true);
            }
        }