public void ProcessDataTable(DataTable dt)
{
foreach (DataRow row in dt.Rows)
{
for (int i = 0; i < row.ItemArray.Length; i++)
{
if (row[i] != null && row[i] is string && row[i] != System.DBNull.Value && row[i].ToString() != "")
{
row[i] = EncodIngHelper.ConvertISOToCP936(row[i].ToString());
}
}
}
}
public void ProcessOutputCommand(IDbCommand command)
{
if (command == null)
{
return;
}
foreach (IDbDataParameter parameter in command.Parameters)
{
if (parameter.Value != DBNull.Value && parameter.Value is string && (parameter.Direction == ParameterDirection.Output || parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.ReturnValue))
{
parameter.Value = EncodIngHelper.ConvertISOToCP936(parameter.Value as string);
}
}
}
public void ProcessInputCommand(IDbCommand command)
{
if (command == null)
{
return;
}
command.CommandText = EncodIngHelper.ConvertCP936ToISO(command.CommandText);
foreach (IDbDataParameter parameter in command.Parameters)
{
if (parameter.Value != System.DBNull.Value && parameter.Value is string && (parameter.Direction == ParameterDirection.Input || parameter.Direction == ParameterDirection.InputOutput))
{
parameter.Value = EncodIngHelper.ConvertCP936ToISO(parameter.Value as string);
}
}
}
