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