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