public static DataSet GetEyeWashsByCriteriaDS(string fieldnames, string criteria, params SqlParameter[] @params) { DBAccess db = new DBAccess(); string query = ""; query += "SELECT "; if (fieldnames.Trim() != "") { query += fieldnames; } else { query += " * "; } query += " FROM vw_Co2Db_EyeWash "; query += " WHERE ( @IsAgent = 0 OR ( @IsAgent = 1 AND [AgentID] = @AgentID ) )"; if (criteria != "") { query += " AND (" + criteria + ")"; } db.CommandType = CommandType.Text; db.CommandText = query; db.AddRange(@params); db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent()); db.AddGuid("AgentID", CurrentUserID); DataSet ds = db.ExecuteDataSet(); //(_SQLSelectByGuid) return(ds); }
public static DataSet GetLogLinesByCriteriaDS(string fieldnames, string criteria, string GroupBY, params SqlParameter[] @params) { DBAccess db = new DBAccess(); string query = ""; query += "SELECT "; if (fieldnames.Trim() != "") { query += fieldnames; } else { query += " * "; } query += " FROM vw_Co2Db_LogLine "; if (criteria != "") { query += " WHERE (" + criteria + ")"; } if (GroupBY != "") { query += " GROUP BY " + GroupBY; } db.CommandType = CommandType.Text; db.CommandText = query; db.AddRange(@params); DataSet ds = db.ExecuteDataSet(); //(_SQLSelectByGuid) return(ds); }
public static DataSet GetPageContentsByCriteriaDS(string fieldnames, string criteria, params SqlParameter[] @params) { DBAccess db = new DBAccess(); string query = ""; query += "SELECT "; if (fieldnames.Trim() != "") { query += fieldnames; } else { query += " * "; } query += " FROM vw_Co2Db_HtmlPageContent "; query += " WHERE ( @IsAgent = 0 OR ( @IsAgent = 1 AND [AgentID] = @AgentID ) )"; if (criteria != "") { query += " AND (" + criteria + ")"; } db.CommandType = CommandType.Text; db.CommandText = query; db.AddRange(@params); DataSet ds = db.ExecuteDataSet(); return(ds); }
public static List <EyeWash> GetEyeWashsByCriteria(string OrderBY, string criteria, params SqlParameter[] @params) { DBAccess db = new DBAccess(); //Dim conn As SqlConnection = DataFunctions.GetConnection() string query = ""; query += "SELECT "; if (OrderBY != "") { query += " TOP (100) PERCENT "; } query += " * FROM vw_Co2Db_EyeWash "; query += " WHERE ( @IsAgent = 0 OR ( @IsAgent = 1 AND [AgentID] = @AgentID ) )"; if (criteria != "") { query += " AND (" + criteria + ")"; } if (OrderBY != "") { query += " ORDER BY " + OrderBY; } //Dim cmd As New SqlCommand(query, conn) db.CommandType = CommandType.Text; db.CommandText = query; db.AddRange(@params); db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent()); db.AddGuid("AgentID", CurrentUserID); db.Open(); SqlDataReader dr = (SqlDataReader)(db.ExecuteReader()); //cmd.ExecuteReader() List <EyeWash> list = new List <EyeWash>(); while (dr.Read()) { EyeWash _EyeWash = new EyeWash(); EyeWash.Populate(dr, _EyeWash); list.Add(_EyeWash); } db.Dispose(); return(list); }
public static List <PageContent> GetPageContentsByCriteria(string OrderBY, string criteria, params SqlParameter[] @params) { DBAccess db = new DBAccess(); //Dim conn As SqlConnection = DataFunctions.GetConnection() string query = ""; query += "SELECT "; if (OrderBY != "") { query += " TOP (100) PERCENT "; } query += " * FROM vw_Co2Db_HtmlPageContent "; query += " WHERE ( @IsAgent = 0 OR ( @IsAgent = 1 AND [AgentID] = @AgentID ) )"; if (criteria != "") { query += " AND (" + criteria + ")"; } if (OrderBY != "") { query += " ORDER BY " + OrderBY; } //Dim cmd As New SqlCommand(query, conn) db.CommandType = CommandType.Text; db.CommandText = query; db.AddRange(@params); db.Open(); SqlDataReader dr = (SqlDataReader)(db.ExecuteReader()); List <PageContent> list = new List <PageContent>(); while (dr.Read()) { PageContent pc = new PageContent(); PageContent.Populate(dr, pc); list.Add(pc); } db.Dispose(); return(list); }
public static List <Korrespondance> GetKorrespondancesByCriteria(string OrderBY, string criteria, params SqlParameter[] @params) { DBAccess db = new DBAccess(); //Dim conn As SqlConnection = DataFunctions.GetConnection() string query = ""; query += "SELECT "; if (OrderBY != "") { query += " TOP (100) PERCENT "; } query += " *"; query += " FROM vw_Co2Db_Korrespondance "; if (criteria != "") { query += " WHERE (" + criteria + ")"; } if (OrderBY != "") { query += " ORDER BY " + OrderBY; } //Dim cmd As New SqlCommand(query, conn) db.CommandType = CommandType.Text; db.CommandText = query; db.AddRange(@params); db.Open(); SqlDataReader dr = (SqlDataReader)(db.ExecuteReader()); //cmd.ExecuteReader() List <Korrespondance> list = new List <Korrespondance>(); while (dr.Read()) { Korrespondance Korr = new Korrespondance(); Populate(dr, Korr); list.Add(Korr); } db.Dispose(); return(list); }