public void closeDBFAll() { cOleDBCommand oleDbCommand = new cOleDBCommand(); oleDbCommand.setConStr(); oleDbCommand.oleDBQueryNonReturn("CLOSE DATABASES ALL"); }
public void updateDBFQuery(List <setDBFValues> setColumnValues) { cOleDBCommand oleDbCommand = new cOleDBCommand(); string updateSQL = ""; string[] editCol = _fields.Split(','); string[] editVal = _values.Split(','); updateSQL = "UPDATE " + _tblName + " SET "; oleDbCommand.setConStr(); oleDbCommand.setOleDbfValues(ref setColumnValues); for (int x = 0; x < editCol.Count(); x++) { if (updateSQL != "UPDATE " + _tblName + " SET ")//used to get first col & value { updateSQL = updateSQL + " , "; } updateSQL = updateSQL + editCol.ElementAt(x) + " = " + editVal.ElementAt(x); } updateSQL = updateSQL + " WHERE " + _condition; oleDbCommand.oleDBQueryNonReturn(updateSQL); }
public void insertDBFQuery(List <setDBFValues> setColumnValues) { cOleDBCommand oleDbCommand = new cOleDBCommand(); string insertSQL = ""; int countColumns = 1; oleDbCommand.setConStr(); oleDbCommand.setOleDbfValues(ref setColumnValues); insertSQL = "INSERT INTO " + _tblName + " (" + _fields + ") VALUES("; //+ _values + ")"; foreach (setDBFValues oDbfValues in setColumnValues) { if (countColumns > 1) { insertSQL = insertSQL + " , "; } insertSQL = insertSQL + oDbfValues.valueName; countColumns++; } insertSQL = insertSQL.Replace('\r', ' ').Replace('\n', ' ') + ")"; //MessageBox.Show(insertSQL); try { oleDbCommand.oleDBQueryNonReturn(insertSQL); } catch (Exception ex) { // MessageBox.Show(insertSQL); MessageBox.Show(ex.ToString()); } }
public void setDBFSequenceNo(string seq_code, string seq_newnum) { string incrementSQL = ""; //int newSequencenum = Convert.ToInt16(seq_newnum) + 1; int newSequencenum = Convert.ToInt16(seq_newnum); //edited for updating sequence.dbf file skipping 1 number incrementSQL = "UPDATE sequence SET seq_num= " + newSequencenum.ToString() + " WHERE seq_code='" + seq_code + "'"; cOleDBCommand oleDbCommand = new cOleDBCommand(); oleDbCommand.setConStr(); oleDbCommand.oleDBQueryNonReturn(incrementSQL); }
public void addToTable() { cMySQLCommands oMySQLCommands = new cMySQLCommands(); cMySQLCommands mySQLAddNewUser = new cMySQLCommands(); MySqlDataReader reader; string[] addedUser = { "" }; mySQLAddNewUser.addFields("usertab.usr_login"); mySQLAddNewUser.addFields("usertab.usr_name"); mySQLAddNewUser.addFields("usertab.usr_pass"); mySQLAddNewUser.addFields("usertab.usr_loc"); mySQLAddNewUser.addFields("usertab.usr_dept"); mySQLAddNewUser.addFields("usertab.usr_pos"); mySQLAddNewUser._tblName = "usertab"; oMySQLCommands._fields = ""; oMySQLCommands._tblName = "usertab"; oMySQLCommands._condition = "usertab.usr_login = '******'"; reader = oMySQLCommands.selectQueryWhere(); if (reader.HasRows == false) { cOleDBCommand oOledbCommand = new cOleDBCommand(); OleDbDataReader dbReader; oOledbCommand.setConStr(setDBManual); dbReader = oOledbCommand.oleDBQueryReturn("SELECT * FROM usertab WHERE alltrim(upper(usertab.usr_login)) = '" + _userlogin + "'"); if (dbReader.HasRows) { if (dbReader.Read()) { mySQLAddNewUser._values = ""; mySQLAddNewUser.addValues(dbReader.GetString(0)); mySQLAddNewUser.addValues(dbReader.GetString(1)); mySQLAddNewUser.addValues("7007a91dd5b0e797a63ad8527b73f108"); mySQLAddNewUser.addValues(dbReader.GetString(5)); mySQLAddNewUser.addValues(dbReader.GetString(6)); mySQLAddNewUser.addValues(dbReader.GetString(7)); mySQLAddNewUser.insertQuery(); } } } }