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