private void btnSave_Click(object sender, EventArgs e)
{
var record = new TrainingTestRecord();
record.Remark = this.rtxtRemark.Text;
record.TestDate = this.dtpTestDate.Value;
record.TestPeople = this.txtTestPeople.Text;
record.TestResult = this.txtTestResult.Text;
record.TrainingContent = this.rtxtTrainingContent.Text;
record.TrainingDate = this.dtpTrainingDate.Value;
record.TrainingDepartment = this.txtTrainingDepartment.Text;
record.TrainingType = this.txtTrainingType.Text;
var bll = new TrainingTestRecordBLL();
CResult<bool> result = new CResult<bool>(false);
if (this._isEdit) {
record.RecordID = this._currentRecordID.Value;
result = bll.UpdateTrainingTestRecord(record);
} else {
record.PeopleID = this._peopleID.Value;
result = bll.InsertTrainingTestRecord(record);
}
MessageHelper.ShowSaveDbResultMessage(result);
if (result.Code == 0) {
this.Dispose();
if (callbackEvent != null) {
callbackEvent.Invoke();
}
}
}
public CResult<bool> UpdateTrainingTestRecord(TrainingTestRecord TrainingTestRecord)
{
if (TrainingTestRecord.RecordID <= 0) {
return new CResult<bool>(false, ErrorCode.ParameterError);
}
var result = new TrainingTestRecordDAL().UpdateTrainingTestRecord(TrainingTestRecord);
if (result) {
return new CResult<bool>(true);
} else {
return new CResult<bool>(false, ErrorCode.SaveDataFailed);
}
}
public CResult<bool> InsertTrainingTestRecord(TrainingTestRecord TrainingTestRecord)
{
if (TrainingTestRecord.PeopleID <= 0) {
return new CResult<bool>(false, ErrorCode.ParameterError);
}
var result = new TrainingTestRecordDAL().InsertTrainingTestRecord(TrainingTestRecord);
if (result) {
return new CResult<bool>(true);
} else {
return new CResult<bool>(false, ErrorCode.DataNotExist);
}
}
public TrainingTestRecord GetTrainingTestRecordByID(int RecordID)
{
using (var connection = new OleDbConnection(ConfigManagement.AccessConStr)) {
string sqlText = string.Format(@"select
RecordID,
PeopleID,
TrainingDate,
TrainingType,
TrainingContent,
TrainingDepartment,
TestDate,
TestResult,
TestPeople,
Remark
from {0} where RecordID=@RecordID", _TrainingTestRecordTableName);
var paras = new OleDbParameter[1];
paras[0] = new OleDbParameter("RecordID", RecordID);
var reader = new OLESqlHelper().GetReader(sqlText, connection, paras);
if (reader.Read()) {
int i = 0;
var TrainingTestRecord = new TrainingTestRecord();
TrainingTestRecord.RecordID = reader.GetInt32(i++);
TrainingTestRecord.PeopleID = reader.GetInt32(i++);
TrainingTestRecord.TrainingDate = reader.IsDBNull(i) ? new Nullable<DateTime>() : reader.GetDateTime(i++);
TrainingTestRecord.TrainingType = reader.GetString(i++);
TrainingTestRecord.TrainingContent = reader.GetString(i++);
TrainingTestRecord.TrainingDepartment = reader.GetString(i++);
TrainingTestRecord.TestDate = reader.IsDBNull(i) ? new Nullable<DateTime>() : reader.GetDateTime(i++);
TrainingTestRecord.TestResult = reader.GetString(i++);
TrainingTestRecord.TestPeople = reader.GetString(i++);
TrainingTestRecord.Remark = reader.GetString(i++);
return TrainingTestRecord;
} else {
return null;
}
}
}
public List<TrainingTestRecord> GetTrainingTestRecordList(int peopleID)
{
string sqlText = string.Format(@"select
RecordID,
TrainingDate,
TrainingType,
TrainingContent,
TrainingDepartment,
TestDate,
TestResult,
TestPeople,
Remark
from {0}
where PeopleID=@PeopleID"
, _TrainingTestRecordTableName);
var paras = new OleDbParameter[1];
paras[0] = new OleDbParameter("PeopleID", peopleID);
var table = new OLESqlHelper().GetTable(sqlText, paras);
var TrainingTestRecordList = new List<TrainingTestRecord>();
foreach (DataRow row in table.Rows) {
var TrainingTestRecord = new TrainingTestRecord() {
RecordID = (int)row["RecordID"],
TrainingDate = (DateTime?)row["TrainingDate"],
TrainingType = row["TrainingType"].ToString(),
TrainingContent = row["TrainingContent"].ToString(),
TrainingDepartment = row["TrainingDepartment"].ToString(),
TestDate = (DateTime?)row["TestDate"],
TestResult = row["TestResult"].ToString(),
TestPeople = row["TestPeople"].ToString(),
Remark = row["Remark"].ToString()
};
TrainingTestRecordList.Add(TrainingTestRecord);
}
return TrainingTestRecordList;
}
public bool UpdateTrainingTestRecord(TrainingTestRecord TrainingTestRecord)
{
string sqlText = string.Format(@"update {0} set
TrainingDate=@TrainingDate,
TrainingType=@TrainingType,
TrainingContent=@TrainingContent,
TrainingDepartment=@TrainingDepartment,
TestDate=@TestDate,
TestResult=@TestResult,
TestPeople=@TestPeople,
Remark=@Remark
where RecordID=@RecordID", _TrainingTestRecordTableName);
var paras = new OleDbParameter[9];
paras[0] = new OleDbParameter("TrainingDate", TrainingTestRecord.TrainingDate);
paras[0].OleDbType = OleDbType.DBDate;
paras[1] = new OleDbParameter("TrainingType", TrainingTestRecord.TrainingType);
paras[2] = new OleDbParameter("TrainingContent", TrainingTestRecord.TrainingContent);
paras[3] = new OleDbParameter("TrainingDepartment", TrainingTestRecord.TrainingDepartment);
paras[4] = new OleDbParameter("TestDate", TrainingTestRecord.TestDate);
paras[4].OleDbType = OleDbType.DBDate;
paras[5] = new OleDbParameter("TestResult", TrainingTestRecord.TestResult);
paras[6] = new OleDbParameter("TestPeople", TrainingTestRecord.TestPeople);
paras[7] = new OleDbParameter("Remark", TrainingTestRecord.Remark);
paras[8] = new OleDbParameter("RecordID", TrainingTestRecord.RecordID);
var result = new OLESqlHelper().ExecuteNoneQuery(sqlText, paras);
return result;
}
public bool InsertTrainingTestRecord(TrainingTestRecord TrainingTestRecord)
{
string sqlText = string.Format(@"insert into {0}(
PeopleID,
TrainingDate,
TrainingType,
TrainingContent,
TrainingDepartment,
TestDate,
TestResult,
TestPeople,
Remark)
values(
@PeopleID,
@TrainingDate,
@TrainingType,
@TrainingContent,
@TrainingDepartment,
@TestDate,
@TestResult,
@TestPeople,
@Remark)", _TrainingTestRecordTableName);
var paras = new OleDbParameter[9];
paras[0] = new OleDbParameter("PeopleID", TrainingTestRecord.PeopleID);
paras[1] = new OleDbParameter("TrainingDate", TrainingTestRecord.TrainingDate);
paras[1].OleDbType = OleDbType.DBDate;
paras[2] = new OleDbParameter("TrainingType", TrainingTestRecord.TrainingType);
paras[3] = new OleDbParameter("TrainingContent", TrainingTestRecord.TrainingContent);
paras[4] = new OleDbParameter("TrainingDepartment", TrainingTestRecord.TrainingDepartment);
paras[5] = new OleDbParameter("TestDate", TrainingTestRecord.TestDate);
paras[5].OleDbType = OleDbType.DBDate;
paras[6] = new OleDbParameter("TestResult", TrainingTestRecord.TestResult);
paras[7] = new OleDbParameter("TestPeople", TrainingTestRecord.TestPeople);
paras[8] = new OleDbParameter("Remark", TrainingTestRecord.Remark);
var result = new OLESqlHelper().ExecuteNoneQuery(sqlText, paras);
return result;
}