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