/// <summary> /// 插入部门信息 /// </summary> /// <param name="employee"></param> /// <returns></returns> public static bool InsertContractProject(ContractProject project) { MySqlConnection con = DBTools.GetMySqlConnection(); MySqlCommand cmd; int count = -1; // 受影响行数 try { con.Open(); cmd = con.CreateCommand(); cmd.CommandText = INSERT_CONTRACT_PROJECT_STR; cmd.Parameters.AddWithValue("@Id", project.Id); // 部门职位 cmd.Parameters.AddWithValue("@CategoryId", project.CategoryId); // 项目类型 cmd.Parameters.AddWithValue("@Project", project.Project); // 项目类型简写 count = cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); con.Dispose(); if (count == 1) // 插入成功后的受影响行数为1 { Console.WriteLine("插入项目类型成功"); return true; } else { Console.WriteLine("插入项目类型失败"); return false; } } catch (Exception) { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } }
public static List<ContractProject> QueryCategoryProject(int categoryId) { MySqlConnection con = DBTools.GetMySqlConnection(); MySqlCommand cmd; List<ContractProject> projects = new List<ContractProject>(); try { con.Open(); cmd = con.CreateCommand(); cmd.CommandText = QUERY_CATEGORY_PROJECT; cmd.Parameters.AddWithValue("@CategoryId", categoryId); MySqlDataReader sqlRead = cmd.ExecuteReader(); cmd.Dispose(); while (sqlRead.Read()) { ContractProject project = new ContractProject(); project.Id = int.Parse(sqlRead["id"].ToString()); project.CategoryId = int.Parse(sqlRead["categoryid"].ToString()); project.Project = sqlRead["project"].ToString(); projects.Add(project); } con.Close(); con.Dispose(); } catch (Exception) { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return projects; }