/// <summary>
/// 添加公司部门
/// </summary>
/// <param name="companyDept"></param>
/// <returns></returns>
public static int AddCompanyDept(Model.CompanyDeptModel companyDept)
{
int i = -1;
try
{
SqlParameter[] paras = new SqlParameter[] {
GetSqlParameter("@Dept", SqlDbType.NVarChar, companyDept.Dept),
GetSqlParameter("@AddDate", SqlDbType.DateTime, companyDept.Adddate)
};
i = DBHelper.ExecuteNonQuery("AddCompanyDept", paras, CommandType.StoredProcedure);
}
catch (SqlException)
{
throw new Exception("添加公司部门信息产生异常!");
}
return(i);
}
/// <summary>
/// ds2012
/// 修改部门信息
/// </summary>
/// <param name="companyDept">部门信息</param>
/// <returns></returns>
public static int UptCompanyDept(Model.CompanyDeptModel companyDept)
{
int i = -1;
try
{
SqlParameter[] paras = new SqlParameter[] {
GetSqlParameter("@Dept", SqlDbType.NVarChar, companyDept.Dept),
GetSqlParameter("@ID", SqlDbType.Int, companyDept.Id)
};
i = DBHelper.ExecuteNonQuery("UptCompanyDept", paras, CommandType.StoredProcedure);
}
catch (SqlException)
{
throw new Exception("修改公司部门信息产生异常!");
}
return(i);
}