Esempio n. 1
0
		///<summary>Updates one Diseasem in the database.</summary>
		internal static void Update(Diseasem diseasem){
			string command="UPDATE diseasem SET "
				+"PatNum       =  "+POut.Long  (diseasem.PatNum)+", "
				+"DiseaseDefNum=  "+POut.Long  (diseasem.DiseaseDefNum)+", "
				+"PatNote      = '"+POut.String(diseasem.PatNote)+"', "
				+"ICD9Num      =  "+POut.Long  (diseasem.ICD9Num)+", "
				+"ProbStatus   =  "+POut.Int   ((int)diseasem.ProbStatus)+", "
				+"DateStart    =  "+POut.Date  (diseasem.DateStart)+", "
				+"DateStop     =  "+POut.Date  (diseasem.DateStop)+" "
				+"WHERE CustomerNum = "+POut.Long(diseasem.CustomerNum)+" AND DiseaseNum = "+POut.Long(diseasem.DiseaseNum);
			Db.NonQ(command);
		}
Esempio n. 2
0
        ///<summary>Updates one Diseasem in the database.</summary>
        internal static void Update(Diseasem diseasem)
        {
            string command = "UPDATE diseasem SET "
                             + "PatNum       =  " + POut.Long(diseasem.PatNum) + ", "
                             + "DiseaseDefNum=  " + POut.Long(diseasem.DiseaseDefNum) + ", "
                             + "PatNote      = '" + POut.String(diseasem.PatNote) + "', "
                             + "ICD9Num      =  " + POut.Long(diseasem.ICD9Num) + ", "
                             + "ProbStatus   =  " + POut.Int((int)diseasem.ProbStatus) + ", "
                             + "DateStart    =  " + POut.Date(diseasem.DateStart) + ", "
                             + "DateStop     =  " + POut.Date(diseasem.DateStop) + " "
                             + "WHERE CustomerNum = " + POut.Long(diseasem.CustomerNum) + " AND DiseaseNum = " + POut.Long(diseasem.DiseaseNum);

            Db.NonQ(command);
        }
Esempio n. 3
0
 ///<summary>Converts one Disease object to its mobile equivalent.  Warning! CustomerNum will always be 0.</summary>
 internal static Diseasem ConvertToM(Disease disease)
 {
     Diseasem diseasem=new Diseasem();
     //CustomerNum cannot be set.  Remains 0.
     diseasem.DiseaseNum   =disease.DiseaseNum;
     diseasem.PatNum       =disease.PatNum;
     diseasem.DiseaseDefNum=disease.DiseaseDefNum;
     diseasem.PatNote      =disease.PatNote;
     diseasem.ICD9Num      =disease.ICD9Num;
     diseasem.ProbStatus   =disease.ProbStatus;
     diseasem.DateStart    =disease.DateStart;
     diseasem.DateStop     =disease.DateStop;
     return diseasem;
 }
Esempio n. 4
0
        ///<summary>Converts one Disease object to its mobile equivalent.  Warning! CustomerNum will always be 0.</summary>
        internal static Diseasem ConvertToM(Disease disease)
        {
            Diseasem diseasem = new Diseasem();

            //CustomerNum cannot be set.  Remains 0.
            diseasem.DiseaseNum    = disease.DiseaseNum;
            diseasem.PatNum        = disease.PatNum;
            diseasem.DiseaseDefNum = disease.DiseaseDefNum;
            diseasem.PatNote       = disease.PatNote;
            diseasem.ICD9Num       = disease.ICD9Num;
            diseasem.ProbStatus    = disease.ProbStatus;
            diseasem.DateStart     = disease.DateStart;
            diseasem.DateStop      = disease.DateStop;
            return(diseasem);
        }
Esempio n. 5
0
		///<summary>Converts a DataTable to a list of objects.</summary>
		internal static List<Diseasem> TableToList(DataTable table){
			List<Diseasem> retVal=new List<Diseasem>();
			Diseasem diseasem;
			for(int i=0;i<table.Rows.Count;i++) {
				diseasem=new Diseasem();
				diseasem.CustomerNum  = PIn.Long  (table.Rows[i]["CustomerNum"].ToString());
				diseasem.DiseaseNum   = PIn.Long  (table.Rows[i]["DiseaseNum"].ToString());
				diseasem.PatNum       = PIn.Long  (table.Rows[i]["PatNum"].ToString());
				diseasem.DiseaseDefNum= PIn.Long  (table.Rows[i]["DiseaseDefNum"].ToString());
				diseasem.PatNote      = PIn.String(table.Rows[i]["PatNote"].ToString());
				diseasem.ICD9Num      = PIn.Long  (table.Rows[i]["ICD9Num"].ToString());
				diseasem.ProbStatus   = (ProblemStatus)PIn.Int(table.Rows[i]["ProbStatus"].ToString());
				diseasem.DateStart    = PIn.Date  (table.Rows[i]["DateStart"].ToString());
				diseasem.DateStop     = PIn.Date  (table.Rows[i]["DateStop"].ToString());
				retVal.Add(diseasem);
			}
			return retVal;
		}
Esempio n. 6
0
		///<summary>Usually set useExistingPK=true.  Inserts one Diseasem into the database.</summary>
		internal static long Insert(Diseasem diseasem,bool useExistingPK){
			if(!useExistingPK) {
				diseasem.DiseaseNum=ReplicationServers.GetKey("diseasem","DiseaseNum");
			}
			string command="INSERT INTO diseasem (";
			command+="DiseaseNum,";
			command+="CustomerNum,PatNum,DiseaseDefNum,PatNote,ICD9Num,ProbStatus,DateStart,DateStop) VALUES(";
			command+=POut.Long(diseasem.DiseaseNum)+",";
			command+=
				     POut.Long  (diseasem.CustomerNum)+","
				+    POut.Long  (diseasem.PatNum)+","
				+    POut.Long  (diseasem.DiseaseDefNum)+","
				+"'"+POut.String(diseasem.PatNote)+"',"
				+    POut.Long  (diseasem.ICD9Num)+","
				+    POut.Int   ((int)diseasem.ProbStatus)+","
				+    POut.Date  (diseasem.DateStart)+","
				+    POut.Date  (diseasem.DateStop)+")";
			Db.NonQ(command);//There is no autoincrement in the mobile server.
			return diseasem.DiseaseNum;
		}
Esempio n. 7
0
        ///<summary>Converts a DataTable to a list of objects.</summary>
        internal static List <Diseasem> TableToList(DataTable table)
        {
            List <Diseasem> retVal = new List <Diseasem>();
            Diseasem        diseasem;

            for (int i = 0; i < table.Rows.Count; i++)
            {
                diseasem               = new Diseasem();
                diseasem.CustomerNum   = PIn.Long(table.Rows[i]["CustomerNum"].ToString());
                diseasem.DiseaseNum    = PIn.Long(table.Rows[i]["DiseaseNum"].ToString());
                diseasem.PatNum        = PIn.Long(table.Rows[i]["PatNum"].ToString());
                diseasem.DiseaseDefNum = PIn.Long(table.Rows[i]["DiseaseDefNum"].ToString());
                diseasem.PatNote       = PIn.String(table.Rows[i]["PatNote"].ToString());
                diseasem.ICD9Num       = PIn.Long(table.Rows[i]["ICD9Num"].ToString());
                diseasem.ProbStatus    = (ProblemStatus)PIn.Int(table.Rows[i]["ProbStatus"].ToString());
                diseasem.DateStart     = PIn.Date(table.Rows[i]["DateStart"].ToString());
                diseasem.DateStop      = PIn.Date(table.Rows[i]["DateStop"].ToString());
                retVal.Add(diseasem);
            }
            return(retVal);
        }
Esempio n. 8
0
        ///<summary>Usually set useExistingPK=true.  Inserts one Diseasem into the database.</summary>
        internal static long Insert(Diseasem diseasem, bool useExistingPK)
        {
            if (!useExistingPK)
            {
                diseasem.DiseaseNum = ReplicationServers.GetKey("diseasem", "DiseaseNum");
            }
            string command = "INSERT INTO diseasem (";

            command += "DiseaseNum,";
            command += "CustomerNum,PatNum,DiseaseDefNum,PatNote,ICD9Num,ProbStatus,DateStart,DateStop) VALUES(";
            command += POut.Long(diseasem.DiseaseNum) + ",";
            command +=
                POut.Long(diseasem.CustomerNum) + ","
                + POut.Long(diseasem.PatNum) + ","
                + POut.Long(diseasem.DiseaseDefNum) + ","
                + "'" + POut.String(diseasem.PatNote) + "',"
                + POut.Long(diseasem.ICD9Num) + ","
                + POut.Int((int)diseasem.ProbStatus) + ","
                + POut.Date(diseasem.DateStart) + ","
                + POut.Date(diseasem.DateStop) + ")";
            Db.NonQ(command);            //There is no autoincrement in the mobile server.
            return(diseasem.DiseaseNum);
        }