public static List <ProjectData> getProjectList()
{
List <ProjectData> pList = new List <ProjectData>();
MySqlDbInterface db = new MySqlDbInterface();
using (DbConnection conn = db.getConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM Project");
cmd.Connection = conn as MySqlConnection;
getProjectList(cmd, pList);
}
return(pList);
}
public static List <Device> getDeviceList(ProjectData project)
{
List <Device> dList = new List <Device>();
MySqlDbInterface db = new MySqlDbInterface();
using (DbConnection conn = db.getConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM ProjectDevice WHERE project_id = @project_id");
cmd.Parameters.AddWithValue("@project_id", project.id);
cmd.Connection = conn as MySqlConnection;
getDeviceList(cmd, project, dList);
}
return(dList);
}
public static List <ProjectData> getProjectList(string keyword)
{
List <ProjectData> pList = new List <ProjectData>();
MySqlDbInterface db = new MySqlDbInterface();
using (DbConnection conn = db.getConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM Project WHERE name LIKE @keyword");
cmd.Parameters.AddWithValue("@keyword", '%' + keyword + '%');
cmd.Connection = conn as MySqlConnection;
getProjectList(cmd, pList);
}
return(pList);
}
public static List <Tag> getTagList(Device device)
{
List <Tag> tList = new List <Tag>();
MySqlDbInterface db = new MySqlDbInterface();
using (DbConnection conn = db.getConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM loginfo WHERE device = @device");
cmd.Parameters.AddWithValue("@device", device.name);
cmd.Connection = conn as MySqlConnection;
getTagList(cmd, device, tList);
}
return(tList);
}
public static int getVal(Tag tag)
{
MySqlDbInterface db = new MySqlDbInterface();
using (DbConnection conn = db.getConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT " + tag.log_id + " FROM " + tag.table);
//cmd.Parameters.AddWithValue("@table", tag.table);
cmd.Connection = conn as MySqlConnection;
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
return(reader.GetInt32(tag.log_id));
}
}
}
return(0);
}
public static List <ProjectData> getProjectList(string[] keywords)
{
List <ProjectData> pList = new List <ProjectData>();
MySqlDbInterface db = new MySqlDbInterface();
using (DbConnection conn = db.getConnection())
{
int i = 0;
conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM Project WHERE FALSE");
cmd.Connection = conn as MySqlConnection;
foreach (string keyword in keywords)
{
cmd.CommandText += " OR name LIKE @keyword" + i;
cmd.Parameters.AddWithValue("@keyword" + i, '%' + keyword + '%');
i++;
}
getProjectList(cmd, pList);
}
return(pList);
}
