///<summary>Updates one LabResultm in the database.</summary> internal static void Update(LabResultm labResultm) { string command = "UPDATE labresultm SET " + "LabPanelNum = " + POut.Long(labResultm.LabPanelNum) + ", " + "DateTimeTest= " + POut.DateT(labResultm.DateTimeTest) + ", " + "TestName = '" + POut.String(labResultm.TestName) + "', " + "TestID = '" + POut.String(labResultm.TestID) + "', " + "ObsValue = '" + POut.String(labResultm.ObsValue) + "', " + "ObsUnits = '" + POut.String(labResultm.ObsUnits) + "', " + "ObsRange = '" + POut.String(labResultm.ObsRange) + "', " + "AbnormalFlag= " + POut.Int((int)labResultm.AbnormalFlag) + " " + "WHERE CustomerNum = " + POut.Long(labResultm.CustomerNum) + " AND LabResultNum = " + POut.Long(labResultm.LabResultNum); Db.NonQ(command); }
///<summary>Converts one LabResult object to its mobile equivalent. Warning! CustomerNum will always be 0.</summary> internal static LabResultm ConvertToM(LabResult labResult) { LabResultm labResultm = new LabResultm(); //CustomerNum cannot be set. Remains 0. labResultm.LabResultNum = labResult.LabResultNum; labResultm.LabPanelNum = labResult.LabPanelNum; labResultm.DateTimeTest = labResult.DateTimeTest; labResultm.TestName = labResult.TestName; labResultm.TestID = labResult.TestID; labResultm.ObsValue = labResult.ObsValue; labResultm.ObsUnits = labResult.ObsUnits; labResultm.ObsRange = labResult.ObsRange; labResultm.AbnormalFlag = labResult.AbnormalFlag; return(labResultm); }
///<summary>Converts a DataTable to a list of objects.</summary> internal static List<LabResultm> TableToList(DataTable table){ List<LabResultm> retVal=new List<LabResultm>(); LabResultm labResultm; for(int i=0;i<table.Rows.Count;i++) { labResultm=new LabResultm(); labResultm.CustomerNum = PIn.Long (table.Rows[i]["CustomerNum"].ToString()); labResultm.LabResultNum= PIn.Long (table.Rows[i]["LabResultNum"].ToString()); labResultm.LabPanelNum = PIn.Long (table.Rows[i]["LabPanelNum"].ToString()); labResultm.DateTimeTest= PIn.DateT (table.Rows[i]["DateTimeTest"].ToString()); labResultm.TestName = PIn.String(table.Rows[i]["TestName"].ToString()); labResultm.TestID = PIn.String(table.Rows[i]["TestID"].ToString()); labResultm.ObsValue = PIn.String(table.Rows[i]["ObsValue"].ToString()); labResultm.ObsUnits = PIn.String(table.Rows[i]["ObsUnits"].ToString()); labResultm.ObsRange = PIn.String(table.Rows[i]["ObsRange"].ToString()); labResultm.AbnormalFlag= (LabAbnormalFlag)PIn.Int(table.Rows[i]["AbnormalFlag"].ToString()); retVal.Add(labResultm); } return retVal; }
///<summary>Usually set useExistingPK=true. Inserts one LabResultm into the database.</summary> internal static long Insert(LabResultm labResultm,bool useExistingPK){ if(!useExistingPK) { labResultm.LabResultNum=ReplicationServers.GetKey("labresultm","LabResultNum"); } string command="INSERT INTO labresultm ("; command+="LabResultNum,"; command+="CustomerNum,LabPanelNum,DateTimeTest,TestName,TestID,ObsValue,ObsUnits,ObsRange,AbnormalFlag) VALUES("; command+=POut.Long(labResultm.LabResultNum)+","; command+= POut.Long (labResultm.CustomerNum)+"," + POut.Long (labResultm.LabPanelNum)+"," + POut.DateT (labResultm.DateTimeTest)+"," +"'"+POut.String(labResultm.TestName)+"'," +"'"+POut.String(labResultm.TestID)+"'," +"'"+POut.String(labResultm.ObsValue)+"'," +"'"+POut.String(labResultm.ObsUnits)+"'," +"'"+POut.String(labResultm.ObsRange)+"'," + POut.Int ((int)labResultm.AbnormalFlag)+")"; Db.NonQ(command);//There is no autoincrement in the mobile server. return labResultm.LabResultNum; }
///<summary>Converts a DataTable to a list of objects.</summary> internal static List <LabResultm> TableToList(DataTable table) { List <LabResultm> retVal = new List <LabResultm>(); LabResultm labResultm; for (int i = 0; i < table.Rows.Count; i++) { labResultm = new LabResultm(); labResultm.CustomerNum = PIn.Long(table.Rows[i]["CustomerNum"].ToString()); labResultm.LabResultNum = PIn.Long(table.Rows[i]["LabResultNum"].ToString()); labResultm.LabPanelNum = PIn.Long(table.Rows[i]["LabPanelNum"].ToString()); labResultm.DateTimeTest = PIn.DateT(table.Rows[i]["DateTimeTest"].ToString()); labResultm.TestName = PIn.String(table.Rows[i]["TestName"].ToString()); labResultm.TestID = PIn.String(table.Rows[i]["TestID"].ToString()); labResultm.ObsValue = PIn.String(table.Rows[i]["ObsValue"].ToString()); labResultm.ObsUnits = PIn.String(table.Rows[i]["ObsUnits"].ToString()); labResultm.ObsRange = PIn.String(table.Rows[i]["ObsRange"].ToString()); labResultm.AbnormalFlag = (LabAbnormalFlag)PIn.Int(table.Rows[i]["AbnormalFlag"].ToString()); retVal.Add(labResultm); } return(retVal); }
///<summary>Usually set useExistingPK=true. Inserts one LabResultm into the database.</summary> internal static long Insert(LabResultm labResultm, bool useExistingPK) { if (!useExistingPK) { labResultm.LabResultNum = ReplicationServers.GetKey("labresultm", "LabResultNum"); } string command = "INSERT INTO labresultm ("; command += "LabResultNum,"; command += "CustomerNum,LabPanelNum,DateTimeTest,TestName,TestID,ObsValue,ObsUnits,ObsRange,AbnormalFlag) VALUES("; command += POut.Long(labResultm.LabResultNum) + ","; command += POut.Long(labResultm.CustomerNum) + "," + POut.Long(labResultm.LabPanelNum) + "," + POut.DateT(labResultm.DateTimeTest) + "," + "'" + POut.String(labResultm.TestName) + "'," + "'" + POut.String(labResultm.TestID) + "'," + "'" + POut.String(labResultm.ObsValue) + "'," + "'" + POut.String(labResultm.ObsUnits) + "'," + "'" + POut.String(labResultm.ObsRange) + "'," + POut.Int((int)labResultm.AbnormalFlag) + ")"; Db.NonQ(command); //There is no autoincrement in the mobile server. return(labResultm.LabResultNum); }
///<summary>Updates one LabResultm in the database.</summary> internal static void Update(LabResultm labResultm){ string command="UPDATE labresultm SET " +"LabPanelNum = "+POut.Long (labResultm.LabPanelNum)+", " +"DateTimeTest= "+POut.DateT (labResultm.DateTimeTest)+", " +"TestName = '"+POut.String(labResultm.TestName)+"', " +"TestID = '"+POut.String(labResultm.TestID)+"', " +"ObsValue = '"+POut.String(labResultm.ObsValue)+"', " +"ObsUnits = '"+POut.String(labResultm.ObsUnits)+"', " +"ObsRange = '"+POut.String(labResultm.ObsRange)+"', " +"AbnormalFlag= "+POut.Int ((int)labResultm.AbnormalFlag)+" " +"WHERE CustomerNum = "+POut.Long(labResultm.CustomerNum)+" AND LabResultNum = "+POut.Long(labResultm.LabResultNum); Db.NonQ(command); }
///<summary>Converts one LabResult object to its mobile equivalent. Warning! CustomerNum will always be 0.</summary> internal static LabResultm ConvertToM(LabResult labResult){ LabResultm labResultm=new LabResultm(); //CustomerNum cannot be set. Remains 0. labResultm.LabResultNum=labResult.LabResultNum; labResultm.LabPanelNum =labResult.LabPanelNum; labResultm.DateTimeTest=labResult.DateTimeTest; labResultm.TestName =labResult.TestName; labResultm.TestID =labResult.TestID; labResultm.ObsValue =labResult.ObsValue; labResultm.ObsUnits =labResult.ObsUnits; labResultm.ObsRange =labResult.ObsRange; labResultm.AbnormalFlag=labResult.AbnormalFlag; return labResultm; }