///<summary>Converts a DataTable to a list of objects.</summary>
public static List<EhrLabResultsCopyTo> TableToList(DataTable table) {
List<EhrLabResultsCopyTo> retVal=new List<EhrLabResultsCopyTo>();
EhrLabResultsCopyTo ehrLabResultsCopyTo;
foreach(DataRow row in table.Rows) {
ehrLabResultsCopyTo=new EhrLabResultsCopyTo();
ehrLabResultsCopyTo.EhrLabResultsCopyToNum = PIn.Long (row["EhrLabResultsCopyToNum"].ToString());
ehrLabResultsCopyTo.EhrLabNum = PIn.Long (row["EhrLabNum"].ToString());
ehrLabResultsCopyTo.CopyToID = PIn.String(row["CopyToID"].ToString());
ehrLabResultsCopyTo.CopyToLName = PIn.String(row["CopyToLName"].ToString());
ehrLabResultsCopyTo.CopyToFName = PIn.String(row["CopyToFName"].ToString());
ehrLabResultsCopyTo.CopyToMiddleNames = PIn.String(row["CopyToMiddleNames"].ToString());
ehrLabResultsCopyTo.CopyToSuffix = PIn.String(row["CopyToSuffix"].ToString());
ehrLabResultsCopyTo.CopyToPrefix = PIn.String(row["CopyToPrefix"].ToString());
ehrLabResultsCopyTo.CopyToAssigningAuthorityNamespaceID= PIn.String(row["CopyToAssigningAuthorityNamespaceID"].ToString());
ehrLabResultsCopyTo.CopyToAssigningAuthorityUniversalID= PIn.String(row["CopyToAssigningAuthorityUniversalID"].ToString());
ehrLabResultsCopyTo.CopyToAssigningAuthorityIDType = PIn.String(row["CopyToAssigningAuthorityIDType"].ToString());
string copyToNameTypeCode=row["CopyToNameTypeCode"].ToString();
if(copyToNameTypeCode=="") {
ehrLabResultsCopyTo.CopyToNameTypeCode =(EhrLaboratories.HL70200)0;
}
else try{
ehrLabResultsCopyTo.CopyToNameTypeCode =(EhrLaboratories.HL70200)Enum.Parse(typeof(EhrLaboratories.HL70200),copyToNameTypeCode);
}
catch{
ehrLabResultsCopyTo.CopyToNameTypeCode =(EhrLaboratories.HL70200)0;
}
string copyToIdentifierTypeCode=row["CopyToIdentifierTypeCode"].ToString();
if(copyToIdentifierTypeCode=="") {
ehrLabResultsCopyTo.CopyToIdentifierTypeCode =(EhrLaboratories.HL70203)0;
}
else try{
ehrLabResultsCopyTo.CopyToIdentifierTypeCode =(EhrLaboratories.HL70203)Enum.Parse(typeof(EhrLaboratories.HL70203),copyToIdentifierTypeCode);
}
catch{
ehrLabResultsCopyTo.CopyToIdentifierTypeCode =(EhrLaboratories.HL70203)0;
}
retVal.Add(ehrLabResultsCopyTo);
}
return retVal;
}
///<summary>Inserts one EhrLabResultsCopyTo into the database. Provides option to use the existing priKey.</summary>
public static long Insert(EhrLabResultsCopyTo ehrLabResultsCopyTo, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
ehrLabResultsCopyTo.EhrLabResultsCopyToNum = ReplicationServers.GetKey("ehrlabresultscopyto", "EhrLabResultsCopyToNum");
}
string command = "INSERT INTO ehrlabresultscopyto (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "EhrLabResultsCopyToNum,";
}
command += "EhrLabNum,CopyToID,CopyToLName,CopyToFName,CopyToMiddleNames,CopyToSuffix,CopyToPrefix,CopyToAssigningAuthorityNamespaceID,CopyToAssigningAuthorityUniversalID,CopyToAssigningAuthorityIDType,CopyToNameTypeCode,CopyToIdentifierTypeCode) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(ehrLabResultsCopyTo.EhrLabResultsCopyToNum) + ",";
}
command +=
POut.Long(ehrLabResultsCopyTo.EhrLabNum) + ","
+ "'" + POut.String(ehrLabResultsCopyTo.CopyToID) + "',"
+ "'" + POut.String(ehrLabResultsCopyTo.CopyToLName) + "',"
+ "'" + POut.String(ehrLabResultsCopyTo.CopyToFName) + "',"
+ "'" + POut.String(ehrLabResultsCopyTo.CopyToMiddleNames) + "',"
+ "'" + POut.String(ehrLabResultsCopyTo.CopyToSuffix) + "',"
+ "'" + POut.String(ehrLabResultsCopyTo.CopyToPrefix) + "',"
+ "'" + POut.String(ehrLabResultsCopyTo.CopyToAssigningAuthorityNamespaceID) + "',"
+ "'" + POut.String(ehrLabResultsCopyTo.CopyToAssigningAuthorityUniversalID) + "',"
+ "'" + POut.String(ehrLabResultsCopyTo.CopyToAssigningAuthorityIDType) + "',"
+ "'" + POut.String(ehrLabResultsCopyTo.CopyToNameTypeCode.ToString()) + "',"
+ "'" + POut.String(ehrLabResultsCopyTo.CopyToIdentifierTypeCode.ToString()) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
ehrLabResultsCopyTo.EhrLabResultsCopyToNum = Db.NonQ(command, true, "EhrLabResultsCopyToNum", "ehrLabResultsCopyTo");
}
return(ehrLabResultsCopyTo.EhrLabResultsCopyToNum);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List<EhrLabResultsCopyTo> TableToList(DataTable table){
List<EhrLabResultsCopyTo> retVal=new List<EhrLabResultsCopyTo>();
EhrLabResultsCopyTo ehrLabResultsCopyTo;
for(int i=0;i<table.Rows.Count;i++) {
ehrLabResultsCopyTo=new EhrLabResultsCopyTo();
ehrLabResultsCopyTo.EhrLabResultsCopyToNum = PIn.Long (table.Rows[i]["EhrLabResultsCopyToNum"].ToString());
ehrLabResultsCopyTo.EhrLabNum = PIn.Long (table.Rows[i]["EhrLabNum"].ToString());
ehrLabResultsCopyTo.CopyToID = PIn.String(table.Rows[i]["CopyToID"].ToString());
ehrLabResultsCopyTo.CopyToLName = PIn.String(table.Rows[i]["CopyToLName"].ToString());
ehrLabResultsCopyTo.CopyToFName = PIn.String(table.Rows[i]["CopyToFName"].ToString());
ehrLabResultsCopyTo.CopyToMiddleNames = PIn.String(table.Rows[i]["CopyToMiddleNames"].ToString());
ehrLabResultsCopyTo.CopyToSuffix = PIn.String(table.Rows[i]["CopyToSuffix"].ToString());
ehrLabResultsCopyTo.CopyToPrefix = PIn.String(table.Rows[i]["CopyToPrefix"].ToString());
ehrLabResultsCopyTo.CopyToAssigningAuthorityNamespaceID= PIn.String(table.Rows[i]["CopyToAssigningAuthorityNamespaceID"].ToString());
ehrLabResultsCopyTo.CopyToAssigningAuthorityUniversalID= PIn.String(table.Rows[i]["CopyToAssigningAuthorityUniversalID"].ToString());
ehrLabResultsCopyTo.CopyToAssigningAuthorityIDType = PIn.String(table.Rows[i]["CopyToAssigningAuthorityIDType"].ToString());
string copyToNameTypeCode=table.Rows[i]["CopyToNameTypeCode"].ToString();
if(copyToNameTypeCode==""){
ehrLabResultsCopyTo.CopyToNameTypeCode =(HL70200)0;
}
else try{
ehrLabResultsCopyTo.CopyToNameTypeCode =(HL70200)Enum.Parse(typeof(HL70200),copyToNameTypeCode);
}
catch{
ehrLabResultsCopyTo.CopyToNameTypeCode =(HL70200)0;
}
string copyToIdentifierTypeCode=table.Rows[i]["CopyToIdentifierTypeCode"].ToString();
if(copyToIdentifierTypeCode==""){
ehrLabResultsCopyTo.CopyToIdentifierTypeCode =(HL70203)0;
}
else try{
ehrLabResultsCopyTo.CopyToIdentifierTypeCode =(HL70203)Enum.Parse(typeof(HL70203),copyToIdentifierTypeCode);
}
catch{
ehrLabResultsCopyTo.CopyToIdentifierTypeCode =(HL70203)0;
}
retVal.Add(ehrLabResultsCopyTo);
}
return retVal;
}
///<summary>Returns true if Update(EhrLabResultsCopyTo,EhrLabResultsCopyTo) would make changes to the database.
///Does not make any changes to the database and can be called before remoting role is checked.</summary>
public static bool UpdateComparison(EhrLabResultsCopyTo ehrLabResultsCopyTo,EhrLabResultsCopyTo oldEhrLabResultsCopyTo) {
if(ehrLabResultsCopyTo.EhrLabNum != oldEhrLabResultsCopyTo.EhrLabNum) {
return true;
}
if(ehrLabResultsCopyTo.CopyToID != oldEhrLabResultsCopyTo.CopyToID) {
return true;
}
if(ehrLabResultsCopyTo.CopyToLName != oldEhrLabResultsCopyTo.CopyToLName) {
return true;
}
if(ehrLabResultsCopyTo.CopyToFName != oldEhrLabResultsCopyTo.CopyToFName) {
return true;
}
if(ehrLabResultsCopyTo.CopyToMiddleNames != oldEhrLabResultsCopyTo.CopyToMiddleNames) {
return true;
}
if(ehrLabResultsCopyTo.CopyToSuffix != oldEhrLabResultsCopyTo.CopyToSuffix) {
return true;
}
if(ehrLabResultsCopyTo.CopyToPrefix != oldEhrLabResultsCopyTo.CopyToPrefix) {
return true;
}
if(ehrLabResultsCopyTo.CopyToAssigningAuthorityNamespaceID != oldEhrLabResultsCopyTo.CopyToAssigningAuthorityNamespaceID) {
return true;
}
if(ehrLabResultsCopyTo.CopyToAssigningAuthorityUniversalID != oldEhrLabResultsCopyTo.CopyToAssigningAuthorityUniversalID) {
return true;
}
if(ehrLabResultsCopyTo.CopyToAssigningAuthorityIDType != oldEhrLabResultsCopyTo.CopyToAssigningAuthorityIDType) {
return true;
}
if(ehrLabResultsCopyTo.CopyToNameTypeCode != oldEhrLabResultsCopyTo.CopyToNameTypeCode) {
return true;
}
if(ehrLabResultsCopyTo.CopyToIdentifierTypeCode != oldEhrLabResultsCopyTo.CopyToIdentifierTypeCode) {
return true;
}
return false;
}
///<summary>Inserts one EhrLabResultsCopyTo into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(EhrLabResultsCopyTo ehrLabResultsCopyTo) {
return InsertNoCache(ehrLabResultsCopyTo,false);
}
///<summary>Updates one EhrLabResultsCopyTo in the database. Uses an old object to compare to, and only alters changed fields. This prevents collisions and concurrency problems in heavily used tables. Returns true if an update occurred.</summary>
public static bool Update(EhrLabResultsCopyTo ehrLabResultsCopyTo, EhrLabResultsCopyTo oldEhrLabResultsCopyTo)
{
string command = "";
if (ehrLabResultsCopyTo.EhrLabNum != oldEhrLabResultsCopyTo.EhrLabNum)
{
if (command != "")
{
command += ",";
}
command += "EhrLabNum = " + POut.Long(ehrLabResultsCopyTo.EhrLabNum) + "";
}
if (ehrLabResultsCopyTo.CopyToID != oldEhrLabResultsCopyTo.CopyToID)
{
if (command != "")
{
command += ",";
}
command += "CopyToID = '" + POut.String(ehrLabResultsCopyTo.CopyToID) + "'";
}
if (ehrLabResultsCopyTo.CopyToLName != oldEhrLabResultsCopyTo.CopyToLName)
{
if (command != "")
{
command += ",";
}
command += "CopyToLName = '" + POut.String(ehrLabResultsCopyTo.CopyToLName) + "'";
}
if (ehrLabResultsCopyTo.CopyToFName != oldEhrLabResultsCopyTo.CopyToFName)
{
if (command != "")
{
command += ",";
}
command += "CopyToFName = '" + POut.String(ehrLabResultsCopyTo.CopyToFName) + "'";
}
if (ehrLabResultsCopyTo.CopyToMiddleNames != oldEhrLabResultsCopyTo.CopyToMiddleNames)
{
if (command != "")
{
command += ",";
}
command += "CopyToMiddleNames = '" + POut.String(ehrLabResultsCopyTo.CopyToMiddleNames) + "'";
}
if (ehrLabResultsCopyTo.CopyToSuffix != oldEhrLabResultsCopyTo.CopyToSuffix)
{
if (command != "")
{
command += ",";
}
command += "CopyToSuffix = '" + POut.String(ehrLabResultsCopyTo.CopyToSuffix) + "'";
}
if (ehrLabResultsCopyTo.CopyToPrefix != oldEhrLabResultsCopyTo.CopyToPrefix)
{
if (command != "")
{
command += ",";
}
command += "CopyToPrefix = '" + POut.String(ehrLabResultsCopyTo.CopyToPrefix) + "'";
}
if (ehrLabResultsCopyTo.CopyToAssigningAuthorityNamespaceID != oldEhrLabResultsCopyTo.CopyToAssigningAuthorityNamespaceID)
{
if (command != "")
{
command += ",";
}
command += "CopyToAssigningAuthorityNamespaceID = '" + POut.String(ehrLabResultsCopyTo.CopyToAssigningAuthorityNamespaceID) + "'";
}
if (ehrLabResultsCopyTo.CopyToAssigningAuthorityUniversalID != oldEhrLabResultsCopyTo.CopyToAssigningAuthorityUniversalID)
{
if (command != "")
{
command += ",";
}
command += "CopyToAssigningAuthorityUniversalID = '" + POut.String(ehrLabResultsCopyTo.CopyToAssigningAuthorityUniversalID) + "'";
}
if (ehrLabResultsCopyTo.CopyToAssigningAuthorityIDType != oldEhrLabResultsCopyTo.CopyToAssigningAuthorityIDType)
{
if (command != "")
{
command += ",";
}
command += "CopyToAssigningAuthorityIDType = '" + POut.String(ehrLabResultsCopyTo.CopyToAssigningAuthorityIDType) + "'";
}
if (ehrLabResultsCopyTo.CopyToNameTypeCode != oldEhrLabResultsCopyTo.CopyToNameTypeCode)
{
if (command != "")
{
command += ",";
}
command += "CopyToNameTypeCode = '" + POut.String(ehrLabResultsCopyTo.CopyToNameTypeCode.ToString()) + "'";
}
if (ehrLabResultsCopyTo.CopyToIdentifierTypeCode != oldEhrLabResultsCopyTo.CopyToIdentifierTypeCode)
{
if (command != "")
{
command += ",";
}
command += "CopyToIdentifierTypeCode = '" + POut.String(ehrLabResultsCopyTo.CopyToIdentifierTypeCode.ToString()) + "'";
}
if (command == "")
{
return(false);
}
command = "UPDATE ehrlabresultscopyto SET " + command
+ " WHERE EhrLabResultsCopyToNum = " + POut.Long(ehrLabResultsCopyTo.EhrLabResultsCopyToNum);
Db.NonQ(command);
return(true);
}
///<summary>Inserts one EhrLabResultsCopyTo into the database. Returns the new priKey.</summary>
public static long Insert(EhrLabResultsCopyTo ehrLabResultsCopyTo){
if(DataConnection.DBtype==DatabaseType.Oracle) {
ehrLabResultsCopyTo.EhrLabResultsCopyToNum=DbHelper.GetNextOracleKey("ehrlabresultscopyto","EhrLabResultsCopyToNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(ehrLabResultsCopyTo,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
ehrLabResultsCopyTo.EhrLabResultsCopyToNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(ehrLabResultsCopyTo,false);
}
}
///<summary>Updates one EhrLabResultsCopyTo in the database. Uses an old object to compare to, and only alters changed fields. This prevents collisions and concurrency problems in heavily used tables.</summary>
public static void Update(EhrLabResultsCopyTo ehrLabResultsCopyTo,EhrLabResultsCopyTo oldEhrLabResultsCopyTo){
string command="";
if(ehrLabResultsCopyTo.EhrLabNum != oldEhrLabResultsCopyTo.EhrLabNum) {
if(command!=""){ command+=",";}
command+="EhrLabNum = "+POut.Long(ehrLabResultsCopyTo.EhrLabNum)+"";
}
if(ehrLabResultsCopyTo.CopyToID != oldEhrLabResultsCopyTo.CopyToID) {
if(command!=""){ command+=",";}
command+="CopyToID = '"+POut.String(ehrLabResultsCopyTo.CopyToID)+"'";
}
if(ehrLabResultsCopyTo.CopyToLName != oldEhrLabResultsCopyTo.CopyToLName) {
if(command!=""){ command+=",";}
command+="CopyToLName = '"+POut.String(ehrLabResultsCopyTo.CopyToLName)+"'";
}
if(ehrLabResultsCopyTo.CopyToFName != oldEhrLabResultsCopyTo.CopyToFName) {
if(command!=""){ command+=",";}
command+="CopyToFName = '"+POut.String(ehrLabResultsCopyTo.CopyToFName)+"'";
}
if(ehrLabResultsCopyTo.CopyToMiddleNames != oldEhrLabResultsCopyTo.CopyToMiddleNames) {
if(command!=""){ command+=",";}
command+="CopyToMiddleNames = '"+POut.String(ehrLabResultsCopyTo.CopyToMiddleNames)+"'";
}
if(ehrLabResultsCopyTo.CopyToSuffix != oldEhrLabResultsCopyTo.CopyToSuffix) {
if(command!=""){ command+=",";}
command+="CopyToSuffix = '"+POut.String(ehrLabResultsCopyTo.CopyToSuffix)+"'";
}
if(ehrLabResultsCopyTo.CopyToPrefix != oldEhrLabResultsCopyTo.CopyToPrefix) {
if(command!=""){ command+=",";}
command+="CopyToPrefix = '"+POut.String(ehrLabResultsCopyTo.CopyToPrefix)+"'";
}
if(ehrLabResultsCopyTo.CopyToAssigningAuthorityNamespaceID != oldEhrLabResultsCopyTo.CopyToAssigningAuthorityNamespaceID) {
if(command!=""){ command+=",";}
command+="CopyToAssigningAuthorityNamespaceID = '"+POut.String(ehrLabResultsCopyTo.CopyToAssigningAuthorityNamespaceID)+"'";
}
if(ehrLabResultsCopyTo.CopyToAssigningAuthorityUniversalID != oldEhrLabResultsCopyTo.CopyToAssigningAuthorityUniversalID) {
if(command!=""){ command+=",";}
command+="CopyToAssigningAuthorityUniversalID = '"+POut.String(ehrLabResultsCopyTo.CopyToAssigningAuthorityUniversalID)+"'";
}
if(ehrLabResultsCopyTo.CopyToAssigningAuthorityIDType != oldEhrLabResultsCopyTo.CopyToAssigningAuthorityIDType) {
if(command!=""){ command+=",";}
command+="CopyToAssigningAuthorityIDType = '"+POut.String(ehrLabResultsCopyTo.CopyToAssigningAuthorityIDType)+"'";
}
if(ehrLabResultsCopyTo.CopyToNameTypeCode != oldEhrLabResultsCopyTo.CopyToNameTypeCode) {
if(command!=""){ command+=",";}
command+="CopyToNameTypeCode = '"+POut.String(ehrLabResultsCopyTo.CopyToNameTypeCode.ToString())+"'";
}
if(ehrLabResultsCopyTo.CopyToIdentifierTypeCode != oldEhrLabResultsCopyTo.CopyToIdentifierTypeCode) {
if(command!=""){ command+=",";}
command+="CopyToIdentifierTypeCode = '"+POut.String(ehrLabResultsCopyTo.CopyToIdentifierTypeCode.ToString())+"'";
}
if(command==""){
return;
}
command="UPDATE ehrlabresultscopyto SET "+command
+" WHERE EhrLabResultsCopyToNum = "+POut.Long(ehrLabResultsCopyTo.EhrLabResultsCopyToNum);
Db.NonQ(command);
}
///<summary>Updates one EhrLabResultsCopyTo in the database.</summary>
public static void Update(EhrLabResultsCopyTo ehrLabResultsCopyTo){
string command="UPDATE ehrlabresultscopyto SET "
+"EhrLabNum = "+POut.Long (ehrLabResultsCopyTo.EhrLabNum)+", "
+"CopyToID = '"+POut.String(ehrLabResultsCopyTo.CopyToID)+"', "
+"CopyToLName = '"+POut.String(ehrLabResultsCopyTo.CopyToLName)+"', "
+"CopyToFName = '"+POut.String(ehrLabResultsCopyTo.CopyToFName)+"', "
+"CopyToMiddleNames = '"+POut.String(ehrLabResultsCopyTo.CopyToMiddleNames)+"', "
+"CopyToSuffix = '"+POut.String(ehrLabResultsCopyTo.CopyToSuffix)+"', "
+"CopyToPrefix = '"+POut.String(ehrLabResultsCopyTo.CopyToPrefix)+"', "
+"CopyToAssigningAuthorityNamespaceID= '"+POut.String(ehrLabResultsCopyTo.CopyToAssigningAuthorityNamespaceID)+"', "
+"CopyToAssigningAuthorityUniversalID= '"+POut.String(ehrLabResultsCopyTo.CopyToAssigningAuthorityUniversalID)+"', "
+"CopyToAssigningAuthorityIDType = '"+POut.String(ehrLabResultsCopyTo.CopyToAssigningAuthorityIDType)+"', "
+"CopyToNameTypeCode = '"+POut.String(ehrLabResultsCopyTo.CopyToNameTypeCode.ToString())+"', "
+"CopyToIdentifierTypeCode = '"+POut.String(ehrLabResultsCopyTo.CopyToIdentifierTypeCode.ToString())+"' "
+"WHERE EhrLabResultsCopyToNum = "+POut.Long(ehrLabResultsCopyTo.EhrLabResultsCopyToNum);
Db.NonQ(command);
}
///<summary>Inserts one EhrLabResultsCopyTo into the database. Provides option to use the existing priKey.</summary>
public static long Insert(EhrLabResultsCopyTo ehrLabResultsCopyTo,bool useExistingPK){
if(!useExistingPK && PrefC.RandomKeys) {
ehrLabResultsCopyTo.EhrLabResultsCopyToNum=ReplicationServers.GetKey("ehrlabresultscopyto","EhrLabResultsCopyToNum");
}
string command="INSERT INTO ehrlabresultscopyto (";
if(useExistingPK || PrefC.RandomKeys) {
command+="EhrLabResultsCopyToNum,";
}
command+="EhrLabNum,CopyToID,CopyToLName,CopyToFName,CopyToMiddleNames,CopyToSuffix,CopyToPrefix,CopyToAssigningAuthorityNamespaceID,CopyToAssigningAuthorityUniversalID,CopyToAssigningAuthorityIDType,CopyToNameTypeCode,CopyToIdentifierTypeCode) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(ehrLabResultsCopyTo.EhrLabResultsCopyToNum)+",";
}
command+=
POut.Long (ehrLabResultsCopyTo.EhrLabNum)+","
+"'"+POut.String(ehrLabResultsCopyTo.CopyToID)+"',"
+"'"+POut.String(ehrLabResultsCopyTo.CopyToLName)+"',"
+"'"+POut.String(ehrLabResultsCopyTo.CopyToFName)+"',"
+"'"+POut.String(ehrLabResultsCopyTo.CopyToMiddleNames)+"',"
+"'"+POut.String(ehrLabResultsCopyTo.CopyToSuffix)+"',"
+"'"+POut.String(ehrLabResultsCopyTo.CopyToPrefix)+"',"
+"'"+POut.String(ehrLabResultsCopyTo.CopyToAssigningAuthorityNamespaceID)+"',"
+"'"+POut.String(ehrLabResultsCopyTo.CopyToAssigningAuthorityUniversalID)+"',"
+"'"+POut.String(ehrLabResultsCopyTo.CopyToAssigningAuthorityIDType)+"',"
+"'"+POut.String(ehrLabResultsCopyTo.CopyToNameTypeCode.ToString())+"',"
+"'"+POut.String(ehrLabResultsCopyTo.CopyToIdentifierTypeCode.ToString())+"')";
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command);
}
else {
ehrLabResultsCopyTo.EhrLabResultsCopyToNum=Db.NonQ(command,true);
}
return ehrLabResultsCopyTo.EhrLabResultsCopyToNum;
}
