/// <summary>
/// 增加部门
/// </summary>
/// <param name="department">
/// 部门对象
/// </param>
/// <returns>
/// 主键编号
/// </returns>
public int Insert(System_Department department)
{
if (department == null)
{
throw new ArgumentNullException("department");
}
int id;
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"Name",
SqlDbType.NVarChar,
department.Name,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Principal",
SqlDbType.NVarChar,
department.Principal,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"PrincipalMobile",
SqlDbType.NVarChar,
department.PrincipalMobile,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Headcount",
SqlDbType.Int,
department.Headcount,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Description",
SqlDbType.NVarChar,
department.Description ?? string.Empty,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"CreateTime",
SqlDbType.DateTime,
department.CreateTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ReferenceID",
SqlDbType.Int,
null,
ParameterDirection.Output)
};
try
{
this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_System_Department_Insert", parameters, null);
id = (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value;
}
catch (Exception exception)
{
throw new Exception("Exception - SystemDepartmentDA - Insert", exception);
}
return id;
}
/// <summary>
/// 修改部门
/// </summary>
/// <param name="department">
/// 部门对象
/// </param>
public void ModifyDepartment(System_Department department)
{
this.systemDepartmentDA.Update(department);
}
/// <summary>
/// 修改部门
/// </summary>
/// <param name="department">
/// 部门对象
/// </param>
public void Update(System_Department department)
{
if (department == null)
{
throw new ArgumentNullException("department");
}
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"ID",
SqlDbType.Int,
department.ID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Name",
SqlDbType.NVarChar,
department.Name,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Principal",
SqlDbType.NVarChar,
department.Principal,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"PrincipalMobile",
SqlDbType.NVarChar,
department.PrincipalMobile,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Headcount",
SqlDbType.Int,
department.Headcount,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Description",
SqlDbType.NVarChar,
department.Description,
ParameterDirection.Input)
};
try
{
this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_System_Department_Update", parameters, null);
}
catch (Exception exception)
{
throw new Exception("Exception - SystemDepartmentDA - Update", exception);
}
}
/// <summary>
/// 添加部门
/// </summary>
/// <param name="department">
/// 部门对象
/// </param>
/// <returns>
/// 部门编号
/// </returns>
public int AddDepartment(System_Department department)
{
return this.systemDepartmentDA.Insert(department);
}
