public IDataReader ExecuteReader(CommandType commandType, string commandText) { this.idbCommand = SalesPOSDBManagerFactory.GetCommand(this.ProviderType); idbCommand.Connection = this.Connection; PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters); this.DataReader = idbCommand.ExecuteReader(); idbCommand.Parameters.Clear(); return(this.DataReader); }
public string GetMaxId(string tbName, string field) { string thisyeaar = string.Empty; try { this.Open(); String maxIDField = ""; int num = 0; string substr = ""; DateTime dt = DateTime.Now; string y = dt.Year.ToString(); string m = dt.Month.ToString(); string d = dt.Day.ToString(); m = m.PadLeft(2, '0'); d = d.PadLeft(2, '0'); thisyeaar = y + "" + m + "" + d; string strSQL = "select max(" + field + ") from " + tbName + " where " + field + " Like'" + thisyeaar + "%'"; this.idbCommand = SalesPOSDBManagerFactory.GetCommand(this.ProviderType); idbCommand.Connection = this.idbConnection; idbCommand.CommandType = CommandType.Text; idbCommand.CommandText = strSQL; if (Convert.IsDBNull(idbCommand.ExecuteScalar())) { thisyeaar = thisyeaar + "0001"; } else { maxIDField = Convert.ToString(idbCommand.ExecuteScalar()); int intCardLength = Convert.ToInt32(maxIDField.Length); substr = maxIDField.Substring(intCardLength - 4).ToString(); num = Convert.ToInt16(substr) + 1; thisyeaar = thisyeaar + num.ToString().PadLeft(4, '0'); } } catch (Exception ex) { throw (ex); } finally { this.Dispose(); } return(thisyeaar); }
public int ExecuteNonQuery(CommandType commandType, string commandText) { BeginTransaction(); try { this.idbCommand = SalesPOSDBManagerFactory.GetCommand(this.ProviderType); PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters); int returnValue = idbCommand.ExecuteNonQuery(); idbCommand.Parameters.Clear(); CommitTransaction(); return(returnValue); } catch (Exception ex) { RollBackTransaction(); throw (ex); //return -2; } }
public IDbCommand getCommand(CommandType commandType, string commandText, IDbDataParameter[] commandParameters) { IDbCommand command = SalesPOSDBManagerFactory.GetCommand(this.providerType); try { command.Connection = this.idbConnection; command.CommandText = commandText; command.CommandType = commandType; if (commandParameters != null) { AttachParameters(command, commandParameters); } } catch (Exception ex) { throw (ex); } finally { } return(command); }