public List<RewardRecord> GetRewardRecordList(int peopleID)
{
string sqlText = string.Format(@"select
RecordID,
RewardDate,
RewardContent
from {0}
where PeopleID=@PeopleID"
, _RewardRecordTableName);
var paras = new OleDbParameter[1];
paras[0] = new OleDbParameter("PeopleID", peopleID);
var table = new OLESqlHelper().GetTable(sqlText, paras);
var rewardRecordList = new List<RewardRecord>();
foreach (DataRow row in table.Rows) {
var rewardRecord = new RewardRecord() {
RecordID = (int)row["RecordID"],
RewardDate = (DateTime?)row["RewardDate"],
RewardContent = row["RewardContent"].ToString(),
};
rewardRecordList.Add(rewardRecord);
}
return rewardRecordList;
}
public RewardRecord GetRewardRecordByID(int recordID)
{
using (var connection = new OleDbConnection(ConfigManagement.AccessConStr)) {
string sqlText = string.Format(@"select
RecordID,
PeopleID,
RewardDate,
RewardContent
from {0} where RecordID=@RecordID", _RewardRecordTableName);
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 RewardRecord = new RewardRecord();
RewardRecord.RecordID = reader.GetInt32(i++);
RewardRecord.PeopleID = reader.GetInt32(i++);
RewardRecord.RewardDate = reader.IsDBNull(i) ? new Nullable<DateTime>() : reader.GetDateTime(i++);
RewardRecord.RewardContent = reader.GetString(i++);
return RewardRecord;
} else {
return null;
}
}
}
public CResult<bool> UpdateRewardRecord(RewardRecord RewardRecord)
{
if (RewardRecord.RecordID <= 0) {
return new CResult<bool>(false, ErrorCode.ParameterError);
}
var result = new RewardRecordDAL().UpdateRewardRecord(RewardRecord);
if (result) {
return new CResult<bool>(true);
} else {
return new CResult<bool>(false, ErrorCode.SaveDataFailed);
}
}
public CResult<bool> InsertRewardRecord(RewardRecord RewardRecord)
{
if (RewardRecord.PeopleID <= 0) {
return new CResult<bool>(false, ErrorCode.ParameterError);
}
var result = new RewardRecordDAL().InsertRewardRecord(RewardRecord);
if (result) {
return new CResult<bool>(true);
} else {
return new CResult<bool>(false, ErrorCode.DataNotExist);
}
}
public bool InsertRewardRecord(RewardRecord rewardRecord)
{
string sqlText = string.Format(@"insert into {0}(
PeopleID,
RewardDate,
RewardContent
)
values(
@PeopleID,
@RewardDate,
@RewardContent
)", _RewardRecordTableName);
var paras = new OleDbParameter[3];
paras[0] = new OleDbParameter("PeopleID", rewardRecord.PeopleID);
paras[1] = new OleDbParameter("RewardDate", rewardRecord.RewardDate);
paras[1].OleDbType = OleDbType.DBDate;
paras[2] = new OleDbParameter("RewardContent", rewardRecord.RewardContent);
var result = new OLESqlHelper().ExecuteNoneQuery(sqlText, paras);
return result;
}
private void btnSave_Click(object sender, EventArgs e)
{
var record = new RewardRecord();
record.RewardDate = this.dtpRewardDate.Value;
record.RewardContent = this.rtxtRewardContent.Text;
var bll = new RewardRecordBLL();
CResult<bool> result = new CResult<bool>(false);
if (this._isEdit) {
record.RecordID = this._currentRecordID.Value;
result = bll.UpdateRewardRecord(record);
} else {
record.PeopleID = this._peopleID.Value;
result = bll.InsertRewardRecord(record);
}
MessageHelper.ShowSaveDbResultMessage(result);
if (result.Code == 0) {
this.Dispose();
if (callbackEvent != null) {
callbackEvent.Invoke();
}
}
}
public bool UpdateRewardRecord(RewardRecord RewardRecord)
{
string sqlText = string.Format(@"update {0} set
RewardDate=@RewardDate,
RewardContent=@RewardContent
where RecordID=@RecordID", _RewardRecordTableName);
var paras = new OleDbParameter[3];
paras[0] = new OleDbParameter("RewardDate", RewardRecord.RewardDate);
paras[0].OleDbType = OleDbType.DBDate;
paras[1] = new OleDbParameter("RewardContent", RewardRecord.RewardContent);
paras[2] = new OleDbParameter("RecordID", RewardRecord.RecordID);
var result = new OLESqlHelper().ExecuteNoneQuery(sqlText, paras);
return result;
}
