/// <summary> /// Loads the entity from a <b>SqlDataReader</b> object. /// </summary> /// <param name="dr">The data reader to read from.</param> /// <returns>Returns the number of columns read.</returns> /// <remarks> /// Always reads at the current cursor position, doesn't calls the <b>Read</b> function /// on the <b>SqlDataReader</b> object. Reads data columns by their ordinal position in /// the query and not by their names. /// </remarks> internal override int LoadFromDataReader(SqlDataReader dr) { int o = base.LoadFromDataReader(dr); ++o; // skip guid this.workflowTypeName = dr.GetString(++o); this.dateStarted = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o); this.dateFinished = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o); this.jobExecutionStatus = (JobExecutionState)dr.GetInt32(++o); this.suspendTimeout = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o); this.scheduleType = (ScheduleType)dr.GetInt32(++o); this.scheduleTime = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o); this.recurringPeriod = (RecurringPeriod)dr.GetInt32(++o); this.recurringInterval = dr.GetInt32(++o); this.recurringMask = dr.GetInt64(++o); this.workflowInstanceId = dr.IsDBNull(++o) ? Guid.Empty : dr.GetGuid(o); this.adminRequestTime = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o); if (!dr.IsDBNull(++o)) { XmlSerializer ser = new XmlSerializer(typeof(JobAdminRequestData)); StringReader sr = new StringReader(dr.GetString(o)); this.adminRequestData = (JobAdminRequestData)ser.Deserialize(sr); } else { this.adminRequestData = null; } this.adminRequestResult = dr.GetInt32(++o); this.exceptionMessage = dr.IsDBNull(++o) ? null : dr.GetString(o); return o; }
protected override Exception ProcessSqlResult(SqlDataReader reader) { Exception nextResultSet = StoreUtilities.GetNextResultSet(base.InstancePersistenceCommand.Name, reader); if (nextResultSet == null) { bool flag = !reader.IsDBNull(1); TimeSpan? taskIntervalOverride = null; bool flag2 = false; if (flag) { DateTime dateTime = reader.GetDateTime(1); DateTime time2 = reader.GetDateTime(2); if (dateTime <= time2) { flag2 = true; } else { taskIntervalOverride = new TimeSpan?(dateTime.Subtract(time2)); } } if (flag2) { base.Store.UpdateEventStatus(true, InstancePersistenceEvent<HasRunnableWorkflowEvent>.Value); return nextResultSet; } base.Store.UpdateEventStatus(false, InstancePersistenceEvent<HasRunnableWorkflowEvent>.Value); base.StoreLock.InstanceDetectionTask.ResetTimer(false, taskIntervalOverride); } return nextResultSet; }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT appname, AccountID, deviceid, pushid, phonetype, status, createdatetime, PHONE_OS, PHONE_NAME, PHONE_MODEL, updatedatetime FROM MobileDeviceData WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _appname = reader.GetString(0); _accountID = reader.GetString(1); _deviceid = reader.GetString(2); _pushid = reader.GetString(3); _phonetype = reader.GetString(4); _status = reader.GetBoolean(5); _createdatetime = reader.GetDateTime(6); _pHONE_OS = reader.GetString(7); _pHONE_NAME = reader.GetString(8); _pHONE_MODEL = reader.GetString(9); _updatedatetime = reader.GetDateTime(10); } reader.Close(); } }
/// <summary> /// 数据转用户实体 /// </summary> public static UserInfo DataToModel(SqlDataReader rdr) { UserInfo user = new UserInfo(); if (!rdr.IsDBNull(0)) user.UserID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) user.UserName = rdr.GetString(1); if (!rdr.IsDBNull(2)) user.UserPassword = rdr.GetString(2); if (!rdr.IsDBNull(3)) user.UserNickName = rdr.GetString(3); if (!rdr.IsDBNull(4)) user.UserImage = rdr.GetString(4); if (!rdr.IsDBNull(5)) user.UserPhone = rdr.GetString(5); if (!rdr.IsDBNull(6)) user.UserEmail = rdr.GetString(6); if (!rdr.IsDBNull(7)) user.UserTheme = rdr.GetString(7); if (!rdr.IsDBNull(8)) user.UserLevel = rdr.GetByte(8); if (!rdr.IsDBNull(9)) user.UserFrom = rdr.GetString(9); if (!rdr.IsDBNull(10)) user.ModifyDate = rdr.GetDateTime(10); if (!rdr.IsDBNull(11)) user.CreateDate = rdr.GetDateTime(11); if (!rdr.IsDBNull(12)) user.UserCity = rdr.GetString(12); if (!rdr.IsDBNull(13)) user.UserMoney = rdr.GetDecimal(13); if (!rdr.IsDBNull(14)) user.UserWorkDay = rdr.GetString(14); if (!rdr.IsDBNull(15)) user.UserFunction = rdr.GetString(15); if (!rdr.IsDBNull(16)) user.CategoryRate = rdr.GetInt32(16); if (!rdr.IsDBNull(17)) user.Synchronize = rdr.GetByte(17); if (!rdr.IsDBNull(18)) user.MoneyStart = rdr.GetDecimal(18); if (!rdr.IsDBNull(19)) user.IsUpdate = rdr.GetByte(19); return user; }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT logID, deviceid, phonetype, webservicenode, webservicemethod, webserviceparams, serverReturnData, sCreateDatetime, sRequestDatetime, webserviceparamsDecode, statuscode, ID, user_type, version FROM WebserviceLog WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _logID = reader.GetString(0); _deviceid = reader.GetString(1); _phonetype = reader.GetString(2); _webservicenode = reader.GetString(3); _webservicemethod = reader.GetString(4); _webserviceparams = reader.GetString(5); _serverReturnData = reader.GetString(6); _sCreateDatetime = reader.GetDateTime(7); _sRequestDatetime = reader.GetDateTime(8); _webserviceparamsDecode = reader.GetString(9); _statuscode = reader.GetInt32(10); _iD = reader.GetString(11); _user_type = reader.GetString(12); _version = reader.GetString(13); } reader.Close(); } }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT GroupID, AccountID, Name, Description, Password, Startup, PWLastUpdateTime, PWType, CreateTime, dModifyTime, iFailTimes, dLockTime, cRoleID, AD_CheckFlag, cCallID, cPWD FROM SecurityUserAccount WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _groupID = reader.GetString(0); _accountID = reader.GetString(1); _name = reader.GetString(2); _description = reader.GetString(3); //_password = reader.GetString(4); _password = (byte[])reader[4]; _startup = reader.GetBoolean(5); _pWLastUpdateTime = reader.GetDateTime(6); _pWType = reader.GetInt16(7); _createTime = reader.GetDateTime(8); _dModifyTime = reader.GetDateTime(9); _iFailTimes = reader.GetInt16(10); _dLockTime = reader.GetDateTime(11); _cRoleID = reader.GetInt16(12); _aD_CheckFlag = reader.GetBoolean(13); _cCallID = reader.GetString(14); _cPWD = reader.GetString(15); } reader.Close(); } }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT HAPPY_ID, CSTATUS, FILE_KIND, APPLY_TARGET, CKEY1, CKEY2, CKEY3, TITLE, URL, F_IDX, F_NAME, CORDER, LDATE, LUSER, SELECTALL, ISTESTER, ONLINE_TIME, OFFLINE_TIME FROM MIP_HAPPY WHERE HAPPY_ID=@HAPPY_ID_PARAM"; cmd.Parameters.AddWithValue("@HAPPY_ID_PARAM", _hAPPY_ID); System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _hAPPY_ID = reader.GetInt32(0); _cSTATUS = reader.GetInt32(1); _fILE_KIND = reader.GetInt32(2); _aPPLY_TARGET = reader.GetInt32(3); _cKEY1 = reader.GetString(4); _cKEY2 = reader.GetString(5); _cKEY3 = reader.GetString(6); _tITLE = reader.GetString(7); _uRL = reader.GetString(8); _f_IDX = reader.GetInt32(9); _f_NAME = reader.GetString(10); _cORDER = reader.GetInt32(11); _lDATE = reader.GetDateTime(12); _lUSER = reader.GetString(13); _sELECTALL = reader.GetInt32(14); _iSTESTER = reader.GetInt32(15); _oNLINE_TIME = reader.GetDateTime(16); _oFFLINE_TIME = reader.GetDateTime(17); } reader.Close(); } }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT MIP_MSG_NO, MSG_TARGET, RESERVATION, ONLINE_TIME, OFFLINE_TIME, DOPUSH, MSG_KIND_1, MSG_KIND_2, MSG_TITLE, MSG_CONTENT, MSG_STATE, LDATE, LUSER, SELECTALL, PROCESSED, ISNEW FROM MIP_MSG_MAIN WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _mIP_MSG_NO = reader.GetInt32(0); _mSG_TARGET = reader.GetString(1); _rESERVATION = reader.GetString(2); _oNLINE_TIME = reader.GetDateTime(3); _oFFLINE_TIME = reader.GetDateTime(4); _dOPUSH = reader.GetString(5); _mSG_KIND_1 = reader.GetString(6); _mSG_KIND_2 = reader.GetString(7); _mSG_TITLE = reader.GetString(8); _mSG_CONTENT = reader.GetString(9); _mSG_STATE = reader.GetString(10); _lDATE = reader.GetDateTime(11); _lUSER = reader.GetString(12); _sELECTALL = reader.GetInt32(13); _pROCESSED = reader.GetInt32(14); _iSNEW = reader.GetInt32(15); } reader.Close(); } }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT MIP_MSG_ID, MSG_NO, MSG_SOURCE, PCA_MSG_ID, ACCOUNTID, RESERVATION, ONLINE_TIME, OFFLINE_TIME, DOPUSH, MSG_KIND_1, MSG_KIND_2, MSG_TITLE, MSG_CONTENT, READ_STATE, READ_TIME, LDATE, REC_STA, PUSHED FROM MIP_MSG_DETAIL WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _mIP_MSG_ID = reader.GetInt32(0); _mSG_NO = reader.GetInt32(1); _mSG_SOURCE = reader.GetString(2); _pCA_MSG_ID = reader.GetString(3); _aCCOUNTID = reader.GetString(4); _rESERVATION = reader.GetString(5); _oNLINE_TIME = reader.GetDateTime(6); _oFFLINE_TIME = reader.GetDateTime(7); _dOPUSH = reader.GetString(8); _mSG_KIND_1 = reader.GetString(9); _mSG_KIND_2 = reader.GetString(10); _mSG_TITLE = reader.GetString(11); _mSG_CONTENT = reader.GetString(12); _rEAD_STATE = reader.GetString(13); _rEAD_TIME = reader.GetDateTime(14); _lDATE = reader.GetDateTime(15); _rEC_STA = reader.GetString(16); _pUSHED = reader.GetInt32(17); } reader.Close(); } }
///<summary></summary> protected override void ReadExecuted(System.Data.SqlClient.SqlDataReader dr) { if (dr != null && !dr.IsClosed) { #region Read Each Field if (!dr.IsDBNull(dr.GetOrdinal("Id"))) { m_Current.Id = dr.GetInt32(dr.GetOrdinal("Id")); } if (!dr.IsDBNull(dr.GetOrdinal("Title"))) { m_Current.Title = dr.GetString(dr.GetOrdinal("Title")); } if (!dr.IsDBNull(dr.GetOrdinal("Body"))) { m_Current.Body = dr.GetString(dr.GetOrdinal("Body")); } if (!dr.IsDBNull(dr.GetOrdinal("ShortDesc"))) { m_Current.ShortDesc = dr.GetString(dr.GetOrdinal("ShortDesc")); } if (!dr.IsDBNull(dr.GetOrdinal("Description"))) { m_Current.Description = dr.GetString(dr.GetOrdinal("Description")); } if (!dr.IsDBNull(dr.GetOrdinal("Meta"))) { m_Current.Meta = dr.GetString(dr.GetOrdinal("Meta")); } if (!dr.IsDBNull(dr.GetOrdinal("UrlSlug"))) { m_Current.UrlSlug = dr.GetString(dr.GetOrdinal("UrlSlug")); } if (!dr.IsDBNull(dr.GetOrdinal("Published"))) { m_Current.Published = dr.GetBoolean(dr.GetOrdinal("Published")); } if (!dr.IsDBNull(dr.GetOrdinal("PostedOn"))) { m_Current.PostedOn = dr.GetDateTime(dr.GetOrdinal("PostedOn")); } if (!dr.IsDBNull(dr.GetOrdinal("Modified"))) { m_Current.Modified = dr.GetDateTime(dr.GetOrdinal("Modified")); } if (!dr.IsDBNull(dr.GetOrdinal("Category"))) { m_Current.Category = dr.GetString(dr.GetOrdinal("Category")); } if (!dr.IsDBNull(dr.GetOrdinal("Enabled"))) { m_Current.Enabled = dr.GetBoolean(dr.GetOrdinal("Enabled")); } #endregion ExistsInDB = true; Mode = EditMode.None; SetOriginalValues(); } }
private UsuarioEntity CrearUsuario(SqlDataReader cursor) { UsuarioEntity usuario = new UsuarioEntity(); usuario.Id = cursor.GetInt32(cursor.GetOrdinal("UsuarioID")); usuario.Nombre = cursor.GetString(cursor.GetOrdinal("UsuarioNombre")); usuario.Perfil =char.Parse( cursor.GetValue(cursor.GetOrdinal("UsuarioPerfil")).ToString()); usuario.Email = cursor.GetString(cursor.GetOrdinal("UsuarioEmail")); usuario.Password = cursor.GetString(cursor.GetOrdinal("UsuarioPassword")); usuario.Provincia = cursor.GetString(cursor.GetOrdinal("UsuarioProvincia")); usuario.Ciudad = cursor.GetString(cursor.GetOrdinal("UsuarioCiudad")); if (!cursor.IsDBNull(cursor.GetOrdinal("UsuarioFoto"))) usuario.Foto = cursor.GetString(cursor.GetOrdinal("UsuarioFoto")); usuario.FechaRegistracion = cursor.GetDateTime(cursor.GetOrdinal("UsuarioFechaRegistracion")); if (!cursor.IsDBNull(cursor.GetOrdinal("UsuarioFechaActualizacion"))) usuario.FechaActualizacion = cursor.GetDateTime(cursor.GetOrdinal("UsuarioFechaActualizacion")); switch (usuario.Perfil) { case 'M': usuario.musico = new MusicoEntity(); usuario.musico.FechaNacimiento = cursor.GetDateTime(cursor.GetOrdinal("UsuarioFechaNacimiento")); usuario.musico.Genero = cursor.GetString(cursor.GetOrdinal("UsuarioGenero")); if (!cursor.IsDBNull(cursor.GetOrdinal("CuentaYoutube"))) usuario.musico.CuentaYoutube = cursor.GetString(cursor.GetOrdinal("CuentaYoutube")); if (!cursor.IsDBNull(cursor.GetOrdinal("CuentaFacebook"))) usuario.musico.CuentaFacebook = cursor.GetString(cursor.GetOrdinal("CuentaFacebook")); if (!cursor.IsDBNull(cursor.GetOrdinal("CuentaSoundCloud"))) usuario.musico.CuentaSoundCloud = cursor.GetString(cursor.GetOrdinal("CuentaSoundCloud")); if (!cursor.IsDBNull(cursor.GetOrdinal("CuentaTwitter"))) usuario.musico.CuentaTwitter = cursor.GetString(cursor.GetOrdinal("CuentaTwitter")); break; default: usuario.lugar = new LugarEntity(); usuario.lugar.DirCalle = cursor.GetString(cursor.GetOrdinal("DirCalle")); usuario.lugar.DirNumero = cursor.GetInt32(cursor.GetOrdinal("DirNro")); if (!cursor.IsDBNull(cursor.GetOrdinal("HorarioDesde"))) usuario.lugar.HorarioDesde = cursor.GetString(cursor.GetOrdinal("HorarioDesde")); if (!cursor.IsDBNull(cursor.GetOrdinal("HorarioHasta"))) usuario.lugar.HorarioHasta = cursor.GetString(cursor.GetOrdinal("HorarioHasta")); break; } return usuario; }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT MAIL_ID, APP_TYPE, SOURCE, EMAIL_ADDR, MAINORCC, NOTETXT, LDATA, LUSER FROM MIP_EMAIL WHERE MAIL_ID=@MAIL_ID_PARAM"; cmd.Parameters.AddWithValue("@MAIL_ID_PARAM", _mAIL_ID); System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _mAIL_ID = reader.GetInt32(0); _aPP_TYPE = reader.GetInt32(1); _sOURCE = reader.GetString(2); _eMAIL_ADDR = reader.GetString(3); _mAINORCC = reader.GetInt32(4); _nOTETXT = reader.GetString(5); _lDATA = reader.GetDateTime(6); _lUSER = reader.GetString(7); } reader.Close(); } }
public RoadMap(string name ) { mName = name; mDatabase.connect(); mReader = mDatabase.executeread("SELECT Timestamp, Description, UserID FROM [dbo].[Roadmap] WHERE Name = '" + name + "'"); mReader.Read(); mTimeStamp = mReader.GetDateTime(0); mDescription = mReader.GetString(1); string UID = mReader.GetString(2); mDatabase.close(); mDatabase.connect(); mReader = mDatabase.executeread("SELECT Name, Email, Password FROM [dbo].[User] WHERE ID = '" + UID + "'"); mReader.Read(); mUser = new User(mReader.GetString(0), UID, mReader.GetString(1), mReader.GetString(2)); mDatabase.close(); mTimeline = new TimeLine(mName); //Get the StrategyPoints mDatabase.connect(); mReader = mDatabase.executeread("SELECT Name, Description FROM [dbo].[StrategyPoint] WHERE RoadmapName = '" + name + "'"); while (mReader.Read()) { StrategyPoint sp = new StrategyPoint(mReader.GetString(0), mReader.GetString(1)); mStrategyPoints.Add(sp); } mDatabase.close(); }
/// <summary> /// 根据sqldatareader进行获取模型 /// </summary> /// <param name="sdr"></param> /// <returns></returns> public T_Member GetModelBySDR(SqlDataReader sdr) { T_Member t_m = null; if (sdr.Read()) { t_m = new T_Member(); t_m.F_Id = sdr.GetInt32(0); t_m.F_Email = sdr.GetString(1); t_m.F_Password = sdr.GetString(2); t_m.F_Sex = sdr.GetBoolean(3); t_m.F_NickName = sdr.GetString(4); t_m.F_Headpic = sdr.GetString(5); t_m.F_SecurityPassWord = sdr.GetString(6); t_m.F_Alipay = sdr.GetString(7); t_m.F_Issues = sdr.GetString(8); t_m.F_Answer = sdr.GetString(9); t_m.F_InitPassWord = sdr.GetString(10); t_m.F_Mobile = sdr.GetString(11); t_m.F_QQ = sdr.GetString(12); t_m.F_Level = sdr.GetInt32(13); t_m.F_Gold = sdr.GetInt32(14); t_m.F_Diamond = sdr.GetInt32(15); t_m.F_VIP = sdr.GetBoolean(16); t_m.F_KEY = sdr.GetString(17); t_m.F_Status = sdr.GetInt32(18); t_m.F_CreateDate = sdr.GetDateTime(19); } return t_m; }
/// <summary> /// find if specific stock symbol has been analysed in the same day. Find if stock record exist in the database /// </summary> /// <param name="symbol"></param> /// <returns></returns> public int IsStockAnalysedRecently(string symbol) { using (StockConn = new SqlConnection(Conn)) { string cmdText = "SELECT TOP (1) [timeStamp] FROM [Stock].[dbo].[StockAnalysis] WHERE [symbol] = '" + symbol + "'"; StockConn.Open(); SqlCommand Cmd = new SqlCommand(cmdText, StockConn); using (System.Data.SqlClient.SqlDataReader oReader = Cmd.ExecuteReader()) { DateTime tmp = new DateTime(1, 1, 1, 1, 1, 1); bool isExist = false; while (oReader.Read()) { tmp = oReader.GetDateTime(0); isExist = true; } if (!isExist) { return(0); } var Now = DateTime.Now; if (tmp.Year == Now.Year && tmp.Month == Now.Month && tmp.Day == Now.Day) { return(2); } else { return(1); } } } }
public int getComments(int id, out List<string> name, out List<DateTime> date, out List<string> comments) { name = new List<string>(); date = new List<DateTime>(); comments = new List<string>(); cmd.CommandText = "SELECT * FROM comment where id=" + id.ToString() + " ORDER BY comdate DESC"; try { SqlInit(); dr = cmd.ExecuteReader(); while (dr.Read()) { name.Add(dr.GetString(1)); date.Add(dr.GetDateTime(2)); comments.Add(dr.GetString(3)); } } catch(SqlException e) { SqlExit(); return 666; } if (name.Count == 0) { SqlExit(); return 1;//no comments } SqlExit(); return 0;//success }
public static NewMemberBalancePrediction Factory(SqlDataReader reader) { var newMemberId = reader.GetInt32(0); var dependentId = reader.GetInt32(1); var birthYear = reader.GetInt32(2); var state = reader.GetString(3); var lastCptCode = reader.GetString(4); var cachedBalance = reader.GetString(5); var recommendedBalance = reader.GetValue(6); double d; double.TryParse(recommendedBalance == null ? "0" : recommendedBalance.ToString(), out d); var sufficientAmount = reader.GetInt32(7); var serviceEnd = reader.GetDateTime(8); return new NewMemberBalancePrediction { NewMemberId = newMemberId, DependentId = dependentId, BirthYear = birthYear, State = state, LastCptCode = lastCptCode, CachedBalance = cachedBalance, RecommendedBalance = Math.Round(d, 2), SufficientAmount = sufficientAmount, ServiceEnd = serviceEnd }; }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT RecordID, ModuleDesc, FunctionDesc, ActionDesc, FieldDesc, FieldBefore, FieldAfter, Name, AccountID, cDatetime, Top5 FROM SecurityUserAccount_OperateRecord WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _recordID = reader.GetString(0); _moduleDesc = reader.GetString(1); _functionDesc = reader.GetString(2); _actionDesc = reader.GetString(3); _fieldDesc = reader.GetString(4); _fieldBefore = reader.GetString(5); _fieldAfter = reader.GetString(6); _name = reader.GetString(7); _accountID = reader.GetString(8); _cDatetime = reader.GetDateTime(9); _top5 = reader.GetInt32(10); } reader.Close(); } }
public static DateTime ValidateDataReader_T(SqlDataReader reader,string colname) { if(reader.GetValue(reader.GetOrdinal(colname))!=DBNull.Value) return reader.GetDateTime(reader.GetOrdinal(colname)); else return System.DateTime.MinValue; }
/** * Descripción: Obtiene el campo fecha de la tabla de forma segura (revisando si es null o no antes de leerlo) * Recibe un SqlDataReader con el que se obtiene el campo y el índice de la columna a consultar * Devuelve un valor DateTime dependiendo del resultado de la consulta. La fecha actual si el campo está nulo */ public static DateTime SafeGetDate(SqlDataReader reader, int colIndex) { if (!reader.IsDBNull(colIndex)) return reader.GetDateTime(colIndex); else return DateTime.Now; }
public static StatsModel readRecord(SqlDataReader dr) { StatsModel currentRecord = new StatsModel(); currentRecord.id = dr["id"].ToString(); //reader.GetDateTime(reader.GetOrdinal("Timestamp")); currentRecord.logtime = dr.GetDateTime(dr.GetOrdinal("logtime")); currentRecord.is_interacting = Convert.ToBoolean(dr["is_interacting"]); currentRecord.pcy = Convert.ToInt32(dr["pcy"]); currentRecord.cpu = Convert.ToInt32(dr["cpu"]); currentRecord.vss = Convert.ToInt32(dr["vss"]); currentRecord.rss = Convert.ToInt32(dr["rss"]); currentRecord.threads = Convert.ToInt32(dr["threads"]); currentRecord.priority = Convert.ToInt32(dr["priority"]); currentRecord.status = dr["status"].ToString(); currentRecord.bg_up_data = Convert.ToInt32(dr["bg_up_data"]) == -1 ? 0 : Convert.ToInt32(dr["bg_up_data"]); ; currentRecord.bg_down_data = Convert.ToInt32(dr["bg_down_data"]) == -1 ? 0 : Convert.ToInt32(dr["bg_down_data"]); ; currentRecord.fg_up_data = Convert.ToInt32(dr["fg_up_data"]) == -1 ? 0 : Convert.ToInt32(dr["fg_up_data"]); currentRecord.fg_down_data = Convert.ToInt32(dr["fg_down_data"]) == -1 ? 0 : Convert.ToInt32(dr["fg_down_data"]); ; currentRecord.bg_up_wifi = Convert.ToInt32(dr["bg_up_wifi"]) == -1 ? 0 : Convert.ToInt32(dr["bg_up_wifi"]); ; currentRecord.bg_down_wifi = Convert.ToInt32(dr["bg_down_wifi"]) == -1 ? 0 : Convert.ToInt32(dr["bg_down_wifi"]); ; currentRecord.fg_up_wifi = Convert.ToInt32(dr["fg_up_wifi"]) == -1 ? 0 : Convert.ToInt32(dr["fg_up_wifi"]); ; currentRecord.fg_down_wifi = Convert.ToInt32(dr["fg_down_wifi"]) == -1 ? 0 : Convert.ToInt32(dr["fg_down_wifi"]); ; //Console.WriteLine("Date Read: " + dt); return currentRecord; }
public List <Employee> GetEmployeeList() { List <Employee> employeeList = new List <Employee>(); Dao dao = new Dao(); string sqlStatement = "SELECT EmployeeID, EmployeeName, Gender, Position, StartDate, Address, PhoneNumber FROM Employee"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader == null) { return(null); } while (reader.Read()) { int id = reader.GetInt32(0); string name = reader.GetString(1); bool gender = reader.GetBoolean(2); string position = reader.GetString(3); DateTime date = reader.GetDateTime(4); string address = reader.GetString(5); string phone = reader.GetString(6); employeeList.Add(new Employee(id, name, gender, position, date, address, phone)); } dao.Con.Close(); return(employeeList); }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT version, sqltype, file_desc, fileUploadOldName, fileUploadNewName, datetime, version_no, imageData FROM userUploadLog WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _version = reader.GetInt32(0); _sqltype = reader.GetInt32(1); _file_desc = reader.GetString(2); _fileUploadOldName = reader.GetString(3); _fileUploadNewName = reader.GetString(4); _datetime = reader.GetDateTime(5); _version_no = reader.GetString(6); //_imageData = reader.GetBytes(7); _imageData = (byte[])reader[7]; } reader.Close(); } }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT FILE_INDEX, FILE_NEW_NAME, FILE_ORI_NAME, FILE_MD5, FILE_IMG, RECSTA, LDATE, LUSER FROM MIP_FILE_STORE WHERE FILE_INDEX=@FILE_INDEX_PARAM"; cmd.Parameters.AddWithValue("@FILE_INDEX_PARAM", _fILE_INDEX); System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _fILE_INDEX = reader.GetInt32(0); _fILE_NEW_NAME = reader.GetString(1); _fILE_ORI_NAME = reader.GetString(2); _fILE_MD5 = reader.GetString(3); //_fILE_IMG = reader.GetByte(4); _fILE_IMG = (byte[])reader[4]; _rECSTA = reader.GetInt32(5); _lDATE = reader.GetDateTime(6); _lUSER = reader.GetString(7); } reader.Close(); } }
private static TimeSpan GetTimeTolive(SqlDataReader dataReader) { if (dataReader.IsDBNull(TimeToLiveIndex)) { return TimeSpan.MaxValue; } DateTime expireDateTime = dataReader.GetDateTime(TimeToLiveIndex); if (dataReader.GetDateTime(TimeToLiveIndex) < DateTime.UtcNow) { return TimeSpan.Zero; } return TimeSpan.FromTicks(expireDateTime.Ticks - DateTime.UtcNow.Ticks); }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT ServiceID, sUrl, sNamespace, sClassname, APName, sDescription, sStatus, sCreateDatetime, ENCRYPTED FROM WebserviceData WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _serviceID = reader.GetString(0); _sUrl = reader.GetString(1); _sNamespace = reader.GetString(2); _sClassname = reader.GetString(3); _aPName = reader.GetString(4); _sDescription = reader.GetString(5); _sStatus = reader.GetBoolean(6); _sCreateDatetime = reader.GetDateTime(7); _eNCRYPTED = reader.GetBoolean(8); } reader.Close(); } }
public TList_Empreendimento Select(TpBusca[] vBusca, Int32 vTop, string vNM_Campo) { bool podeFecharBco = false; TList_Empreendimento lista = new TList_Empreendimento(); if (Banco_Dados == null) { this.CriarBanco_Dados(false); podeFecharBco = true; } System.Data.SqlClient.SqlDataReader reader = this.ExecutarBusca(this.SqlCodeBusca(vBusca, vTop, vNM_Campo)); try { while (reader.Read()) { TRegistro_Empreendimento reg = new TRegistro_Empreendimento(); if (!(reader.IsDBNull(reader.GetOrdinal("ID_Empreendimento")))) { reg.Id_empreendimento = reader.GetDecimal(reader.GetOrdinal("ID_Empreendimento")); } if (!(reader.IsDBNull(reader.GetOrdinal("CD_Empresa")))) { reg.Cd_empresa = reader.GetString(reader.GetOrdinal("CD_Empresa")); } if (!(reader.IsDBNull(reader.GetOrdinal("NM_Empresa")))) { reg.Nm_empresa = reader.GetString(reader.GetOrdinal("NM_Empresa")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Empreendimento"))) { reg.Ds_empreendimento = reader.GetString(reader.GetOrdinal("DS_Empreendimento")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Observacao"))) { reg.Ds_observacao = reader.GetString(reader.GetOrdinal("DS_Observacao")); } if (!reader.IsDBNull(reader.GetOrdinal("DT_IniEmpreendimento"))) { reg.Dt_iniempreendimento = reader.GetDateTime(reader.GetOrdinal("DT_IniEmpreendimento")); } if (!(reader.IsDBNull(reader.GetOrdinal("ST_Registro")))) { reg.St_registro = reader.GetString(reader.GetOrdinal("ST_Registro")); } lista.Add(reg); } } finally { reader.Close(); reader.Dispose(); if (podeFecharBco) { this.deletarBanco_Dados(); } } return(lista); }
public Dictionary <Tuple <long, DateTime>, DERMSCommon.SCADACommon.MonthItem> ReadFromDayTable(string connectionString) { DERMSCommon.SCADACommon.MonthItem itemMonth = null; Dictionary <Tuple <long, DateTime>, DERMSCommon.SCADACommon.MonthItem> monthItems = new Dictionary <Tuple <long, DateTime>, DERMSCommon.SCADACommon.MonthItem>(); Tuple <long, DateTime> key = null; Tuple <long, DateTime> keyM = null; Dictionary <Tuple <long, DateTime>, DERMSCommon.SCADACommon.DayItem> dayItemsData = new Dictionary <Tuple <long, DateTime>, DERMSCommon.SCADACommon.DayItem>(); using (System.Data.SqlClient.SqlConnection _con = new System.Data.SqlClient.SqlConnection(connectionString)) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT Timestamp, Gid, E, PMax, PMin, PAvg FROM dbo.Day", _con)) { _con.Open(); using (System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader()) { // Check is the reader has any rows at all before starting to read. if (reader.HasRows) { // Read advances to the next row. while (reader.Read()) { DERMSCommon.SCADACommon.DayItem c = new DERMSCommon.SCADACommon.DayItem(); // To avoid unexpected bugs access columns by name. try { c.E = reader.GetDouble(reader.GetOrdinal("E")); c.PAvg = reader.GetDouble(reader.GetOrdinal("PAvg")); c.PMax = reader.GetDouble(reader.GetOrdinal("PMax")); c.PMin = reader.GetDouble(reader.GetOrdinal("PMin")); c.Timestamp = reader.GetDateTime(reader.GetOrdinal("Timestamp")); c.Gid = reader.GetInt64(reader.GetOrdinal("Gid")); //c.P = reader.GetDouble(reader.GetOrdinal("P")); key = new Tuple <long, DateTime>(c.Gid, c.Timestamp); dayItemsData.Add(key, c); } catch (Exception e) { } } } } _con.Close(); } } foreach (var d in dayItemsData) { //itemDay = new DERMSCommon.SCADACommon.DayItem(d.Key.Item1, d.Key.Item2.Date.AddHours(d.Key.Item2.Hour), MinProductionPerHour(d.Key.Item2.Hour, d.Key.Item2.DayOfYear, collectItemsData), MaxProductionPerHour(d.Key.Item2.Hour, d.Key.Item2.DayOfYear, collectItemsData), AvgProductionPerHour(d.Key.Item2.Hour, d.Key.Item2.DayOfYear, collectItemsData), 0, 0); itemMonth = new DERMSCommon.SCADACommon.MonthItem(d.Key.Item1, d.Key.Item2.Date, MinProductionPerDay(d.Key.Item2.DayOfYear, d.Key.Item2.Month, dayItemsData, d.Key.Item1), MaxProductionPerDay(d.Key.Item2.DayOfYear, d.Key.Item2.Month, dayItemsData, d.Key.Item1), AvgProductionPerDay(d.Key.Item2.DayOfYear, d.Key.Item2.Month, dayItemsData, d.Key.Item1), 0, d.Value.P); keyM = new Tuple <long, DateTime>(itemMonth.Gid, itemMonth.Timestamp); if (!monthItems.ContainsKey(keyM)) { monthItems.Add(keyM, itemMonth); } } return(monthItems); }
protected override DomainObject LoadEntity(int Id, SqlDataReader res) { Ilan ilan = new Ilan(Id); if (res.Read()) { string kur = res.GetString(4); int ilanFiyat = res.GetInt32(3); DateTime basTarih = res.GetDateTime(1); DateTime bitTarih = res.GetDateTime(2); IlanSuresi _ilanSuresi = new IlanSuresi(basTarih,bitTarih); Fiyat _ilanFiyat = new Fiyat(ilanFiyat,kur); ilan.IlanAdi = res.GetString(5); ilan.IlanFiyat = _ilanFiyat; ilan.IlanSuresi = _ilanSuresi; } return ilan; }
private Category FillCategory(SqlDataReader reader) { var author = new Category(); author.Id = reader.GetInt32(0); author.Name = reader.GetString(1); author.DateCreated = reader.GetDateTime(2); return author; }
/// <summary> /// 数据转转账实体 /// </summary> public static ZhuanZhangInfo DataToModel(SqlDataReader rdr) { ZhuanZhangInfo zhang = new ZhuanZhangInfo(); if (!rdr.IsDBNull(0)) zhang.ZhuanZhangID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) zhang.ZhuanZhangFrom = rdr.GetInt32(1); if (!rdr.IsDBNull(2)) zhang.ZhuanZhangTo = rdr.GetInt32(2); if (!rdr.IsDBNull(3)) zhang.ZhuanZhangDate = rdr.GetDateTime(3); if (!rdr.IsDBNull(4)) zhang.ZhuanZhangMoney = rdr.GetDecimal(4); if (!rdr.IsDBNull(5)) zhang.ZhuanZhangLive = rdr.GetByte(5); if (!rdr.IsDBNull(7)) zhang.Synchronize = rdr.GetByte(6); if (!rdr.IsDBNull(6)) zhang.ModifyDate = rdr.GetDateTime(7); if (!rdr.IsDBNull(7)) zhang.UserID = rdr.GetInt32(8); if (!rdr.IsDBNull(7)) zhang.ZhuanZhangNote = rdr.GetString(9); if (!rdr.IsDBNull(7)) zhang.ZZID = rdr.GetInt32(10); return zhang; }
public void PrepareListModel(SqlDataReader dr, List<TableBaseInfo> infoList) { while (dr.Read()) { TableBaseInfo info = new TableBaseInfo(); info.ID = dr.GetInt32(0); info.TableName = dr[1].ToString(); info.TableDescription = dr[2].ToString(); info.Fields = dr[3].ToString(); info.UserID = dr.GetInt32(4); info.UserName = dr[5].ToString(); info.Status = dr.GetInt32(6); info.AddTime = dr.GetDateTime(7); info.UpdateTime = (dr[8] == DBNull.Value ? info.AddTime : dr.GetDateTime(8)); info.MySysTableID = dr.GetInt32(9); infoList.Add(info); } }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT MCID, GroupID, Model, MCNo, MaintainID, IPAddress, PU, LU, DevicePoint, SourceConnection, ATMBandWidth, SDGatewayID, BandWidth, MCAccountID, MCFunc, SystemOS, OpenTime, bPoint, DetailAddress, Maintain_Money, Maintain_Sys, Maintain_Fix, BuyCaseNo, BuyDate, OpenDate, InstallDate, Memo, LoginGorupID FROM MCData WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _mCID = reader.GetString(0); _groupID = reader.GetString(1); _model = reader.GetString(2); _mCNo = reader.GetString(3); _maintainID = reader.GetString(4); _iPAddress = reader.GetString(5); _pU = reader.GetString(6); _lU = reader.GetString(7); _devicePoint = reader.GetString(8); _sourceConnection = reader.GetString(9); _aTMBandWidth = reader.GetInt32(10); _sDGatewayID = reader.GetString(11); _bandWidth = reader.GetInt32(12); _mCAccountID = reader.GetString(13); _mCFunc = reader.GetInt16(14); _systemOS = reader.GetInt16(15); _openTime = reader.GetString(16); _bPoint = reader.GetString(17); _detailAddress = reader.GetString(18); _maintain_Money = reader.GetString(19); _maintain_Sys = reader.GetString(20); _maintain_Fix = reader.GetString(21); _buyCaseNo = reader.GetString(22); _buyDate = reader.GetDateTime(23); _openDate = reader.GetDateTime(24); _installDate = reader.GetDateTime(25); _memo = reader.GetString(26); _loginGorupID = reader.GetString(27); } reader.Close(); } }
protected void moreInfoStudentLinkBtn_Click(object sender, CommandEventArgs e) { String connectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; System.Data.SqlClient.SqlConnection sql = new System.Data.SqlClient.SqlConnection(connectionString); int rowIndex = Convert.ToInt32(((sender as LinkButton).NamingContainer as GridViewRow).RowIndex); GridViewRow row = GridView1.Rows[rowIndex]; int applicationID = Convert.ToInt32(e.CommandArgument); sql.Open(); System.Data.SqlClient.SqlCommand moreJobInfo = new System.Data.SqlClient.SqlCommand(); moreJobInfo.Connection = sql; moreJobInfo.CommandText = "SELECT Student.FirstName + ' ' + Student.LastName, Student.StudentGPA, Student.StudentGraduationTrack, JobListing.JobTitle, JobListing.JobDescription, JobListing.JobType, JobListing.Location, JobListing.Deadline, JobListing.NumOfApplicants, Organization.OrganizationName, Organization.OrganizationDescription FROM Organization INNER JOIN JobListing ON Organization.OrganizationEntityID = JobListing.OrganizationID INNER JOIN ApplicationRequest ON JobListing.JobListingID = ApplicationRequest.JobListingID INNER JOIN Student ON ApplicationRequest.StudentEntityID = Student.StudentEntityID where ApplicationRequest.ApplicationID = " + applicationID; System.Data.SqlClient.SqlDataReader reader = moreJobInfo.ExecuteReader(); while (reader.Read()) { //set labels to db values lblStudentName.Text = reader.GetString(0); lblSudentGPA.Text = "GPA: " + reader.GetDouble(1).ToString(); // On track if statement String status = reader.GetString(2); if (status == "Y") { lblStudentStatus.Text = "Student on Track"; } else { lblStudentStatus.Text = "Student not on Track"; } lblOrgName.Text = "Organization Name: " + reader.GetString(9); lblOrgDesc.Text = "Organization Description: " + reader.GetString(10); lblJobTitle.Text = "Job Title: " + reader.GetString(3); lblJobDesc.Text = "Job Description: " + reader.GetString(4); lblJobLocation.Text = "Location: " + reader.GetString(6); lblJobDeadline.Text = "Deadline: " + reader.GetDateTime(7).ToString(); lblNumberOfApplicants.Text = "Number Of Applicants: " + reader.GetInt32(8).ToString(); } sql.Close(); Session["selectedapplicationID"] = applicationID.ToString(); ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openEditSModal();", true); }
} //gets int or defaults value to '0' public DateTime GetDateTimeOrMinValue(System.Data.SqlClient.SqlDataReader r, int i) { DateTime rv = DateTime.MinValue; if (!r.IsDBNull(i)) { rv = r.GetDateTime(i); } return(rv); } //gets the date or sets the minimum value
private string GetObjectValue(System.Data.SqlClient.SqlDataReader reader, int i) { string fieldType = reader.GetFieldType(i).ToString(); object FieldValue = null;; if (fieldType.Contains("Int32")) { FieldValue = reader.GetInt32(i); } else if (fieldType.Contains("Int64")) { FieldValue = reader.GetInt64(i); } else if (fieldType.Contains("Decimal")) { FieldValue = reader.GetDecimal(i); } else if (fieldType.Contains("Double")) { FieldValue = reader.GetDouble(i); } else if (fieldType.Contains("DateTime")) { FieldValue = reader.GetDateTime(i); } else if (fieldType.Contains("String")) { FieldValue = reader.GetString(i); } else if (fieldType.Contains("Boolean")) { FieldValue = reader.GetBoolean(i); } else if (fieldType.Contains("Byte")) { FieldValue = reader.GetByte(i); } else if (fieldType.Contains("Guid")) { FieldValue = reader.GetGuid(i); } else { FieldValue = reader.GetString(i); } if (FieldValue != null) { return(FieldValue.ToString()); } else { return(""); } }
private Author FillAuthor(SqlDataReader reader) { var author = new Author(); author.Id = reader.GetInt32(0); author.Name = reader.GetString(1); author.Email = reader.GetString(2); author.Password = reader.GetString(3); author.IsActive = reader.GetBoolean(4); author.DateCreated = reader.GetDateTime(5); return author; }
public TimeLine(string roadmapname) { mDatabase.connect(); mReader = mDatabase.executeread("SELECT ID, StartDate, EndDate FROM [dbo].[Timeline] WHERE RoadmapName = '" + roadmapname + "'"); mReader.Read(); mID = mReader.GetInt32(0); mStartDate = mReader.GetDateTime(1); mEndDate = mReader.GetDateTime(2); mDatabase.close(); mDatabase.connect(); mReader = mDatabase.executeread("SELECT Name, XPlacement FROM [dbo].[TickMark] WHERE TimelineID = '" + mID + "'"); while (mReader.Read()) { TickMark tick = new TickMark(mReader.GetString(0).ToString(), mReader.GetInt32(1)); mTicks.Add(tick); } mDatabase.close(); }
/// <summary> /// 数据转查询实体 /// </summary> public static UserQueryInfo DataToModel(SqlDataReader rdr) { UserQueryInfo query = new UserQueryInfo(); if (!rdr.IsDBNull(0)) query.UserQueryID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) query.UserQueryName = rdr.GetString(1); if (!rdr.IsDBNull(2)) query.UserQueryURL = rdr.GetString(2); if (!rdr.IsDBNull(3)) query.UserQueryValue = rdr.GetString(3); if (!rdr.IsDBNull(4)) query.UserQueryLive = rdr.GetByte(4); if (!rdr.IsDBNull(5)) query.UserID = rdr.GetInt32(5); if (!rdr.IsDBNull(6)) query.ModifyDate = rdr.GetDateTime(6); return query; }
private Post FillPost(SqlDataReader reader) { var post = new Post(); post.Id = reader.GetInt32(0); post.Author = new Author(); post.Author.Id = reader.GetInt32(1); post.Title = reader.GetValueOrDefault<string>(2); post.Body = reader.GetValueOrDefault<string>(3); post.IsPublished = reader.GetBoolean(4); post.DateCreated = reader.GetDateTime(5); return post; }
private Comment FillComment(SqlDataReader reader) { var comment = new Comment(); comment.Id = reader.GetInt32(0); comment.PostId = reader.GetInt32(1); comment.Name = reader.GetString(2); comment.Email = reader.GetValueOrDefault<string>(3); comment.Url = reader.GetValueOrDefault<string>(4); comment.Body = reader.GetString(5); comment.Status = (CommentStatus)reader.GetInt32(6); comment.DateCreated = reader.GetDateTime(7); return comment; }
/// <summary> /// 数据转专题实体 /// </summary> public static ZhuanTiInfo DataToModel(SqlDataReader rdr) { ZhuanTiInfo zhuanTi = new ZhuanTiInfo(); if (!rdr.IsDBNull(0)) zhuanTi.ZhuanTiID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) zhuanTi.ZhuanTiName = rdr.GetString(1); if (!rdr.IsDBNull(2)) zhuanTi.ZhuanTiImage = rdr.GetString(2); if (!rdr.IsDBNull(3)) zhuanTi.UserID = rdr.GetInt32(3); if (!rdr.IsDBNull(4)) zhuanTi.ZhuanTiLive = rdr.GetByte(4); if (!rdr.IsDBNull(5)) zhuanTi.Synchronize = rdr.GetByte(5); if (!rdr.IsDBNull(6)) zhuanTi.ModifyDate = rdr.GetDateTime(6); if (!rdr.IsDBNull(7)) zhuanTi.ZTID = rdr.GetInt32(7); return zhuanTi; }
private Library ReadLibrary(SqlDataReader reader) { return new Library { MovieId = reader.GetInt32(0), Title = reader.GetString(1), ReleaseDate = reader.GetDateTime(2), Description = reader.GetString(3), GenresName = reader.GetString(4), DirectorsFirstName = reader.GetString(5), DirectorsLastName = reader.GetString(6), LanguagesName = reader.GetString(7) }; }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT SecureKey, AccounID, LoginType, IPAddress, CreateDatetime, UsedDatetime, IsUsed FROM SecurityUserAccount_SecureKey WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _secureKey = reader.GetString(0); _accounID = reader.GetString(1); _loginType = reader.GetInt32(2); _iPAddress = reader.GetString(3); _createDatetime = reader.GetDateTime(4); _usedDatetime = reader.GetDateTime(5); _isUsed = reader.GetInt32(6); } reader.Close(); } }
/// <summary> /// 数据转第三方登录实体 /// </summary> public static OAuthInfo DataToModel(SqlDataReader rdr) { OAuthInfo oauth = new OAuthInfo(); if (!rdr.IsDBNull(0)) oauth.OAuthID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) oauth.OpenID = rdr.GetString(1); if (!rdr.IsDBNull(2)) oauth.AccessToken = rdr.GetString(2); if (!rdr.IsDBNull(3)) oauth.UserID = rdr.GetInt32(3); if (!rdr.IsDBNull(4)) oauth.OldUserID = rdr.GetInt32(4); if (!rdr.IsDBNull(5)) oauth.OAuthBound = rdr.GetByte(5); if (!rdr.IsDBNull(6)) oauth.OAuthFrom = rdr.GetString(6); if (!rdr.IsDBNull(7)) oauth.ModifyDate = rdr.GetDateTime(7); return oauth; }
public void Property(string key, SqlDataReader reader, int idx) { jsonWriter.WritePropertyName(key); string typeName = reader.GetDataTypeName(idx); if (reader.IsDBNull(idx)) jsonWriter.WriteNull(); else if (typeName == "decimal") jsonWriter.WriteValue(reader.GetDecimal(idx)); else if (typeName == "datetime") jsonWriter.WriteValue(reader.GetDateTime(idx)); else if (typeName == "varchar" || typeName == "nvarchar") jsonWriter.WriteValue(reader.GetString(idx)); else throw new Exception("Unknown data type " + typeName); }
SqlJobMetrics build_sql_job_metric_from_reader(SqlDataReader reader) { var metric = new SqlJobMetrics(); metric.job_name = reader.GetString(0); metric.message = reader.GetString(1); var job_outcome_key = reader.GetByte(2); metric.job_status = get_job_outcome_from_key(job_outcome_key); metric.last_run = reader.GetDateTime(3); metric.job_step = reader.GetInt16(4); return metric; }
protected override Exception ProcessSqlResult(SqlDataReader reader) { Exception exception = StoreUtilities.GetNextResultSet(base.InstancePersistenceCommand.Name, reader); if (exception == null) { bool instancesExist = !reader.IsDBNull(1); TimeSpan? timeTillNextPoll = null; bool instancesReadyToRun = false; if (instancesExist) { DateTime expirationTime = reader.GetDateTime(1); DateTime utcNow = reader.GetDateTime(2); if (expirationTime <= utcNow) { instancesReadyToRun = true; } else { timeTillNextPoll = expirationTime.Subtract(utcNow); } } if (instancesReadyToRun) { base.Store.UpdateEventStatus(true, HasRunnableWorkflowEvent.Value); } else { base.Store.UpdateEventStatus(false, HasRunnableWorkflowEvent.Value); base.StoreLock.InstanceDetectionTask.ResetTimer(false, timeTillNextPoll); } } return exception; }
public static string ParseDateAsString(System.Data.SqlClient.SqlDataReader rdr, int index) { DateTime data = DateTime.Now; try { data = rdr.GetDateTime(index); return(DateAsString(data)); } catch (Exception ex) { data = DateTime.MinValue; return(DateAsString(data)); } }
public ArticleListInfo(SqlDataReader reader) { //Id, Guid, Template, Classes, Categorys, Title, ShortTitle,Thumbnail, Datetime, Editor,Hits id = reader.GetInt32(0); guid = reader.GetString(1); templateId = reader.GetString(2); classes = reader.GetString(3); categories = reader.GetString(4); title = reader.GetString(5); shortTitle = reader.GetString(6); thumbnail = reader.GetString(7); datetime = reader.GetDateTime(8); editor = reader.GetString(9); hits = reader.GetInt32(10); }
//Bold the dates that have events public void boldEventDays() { sqlCmd = new SqlCommand("select event_begin as 'Event Begin' from event", sc); sqlRdr = sqlCmd.ExecuteReader(); monthCalendar.RemoveAllBoldedDates(); while (sqlRdr.Read()) { monthCalendar.AddBoldedDate(sqlRdr.GetDateTime(0)); } monthCalendar.UpdateBoldedDates(); sqlRdr.Close(); }
public static DateTime ParseDateTime(System.Data.SqlClient.SqlDataReader rdr, int index) { DateTime data = DateTime.Now; try { data = rdr.GetDateTime(index); } catch (Exception ex) { data = DateTime.MinValue; ex.GetHashCode(); } return(data); }
//Does not load the fileData column public override FileVO ReadRecord(System.Data.SqlClient.SqlDataReader reader) { FileVO result = new FileVO(); result.Id = reader.GetInt32(reader.GetOrdinal(idColumnName)); result.Name = reader[fileName].ToString(); DocumentDAO ddao = new DocumentDAO(); result.Document = ddao.GetItem(reader.GetInt32(reader.GetOrdinal(fileDocumentId))); ddao.CloseConnection(); short valInt = reader.GetInt16(reader.GetOrdinal(fileType)); result.Type = (FileVO.FileType)valInt; result.AdditionDateTime = reader.GetDateTime(reader.GetOrdinal(fileAdditionDate)); return(result); }
public Paciente crearObjetoPaciente(SqlDataReader resultado) { Paciente paciente = new Paciente(); paciente.Id = resultado.GetInt32(0); paciente.Nombre = resultado.GetString(1); paciente.ApellidoPaterno = resultado.GetString(2); paciente.ApellidoMaterno = resultado.GetString(3); paciente.Dni = resultado.GetString(4); paciente.Direccion = resultado.GetString(5); paciente.Telefono = resultado.GetString(6); paciente.Celular = resultado.GetString(7); paciente.Sexo = resultado.GetString(8); paciente.Correo = resultado.GetString(9); paciente.FechaNacimiento = resultado.GetDateTime(10); paciente.Estado = resultado.GetString(11); return paciente; }
public override LogEntryVO ReadRecord(System.Data.SqlClient.SqlDataReader reader) { LogEntryVO result = new LogEntryVO(); result.Id = reader.GetInt32(reader.GetOrdinal(idColumnName)); result.DateTime = reader.GetDateTime(reader.GetOrdinal(logEntryDateTime)); result.Description = reader[logEntryDescription].ToString(); int userId = reader.GetInt32(reader.GetOrdinal(logEntryUserId)); int operationId = reader.GetInt32(reader.GetOrdinal(logEntryOperationId)); result.User = firstTableDAO.GetItem(userId); result.Operation = secondTableDAO.GetItem(operationId); firstTableDAO.CloseConnection(); secondTableDAO.CloseConnection(); return(result); }
public StockSummary ReadStockAnalysis(string symbol) { if (StockConn.ConnectionString == String.Empty) { StockConn = new SqlConnection(Conn); } string query = "SELECT * FROM [Stock].[dbo].[StockAnalysis] WHERE [symbol] = @symbol"; StockConn.Open(); SqlCommand cmd = new SqlCommand(query, StockConn); cmd.Parameters.Add("@symbol", System.Data.SqlDbType.Char); // set values to parameters from textboxes cmd.Parameters["@symbol"].Value = symbol; using (System.Data.SqlClient.SqlDataReader oReader = cmd.ExecuteReader()) { StockSummary summary = new StockSummary(); summary.Symbol = symbol; if (oReader.HasRows) { while (oReader.Read()) { var parsed = JObject.Parse(oReader["patternData"].ToString()); var r = parsed["boundaries"].ToString(); r = r.Substring(1, r.Length - 2); string[] r1 = r.Split(','); double[] re = new double[4] { double.Parse(r1[0]), double.Parse(r1[1]), double.Parse(r1[2]), double.Parse(r1[3]) }; summary.SerializedProperties = new Dictionary <string, object>(); summary.SerializedProperties.Add("boundaries", re); summary.CacheData.Add("fail", false); summary.LastUpdate = oReader.GetDateTime(8); } } else { summary.CacheData.Add("fail", true); } StockConn.Close(); return(summary); } }
public Receipt GetReceiptByReceiptID(int id) { Receipt Receipt = null; Dao dao = new Dao(); string sqlStatement = "SELECT EmployeeID, TableNumber, PrintDate, Total, AdditionalFee FROM Receipt WHERE ReceiptID='" + id + "'"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader.Read()) { int emID = reader.GetInt32(0); int tablenumber = reader.GetInt32(1); DateTime date = reader.GetDateTime(2); double total = (double)reader.GetDecimal(3); double addFee = (double)reader.GetDecimal(4); Receipt = new Receipt(id, emID, tablenumber, date, total, addFee); } dao.Con.Close(); return(Receipt); }
public Payment GetPaymentByEmpID(int employeeID) { Payment payment = null; Dao dao = new Dao(); string sqlStatement = "SELECT PaymentID, EmployeeID, PayDate, TotalFee, Detail FROM Payment WHERE EmployeeID='" + employeeID + "'"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader.Read()) { int pID = reader.GetInt32(0); int eID = reader.GetInt32(1); DateTime pD = reader.GetDateTime(2); decimal tF = reader.GetDecimal(3); string de = reader.GetString(4); payment = new Payment(pID, eID, pD, Decimal.ToDouble(tF), de); } dao.Con.Close(); return(payment); }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT PCAURS_ID, PCAGROUP_ID, LDATE, LUSER FROM MIP_PCAGROUP_PCAURS WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _pCAURS_ID = reader.GetString(0); _pCAGROUP_ID = reader.GetString(1); _lDATE = reader.GetDateTime(2); _lUSER = reader.GetString(3); } reader.Close(); } }
public Employee GetEmployeeByID(int id) { Employee employee = null; Dao dao = new Dao(); string sqlStatement = "SELECT EmployeeName, Gender, Position, StartDate, Address, PhoneNumber FROM Employee WHERE EmployeeID='" + id + "'"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader.Read()) { string name = reader.GetString(0); bool gender = reader.GetBoolean(1); string position = reader.GetString(2); DateTime date = reader.GetDateTime(3); string address = reader.GetString(4); string phone = reader.GetString(5); employee = new Employee(id, name, gender, position, date, address, phone); } dao.Con.Close(); return(employee); }