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