/// <summary>
/// return a dataset from database with Parameter
/// </summary>
/// <param name="Command">SQL command String</param>
/// <param name="Parameter">Parameter</param>
/// <param name="Timeout">[option] timeout of database connect(seconds)</param>
/// <returns>
/// dataset value
/// </returns>
public DataSet GetDataSet(String Command, ParameterClass[] Parameter, Int32 Timeout = 30)
{
if (conn == null)
{
throw new Exception("Connection has not initialize.");
}
if (conn.IsValid() != true)
{
throw new Exception("Connection has not opened.");
}
PDBCommand cmd = conn.CreateCommand();
//add parameter
PDBParameter[] parameter = new PDBParameter[Parameter.Length];
for (int number = 0; number < Parameter.Length; number++)
{
parameter[number] = new PDBParameter(Parameter[number].ParameterName,
(PDBType)Enum.Parse(typeof(PDBType), Parameter[number].Value.GetType().ToString()));
parameter[number].Value = Parameter[number].Value;
}
DataTable dt = cmd.ExecuteQuery(Command, parameter);
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return(ds);
}
/// <summary>
/// Execue sql Command With Parameter
/// </summary>
/// <param name="Command">SQL command String</param>
/// <param name="Parameter">Parameter</param>
/// <param name="Timeout">[option] timeout of database connect(seconds)</param>
/// <returns>
/// The number of rows affected
/// </returns>
public Int32 ExecueCommand(String Command, ParameterINClass[] Parameter, Int32 Timeout = 30)
{
Int32 Value = 0;
if (conn == null)
{
throw new Exception("Connection has not initialize.");
}
if (conn.IsValid() != true)
{
throw new Exception("Connection has not opened.");
}
PDBCommand cmd = conn.CreateCommand();
PDBParameter[] parameter = new PDBParameter[Parameter.Length];
for (int number = 0; number < Parameter.Length; number++)
{
parameter[number] = new PDBParameter(Parameter[number].ParameterName,
(PDBType)Enum.Parse(typeof(PDBType), Parameter[number].Value.GetType().ToString()));
parameter[number].Value = Parameter[number].Value;
}
cmd.ExecuteNonQuery(Command, parameter);
return(Value);
}
/// <summary>
/// get first row and first colunm value from database with Parameter
/// </summary>
/// <param name="Command">SQL command String</param>
/// <param name="Parameter">Parameter</param>
/// <param name="Timeout">[option] timeout of database connect(seconds)</param>
/// <returns>
/// object value
/// </returns>
public object GetSpeciaRecordValue(String Command, ParameterClass[] Parameter, Int32 Timeout = 30)
{
object Value;
if (conn == null)
{
throw new Exception("Connection has not initialize.");
}
if (conn.IsValid() != true)
{
throw new Exception("Connection has not opened.");
}
PDBCommand cmd = conn.CreateCommand();
//add parameter
PDBParameter[] parameter = new PDBParameter[Parameter.Length];
for (int number = 0; number < Parameter.Length; number++)
{
parameter[number] = new PDBParameter(Parameter[number].ParameterName,
(PDBType)Enum.Parse(typeof(PDBType), Parameter[number].Value.GetType().ToString()));
parameter[number].Value = Parameter[number].Value;
}
DataTable dt = cmd.ExecuteQuery(Command, parameter);
if (dt.Rows.Count > 0)
{
Value = dt.Rows[0][0];
}
else
{
Value = null;
}
return(Value);
}
