/* */ 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); } }