///<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);
}
