///<summary>Updates one DiseaseDefm in the database.</summary> internal static void Update(DiseaseDefm diseaseDefm) { string command = "UPDATE diseasedefm SET " + "DiseaseName = '" + POut.String(diseaseDefm.DiseaseName) + "' " + "WHERE CustomerNum = " + POut.Long(diseaseDefm.CustomerNum) + " AND DiseaseDefNum = " + POut.Long(diseaseDefm.DiseaseDefNum); Db.NonQ(command); }
///<summary>Converts one DiseaseDef object to its mobile equivalent. Warning! CustomerNum will always be 0.</summary> internal static DiseaseDefm ConvertToM(DiseaseDef diseaseDef) { DiseaseDefm diseaseDefm = new DiseaseDefm(); //CustomerNum cannot be set. Remains 0. diseaseDefm.DiseaseDefNum = diseaseDef.DiseaseDefNum; diseaseDefm.DiseaseName = diseaseDef.DiseaseName; return(diseaseDefm); }
///<summary>Converts a DataTable to a list of objects.</summary> internal static List<DiseaseDefm> TableToList(DataTable table){ List<DiseaseDefm> retVal=new List<DiseaseDefm>(); DiseaseDefm diseaseDefm; for(int i=0;i<table.Rows.Count;i++) { diseaseDefm=new DiseaseDefm(); diseaseDefm.CustomerNum = PIn.Long (table.Rows[i]["CustomerNum"].ToString()); diseaseDefm.DiseaseDefNum= PIn.Long (table.Rows[i]["DiseaseDefNum"].ToString()); diseaseDefm.DiseaseName = PIn.String(table.Rows[i]["DiseaseName"].ToString()); retVal.Add(diseaseDefm); } return retVal; }
///<summary>Usually set useExistingPK=true. Inserts one DiseaseDefm into the database.</summary> internal static long Insert(DiseaseDefm diseaseDefm,bool useExistingPK){ if(!useExistingPK) { diseaseDefm.DiseaseDefNum=ReplicationServers.GetKey("diseasedefm","DiseaseDefNum"); } string command="INSERT INTO diseasedefm ("; command+="DiseaseDefNum,"; command+="CustomerNum,DiseaseName) VALUES("; command+=POut.Long(diseaseDefm.DiseaseDefNum)+","; command+= POut.Long (diseaseDefm.CustomerNum)+"," +"'"+POut.String(diseaseDefm.DiseaseName)+"')"; Db.NonQ(command);//There is no autoincrement in the mobile server. return diseaseDefm.DiseaseDefNum; }
///<summary>Converts a DataTable to a list of objects.</summary> internal static List <DiseaseDefm> TableToList(DataTable table) { List <DiseaseDefm> retVal = new List <DiseaseDefm>(); DiseaseDefm diseaseDefm; for (int i = 0; i < table.Rows.Count; i++) { diseaseDefm = new DiseaseDefm(); diseaseDefm.CustomerNum = PIn.Long(table.Rows[i]["CustomerNum"].ToString()); diseaseDefm.DiseaseDefNum = PIn.Long(table.Rows[i]["DiseaseDefNum"].ToString()); diseaseDefm.DiseaseName = PIn.String(table.Rows[i]["DiseaseName"].ToString()); retVal.Add(diseaseDefm); } return(retVal); }
///<summary>Usually set useExistingPK=true. Inserts one DiseaseDefm into the database.</summary> internal static long Insert(DiseaseDefm diseaseDefm, bool useExistingPK) { if (!useExistingPK) { diseaseDefm.DiseaseDefNum = ReplicationServers.GetKey("diseasedefm", "DiseaseDefNum"); } string command = "INSERT INTO diseasedefm ("; command += "DiseaseDefNum,"; command += "CustomerNum,DiseaseName) VALUES("; command += POut.Long(diseaseDefm.DiseaseDefNum) + ","; command += POut.Long(diseaseDefm.CustomerNum) + "," + "'" + POut.String(diseaseDefm.DiseaseName) + "')"; Db.NonQ(command); //There is no autoincrement in the mobile server. return(diseaseDefm.DiseaseDefNum); }
///<summary>Converts one DiseaseDef object to its mobile equivalent. Warning! CustomerNum will always be 0.</summary> internal static DiseaseDefm ConvertToM(DiseaseDef diseaseDef){ DiseaseDefm diseaseDefm=new DiseaseDefm(); //CustomerNum cannot be set. Remains 0. diseaseDefm.DiseaseDefNum=diseaseDef.DiseaseDefNum; diseaseDefm.DiseaseName =diseaseDef.DiseaseName; return diseaseDefm; }
///<summary>Updates one DiseaseDefm in the database.</summary> internal static void Update(DiseaseDefm diseaseDefm){ string command="UPDATE diseasedefm SET " +"DiseaseName = '"+POut.String(diseaseDefm.DiseaseName)+"' " +"WHERE CustomerNum = "+POut.Long(diseaseDefm.CustomerNum)+" AND DiseaseDefNum = "+POut.Long(diseaseDefm.DiseaseDefNum); Db.NonQ(command); }