/// <summary> /// 添加部门 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Insert_DepartmentTableData(Department_Table obj) { return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"), CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("@Dep_Name", obj.Dep_Name) })); }
/// <summary> /// 获取全部的部门 /// </summary> /// <returns></returns> public List <Department_Table> GetDepartmentTableAll() { List <Department_Table> list = new List <Department_Table>(); SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"), CommandType.StoredProcedure); while (dr.Read()) { Department_Table obj = new Department_Table(); obj.Dep_id = Convert.ToInt32(dr["Dep_id"].ToString()); obj.Dep_Name = dr["Dep_Name"].ToString(); list.Add(obj); } dr.Close(); return(list); }
/// <summary> /// 根据ID查询部门信息 /// </summary> /// <param name="con"></param> /// <returns></returns> public Department_Table GetDepartmentTableByConn(string con) { Department_Table obj = new Department_Table(); SqlDataReader dr = DBHerlper.ExecuteReader( "Select * from Department_Table where Dep_id=@Dep_id", CommandType.Text, new SqlParameter[] { new SqlParameter("@Dep_id", con) }); if (dr.Read()) { obj.Dep_id = Convert.ToInt32(dr["Dep_id"].ToString()); obj.Dep_Name = dr["Dep_Name"].ToString(); } dr.Close(); return(obj); }
/// <summary> /// 更改部门信息 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Update_DepartmentTableData(Department_Table obj) { return(relevanceClass.Update_DepartmentTableData(obj)); }
/// <summary> /// 添加部门信息 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Insert_DepartmentTableData(Department_Table obj) { return(relevanceClass.Insert_DepartmentTableData(obj)); }