///<summary>Converts a DataTable to a list of objects.</summary>
public static List<HL7DefField> TableToList(DataTable table){
List<HL7DefField> retVal=new List<HL7DefField>();
HL7DefField hL7DefField;
for(int i=0;i<table.Rows.Count;i++) {
hL7DefField=new HL7DefField();
hL7DefField.HL7DefFieldNum = PIn.Long (table.Rows[i]["HL7DefFieldNum"].ToString());
hL7DefField.HL7DefSegmentNum= PIn.Long (table.Rows[i]["HL7DefSegmentNum"].ToString());
hL7DefField.OrdinalPos = PIn.Int (table.Rows[i]["OrdinalPos"].ToString());
hL7DefField.TableId = PIn.String(table.Rows[i]["TableId"].ToString());
string dataType=table.Rows[i]["DataType"].ToString();
if(dataType==""){
hL7DefField.DataType =(DataTypeHL7)0;
}
else try{
hL7DefField.DataType =(DataTypeHL7)Enum.Parse(typeof(DataTypeHL7),dataType);
}
catch{
hL7DefField.DataType =(DataTypeHL7)0;
}
hL7DefField.FieldName = PIn.String(table.Rows[i]["FieldName"].ToString());
hL7DefField.FixedText = PIn.String(table.Rows[i]["FixedText"].ToString());
retVal.Add(hL7DefField);
}
return retVal;
}
///<summary>Inserts one HL7DefField into the database. Returns the new priKey.</summary>
public static long Insert(HL7DefField hL7DefField){
if(DataConnection.DBtype==DatabaseType.Oracle) {
hL7DefField.HL7DefFieldNum=DbHelper.GetNextOracleKey("hl7deffield","HL7DefFieldNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(hL7DefField,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
hL7DefField.HL7DefFieldNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(hL7DefField,false);
}
}
///<summary>Inserts one HL7DefField into the database. Provides option to use the existing priKey.</summary>
public static long Insert(HL7DefField hL7DefField,bool useExistingPK){
if(!useExistingPK && PrefC.RandomKeys) {
hL7DefField.HL7DefFieldNum=ReplicationServers.GetKey("hl7deffield","HL7DefFieldNum");
}
string command="INSERT INTO hl7deffield (";
if(useExistingPK || PrefC.RandomKeys) {
command+="HL7DefFieldNum,";
}
command+="HL7DefSegmentNum,OrdinalPos,TableId,DataType,FieldName,FixedText) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(hL7DefField.HL7DefFieldNum)+",";
}
command+=
POut.Long (hL7DefField.HL7DefSegmentNum)+","
+ POut.Int (hL7DefField.OrdinalPos)+","
+"'"+POut.String(hL7DefField.TableId)+"',"
+"'"+POut.String(hL7DefField.DataType.ToString())+"',"
+"'"+POut.String(hL7DefField.FieldName)+"',"
+"'"+POut.String(hL7DefField.FixedText)+"')";
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command);
}
else {
hL7DefField.HL7DefFieldNum=Db.NonQ(command,true);
}
return hL7DefField.HL7DefFieldNum;
}
///<summary>Updates one HL7DefField 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(HL7DefField hL7DefField,HL7DefField oldHL7DefField){
string command="";
if(hL7DefField.HL7DefSegmentNum != oldHL7DefField.HL7DefSegmentNum) {
if(command!=""){ command+=",";}
command+="HL7DefSegmentNum = "+POut.Long(hL7DefField.HL7DefSegmentNum)+"";
}
if(hL7DefField.OrdinalPos != oldHL7DefField.OrdinalPos) {
if(command!=""){ command+=",";}
command+="OrdinalPos = "+POut.Int(hL7DefField.OrdinalPos)+"";
}
if(hL7DefField.TableId != oldHL7DefField.TableId) {
if(command!=""){ command+=",";}
command+="TableId = '"+POut.String(hL7DefField.TableId)+"'";
}
if(hL7DefField.DataType != oldHL7DefField.DataType) {
if(command!=""){ command+=",";}
command+="DataType = '"+POut.String(hL7DefField.DataType.ToString())+"'";
}
if(hL7DefField.FieldName != oldHL7DefField.FieldName) {
if(command!=""){ command+=",";}
command+="FieldName = '"+POut.String(hL7DefField.FieldName)+"'";
}
if(hL7DefField.FixedText != oldHL7DefField.FixedText) {
if(command!=""){ command+=",";}
command+="FixedText = '"+POut.String(hL7DefField.FixedText)+"'";
}
if(command==""){
return false;
}
command="UPDATE hl7deffield SET "+command
+" WHERE HL7DefFieldNum = "+POut.Long(hL7DefField.HL7DefFieldNum);
Db.NonQ(command);
return true;
}
///<summary>Updates one HL7DefField in the database.</summary>
public static void Update(HL7DefField hL7DefField){
string command="UPDATE hl7deffield SET "
+"HL7DefSegmentNum= "+POut.Long (hL7DefField.HL7DefSegmentNum)+", "
+"OrdinalPos = "+POut.Int (hL7DefField.OrdinalPos)+", "
+"TableId = '"+POut.String(hL7DefField.TableId)+"', "
+"DataType = '"+POut.String(hL7DefField.DataType.ToString())+"', "
+"FieldName = '"+POut.String(hL7DefField.FieldName)+"', "
+"FixedText = '"+POut.String(hL7DefField.FixedText)+"' "
+"WHERE HL7DefFieldNum = "+POut.Long(hL7DefField.HL7DefFieldNum);
Db.NonQ(command);
}
