Пример #1
0
		///<summary>Updates one MedicationPatm in the database.</summary>
		internal static void Update(MedicationPatm medicationPatm){
			string command="UPDATE medicationpatm SET "
				+"PatNum          =  "+POut.Long  (medicationPatm.PatNum)+", "
				+"MedicationNum   =  "+POut.Long  (medicationPatm.MedicationNum)+", "
				+"PatNote         = '"+POut.String(medicationPatm.PatNote)+"', "
				+"DateStart       =  "+POut.Date  (medicationPatm.DateStart)+", "
				+"DateStop        =  "+POut.Date  (medicationPatm.DateStop)+" "
				+"WHERE CustomerNum = "+POut.Long(medicationPatm.CustomerNum)+" AND MedicationPatNum = "+POut.Long(medicationPatm.MedicationPatNum);
			Db.NonQ(command);
		}
Пример #2
0
        ///<summary>Updates one MedicationPatm in the database.</summary>
        internal static void Update(MedicationPatm medicationPatm)
        {
            string command = "UPDATE medicationpatm SET "
                             + "PatNum          =  " + POut.Long(medicationPatm.PatNum) + ", "
                             + "MedicationNum   =  " + POut.Long(medicationPatm.MedicationNum) + ", "
                             + "PatNote         = '" + POut.String(medicationPatm.PatNote) + "', "
                             + "DateStart       =  " + POut.Date(medicationPatm.DateStart) + ", "
                             + "DateStop        =  " + POut.Date(medicationPatm.DateStop) + " "
                             + "WHERE CustomerNum = " + POut.Long(medicationPatm.CustomerNum) + " AND MedicationPatNum = " + POut.Long(medicationPatm.MedicationPatNum);

            Db.NonQ(command);
        }
Пример #3
0
        ///<summary>Converts one MedicationPat object to its mobile equivalent.  Warning! CustomerNum will always be 0.</summary>
        internal static MedicationPatm ConvertToM(MedicationPat medicationPat)
        {
            MedicationPatm medicationPatm = new MedicationPatm();

            //CustomerNum cannot be set.  Remains 0.
            medicationPatm.MedicationPatNum = medicationPat.MedicationPatNum;
            medicationPatm.PatNum           = medicationPat.PatNum;
            medicationPatm.MedicationNum    = medicationPat.MedicationNum;
            medicationPatm.PatNote          = medicationPat.PatNote;
            medicationPatm.DateStart        = medicationPat.DateStart;
            medicationPatm.DateStop         = medicationPat.DateStop;
            return(medicationPatm);
        }
Пример #4
0
		///<summary>Converts a DataTable to a list of objects.</summary>
		internal static List<MedicationPatm> TableToList(DataTable table){
			List<MedicationPatm> retVal=new List<MedicationPatm>();
			MedicationPatm medicationPatm;
			for(int i=0;i<table.Rows.Count;i++) {
				medicationPatm=new MedicationPatm();
				medicationPatm.CustomerNum     = PIn.Long  (table.Rows[i]["CustomerNum"].ToString());
				medicationPatm.MedicationPatNum= PIn.Long  (table.Rows[i]["MedicationPatNum"].ToString());
				medicationPatm.PatNum          = PIn.Long  (table.Rows[i]["PatNum"].ToString());
				medicationPatm.MedicationNum   = PIn.Long  (table.Rows[i]["MedicationNum"].ToString());
				medicationPatm.PatNote         = PIn.String(table.Rows[i]["PatNote"].ToString());
				medicationPatm.DateStart       = PIn.Date  (table.Rows[i]["DateStart"].ToString());
				medicationPatm.DateStop        = PIn.Date  (table.Rows[i]["DateStop"].ToString());
				retVal.Add(medicationPatm);
			}
			return retVal;
		}
Пример #5
0
		///<summary>Usually set useExistingPK=true.  Inserts one MedicationPatm into the database.</summary>
		internal static long Insert(MedicationPatm medicationPatm,bool useExistingPK){
			if(!useExistingPK) {
				medicationPatm.MedicationPatNum=ReplicationServers.GetKey("medicationpatm","MedicationPatNum");
			}
			string command="INSERT INTO medicationpatm (";
			command+="MedicationPatNum,";
			command+="CustomerNum,PatNum,MedicationNum,PatNote,DateStart,DateStop) VALUES(";
			command+=POut.Long(medicationPatm.MedicationPatNum)+",";
			command+=
				     POut.Long  (medicationPatm.CustomerNum)+","
				+    POut.Long  (medicationPatm.PatNum)+","
				+    POut.Long  (medicationPatm.MedicationNum)+","
				+"'"+POut.String(medicationPatm.PatNote)+"',"
				+    POut.Date  (medicationPatm.DateStart)+","
				+    POut.Date  (medicationPatm.DateStop)+")";
			Db.NonQ(command);//There is no autoincrement in the mobile server.
			return medicationPatm.MedicationPatNum;
		}
Пример #6
0
        ///<summary>Converts a DataTable to a list of objects.</summary>
        internal static List <MedicationPatm> TableToList(DataTable table)
        {
            List <MedicationPatm> retVal = new List <MedicationPatm>();
            MedicationPatm        medicationPatm;

            for (int i = 0; i < table.Rows.Count; i++)
            {
                medicationPatm                  = new MedicationPatm();
                medicationPatm.CustomerNum      = PIn.Long(table.Rows[i]["CustomerNum"].ToString());
                medicationPatm.MedicationPatNum = PIn.Long(table.Rows[i]["MedicationPatNum"].ToString());
                medicationPatm.PatNum           = PIn.Long(table.Rows[i]["PatNum"].ToString());
                medicationPatm.MedicationNum    = PIn.Long(table.Rows[i]["MedicationNum"].ToString());
                medicationPatm.PatNote          = PIn.String(table.Rows[i]["PatNote"].ToString());
                medicationPatm.DateStart        = PIn.Date(table.Rows[i]["DateStart"].ToString());
                medicationPatm.DateStop         = PIn.Date(table.Rows[i]["DateStop"].ToString());
                retVal.Add(medicationPatm);
            }
            return(retVal);
        }
Пример #7
0
        ///<summary>Usually set useExistingPK=true.  Inserts one MedicationPatm into the database.</summary>
        internal static long Insert(MedicationPatm medicationPatm, bool useExistingPK)
        {
            if (!useExistingPK)
            {
                medicationPatm.MedicationPatNum = ReplicationServers.GetKey("medicationpatm", "MedicationPatNum");
            }
            string command = "INSERT INTO medicationpatm (";

            command += "MedicationPatNum,";
            command += "CustomerNum,PatNum,MedicationNum,PatNote,DateStart,DateStop) VALUES(";
            command += POut.Long(medicationPatm.MedicationPatNum) + ",";
            command +=
                POut.Long(medicationPatm.CustomerNum) + ","
                + POut.Long(medicationPatm.PatNum) + ","
                + POut.Long(medicationPatm.MedicationNum) + ","
                + "'" + POut.String(medicationPatm.PatNote) + "',"
                + POut.Date(medicationPatm.DateStart) + ","
                + POut.Date(medicationPatm.DateStop) + ")";
            Db.NonQ(command);            //There is no autoincrement in the mobile server.
            return(medicationPatm.MedicationPatNum);
        }
Пример #8
0
		///<summary>Converts one MedicationPat object to its mobile equivalent.  Warning! CustomerNum will always be 0.</summary>
		internal static MedicationPatm ConvertToM(MedicationPat medicationPat){
			MedicationPatm medicationPatm=new MedicationPatm();
			//CustomerNum cannot be set.  Remains 0.
			medicationPatm.MedicationPatNum=medicationPat.MedicationPatNum;
			medicationPatm.PatNum          =medicationPat.PatNum;
			medicationPatm.MedicationNum   =medicationPat.MedicationNum;
			medicationPatm.PatNote         =medicationPat.PatNote;
			medicationPatm.DateStart       =medicationPat.DateStart;
			medicationPatm.DateStop        =medicationPat.DateStop;
			return medicationPatm;
		}