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