private void btnOk_Click(object sender, EventArgs e) { string approver = txtApprover.Text.Trim(); string comment = txtComment.Text.Trim(); if (approver.Length == 0) { MessageBox.Show("批准人不能为空"); return; } LeaveRecord record = new LeaveRecord(); record.EId = _eId; record.Type = cbType.SelectedItem.ToString(); record.StartDate =Convert.ToDateTime(dtpStartDate.Text); record.EndDate = Convert.ToDateTime(dtpEndDate.Text); record.Approver = approver; record.Comment = comment; rBll.Insert(record); MessageBox.Show("添加成功!"); this.DialogResult = DialogResult.OK; this.Close(); }
/// <summary> /// 获取所有休假记录列表 /// </summary> /// <returns>休假记录集合</returns> public IList<LeaveRecord> GetAllLeaveRecord() { IList<LeaveRecord> list = new List<LeaveRecord>(); string sql = "select * from TB_LeaveRecord order by StartDate desc"; 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) { LeaveRecord record = new LeaveRecord(); record.Id = (int)row["ID"]; record.EId = (int)row["EId"]; record.Type = (string)row["Type"]; record.Approver = (string)row["Approver"]; record.StartDate = (DateTime)row["StartDate"]; record.EndDate = (DateTime)row["EndDate"]; if (!Convert.IsDBNull(row["Comment"])) { record.Comment = (string)row["Comment"]; } list.Add(record); } } return list; }
/// <summary> /// 绑定休假记录信息 /// </summary> private void BindLeaveRecordInfo() { record = rBll.GetLeaveRecord(_id); lblEmployeeName.Text = eBll.GetEmployee(record.EId).EName; dtpStartDate.Text = record.StartDate.ToString("yyyy年MM月dd日"); dtpEndDate.Text = record.EndDate.ToString("yyyy年MM月dd日"); txtApprover.Text = record.Approver; txtComment.Text = record.Comment; for (int i = 0; i < cbType.Items.Count; i++) { if (cbType.Items[i].ToString() == record.Type) { cbType.SelectedIndex = i; break; } } }
/// <summary> /// 获取休假记录对象 /// </summary> /// <param name="eId">Id</param> /// <returns>休假记录对象</returns> public LeaveRecord GetLeaveRecord(int id) { LeaveRecord record = null; string sql = "select * from TB_LeaveRecord where ID=" + 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]; record = new LeaveRecord(); record.Id = (int)row["ID"]; record.EId = (int)row["EId"]; record.Type = (string)row["Type"]; record.Approver = (string)row["Approver"]; record.StartDate = (DateTime)row["StartDate"]; record.EndDate = (DateTime)row["EndDate"]; if (!Convert.IsDBNull(row["Comment"])) { record.Comment = (string)row["Comment"]; } } return record; }
/// <summary> /// 修改休假记录 /// </summary> /// <param name="record">休假记录对象</param> /// <returns>影响行数</returns> public int Update(LeaveRecord record) { string sql = "update TB_LeaveRecord set EId=@EId,Type=@Type,Approver=@Approver,StartDate=@StartDate,EndDate=@EndDate,Comment=@Comment where ID=@ID"; OleDbParameter[] param = new OleDbParameter[] { new OleDbParameter("@EId",record.EId), new OleDbParameter("@Type",record.Type), new OleDbParameter("@Approver",record.Approver), new OleDbParameter("@StartDate",record.StartDate), new OleDbParameter("@EndDate",record.EndDate), new OleDbParameter("@Approver",record.Comment), new OleDbParameter("@ID",record.Id) }; int count = AccessHelper.ExecuteNonQuery(_connectionString, sql, param); return count; }
/// <summary> /// 添加休假记录 /// </summary> /// <param name="record">休假记录对象</param> /// <returns>ID</returns> public int Insert(LeaveRecord record) { string sql = "insert into TB_LeaveRecord(EId,Type,Approver,StartDate,EndDate,Comment) "; sql += "values(@EId,@Type,@Approver,@StartDate,@EndDate,@Comment)"; OleDbParameter[] param = new OleDbParameter[] { new OleDbParameter("@EId",record.EId), new OleDbParameter("@Type",record.Type), new OleDbParameter("@Approver",record.Approver), new OleDbParameter("@StartDate",record.StartDate), new OleDbParameter("@EndDate",record.EndDate), new OleDbParameter("@Approver",record.Comment) }; AccessHelper.ExecuteNonQuery(_connectionString, sql, param); object id = AccessHelper.ExecuteScalar(_connectionString, "select @@identity"); return Convert.ToInt32(id); }