Beispiel #1
0
        ///<summary>Updates one Recallm in the database.</summary>
        internal static void Update(Recallm recallm)
        {
            string command = "UPDATE recallm SET "
                             + "PatNum             =  " + POut.Long(recallm.PatNum) + ", "
                             + "DateDue            =  " + POut.Date(recallm.DateDue) + ", "
                             + "DatePrevious       =  " + POut.Date(recallm.DatePrevious) + ", "
                             + "RecallStatus       =  " + POut.Long(recallm.RecallStatus) + ", "
                             + "Note               = '" + POut.String(recallm.Note) + "', "
                             + "IsDisabled         =  " + POut.Bool(recallm.IsDisabled) + ", "
                             + "DisableUntilBalance= '" + POut.Double(recallm.DisableUntilBalance) + "', "
                             + "DisableUntilDate   =  " + POut.Date(recallm.DisableUntilDate) + " "
                             + "WHERE CustomerNum = " + POut.Long(recallm.CustomerNum) + " AND RecallNum = " + POut.Long(recallm.RecallNum);

            Db.NonQ(command);
        }
Beispiel #2
0
        ///<summary>Converts one Recall object to its mobile equivalent.  Warning! CustomerNum will always be 0.</summary>
        internal static Recallm ConvertToM(Recall recall)
        {
            Recallm recallm = new Recallm();

            //CustomerNum cannot be set.  Remains 0.
            recallm.RecallNum           = recall.RecallNum;
            recallm.PatNum              = recall.PatNum;
            recallm.DateDue             = recall.DateDue;
            recallm.DatePrevious        = recall.DatePrevious;
            recallm.RecallStatus        = recall.RecallStatus;
            recallm.Note                = recall.Note;
            recallm.IsDisabled          = recall.IsDisabled;
            recallm.DisableUntilBalance = recall.DisableUntilBalance;
            recallm.DisableUntilDate    = recall.DisableUntilDate;
            return(recallm);
        }
		///<summary>Converts a DataTable to a list of objects.</summary>
		internal static List<Recallm> TableToList(DataTable table){
			List<Recallm> retVal=new List<Recallm>();
			Recallm recallm;
			for(int i=0;i<table.Rows.Count;i++) {
				recallm=new Recallm();
				recallm.CustomerNum        = PIn.Long  (table.Rows[i]["CustomerNum"].ToString());
				recallm.RecallNum          = PIn.Long  (table.Rows[i]["RecallNum"].ToString());
				recallm.PatNum             = PIn.Long  (table.Rows[i]["PatNum"].ToString());
				recallm.DateDue            = PIn.Date  (table.Rows[i]["DateDue"].ToString());
				recallm.DatePrevious       = PIn.Date  (table.Rows[i]["DatePrevious"].ToString());
				recallm.RecallStatus       = PIn.Long  (table.Rows[i]["RecallStatus"].ToString());
				recallm.Note               = PIn.String(table.Rows[i]["Note"].ToString());
				recallm.IsDisabled         = PIn.Bool  (table.Rows[i]["IsDisabled"].ToString());
				recallm.DisableUntilBalance= PIn.Double(table.Rows[i]["DisableUntilBalance"].ToString());
				recallm.DisableUntilDate   = PIn.Date  (table.Rows[i]["DisableUntilDate"].ToString());
				retVal.Add(recallm);
			}
			return retVal;
		}
		///<summary>Usually set useExistingPK=true.  Inserts one Recallm into the database.</summary>
		internal static long Insert(Recallm recallm,bool useExistingPK){
			if(!useExistingPK) {
				recallm.RecallNum=ReplicationServers.GetKey("recallm","RecallNum");
			}
			string command="INSERT INTO recallm (";
			command+="RecallNum,";
			command+="CustomerNum,PatNum,DateDue,DatePrevious,RecallStatus,Note,IsDisabled,DisableUntilBalance,DisableUntilDate) VALUES(";
			command+=POut.Long(recallm.RecallNum)+",";
			command+=
				     POut.Long  (recallm.CustomerNum)+","
				+    POut.Long  (recallm.PatNum)+","
				+    POut.Date  (recallm.DateDue)+","
				+    POut.Date  (recallm.DatePrevious)+","
				+    POut.Long  (recallm.RecallStatus)+","
				+"'"+POut.String(recallm.Note)+"',"
				+    POut.Bool  (recallm.IsDisabled)+","
				+"'"+POut.Double(recallm.DisableUntilBalance)+"',"
				+    POut.Date  (recallm.DisableUntilDate)+")";
			Db.NonQ(command);//There is no autoincrement in the mobile server.
			return recallm.RecallNum;
		}
Beispiel #5
0
        ///<summary>Converts a DataTable to a list of objects.</summary>
        internal static List <Recallm> TableToList(DataTable table)
        {
            List <Recallm> retVal = new List <Recallm>();
            Recallm        recallm;

            for (int i = 0; i < table.Rows.Count; i++)
            {
                recallm                     = new Recallm();
                recallm.CustomerNum         = PIn.Long(table.Rows[i]["CustomerNum"].ToString());
                recallm.RecallNum           = PIn.Long(table.Rows[i]["RecallNum"].ToString());
                recallm.PatNum              = PIn.Long(table.Rows[i]["PatNum"].ToString());
                recallm.DateDue             = PIn.Date(table.Rows[i]["DateDue"].ToString());
                recallm.DatePrevious        = PIn.Date(table.Rows[i]["DatePrevious"].ToString());
                recallm.RecallStatus        = PIn.Long(table.Rows[i]["RecallStatus"].ToString());
                recallm.Note                = PIn.String(table.Rows[i]["Note"].ToString());
                recallm.IsDisabled          = PIn.Bool(table.Rows[i]["IsDisabled"].ToString());
                recallm.DisableUntilBalance = PIn.Double(table.Rows[i]["DisableUntilBalance"].ToString());
                recallm.DisableUntilDate    = PIn.Date(table.Rows[i]["DisableUntilDate"].ToString());
                retVal.Add(recallm);
            }
            return(retVal);
        }
Beispiel #6
0
        ///<summary>Usually set useExistingPK=true.  Inserts one Recallm into the database.</summary>
        internal static long Insert(Recallm recallm, bool useExistingPK)
        {
            if (!useExistingPK)
            {
                recallm.RecallNum = ReplicationServers.GetKey("recallm", "RecallNum");
            }
            string command = "INSERT INTO recallm (";

            command += "RecallNum,";
            command += "CustomerNum,PatNum,DateDue,DatePrevious,RecallStatus,Note,IsDisabled,DisableUntilBalance,DisableUntilDate) VALUES(";
            command += POut.Long(recallm.RecallNum) + ",";
            command +=
                POut.Long(recallm.CustomerNum) + ","
                + POut.Long(recallm.PatNum) + ","
                + POut.Date(recallm.DateDue) + ","
                + POut.Date(recallm.DatePrevious) + ","
                + POut.Long(recallm.RecallStatus) + ","
                + "'" + POut.String(recallm.Note) + "',"
                + POut.Bool(recallm.IsDisabled) + ","
                + "'" + POut.Double(recallm.DisableUntilBalance) + "',"
                + POut.Date(recallm.DisableUntilDate) + ")";
            Db.NonQ(command);            //There is no autoincrement in the mobile server.
            return(recallm.RecallNum);
        }
		///<summary>Updates one Recallm in the database.</summary>
		internal static void Update(Recallm recallm){
			string command="UPDATE recallm SET "
				+"PatNum             =  "+POut.Long  (recallm.PatNum)+", "
				+"DateDue            =  "+POut.Date  (recallm.DateDue)+", "
				+"DatePrevious       =  "+POut.Date  (recallm.DatePrevious)+", "
				+"RecallStatus       =  "+POut.Long  (recallm.RecallStatus)+", "
				+"Note               = '"+POut.String(recallm.Note)+"', "
				+"IsDisabled         =  "+POut.Bool  (recallm.IsDisabled)+", "
				+"DisableUntilBalance= '"+POut.Double(recallm.DisableUntilBalance)+"', "
				+"DisableUntilDate   =  "+POut.Date  (recallm.DisableUntilDate)+" "
				+"WHERE CustomerNum = "+POut.Long(recallm.CustomerNum)+" AND RecallNum = "+POut.Long(recallm.RecallNum);
			Db.NonQ(command);
		}
		///<summary>Converts one Recall object to its mobile equivalent.  Warning! CustomerNum will always be 0.</summary>
		internal static Recallm ConvertToM(Recall recall){
			Recallm recallm=new Recallm();
			//CustomerNum cannot be set.  Remains 0.
			recallm.RecallNum          =recall.RecallNum;
			recallm.PatNum             =recall.PatNum;
			recallm.DateDue            =recall.DateDue;
			recallm.DatePrevious       =recall.DatePrevious;
			recallm.RecallStatus       =recall.RecallStatus;
			recallm.Note               =recall.Note;
			recallm.IsDisabled         =recall.IsDisabled;
			recallm.DisableUntilBalance=recall.DisableUntilBalance;
			recallm.DisableUntilDate   =recall.DisableUntilDate;
			return recallm;
		}