public static void Update(ArrayList vCodes)
{
for (int i = 0; i < vCodes.Count; i++)
{
ClaimValCode vc = (ClaimValCode)vCodes[i];
if (vc.ClaimValCodeLogNum == 0)
{
string command = "INSERT INTO claimvalcodelog (ClaimNum,ClaimField,ValCode,ValAmount,Ordinal) VALUES("
+ "'" + POut.PInt(vc.ClaimNum) + "', "
+ "'" + POut.PString(vc.ClaimField) + "', "
+ "'" + POut.PString(vc.ValCode) + "', "
+ "'" + POut.PDouble(vc.ValAmount) + "', "
+ "'" + POut.PInt(vc.Ordinal) + "')";
General.NonQ(command);
}
else
{
string command = "UPDATE claimvalcodelog SET "
+ "ClaimNum='" + POut.PInt(vc.ClaimNum) + "',"
+ "ValCode='" + POut.PString(vc.ValCode) + "',"
+ "ValAmount='" + POut.PDouble(vc.ValAmount) + "' "
+ "WHERE ClaimValCodeLogNum='" + POut.PInt(vc.ClaimValCodeLogNum) + "'";
General.NonQ(command);
}
}
} //Update
public static ArrayList GetValCodes(Claim Cur)
{
string command = "SELECT * FROM claimvalcodelog WHERE ClaimNum='" + Cur.ClaimNum + "'";
DataTable table = General.GetTable(command);
List = new ArrayList();
for (int i = 0; i < table.Rows.Count; i++)
{
ClaimValCode vc = new ClaimValCode();
vc.ClaimValCodeLogNum = PIn.PInt(table.Rows[i][0].ToString());
vc.ClaimNum = PIn.PInt(table.Rows[i][1].ToString());
vc.ClaimField = PIn.PString(table.Rows[i][2].ToString());
vc.ValCode = PIn.PString(table.Rows[i][3].ToString());
vc.ValAmount = PIn.PDouble(table.Rows[i][4].ToString());
vc.Ordinal = PIn.PInt(table.Rows[i][5].ToString());
List.Add(vc);
}
return(List);
}
