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