public void getSERSHeader(string selSERSNo) { DBConnection dbCon = new DBConnection(); cLocation oLocation = new cLocation(); cCompany oCompany = new cCompany(); cMySQLCommands oMySQLCommand = new cMySQLCommands(); MySqlDataReader reader; oMySQLCommand.addFields("sers_tran.rsh_dreq"); oMySQLCommand.addFields("sers_tran.rsh_dneed"); oMySQLCommand.addFields("sers_tran.rsh_loccd"); oMySQLCommand.addFields("sers_tran.rsh_depcd"); oMySQLCommand.addFields("sers_tran.rsh_dstamp"); oMySQLCommand.addFields("sers_tran.rsh_stat"); oMySQLCommand.addFields("usertab.usr_name"); oMySQLCommand.addFields("sers_tran.rsh_rem"); oMySQLCommand.addFields("sers_tran.rsh_type"); oMySQLCommand.addFields("sers_tran.rsh_apprby"); oMySQLCommand._tblName = "sers_tran"; oMySQLCommand._innerTableName = "usertab"; oMySQLCommand._innerLeftOn = "sers_tran.rsh_uid"; oMySQLCommand._innerRightOn = "usertab.usr_login"; oMySQLCommand._condition = "sers_tran.rsh_no = '" + selSERSNo + "'"; reader = oMySQLCommand.innerSelectQueryWhere(); if (reader.HasRows) { while (reader.Read()) { _dateRequested = reader.GetString(0); _dateNeeded = reader.GetString(1); _loccode = reader.GetString(2); _deptcode = reader.GetString(3); _datestamp = reader.GetString(4); _status = reader.GetString(5); _uid = reader.GetString(6); _remarks = reader.GetString(7); _sersType = reader.GetString(8); //_noOfCopies = reader.GetString(25); _approvedBy = reader.GetString(9); } } ////getLocation(); //getCompany(); }
public void addEventEntry() { cLocation oLocation = new cLocation(); oLocation._code = _locCode; oLocation.setLocationDetails(); cMySQLCommands oMySQLCommands = new cMySQLCommands(); oMySQLCommands._tblName = "eventlog"; oMySQLCommands.addFields("eventtime"); oMySQLCommands.addFields("eventname"); oMySQLCommands._values = ""; oMySQLCommands.addValues(_logEventDateTime); oMySQLCommands.addValues(oLocation._name.TrimEnd() + " has " + _logEventCount + "entries of " + _logEventName); oMySQLCommands.insertQuery(); }