/// <summary>
/// 添加职位
/// </summary>
/// <param name="position"></param>
/// <returns></returns>
public int AddPosition(Position position)
{
//创建存储过程参数
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@PositionName", position.PositionName),
new SqlParameter("@PositionDescribe", position.PositionDescribe)
};
if (SqlDbHelper.ExecuteNonQueryByProc("sp_AddPosition", parameters))
{
return(0);
}
else
{
return(1);
}
//string sqlText = $"INSERT INTO Position VALUES('{position.PositionName}', '{position.PositionDescribe}', '0', GETDATE())";
//if (SqlDbHelper.ExecuteNonQuery(sqlText))
//{
// return 0;
//}
//else
//{
// return 0;
//}
}
/// <summary>
/// 删除职位
/// </summary>
/// <param name="userid">职位ID</param>
/// <returns></returns>
public int DelPosition(int positionid)
{
//创建存储过程参数
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@PositionId", positionid)
};
if (SqlDbHelper.ExecuteNonQueryByProc("sp_DelPosition", parameters))
{
return(0);
}
else
{
return(1);
}
//string sqlText = $"DELETE dbo.Position WHERE PositionId = {positionid}";
//if (SqlDbHelper.ExecuteNonQuery(sqlText))
//{
// return 0;
//}
//else
//{
// return 1;
//}
}
