/* */
public DataTable SelectInformation(params Object[] args)
{
DataTable result = null;
using (MySqlConnection myCon = new MySqlConnection(connString))
{
myCommand = new MySqlCommand();
myCommand.Connection = myCon;
myCommand.Connection.Open();
using (SelectingCommand SelCmd = new SelectingCommand(myCommand))
{
switch (args.Length)
{
case 0:
result = SelCmd.GetReqInfo();
break;
case 1:
result = SelCmd.GetReqInfo((int)args[0]);
break;
case 2:
case 3:
result = SelCmd.GetReqInfo((String)args[0], (String)args[1], (String)args[2]);
break;
}
}
myCommand.Connection.Close();
}
return(result);
}
public DataTable SelectDepoInfo(params Int32[] info)
{
DataTable result = null;
using (MySqlConnection myCon = new MySqlConnection(connString))
{
myCommand = new MySqlCommand();
myCommand.Connection = myCon;
myCommand.Connection.Open();
using (SelectingCommand SelCmd = new SelectingCommand(myCommand))
{
result = SelCmd.GetDepoInfo(info);
}
myCommand.Connection.Close();
}
return(result);
}
public DataTable SelectAgreementInfo(Int32 num)
{
DataTable result = null;
using (MySqlConnection myCon = new MySqlConnection(connString))
{
myCommand = new MySqlCommand();
myCommand.Connection = myCon;
myCommand.Connection.Open();
using (SelectingCommand SelCmd = new SelectingCommand(myCommand))
{
result = SelCmd.GetAgreementInfo(num);
}
myCommand.Connection.Close();
}
return(result);
}
public Boolean IfExistsPassport(params String[] args)
{
Boolean result = false;
using (MySqlConnection myCon = new MySqlConnection(connString))
{
myCommand = new MySqlCommand();
myCommand.Connection = myCon;
myCommand.Connection.Open();
using (SelectingCommand SelCmd = new SelectingCommand(myCommand))
{
result = SelCmd.GetPassportCheck(args[0], args[1]);
}
myCommand.Connection.Close();
return(result);
}
}
