///<summary>Updates one ICD9m in the database.</summary>
		internal static void Update(ICD9m iCD9m){
			string command="UPDATE icd9m SET "
				+"ICD9Code   = '"+POut.String(iCD9m.ICD9Code)+"', "
				+"Description= '"+POut.String(iCD9m.Description)+"' "
				+"WHERE CustomerNum = "+POut.Long(iCD9m.CustomerNum)+" AND ICD9Num = "+POut.Long(iCD9m.ICD9Num);
			Db.NonQ(command);
		}
Exemple #2
0
        ///<summary>Updates one ICD9m in the database.</summary>
        internal static void Update(ICD9m iCD9m)
        {
            string command = "UPDATE icd9m SET "
                             + "ICD9Code   = '" + POut.String(iCD9m.ICD9Code) + "', "
                             + "Description= '" + POut.String(iCD9m.Description) + "' "
                             + "WHERE CustomerNum = " + POut.Long(iCD9m.CustomerNum) + " AND ICD9Num = " + POut.Long(iCD9m.ICD9Num);

            Db.NonQ(command);
        }
Exemple #3
0
        ///<summary>Converts one ICD9 object to its mobile equivalent.  Warning! CustomerNum will always be 0.</summary>
        internal static ICD9m ConvertToM(ICD9 iCD9)
        {
            ICD9m iCD9m = new ICD9m();

            //CustomerNum cannot be set.  Remains 0.
            iCD9m.ICD9Num     = iCD9.ICD9Num;
            iCD9m.ICD9Code    = iCD9.ICD9Code;
            iCD9m.Description = iCD9.Description;
            return(iCD9m);
        }
		///<summary>Converts a DataTable to a list of objects.</summary>
		internal static List<ICD9m> TableToList(DataTable table){
			List<ICD9m> retVal=new List<ICD9m>();
			ICD9m iCD9m;
			for(int i=0;i<table.Rows.Count;i++) {
				iCD9m=new ICD9m();
				iCD9m.CustomerNum= PIn.Long  (table.Rows[i]["CustomerNum"].ToString());
				iCD9m.ICD9Num    = PIn.Long  (table.Rows[i]["ICD9Num"].ToString());
				iCD9m.ICD9Code   = PIn.String(table.Rows[i]["ICD9Code"].ToString());
				iCD9m.Description= PIn.String(table.Rows[i]["Description"].ToString());
				retVal.Add(iCD9m);
			}
			return retVal;
		}
		///<summary>Usually set useExistingPK=true.  Inserts one ICD9m into the database.</summary>
		internal static long Insert(ICD9m iCD9m,bool useExistingPK){
			if(!useExistingPK) {
				iCD9m.ICD9Num=ReplicationServers.GetKey("icd9m","ICD9Num");
			}
			string command="INSERT INTO icd9m (";
			command+="ICD9Num,";
			command+="CustomerNum,ICD9Code,Description) VALUES(";
			command+=POut.Long(iCD9m.ICD9Num)+",";
			command+=
				     POut.Long  (iCD9m.CustomerNum)+","
				+"'"+POut.String(iCD9m.ICD9Code)+"',"
				+"'"+POut.String(iCD9m.Description)+"')";
			Db.NonQ(command);//There is no autoincrement in the mobile server.
			return iCD9m.ICD9Num;
		}
Exemple #6
0
        ///<summary>Converts a DataTable to a list of objects.</summary>
        internal static List <ICD9m> TableToList(DataTable table)
        {
            List <ICD9m> retVal = new List <ICD9m>();
            ICD9m        iCD9m;

            for (int i = 0; i < table.Rows.Count; i++)
            {
                iCD9m             = new ICD9m();
                iCD9m.CustomerNum = PIn.Long(table.Rows[i]["CustomerNum"].ToString());
                iCD9m.ICD9Num     = PIn.Long(table.Rows[i]["ICD9Num"].ToString());
                iCD9m.ICD9Code    = PIn.String(table.Rows[i]["ICD9Code"].ToString());
                iCD9m.Description = PIn.String(table.Rows[i]["Description"].ToString());
                retVal.Add(iCD9m);
            }
            return(retVal);
        }
Exemple #7
0
        ///<summary>Usually set useExistingPK=true.  Inserts one ICD9m into the database.</summary>
        internal static long Insert(ICD9m iCD9m, bool useExistingPK)
        {
            if (!useExistingPK)
            {
                iCD9m.ICD9Num = ReplicationServers.GetKey("icd9m", "ICD9Num");
            }
            string command = "INSERT INTO icd9m (";

            command += "ICD9Num,";
            command += "CustomerNum,ICD9Code,Description) VALUES(";
            command += POut.Long(iCD9m.ICD9Num) + ",";
            command +=
                POut.Long(iCD9m.CustomerNum) + ","
                + "'" + POut.String(iCD9m.ICD9Code) + "',"
                + "'" + POut.String(iCD9m.Description) + "')";
            Db.NonQ(command);            //There is no autoincrement in the mobile server.
            return(iCD9m.ICD9Num);
        }
		///<summary>Converts one ICD9 object to its mobile equivalent.  Warning! CustomerNum will always be 0.</summary>
		internal static ICD9m ConvertToM(ICD9 iCD9){
			ICD9m iCD9m=new ICD9m();
			//CustomerNum cannot be set.  Remains 0.
			iCD9m.ICD9Num    =iCD9.ICD9Num;
			iCD9m.ICD9Code   =iCD9.ICD9Code;
			iCD9m.Description=iCD9.Description;
			return iCD9m;
		}