public static void SearchPlanInfo(string planID, out plan PLAN, out int plan_status, out string projectID) { MySqlConnection conn = new MySqlConnection(Conn); MySqlCommand command; conn.Open(); string sql = String.Format("select plan_name, plan_priority, plan_status, plan_project ,description,plan_manager from table_plan where plan_id = {0}", planID); command = new MySqlCommand(sql, conn); var reader = command.ExecuteReader(); reader.Read(); string plan_name = reader["plan_name"].ToString(); int plan_priority = int.Parse(reader["plan_priority"].ToString()); plan_status = int.Parse(reader["plan_status"].ToString()); projectID = reader["plan_project"].ToString(); string description = reader["description"].ToString(); string plan_managerID = reader["plan_manager"].ToString(); reader.Close(); string sql2 = String.Format("select user_name from table_user_info where user_id = {0}", plan_managerID); command = new MySqlCommand(sql2, conn); var reader2 = command.ExecuteReader(); reader2.Read(); string plan_managerName = reader2["user_name"].ToString(); // MessageBox.Show(plan_managerName); PLAN = new plan(plan_name, description, plan_managerName, plan_managerID, plan_priority); conn.Close(); }
private void InitiateInfos() { plan p = new plan("", "", "", "", 0); string projectID = ""; int plan_status = 0; Global_Database.SearchPlanInfo(planID, out p, out plan_status, out projectID); MessageBox.Show(p.description); textBox_planName.Text = p.name; comboBox_priority.SelectedIndex = p.priority; textBox_manageName.Text = p.manager_name; textBox_manageName.ReadOnly = true; textBox_managerID.Text = p.manager_id; textBox_description.Text = p.description; comboBox_priority.Enabled = false; }