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();
}
}
}
}
