public Config GetConfig(string Version = "")
{
Config pikoConfig = null;
try
{
using (PikoDataContext dataContext = new PikoDataContext(PikoDataServiceApp.DatabasePath, "PikoServer"))
{
String sqlQuery = "SELECT VERSION,SUPPORTS_ID,HASRUNS_ID FROM Config";
if (!String.IsNullOrEmpty(Version))
{
sqlQuery += " WHERE VERSION = '" + Version + "'";
}
OleDbDataReader result = dataContext.Select(sqlQuery);
if (result.HasRows)
{
pikoConfig = new Config();
int idxColumn = result.GetOrdinal("VERSION");
pikoConfig.Version = (ulong)result.GetInt64(idxColumn);
idxColumn = result.GetOrdinal("SUPPORTS_ID");
pikoConfig.SupportsId = result.GetString(idxColumn);
idxColumn = result.GetOrdinal("HASRUNS_ID");
pikoConfig.HasRunsId = result.GetString(idxColumn);
}
result.Close();
}
}
catch (Exception ex)
{ }
return(pikoConfig);
}
// Token: 0x0600003B RID: 59 RVA: 0x00007510 File Offset: 0x00005710
public frmMasterLevel(string charName)
{
InitializeComponent();
charName = charName;
string text = string.Format("SELECT T_MasterLevelSystem.CHAR_NAME, T_MasterLevelSystem.MASTER_LEVEL, T_MasterLevelSystem.ML_EXP, T_MasterLevelSystem.ML_NEXTEXP, T_MasterLevelSystem.ML_POINT, Character.Class FROM Character INNER JOIN T_MasterLevelSystem ON Character.Name = T_MasterLevelSystem.CHAR_NAME COLLATE Chinese_PRC_CS_AS_KS_WS WHERE (T_MasterLevelSystem.CHAR_NAME = '{0}')", charName);
try
{
OleDbCommand oleDbCommand = new OleDbCommand(text, frmBase.Mu_Conn);
OleDbDataReader oleDbDataReader = oleDbCommand.ExecuteReader();
if (oleDbDataReader.Read())
{
txtCharacter.Text = Convert.ToString(oleDbDataReader.GetValue(0));
txtLevel.Text = oleDbDataReader.GetInt16(1).ToString();
txtEXP.Text = oleDbDataReader.GetInt64(2).ToString();
txtNextEXP.Text = oleDbDataReader.GetInt64(3).ToString();
txtPoint.Text = oleDbDataReader.GetInt16(4).ToString();
if (oleDbDataReader.GetValue(5) != DBNull.Value)
{
classID = (int)oleDbDataReader.GetByte(5);
}
}
else
{
Utils.WarningMessage("对不起，没有找到角色[" + charName + "]对应的帐号信息！");
btnOK.Enabled = false;
}
oleDbDataReader.Close();
}
catch (Exception ex)
{
Utils.WarningMessage(string.Concat(new string[]
{
"SQL：",
text,
"\nError:",
ex.Message,
"\nSource:",
ex.Source,
"\nTrace:",
ex.StackTrace
}));
}
}
public static long GetLongFromDb(OleDbDataReader reader, string key)
{
int o = reader.GetOrdinal(key);
if (!reader.IsDBNull(o))
{
return(reader.GetInt64(o));
}
return(0);
}
public long GetInt64(int i)
{
if (SDR != null)
{
return(SDR.GetInt64(i));
}
else
{
return(ODR.GetInt64(i));
}
}
private void populateItemDetail(string itemName, string date)
{
string sqlQry = "SELECT tDate, Pcode as Item, Tno as TagNo, MetalType, Pcs, GW,NW FROM TRANS WHERE PCODE = '" + itemName + "' AND (OUTDATE IS NULL OR OUTDATE >= #" + date + "#) AND TDATE <= #" + date + "#";
OleDbDataReader reader = dbUtils.fetch(sqlQry);
int columnCount = reader.FieldCount;
/* dgItemDetail.Columns.Clear();
* for (int i = 0; i < columnCount; i++)
* {
* dgItemDetail.Columns.Add(reader.GetName(i).ToString(), reader.GetName(i).ToString());
* }*/
dgItemDetail.Rows.Clear();
string[] rowData = new string[columnCount];
while (reader.Read())
{
for (int k = 0; k < columnCount; k++)
{
if (reader.GetFieldType(k).ToString() == "System.Int16")
{
rowData[k] = reader.GetInt16(k).ToString();
}
if (reader.GetFieldType(k).ToString() == "System.Int32")
{
rowData[k] = reader.GetInt32(k).ToString();
}
if (reader.GetFieldType(k).ToString() == "System.Int64")
{
rowData[k] = reader.GetInt64(k).ToString();
}
if (reader.GetFieldType(k).ToString() == "System.String")
{
rowData[k] = reader.GetString(k);
}
if (reader.GetFieldType(k).ToString() == "System.Double")
{
rowData[k] = dbUtils.Decimal3digit(reader.GetDouble(k).ToString());
}
if (reader.GetFieldType(k).ToString() == "System.DateTime")
{
rowData[k] = reader.GetDateTime(k).ToShortDateString();
}
}
dgItemDetail.Rows.Add(rowData);
}
reader.Close();
reader = null;
}
public Int32 GetValueTabla(Int32 numRegistro, string tabla, string indexName, string nombreIndex)
{
Int32 Curvalue = 0;
try
{
string query = "select " + nombreIndex + " from " + tabla + " where " + indexName + "=" + numRegistro.ToString();
OleDbCommand com = new OleDbCommand();
com.Connection = GetConnection();
com.CommandText = query;
OleDbDataReader resuldata = com.ExecuteReader();
if (resuldata.HasRows)
{
resuldata.Read();
System.Type curType = resuldata.GetType();
Curvalue = resuldata.GetInt32(0);
if (curType == typeof(Int32))
{
Curvalue = resuldata.GetInt32(0);
}
if (curType == typeof(Int16))
{
Curvalue = System.Convert.ToInt32(resuldata.GetInt16(0));
}
if (curType == typeof(Int64))
{
Curvalue = System.Convert.ToInt32(resuldata.GetInt64(0));
}
if (curType == typeof(Byte))
{
Curvalue = System.Convert.ToInt32(resuldata.GetByte(0));
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Exception: GetNombreTabla");
return(0);
}
return(Curvalue);
}
public string RUN_Sql_Table_Template_View(string InsertSQL)
{
var serializedResult = "";
var TableTemplate = new List <Table_Template>();
OleDbCommand command = new OleDbCommand(InsertSQL);
command.Connection = connection;
try
{
OleDbDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DateTime date1 = new DateTime();
DateTime date3 = new DateTime();
DateTime.TryParse(reader.GetString(2), out date1);
DateTime date2 = new DateTime(date1.Year, date1.Month, date1.Day);
date3 = reader.GetDateTime(6);
TableTemplate.Add(new Table_Template()
{
ID = reader.GetInt64(0),
Nvarchar = reader.GetString(1),
Date = date2.ToString("yyyyMMdd"),
Decimal = reader.GetDecimal(3),
Boolean = reader.GetBoolean(4),
Int = reader.GetInt32(5),
DateTime = date3.ToString("yyyyMMddHHmmss")
});
}
}
else
{
}
reader.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
var serializer = new JavaScriptSerializer();
serializedResult = serializer.Serialize(TableTemplate);
return(serializedResult);
}
private OneProcess GetProcessFromDB2(long idProcessMySql)
{
OneProcess process = new OneProcess();
try
{
string sql = String.Format("SELECT * FROM DB2ADMIN.PROCESSES AS T WHERE T.ID_PROCESS = {0}", idProcessMySql);
OleDbCommand commandDb2 = new OleDbCommand(sql, connectionDb2);
try
{
using (OleDbDataReader readerDb2 = commandDb2.ExecuteReader())
{
if (readerDb2.HasRows)
{
if (readerDb2.Read())
{
process.Id_Process = readerDb2.GetInt64(0);
process.Dateofcomming = readerDb2.GetDateTime(1);
if (!readerDb2.IsDBNull(2))
{
process.Dateofcomletion = readerDb2.GetDateTime(2);
process.id_Status = readerDb2.GetInt16(3);
process.id_Type_process = readerDb2.GetInt16(4);
process.id_Department = readerDb2.GetInt16(5);
}
else
{
process.Id_Process = 0;
}
}
}
}
}
catch (Exception e)
{
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(process);
}
protected void Page_Load(object sender, EventArgs e)
{
// Don't allow this page to be cached
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetExpires(DateTime.Now);
if (!IsPostBack)
{
// Get how many lines to display per page
int lines = Properties.Settings.Default.DisplayLines;
if (lines > 0)
{
dgMain.PageSize = lines;
}
using (OleDbConnection conn = GetConnection())
{
conn.Open();
// Work out how many rows there are
OleDbCommand cmd = new OleDbCommand("SELECT count(id) as ct, MAX(id) as mx from syslog",
conn);
OleDbDataReader rd = cmd.ExecuteReader();
if (!rd.Read())
{
throw new Exception("Unable to read from database!");
}
int count = rd.GetInt32(0);
long max = count > 0 ? rd.GetInt64(1) : 0;
rd.Close();
dgMain.VirtualItemCount = count;
Session[_currentRows] = max;
conn.Close();
}
dgMain.DataSource = CreateDataSource();
dgMain.DataBind();
}
}
public List <TTicker> getTickersPending()
{
List <TTicker> data = new List <TTicker>();
String qry = "SELECT Moneda, Fecha FROM Tickers WHERE Hecho = 0";
OleDbCommand cmd = new OleDbCommand(qry);
cmd.Connection = cn;
OleDbDataReader rdr = cmd.ExecuteReader();
try {
while (rdr.Read())
{
TTicker d = new TTicker();
d.Moneda = rdr.GetString(0);
d.Fecha = rdr.GetInt64(1);
data.Add(d);
}
}
finally {
rdr.Close();
}
return(data);
}
////registrar usuario
//public static int registrar_usuario( Clase_usuario usu)
//{
// int retorno = 0;
//MySqlCommand comando = new MySqlCommand(string.Format("INSERT INTO usuario(identificacion, nick_name, nombres, apellidos, sexo, correo, fecha_nacimiento,contra) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')",
// usu.identificacion,usu.nick_name, usu.nombres, usu.apellidos,usu.sexo,usu.correo,usu.fecha_nacimiento,usu.contra), clase_conexion.ObtenerConexion());
// retorno = comando.ExecuteNonQuery();
// return retorno;
//}
//login
public static Clase_usuario login(string lnick, string lpass)
{
Clase_usuario Iusuario = new Clase_usuario();
OleDbCommand comando = new OleDbCommand(string.Format("SELECT * FROM usuario WHERE nick_name = '{0}'and contra= '{1}'",
lnick, lpass), clase_conexion.ObtenerConexion());
OleDbDataReader reader = comando.ExecuteReader();
while (reader.Read())
{
Iusuario.identificacion = reader.GetInt64(0);
Iusuario.nick_name = reader.GetString(1);
Iusuario.nombres = reader.GetString(2);
Iusuario.apellidos = reader.GetString(3);
Iusuario.sexo = reader.GetString(4);
Iusuario.correo = reader.GetString(5);
Iusuario.fecha_nacimiento = reader.GetString(6);
Iusuario.contra = reader.GetString(7);
}
return(Iusuario);
}
public void DoTestTypes(DbTypeParametersCollection row)
{
testTypesInvocations++;
exp = null;
string rowId = "43972_" + this.testTypesInvocations.ToString();
OleDbDataReader rdr = null;
OleDbConnection con = null;
try
{
row.ExecuteInsert(rowId);
row.ExecuteSelectReader(rowId, out rdr, out con);
while (rdr.Read())
{
//Run over all the columns in the result set row.
//For each column, try to read it as a Int64.
for (int i = 0; i < row.Count; i++)
{
if (row[i].Value.GetType() == typeof(Int64)) //The value in the result set should be a Int64.
{
try
{
BeginCase(string.Format("Calling GetInt64() on a field of dbtype {0}", row[i].DbTypeName));
Int64 retInt64 = rdr.GetInt64(i);
Compare(row[i].Value, retInt64);
}
catch (Exception ex)
{
exp = ex;
}
finally
{
EndCase(exp);
exp = null;
}
}
else //The value in the result set should NOT be Int64. In this case an Invalid case exception should be thrown.
{
try
{
BeginCase(string.Format("Calling GetInt64() on a field of dbtype {0}", row[i].DbTypeName));
Int64 retInt64 = rdr.GetInt64(i);
ExpectedExceptionNotCaught("InvalidCastException");
}
catch (InvalidCastException ex)
{
ExpectedExceptionCaught(ex);
}
catch (Exception ex)
{
exp = ex;
}
finally
{
EndCase(exp);
exp = null;
}
}
}
}
}
finally
{
row.ExecuteDelete(rowId);
if ((rdr != null) && (!rdr.IsClosed))
{
rdr.Close();
}
if ((con != null) && (con.State != ConnectionState.Closed))
{
con.Close();
}
}
}
private static ArrayList recoverEmployee()
{
OleDbConnection connection = Connect();
OleDbCommand command = null;
OleDbDataReader reader = null;
ArrayList empployee = new ArrayList();
try
{
connection.Open();
string read = "select* From Funcionario";
command = new OleDbCommand(read, connection);
reader = command.ExecuteReader();
while (reader.Read())
{
empployee.Add(new ObjectosFuncionarios(reader.GetInt32(0),
reader.GetString(1), reader.GetInt32(2), reader.GetInt64(3)));
}
}
catch (Exception e)
{
MessageBox.Show("Erro na solicitação de dados: " + e.Message, "DADOS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
connection.Close();
}
return(empployee);
}
/***
* This is used in the CallMarker classes, to fill the PhoneCall objects from the database reader.
*/
public static PhoneCall FillPhoneCallFromOleDataReader(OleDbDataReader dataReader)
{
var column = string.Empty;
var phoneCall = new PhoneCall();
//Start filling the PhoneCall object
phoneCall.SessionIdTime =
dataReader.GetDateTime(dataReader.GetOrdinal(Enums.GetDescription(Enums.PhoneCalls.SessionIdTime)));
//phoneCall.SessionIdTime = Convert.ToDateTime(dataReader[enums.GetDescription(ENUMS.PhoneCalls.SessionIdTime)].ToString());
phoneCall.SessionIdSeq =
dataReader.GetInt32(dataReader.GetOrdinal(Enums.GetDescription(Enums.PhoneCalls.SessionIdSeq)));
column = Enums.GetDescription(Enums.PhoneCalls.ResponseTime);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.ResponseTime = dataReader.GetDateTime(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.SessionEndTime);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.SessionEndTime = dataReader.GetDateTime(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.SourceUserUri);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.SourceUserUri = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.SourceNumberUri);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.SourceNumberUri = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.DestinationUserUri);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.DestinationUserUri = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.DestinationNumberUri);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.DestinationNumberUri = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.FromMediationServer);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.FromMediationServer = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.ToMediationServer);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.ToMediationServer = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.FromGateway);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.FromGateway = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.ToGateway);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.ToGateway = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.SourceUserEdgeServer);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.SourceUserEdgeServer = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.DestinationUserEdgeServer);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.DestinationUserEdgeServer = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.ServerFqdn);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.ServerFqdn = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.PoolFqdn);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.PoolFqdn = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.OnBehalf);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.OnBehalf = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.ReferredBy);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.ReferredBy = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.CalleeUri);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.CalleeUri = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.ChargingParty);
if (ValidateColumnName(ref dataReader, ref column) &&
(dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty))
{
phoneCall.ChargingParty = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.Duration);
if (dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty)
{
phoneCall.Duration = dataReader.GetDecimal(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.MarkerCallFrom);
if (ValidateColumnName(ref dataReader, ref column) &&
(dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty))
{
phoneCall.MarkerCallFrom = dataReader.GetInt64(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.MarkerCallTo);
if (ValidateColumnName(ref dataReader, ref column) &&
(dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty))
{
phoneCall.MarkerCallTo = dataReader.GetInt64(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.MarkerCallToCountry);
if (ValidateColumnName(ref dataReader, ref column) &&
(dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty))
{
phoneCall.MarkerCallToCountry = dataReader.GetString(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.MarkerCallTypeId);
if (ValidateColumnName(ref dataReader, ref column) &&
(dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty))
{
phoneCall.MarkerCallTypeId = dataReader.GetInt32(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.MarkerCallCost);
if (ValidateColumnName(ref dataReader, ref column) &&
(dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty))
{
phoneCall.MarkerCallCost = dataReader.GetInt32(dataReader.GetOrdinal(column));
}
column = Enums.GetDescription(Enums.PhoneCalls.MarkerCallType);
if (ValidateColumnName(ref dataReader, ref column) &&
(dataReader[column] != DBNull.Value || dataReader[column].ToString() != string.Empty))
{
phoneCall.MarkerCallType = dataReader.GetString(dataReader.GetOrdinal(column));
}
//Return teh filled object
return(phoneCall);
}
/// <summary>
/// Test CUBRID data types Get...()
/// </summary>
private static void Test_Various_DataTypes()
{
using (OleDbConnection conn = new OleDbConnection())
{
conn.ConnectionString = TestCasesOld.connString;
conn.Open();
TestCasesOld.ExecuteSQL("drop table if exists t", conn);
string sql = "create table t(";
sql += "c_integer_ai integer AUTO_INCREMENT, ";
sql += "c_smallint smallint, ";
sql += "c_integer integer, ";
sql += "c_bigint bigint, ";
sql += "c_numeric numeric(15,1), ";
sql += "c_float float, ";
sql += "c_decimal decimal(15,3), ";
sql += "c_double double, ";
sql += "c_char char, ";
sql += "c_varchar varchar(4096), ";
sql += "c_time time, ";
sql += "c_date date, ";
sql += "c_timestamp timestamp, ";
sql += "c_datetime datetime, ";
sql += "c_bit bit(1), ";
sql += "c_varbit bit varying(4096), ";
sql += "c_monetary monetary, ";
sql += "c_string string";
sql += ")";
TestCasesOld.ExecuteSQL(sql, conn);
sql = "insert into t values(";
sql += "1, ";
sql += "11, ";
sql += "111, ";
sql += "1111, ";
sql += "1.1, ";
sql += "1.11, ";
sql += "1.111, ";
sql += "1.1111, ";
sql += "'a', ";
sql += "'abcdfghijk', ";
sql += "TIME '13:15:45 pm', ";
sql += "DATE '00-10-31', ";
sql += "TIMESTAMP '13:15:45 10/31/2008', ";
sql += "DATETIME '13:15:45 10/31/2008', ";
sql += "B'0', ";
sql += "B'0', ";
sql += "123456789, ";
sql += "'qwerty'";
sql += ")";
TestCasesOld.ExecuteSQL(sql, conn);
sql = "select * from t";
using (OleDbCommand cmd = new OleDbCommand(sql, conn))
{
try
{
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read()) //only one row will be available
{
Debug.Assert(reader.GetInt32(0) == 1);
Debug.Assert(reader.GetInt16(1) == 11);
Debug.Assert(reader.GetInt32(2) == 111);
Debug.Assert(reader.GetInt64(3) == 1111);
Debug.Assert(reader.GetDecimal(4) == (decimal)1.1);
Debug.Assert(reader.GetFloat(5) == (float)1.11); //"Single"
Debug.Assert(reader.GetDecimal(6) == (decimal)1.111);
Debug.Assert(reader.GetDouble(7) == (double)1.1111);
//We use GetString() because GetChar() is not supported or System.Data.OleDb.
//http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbdatareader.getchar
Debug.Assert(reader.GetString(8) == "a"); //"String" ("Char" in CUBRID)
Debug.Assert(reader.GetString(9) == "abcdfghijk"); //"String" ("String in CUBRID)
//GetGateTime cannot cast just the time value in a DateTime object, so we use TimeSpan
Debug.Assert(reader.GetTimeSpan(10) == new TimeSpan(13, 15, 45)); //"TimeSpan"
Debug.Assert(reader.GetDateTime(11) == new DateTime(2000, 10, 31)); //"DateTime"
Debug.Assert(reader.GetDateTime(12) == new DateTime(2008, 10, 31, 13, 15, 45)); //"DateTime"
Console.WriteLine(reader.GetValue(13));
Debug.Assert(reader.GetDateTime(13) == new DateTime(2008, 10, 31, 13, 15, 45)); //"DateTime"
//The GetByte() method does not perform any conversions and the driver does not give tha data as Byte
//http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbdatareader.getbyte
//Use GetValue() or GetBytes() methods to retrieve BIT coulumn value
// Debug.Assert((reader.GetValue(14) as byte[])[0] == (byte)0); //"Byte[]" ("bit(1)" in CUBRID)
//Or
Byte[] value = new Byte[1];
reader.GetBytes(14, 0, value, 0, 1);
// Debug.Assert(value[0] == (byte)0);//"Byte[]" ("bit(1)" in CUBRID)
//Debug.Assert((reader.GetValue(14) as byte[])[0] == (byte)0); //"Byte[]" ("bit varying(4096)" in CUBRID)
//Or
// reader.GetBytes(15, 0, value, 0, 1);
// Debug.Assert(value[0] == (byte)0);//"Byte[]" ("bit varying(4096)" in CUBRID)
Debug.Assert(reader.GetDouble(16) == 123456789.0); //"Double" ("Monetary" in CUBRID)
Debug.Assert(reader.GetString(17) == "qwerty"); //"String"
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
TestCasesOld.ExecuteSQL("drop table if exists t", conn);
}
}
//-----------------------------------------------------------------------------------------------------------------------
public int InsertNewTasksFromDate(long lastDateIc, int iday)
{
int alladd = 0;
string nn1 = "NULL";
string nn2 = "NULL";
string nn3 = "NULL";
string sql;
int allAdded = 0;
OneTask oneTask = new OneTask();
DateTime dtfrom = new DateTime(lastDateIc);
DateTime dtto = dtfrom.AddDays(iday);
string sDateFrom = dtfrom.ToString("yyyy-MM-dd hh:mm:ss.fff");
string sDateTo = dtto.ToString("yyyy-MM-dd hh:mm:ss.fff");
if (connectionDb2 != null)
{
string commandString =
string.Format(
"SELECT * FROM DB2ADMIN.TASKS AS T WHERE (DATE(T.DATEOFCOMMING)>='{0}')AND(DATE(T.DATEOFCOMMING)<='{1}')AND(T.ID_DEPARTMENT={2})",
sDateFrom, sDateTo, _params.Department);
OleDbCommand commandDB2 = new OleDbCommand(commandString, connectionDb2);
using (OleDbDataReader dataReader = commandDB2.ExecuteReader())
{
if (dataReader.HasRows)
{
while (dataReader.Read())
{
try
{
oneTask.Id_task = dataReader.GetInt64(0);
oneTask.Id_type_process = dataReader.GetInt64(1);
oneTask.Id_process = dataReader.GetInt64(2);
if (!dataReader.IsDBNull(3))
{
oneTask.Id_stage_to = dataReader.GetInt32(3);
}
if (!dataReader.IsDBNull(4))
{
oneTask.Id_stage_from = dataReader.GetInt32(4);
}
else
{
nn1 = "NULL";
}
oneTask.Type_transaction = dataReader.GetInt32(5);
oneTask.Dateofcomming = dataReader.GetDateTime(6);
if (!dataReader.IsDBNull(7))
{
oneTask.Dateoftaking = dataReader.GetDateTime(7);
nn2 = "'" + oneTask.Dateoftaking.ToString(DATEFORMAT) + "'";
}
else
{
nn2 = "NULL";
}
if (!dataReader.IsDBNull(8))
{
oneTask.Dateofcomlation = dataReader.GetDateTime(8);
nn3 = "'" + oneTask.Dateofcomlation.ToString(DATEFORMAT) + "'";
}
else
{
nn3 = "NULL";
}
if (!dataReader.IsDBNull(9))
{
oneTask.Id_user = dataReader.GetString(9);
}
else
{
oneTask.Id_user = "******";
}
if (!dataReader.IsDBNull(10))
{
oneTask.Type_complation = dataReader.GetInt32(10);
}
else
{
oneTask.Type_complation = 0;
}
oneTask.Id_department = dataReader.GetInt32(13);
oneTask.Id_tabel = "XXX";
}
catch (Exception e)
{
Log.we(DateTime.Now, "Считывание данных из ПФР (TASKS)", e.Message);
}
//подготовим sql
sql =
"INSERT INTO TASKS (ID_TASK,ID_TYPE_PROCESS,ID_PROCESS,ID_STAGE_TO,ID_STAGE_FROM,TYPE_TRANSACTION," +
"DATEOFCOMMING,DATEOFTAKING,DATEOFCOMLATION,ID_USER,TYPE_COMPLATION,ID_DEPARTMENT,ID_TABEL) VALUES (";
sql = sql + String.Format("{0},{1},{2},{3},{4},{5},'{6}',{7},{8},'{9}',{10},{11},'{12}')", oneTask.Id_task, oneTask.Id_type_process,
oneTask.Id_process, oneTask.Id_stage_to, nn1, oneTask.Type_transaction,
oneTask.Dateofcomming.ToString(DATEFORMAT), nn2, nn3, oneTask.Id_user, oneTask.Type_complation,
oneTask.Id_department, oneTask.Id_tabel);
//подготовим вставку в БД Инфоцентра
MySqlCommand commandMySQL = new MySqlCommand(sql, connectionMySQL);
try
{
alladd = commandMySQL.ExecuteNonQuery();
allAdded += alladd;
}
catch (Exception e)
{
Log.we(DateTime.Now, "Запись в БД Инфоцентр (TASKS)", e.Message);
}
}// цикл переьор всех записей
Log.wi(DateTime.Now, "Новые задачи", i: string.Format("Добавлено:{0}", allAdded));
// если все-таки ничего не добавлено, то счетчик даты увеличиваем на день
if (allAdded <= 0)
{
lastDateIc = IncrementDate(lastDateIc, iday);
SaveLastDate(lastDateIc, TableType.Task);
}
} //если есть хоть одна запись в данном диапазоне дней
else /*в БД ИЦ ничего не нашлось*/
{
Log.wi(DateTime.Now, "Выборка данных из БД ПФР (TASKS)",
i: string.Format("За {0} + 1день ничего не нашлось", new DateTime(lastDateIc).ToString(DATEFORMAT)));
//если в БД ИЦ нет выбраны данные то счетчик даты увеличиваем на (N)день, что-бы стартовать потом со след. даты
lastDateIc = IncrementDate(lastDateIc, iday);
SaveLastDate(lastDateIc, TableType.Task);
}
} //using
} //if connection
return(allAdded);
} //insert method end
public string RUN_Sql_Table_Template_Add(string InsertSQL, string jsonnewrow)
{
int ibool;
long iDec;
decimal jDec;
string strDateTime;
//var serializedResult = "";
var ErrorTable = new List <WebService_Error>();
var TableTemplate = new List <Table_Template>();
var serializer = new JavaScriptSerializer();
var deserializedResult = serializer.Deserialize <List <Table_Template> >(jsonnewrow);
jDec = deserializedResult[0].Decimal * 100;
iDec = Convert.ToInt64(jDec);
if (deserializedResult[0].Boolean == true)
{
ibool = 1;
}
else
{
ibool = 0;
}
strDateTime = deserializedResult[0].DateTime.ToString().Substring(0, 8) + " " + deserializedResult[0].DateTime.ToString().Substring(8, 2) + ":" + deserializedResult[0].DateTime.ToString().Substring(10, 2) + ":" + deserializedResult[0].DateTime.ToString().Substring(12, 2);
InsertSQL = InsertSQL + " '" + deserializedResult[0].Nvarchar.ToString() + "','" + deserializedResult[0].Date.ToString() + "'," + iDec.ToString() + "," + ibool.ToString() + "," + deserializedResult[0].Int.ToString() + ",'" + strDateTime + "'";
OleDbCommand command = new OleDbCommand(InsertSQL);
command.Connection = connection;
try
{
OleDbDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
ErrorTable.Add(new WebService_Error()
{
Result = reader.GetInt32(0),
SQL_Error_Message = reader.GetString(1),
SQL_Error_Procedure = reader.GetString(2),
SQL_Error_Line = reader.GetString(3),
ID = reader.GetInt64(4)
});
}
else
{
}
reader.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
var serializedResult = serializer.Serialize(ErrorTable);
return(serializedResult);
}
public int InsertNewProcessFromDate(long lastDateIc, int iday)
{
int alladd = 0;
string nnn = "NULL";
string sql;
int allAdded = 0;
OneProcess oneProcess = new OneProcess();
DateTime dtfrom = new DateTime(lastDateIc);
DateTime dtto = dtfrom.AddDays(iday);
string sDateFrom = dtfrom.ToString("yyyy-MM-dd hh:mm:ss.fff");
string sDateTo = dtto.ToString("yyyy-MM-dd hh:mm:ss.fff");
if (connectionDb2 != null)
{
OleDbCommand commandDB2 = new OleDbCommand();
;
string commandString =
string.Format(
"SELECT * FROM DB2ADMIN.PROCESSES AS T WHERE (DATE(T.DATEOFCOMMING)>='{0}')AND(DATE(T.DATEOFCOMMING)<='{1}')AND(T.ID_DEPARTMENT={2})",
sDateFrom, sDateTo, _params.Department);
commandDB2.CommandText = commandString;
commandDB2.Connection = connectionDb2;
OleDbDataReader readerDB2 = commandDB2.ExecuteReader();
if (readerDB2.HasRows) // выбраны новые данные из БД ИЦ
{
while (readerDB2.Read())
{
try
{
oneProcess.Id_Process = readerDB2.GetInt64(0);
oneProcess.Dateofcomming = readerDB2.GetDateTime(1);
if (!readerDB2.IsDBNull(2))
{
oneProcess.Dateofcomletion = readerDB2.GetDateTime(2);
nnn = oneProcess.Dateofcomletion.ToString(DATEFORMAT);
}
else
{
nnn = "NULL";
}
if (!readerDB2.IsDBNull(3))
{
oneProcess.id_Status = readerDB2.GetInt32(3);
}
if (!readerDB2.IsDBNull(4))
{
oneProcess.id_Type_process = readerDB2.GetInt32(4);
}
oneProcess.id_Department = readerDB2.GetInt32(5);
}
catch (Exception e)
{
Log.we(DateTime.Now, "Добавление данных PROCESSES в ИнфоЦентр", e.Message);
}
if (nnn != "NULL")
{
sql = string.Format(
"INSERT INTO PROCESSES (ID_PROCESS, DATEOFCOMMING, DATEOFCOMPLETION, ID_STATUS, ID_TYPE_PROCESS, ID_DEPARTMENT)" +
"VALUES({0},'{1}','{2}',{3},{4},{5});", oneProcess.Id_Process,
oneProcess.Dateofcomming.ToString(DATEFORMAT), nnn,
oneProcess.id_Status, oneProcess.id_Type_process, oneProcess.id_Department);
}
else
{
//вариант запроса с пустым значением даты
sql = string.Format(
"INSERT INTO PROCESSES (ID_PROCESS, DATEOFCOMMING, DATEOFCOMPLETION, ID_STATUS, ID_TYPE_PROCESS, ID_DEPARTMENT)" +
"VALUES({0},'{1}',{2},{3},{4},{5});", oneProcess.Id_Process, oneProcess.Dateofcomming.ToString(DATEFORMAT),
nnn,
oneProcess.id_Status, oneProcess.id_Type_process, oneProcess.id_Department);
}
//подготовим вставку в БД Инфоцентра
MySqlCommand commandMySQL = new MySqlCommand(sql, connectionMySQL);
//добавляем запись
try
{
alladd = commandMySQL.ExecuteNonQuery();
allAdded += alladd;
}
catch (Exception e)
{
//Log.we(DateTime.Now, "Запись в БД Инфоцентр", e.Message);
}
} //цикл по найденым в ПФР
Log.wi(DateTime.Now, "Новые процессы", i: string.Format("Добавлено:{0}", allAdded));
// если все-таки ничего не добавлено, то счетчик даты увеличиваем на день
if (allAdded <= 0)
{
lastDateIc = IncrementDate(lastDateIc, iday);
SaveLastDate(lastDateIc, TableType.Process);
}
}
else /*в БД ИЦ ничего не нашлось*/
{
Log.wi(DateTime.Now, "Выборка данных из БД ПФР",
i: string.Format("За {0} + 1день ничего не нашлось", new DateTime(lastDateIc).ToString(DATEFORMAT)));
//если в БД ИЦ нет выбраны данные то счетчик даты увеличиваем на день, что-бы стартовать потом со след. даты
lastDateIc = IncrementDate(lastDateIc, iday);
SaveLastDate(lastDateIc, TableType.Process);
}
} //if connection
return(allAdded);
}
