public void ListDoldur900(ref ListView list, string sql) { CheckConnection(); System.Data.IDataReader rd = TSelect(sql); int i; while (rd != null && rd.Read()) { if (rd.GetValue(1).ToString().Trim() == "HATA") { m mx = new m(); mx.tistex = "HATA!"; mx.label1.Text = rd.GetValue(0).ToString().Trim(); mx.ShowDialog(); break; } else { list.Items.Clear(); } ListViewItem row = new ListViewItem(); if (rd.IsDBNull(0)) { row.Text = ""; } else { row.Text = rd.GetValue(0).ToString(); } for (i = 1; i < rd.FieldCount; i++) { if (rd.IsDBNull(i)) { row.SubItems.Add(""); } else { row.SubItems.Add(rd.GetValue(i).ToString()); } } list.Items.Add(row); } if (rd != null) { rd.Close(); } }
/// <summary> /// Returns all OPC Sample Group key and Name map /// </summary> /// <returns>Sample group key-Name map</returns> public Dictionary <string, string> GetAllOPCGrpIdAndName(bool checkLoc) { string Function_Name = "GetAllOPCGrpIdAndName"; LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered"); Dictionary <string, string> opcGrpIDToNameDic = new Dictionary <string, string>(); string localSQL; localSQL = "SELECT PKEY, NAME FROM DATALOG_DP_GROUP_TREND"; string LocationClauseStr = DAOHelper.CheckLocationAndAddSQL(COLUMN_LOCATION_KEY); if (LocationClauseStr.Length != 0 && checkLoc) { localSQL += " WHERE" + LocationClauseStr; } System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL); try { while (drReader != null && drReader.Read()) { string grpID = "", grpName = ""; if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_PKEY))) { grpID = drReader[COLUMN_PKEY].ToString(); } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_NAME))) { grpName = DAOHelper.convert8859P1ToGB2312(drReader[COLUMN_NAME].ToString()); } opcGrpIDToNameDic.Add(grpID, grpName); } } catch (System.Exception ex) { LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString()); } if (drReader != null) { drReader.Close(); drReader.Dispose(); //SimpleDatabase.GetInstance().CloseCurrentSession(); } LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited"); return(opcGrpIDToNameDic); }
public void ListDoldurEkle(ref ListView list, string sql, string PaletID) { CheckConnection(); System.Data.IDataReader rd = TSelect(sql); for (int j = 0; j < list.Items.Count; j++) { if (PaletID.Trim() == list.Items[0].ToString().Trim()) { return; } } //list.Items.Clear(); int i; while (rd != null && rd.Read()) { ListViewItem row = new ListViewItem(); if (rd.IsDBNull(0)) { row.Text = ""; } else { row.Text = rd.GetValue(0).ToString(); } for (i = 1; i < rd.FieldCount; i++) { if (rd.IsDBNull(i)) { row.SubItems.Add(""); } else { row.SubItems.Add(rd.GetValue(i).ToString()); } } list.Items.Add(row); } if (rd != null) { rd.Close(); } }
public override int DrToInt32(System.Data.IDataReader dr, int index) { Type t = dr.GetFieldType(index); if (t.Equals(typeof(decimal))) { return(dr.IsDBNull(index) ? 0 : (int)dr.GetDecimal(index)); } else if (t.Equals(typeof(Int32))) { return(dr.IsDBNull(index) ? 0 : (int)dr.GetInt32(index)); } else { throw new NotImplementedException(); } }
///******************************************************************************* ///NOMBRE DE LA FUNCIÓN : Consultar_Detalles_Menu ///DESCRIPCIÓN : Regresa un objeto con los datos de un Menu. ///PARAMETROS : Parametros: Contiene los criterios para la busqueda. ///CREO : Salvador Vázquez Camacho ///FECHA_CREO : 12/Enero/2013 ///MODIFICO : ///FECHA_MODIFICO : ///CAUSA_MODIFICACIÓN : ///******************************************************************************* public static Cls_Cat_Menus_Negocio Consultar_Detalles_Menu(Cls_Cat_Menus_Negocio Parametros) { StringBuilder Mi_SQL; Cls_Cat_Menus_Negocio Contrato = new Cls_Cat_Menus_Negocio(); Conexion.Iniciar_Helper(); Conexion.HelperGenerico.Conexion_y_Apertura(); Mi_SQL = new StringBuilder(); Mi_SQL.Append("SELECT * FROM " + Cat_Menus.Tabla_Cat_Menus); Mi_SQL.Append(" WHERE " + Cat_Menus.Campo_Menu_Id + " = '" + Parametros.P_Menu_Id + "'"); System.Data.IDataReader Dr_Menu = (System.Data.IDataReader)Conexion.HelperGenerico.Obtener_Data_Reader(Mi_SQL.ToString()); while (Dr_Menu.Read()) { Contrato.P_Menu_Id = Dr_Menu.IsDBNull(0) ? "" : Dr_Menu.GetString(0); Contrato.P_Parent_Id = Dr_Menu.IsDBNull(1) ? "" : Dr_Menu.GetString(1); Contrato.P_Menu_Descripcion = Dr_Menu.IsDBNull(2) ? "" : Dr_Menu.GetString(2); Contrato.P_Url_Link = Dr_Menu.IsDBNull(3) ? "" : Dr_Menu.GetString(3); Contrato.P_Nombre_Menu = Dr_Menu.IsDBNull(4) ? "" : Dr_Menu.GetString(4); Contrato.P_Orden = Dr_Menu.IsDBNull(5) ? "" : Dr_Menu.GetString(5); Contrato.P_Estatus = Dr_Menu.IsDBNull(6) ? "" : Dr_Menu.GetString(6); } Conexion.HelperGenerico.Cerrar_Conexion(); return(Contrato); }
public override float DrToFloat(System.Data.IDataReader dr, int index) { Type t = dr.GetFieldType(index); if (t.Equals(typeof(decimal))) { return(dr.IsDBNull(index) ? 0 : (float)dr.GetDecimal(index)); } else if (t.Equals(typeof(double))) { return(dr.IsDBNull(index) ? 0 : (float)dr.GetDouble(index)); } else if (t.Equals(typeof(float))) { return(dr.IsDBNull(index) ? 0 : dr.GetFloat(index)); } throw new NotImplementedException(); }
public decimal PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, decimal Atributo) { if ((lDataReader.IsDBNull(NumeroColuna) == true)) { return(decimal.MinValue); } else { return(lDataReader.GetDecimal(NumeroColuna)); } }
public double PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, double Atributo) { if ((lDataReader.IsDBNull(NumeroColuna) == true)) { return(double.MinValue); } else { return(lDataReader.GetDouble(NumeroColuna)); } }
public float PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, float Atributo) { if ((lDataReader.IsDBNull(NumeroColuna) == true)) { return(float.MinValue); } else { return(lDataReader.GetFloat(NumeroColuna)); } }
public long PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, long Atributo) { if ((lDataReader.IsDBNull(NumeroColuna) == true)) { return(Int64.MinValue); } else { return(lDataReader.GetInt64(NumeroColuna)); } }
public short PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, short Atributo) { if ((lDataReader.IsDBNull(NumeroColuna) == true)) { return(Int16.MinValue); } else { return(lDataReader.GetInt16(NumeroColuna)); } }
public DateTime PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, System.DateTime Atributo) { if ((lDataReader.IsDBNull(NumeroColuna) == true)) { return(DateTime.MinValue); } else { return(lDataReader.GetDateTime(NumeroColuna)); } }
public bool PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, bool Atributo) { if ((lDataReader.IsDBNull(NumeroColuna) == true)) { return(false); } else { return(lDataReader.GetBoolean(NumeroColuna)); } }
public string PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, string Atributo) { if ((lDataReader.IsDBNull(NumeroColuna) == true)) { return(null); } else { return(lDataReader.GetString(NumeroColuna)); } }
public char PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, char Atributo) { if ((lDataReader.IsDBNull(NumeroColuna) == true)) { return(char.MinValue); } else { return(Convert.ToChar(lDataReader.GetString(NumeroColuna))); } }
public byte PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, byte Atributo) { if ((lDataReader.IsDBNull(NumeroColuna) == true)) { return(byte.MinValue); } else { return(lDataReader.GetByte(NumeroColuna)); } }
private Model.hierarchy3a GetInstance(System.Data.IDataReader result, System.Collections.Generic.IDictionary <string, int> ordinals) { var obj = new Model.hierarchy3a() { pid = result.IsDBNull(ordinals["pid"]) ? new Guid() : result.GetGuid(ordinals["pid"]), fid = result.IsDBNull(ordinals["fid"]) ? 0 : result.GetInt64(ordinals["fid"]), uid = result.IsDBNull(ordinals["uid"]) ? new Guid() : result.GetGuid(ordinals["uid"]), numfield1 = result.IsDBNull(ordinals["numfield1"]) ? 0 : result.GetInt32(ordinals["numfield1"]), numfield2 = result.IsDBNull(ordinals["numfield2"]) ? 0 : result.GetInt32(ordinals["numfield2"]), numfield3 = result.IsDBNull(ordinals["numfield3"]) ? 0 : result.GetInt32(ordinals["numfield3"]), textfield1 = result.IsDBNull(ordinals["textfield1"]) ? null : result.GetString(ordinals["textfield1"]), textfield2 = result.IsDBNull(ordinals["textfield2"]) ? null : result.GetString(ordinals["textfield2"]), textfield3 = result.IsDBNull(ordinals["textfield3"]) ? null : result.GetString(ordinals["textfield3"]) }; return(obj); }
/// <summary> /// Creazione oggetto "OrgFunzione" da datareader /// </summary> /// <param name="reader"></param> /// <returns></returns> private static OrgFunzione CreateFunzione(System.Data.IDataReader reader) { OrgFunzione retValue = new OrgFunzione(); if (!reader.IsDBNull(reader.GetOrdinal("ID_ASSOCIAZIONE"))) { retValue.ID = reader.GetValue(reader.GetOrdinal("ID_ASSOCIAZIONE")).ToString(); } if (!reader.IsDBNull(reader.GetOrdinal("ID_TIPO_FUNZIONE"))) { retValue.IDTipoFunzione = reader.GetValue(reader.GetOrdinal("ID_TIPO_FUNZIONE")).ToString(); } string associato = reader.GetString(reader.GetOrdinal("ASSOCIATO")); retValue.Associato = Convert.ToBoolean(associato); retValue.FunzioneAnagrafica = CreateFunzioneAnagrafica(reader); return(retValue); }
public object NullSafeGet(System.Data.IDataReader rs, string[] names, object owner) { int index = rs.GetOrdinal(names[0]); if (rs.IsDBNull(index)) { return(string.Empty); } else { return(rs[index]); } }
public byte[] PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, byte[] Atributo) { if ((lDataReader.IsDBNull(NumeroColuna) == true)) { Byte[] TimesTamp = new Byte[8]; return(TimesTamp); } else { Byte[] TimesTamp = new Byte[8]; lDataReader.GetBytes(NumeroColuna, 0, TimesTamp, 0, 8); return(TimesTamp); } }
public object NullSafeGet(System.Data.IDataReader rs, string[] names, object owner) { ListSet result = new ListSet(); Int32 index = rs.GetOrdinal(names[0]); if (rs.IsDBNull(index) || String.IsNullOrEmpty((String)rs[index])) { return(result); } foreach (String s in ((String)rs[index]).Split(cStringSeparator)) { result.Add(s); } return(result); }
///******************************************************************************* ///NOMBRE DE LA FUNCIÓN : Consultar_Detalles_Rol ///DESCRIPCIÓN : Regresa un objeto con los datos de un Rol. ///PARAMETROS : Parametros: Contiene los criterios para la busqueda. ///CREO : Salvador Vázquez Camacho ///FECHA_CREO : 12/Enero/2013 ///MODIFICO : ///FECHA_MODIFICO : ///CAUSA_MODIFICACIÓN : ///******************************************************************************* public static Cls_Apl_Roles_Negocio Consultar_Detalles_Rol(Cls_Apl_Roles_Negocio Parametros) { StringBuilder Mi_SQL; Cls_Apl_Roles_Negocio Contrato = new Cls_Apl_Roles_Negocio(); Conexion.Iniciar_Helper(); Conexion.HelperGenerico.Conexion_y_Apertura(); Mi_SQL = new StringBuilder(); Mi_SQL.Append("SELECT * FROM " + Apl_Roles.Tabla_Apl_Roles); Mi_SQL.Append(" WHERE " + Apl_Roles.Campo_Rol_Id + " = '" + Parametros.P_Rol_Id + "'"); System.Data.IDataReader Dr_Rol = (System.Data.IDataReader)Conexion.HelperGenerico.Obtener_Data_Reader(Mi_SQL.ToString()); while (Dr_Rol.Read()) { Contrato.P_Rol_Id = Dr_Rol.IsDBNull(0) ? "" : Dr_Rol.GetString(0); Contrato.P_Nombre = Dr_Rol.IsDBNull(1) ? "" : Dr_Rol.GetString(1); Contrato.P_Descripcion = Dr_Rol.IsDBNull(2) ? "" : Dr_Rol.GetString(2); Contrato.P_Estatus = Dr_Rol.IsDBNull(3) ? "" : Dr_Rol.GetString(3); } Conexion.HelperGenerico.Cerrar_Conexion(); return(Contrato); }
/// <summary> /// Returns the total sample group records count in table /// </summary> /// <returns>No of Sample group configured</returns> public int GetRowCount() { string Function_Name = "GetRowCount"; LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered"); string localSQL; int nRowCount = 0; localSQL = "SELECT COUNT(NAME) AS MAXROWS FROM DATALOG_DP_GROUP_TREND"; string LocationClauseStr = DAOHelper.CheckLocationAndAddSQL(COLUMN_LOCATION_KEY); if (LocationClauseStr.Length != 0) { localSQL += " WHERE" + LocationClauseStr; } System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL); try { if (drReader != null && drReader.Read()) { if (!drReader.IsDBNull(0)) { LogHelper.Debug(CLASS_NAME, Function_Name, "Function_Exited"); nRowCount = Convert.ToInt32(drReader["MAXROWS"]); } } } catch (System.Exception ex) { LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString()); } if (drReader != null) { drReader.Close(); drReader.Dispose(); //SimpleDatabase.GetInstance().CloseCurrentSession(); } LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited"); return(nRowCount); }
public ExpandoObject AutoMap() { ExpandoObject expandoObject = new ExpandoObject(); IDictionary <string, object> dictionary = expandoObject; foreach (DataReaderField item in list_0) { if (idataReader_0.IsDBNull(item.Index)) { dictionary.Add(item.Name, null); } else { dictionary.Add(item.Name, idataReader_0[item.Index]); } } return(expandoObject); }
/// <summary> /// Get all the historical datapoint configuration names /// </summary> /// <returns></returns> public List <string> GetAllHistDPGrpNames() { string Function_Name = "GetAllHistDPGrpNames"; LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered"); List <string> dpGrpNames = new List <string>(); string localSQL = " SELECT DISTINCT CONFIG_NAME FROM TRENDVIEWER_HIST_CONFIG order by config_name "; System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL); try { while (drReader != null && drReader.Read()) { if (!drReader.IsDBNull(0)) { dpGrpNames.Add(DAOHelper.convert8859P1ToGB2312(drReader.GetString(0).ToString())); } } } catch (System.Exception ex) { LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString()); } if (drReader != null) { drReader.Close(); drReader.Dispose(); //SimpleDatabase.GetInstance().CloseCurrentSession(); } LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited"); return(dpGrpNames); }
internal static void setValuesFromReader <T>(T obj, d.IDataReader reader) where T : class { //reader.FieldCount for (int i = 0; i < reader.FieldCount; i++) { var fieldName = reader.GetName(i); //this might be slow this is where some mapper would be handy //if considering larger results sets //which are mostly not existing if (reader.GetFieldType(i) == typeof(byte[])) { //reader all bytes long size = reader.GetBytes(i, 0, null, 0, 0); byte[] values = new byte[size]; int bufferSize = 1024; long bytesRead = 0; int curPos = 0; while (bytesRead < size) { bytesRead += reader.GetBytes(i, curPos, values, curPos, bufferSize); curPos += bufferSize; } obj.SetValue(fieldName, values); } else { if (reader.IsDBNull(i)) { obj.SetValue(fieldName, null); } else { var value = reader.GetValue(i); obj.SetValue(fieldName, value); } } } }
public static IEnumerable <Dictionary <string, object> > AsEnumerableDictionary(this System.Data.IDataReader source) { if (source == null) { throw new ArgumentNullException("source"); } while (source.Read()) { Dictionary <string, object> row = new Dictionary <string, object>(); for (int i = 0; i < source.FieldCount; i++) { object value = source.GetValue(i); // return an empty string for dbnull value of field type string if (source.GetFieldType(i) == typeof(string) && source.IsDBNull(i)) { value = string.Empty; } row.Add(source.GetName(i), value); } yield return(row); } }
internal static void setValuesFromReader <T>(T obj, d.IDataReader reader) where T : IBattleAxe { //reader.FieldCount for (int i = 0; i < reader.FieldCount; i++) { var fieldName = reader.GetName(i); if (reader.GetFieldType(i) == typeof(byte[])) { //reader all bytes long size = reader.GetBytes(i, 0, null, 0, 0); byte[] values = new byte[size]; int bufferSize = 1024; long bytesRead = 0; int curPos = 0; while (bytesRead < size) { bytesRead += reader.GetBytes(i, curPos, values, curPos, bufferSize); curPos += bufferSize; } obj[fieldName] = values; } else { var value = reader.GetValue(i); if (reader.IsDBNull(i)) { obj[fieldName] = null; } else { obj[fieldName] = value; } } } }
/// <summary> /// Returns Sample Group details of the specified Sample group Key. /// </summary> /// <param name="opcGrpID">Sample group key</param> /// <returns>Sample Group entity</returns> public EtyDataLogDPGroupTrend GetOPCGrpByID(double opcGrpID) { string Function_Name = "GetOPCGrpByID"; LogHelper.Trace(CLASS_NAME, Function_Name, string.Format("Function_Entered with params - {0}", opcGrpID)); EtyDataLogDPGroupTrend etyDpGroupTrend = new EtyDataLogDPGroupTrend(); string localSQL = " SELECT DP.NAME,DP.DESCRIPTION,DP.SAMPLE_INTERVAL,DP.INTERVAL_TYPE,DP.START_TIME,DP.DELTA_VALUE,DP.ENABLED,DP.LOCATION_KEY,LOC.NAME AS LOCATION_NAME" + " FROM DATALOG_DP_GROUP_TREND DP,LOCATION LOC WHERE DP.PKEY = " + opcGrpID.ToString() + "AND LOC.PKEY = DP.LOCATION_KEY"; /* string LocationClauseStr = DAOHelper.CheckLocationAndAddSQL(COLUMN_LOCATION_KEY); * if (LocationClauseStr.Length != 0) * { * localSQL += " AND" + LocationClauseStr; * }*/ System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL); try { while (drReader != null && drReader.Read()) { if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_NAME))) { etyDpGroupTrend.SampleGrpName = DAOHelper.convert8859P1ToGB2312(drReader[COLUMN_NAME].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_DESCRIPTION))) { etyDpGroupTrend.SampleGrpDescription = DAOHelper.convert8859P1ToGB2312(drReader[COLUMN_DESCRIPTION].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_SAMPLE_INTERVAL))) { etyDpGroupTrend.Interval = Convert.ToInt32(drReader[COLUMN_SAMPLE_INTERVAL]); } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_INTERVAL_TYPE))) { etyDpGroupTrend.IntervalType = drReader[COLUMN_INTERVAL_TYPE].ToString(); } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_START_TIME))) { etyDpGroupTrend.StartTime = drReader[COLUMN_START_TIME].ToString(); } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_DELTA_VALUE))) { etyDpGroupTrend.DeltaValue = Convert.ToDouble(drReader[COLUMN_DELTA_VALUE]); } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_ENABLED))) { etyDpGroupTrend.Disabled = !(DAOHelper.ChangeStrToBool(drReader[COLUMN_ENABLED].ToString())); } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_LOCATION_KEY))) { etyDpGroupTrend.LocationKey = Convert.ToDouble(drReader[COLUMN_LOCATION_KEY]); } if (!drReader.IsDBNull(drReader.GetOrdinal(LOCATION_NAME))) { etyDpGroupTrend.LocationName = DAOHelper.convert8859P1ToGB2312(drReader[LOCATION_NAME].ToString()); } } } catch (System.Exception ex) { LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString()); } if (drReader != null) { drReader.Close(); drReader.Dispose(); } LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited"); return(etyDpGroupTrend); }
public List <EtyDataLogDPGroupTrend> GetAllOPCGrpsBySort(string sortColumn, string sortOrder) { string Function_Name = "GetAllOPCGrpsBySort"; LogHelper.Trace(CLASS_NAME, Function_Name, string.Format("Function_Entered with params - {0},{1}", sortColumn, sortOrder)); List <EtyDataLogDPGroupTrend> etyDPGrpTrendList = new List <EtyDataLogDPGroupTrend>(); string localSQL; localSQL = " SELECT DP.PKEY,DP.NAME,DP.DESCRIPTION,DP.SAMPLE_INTERVAL,DP.INTERVAL_TYPE,DP.START_TIME,DP.DELTA_VALUE,DP.ENABLED,DP.LOCATION_KEY,LOC.NAME AS LOCATION_NAME " + " FROM DATALOG_DP_GROUP_TREND DP, LOCATION LOC WHERE DP.LOCATION_KEY = LOC.PKEY"; string LocationClauseStr = DAOHelper.CheckLocationAndAddSQL(COLUMN_LOCATION_KEY); if (LocationClauseStr.Length != 0) { localSQL += " AND" + LocationClauseStr; } localSQL += " ORDER BY " + sortColumn; sortOrder = sortOrder.ToUpper(); if (sortOrder.Equals("ASCENDING") || sortOrder.Equals("ASC")) { localSQL += " ASC "; } else { localSQL += " DESC "; } System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL); try { while (drReader != null && drReader.Read()) { EtyDataLogDPGroupTrend etyDPGroupTrend = new EtyDataLogDPGroupTrend(); if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_PKEY))) { etyDPGroupTrend.SampleGrpID = Convert.ToDouble(drReader[COLUMN_PKEY]); } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_NAME))) { etyDPGroupTrend.SampleGrpName = DAOHelper.convert8859P1ToGB2312(drReader[COLUMN_NAME].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_DESCRIPTION))) { etyDPGroupTrend.SampleGrpDescription = DAOHelper.convert8859P1ToGB2312(drReader[COLUMN_DESCRIPTION].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_SAMPLE_INTERVAL))) { etyDPGroupTrend.Interval = Convert.ToDouble(drReader[COLUMN_SAMPLE_INTERVAL]); } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_INTERVAL_TYPE))) { etyDPGroupTrend.IntervalType = drReader[COLUMN_INTERVAL_TYPE].ToString(); } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_START_TIME))) { etyDPGroupTrend.StartTime = drReader[COLUMN_START_TIME].ToString(); } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_DELTA_VALUE))) { etyDPGroupTrend.DeltaValue = Convert.ToDouble(drReader[COLUMN_DELTA_VALUE]); } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_ENABLED))) { if (drReader[COLUMN_ENABLED].ToString() == "Y") { etyDPGroupTrend.Disabled = false; } else { etyDPGroupTrend.Disabled = true; } } if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_LOCATION_KEY))) { etyDPGroupTrend.LocationKey = Convert.ToDouble(drReader[COLUMN_LOCATION_KEY]); } if (!drReader.IsDBNull(drReader.GetOrdinal(LOCATION_NAME))) { etyDPGroupTrend.LocationName = DAOHelper.convert8859P1ToGB2312(drReader[LOCATION_NAME].ToString()); } etyDPGrpTrendList.Add(etyDPGroupTrend); } } catch (System.Exception ex) { LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString()); } if (drReader != null) { drReader.Close(); drReader.Dispose(); } LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited"); return(etyDPGrpTrendList); }