/// <summary>
/// 获取所有职位列表
/// </summary>
/// <returns>职位集合</returns>
public IList<Position> GetAllPosition()
{
IList<Position> list = new List<Position>();
string sql = "select * from TB_Position order by PName asc";
DataSet ds = AccessHelper.ExecuteDataSet(_connectionString, sql);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
Position position = new Position();
position.PId = (int)row["PId"];
position.PName = (string)row["PName"];
if (!Convert.IsDBNull(row["Comment"]))
{
position.Comment = (string)row["Comment"];
}
list.Add(position);
}
}
return list;
}
private void btnOk_Click(object sender, EventArgs e)
{
string name = txtPName.Text.Trim();
string comment = txtComment.Text.Trim();
if (name.Length == 0)
{
MessageBox.Show("名称不能为空");
return;
}
Position position = new Position();
position.PName = name;
position.Comment = comment;
pBll.Insert(position);
MessageBox.Show("添加成功！");
this.DialogResult = DialogResult.OK;
this.Close();
}
/// <summary>
/// 绑定职务信息
/// </summary>
private void BindPositionInfo()
{
position = pBll.GetPosition(_id);
txtPName.Text = position.PName;
txtComment.Text = position.Comment;
}
/// <summary>
/// 获取职位对象
/// </summary>
/// <param name="eId">Id</param>
/// <returns>职位对象</returns>
public Position GetPosition(int id)
{
Position position = null;
string sql = "select * from TB_Position where PId=" + id;
DataSet ds = AccessHelper.ExecuteDataSet(_connectionString, sql);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataRow row = ds.Tables[0].Rows[0];
position = new Position();
position.PId = (int)row["PId"];
position.PName = (string)row["PName"];
if (!Convert.IsDBNull(row["Comment"]))
{
position.Comment = (string)row["Comment"];
}
}
return position;
}
/// <summary>
/// 修改职位
/// </summary>
/// <param name="position">职位对象</param>
/// <returns>影响行数</returns>
public int Update(Position position)
{
string sql = "update TB_Position set PName=@PName,Comment=@Comment where PId=@PId";
OleDbParameter[] param = new OleDbParameter[] {
new OleDbParameter("@PName",position.PName),
new OleDbParameter("@Comment",position.Comment),
new OleDbParameter("@PId",position.PId)
};
int count = AccessHelper.ExecuteNonQuery(_connectionString, sql, param);
return count;
}
/// <summary>
/// 添加职位
/// </summary>
/// <param name="position">职位对象</param>
/// <returns>ID</returns>
public int Insert(Position position)
{
string sql = "insert into TB_Position(PName,Comment) ";
sql += "values(@PName,@Comment)";
OleDbParameter[] param = new OleDbParameter[] {
new OleDbParameter("@PName",position.PName),
new OleDbParameter("@Comment",position.Comment)
};
AccessHelper.ExecuteNonQuery(_connectionString, sql, param);
object id = AccessHelper.ExecuteScalar(_connectionString, "select @@identity");
return Convert.ToInt32(id);
}
