/// <summary> /// 记录历史 /// </summary> /// <param name="operatorType"></param> private void CreateHistory(OperatorType operatorType) { string remark = ""; AdjustRestHistory _AdjustRestHistory = UpdateAdjustRestByOperator.GetNewAdjustRestHistory(AdjustRestHistoryTypeEnum.OutCityApplication, _AccountID); if (operatorType == OperatorType.add) { remark = _OutApplicationItem.FromDate + " - " + _OutApplicationItem.ToDate + " 出差" + _OutApplicationItem.CostTime + "小时"; _AdjustRestHistory.ChangeHours = _ChangeHour; } else if (operatorType == OperatorType.delete) { remark = _OutApplicationItem.FromDate + " - " + _OutApplicationItem.ToDate + " 取消出差" + _OutApplicationItem.CostTime + "小时"; _AdjustRestHistory.ChangeHours = -_ChangeHour; } _AdjustRestHistory.Remark = remark; _AdjustRestHistory.RelevantID = _OutApplicationItem.OutApplicationID; _IAdjustRestHistory.InsertAdjustRestHistory(_AccountID, _AdjustRestHistory); }
/// <summary> /// /// </summary> public static AdjustRestHistory GetNewAdjustRestHistory(AdjustRestHistoryTypeEnum type, int accountid) { AdjustRestHistory adjustRestHistory = new AdjustRestHistory(0, DateTime.Now, 0, type); adjustRestHistory.Operator = new Account(accountid, "", ""); return(adjustRestHistory); }
/// <summary> /// 手工修改 /// </summary> public UpdateAdjustRestByOperator(int adjustID, decimal surplusAdjustRest, string remark, int operatorID) { _SurplusAdjustRest = surplusAdjustRest; _Remark = remark; _OperatorID = operatorID; _AdjustRestHistory = GetNewAdjustRestHistory(AdjustRestHistoryTypeEnum.ModifyByOperator, operatorID); _AdjustRestHistory.AdjustRestHistoryTypeEnum = AdjustRestHistoryTypeEnum.ModifyByOperator; _AdjustRestID = adjustID; }
/// <summary> /// 记录历史 /// </summary> private void CreateHistory() { string remark; AdjustRestHistory _AdjustRestHistory = UpdateAdjustRestByOperator.GetNewAdjustRestHistory(AdjustRestHistoryTypeEnum.AdjustRestRequest, _AccountID); remark = _LeaveRequestItem.FromDate + " - " + _LeaveRequestItem.ToDate + " 调休" + _LeaveRequestItem.CostTime + "小时"; _AdjustRestHistory.ChangeHours = -_LeaveRequestItem.CostTime; _AdjustRestHistory.Remark = remark; _AdjustRestHistory.RelevantID = _LeaveRequestID; _IAdjustRestHistory.InsertAdjustRestHistory(_AccountID, _AdjustRestHistory); }
public int InsertAdjustRestHistory(int accountid, AdjustRestHistory adjustRestHistory) { int pkid; SqlCommand cmd = new SqlCommand(); cmd.Parameters.Add(_ParmPKID, SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add(_ParmAdjustRestHistoryType, SqlDbType.Int).Value = (Int32)adjustRestHistory.AdjustRestHistoryTypeEnum; cmd.Parameters.Add(_ParmAccountID, SqlDbType.Int).Value = accountid; cmd.Parameters.Add(_ParmChangeHours, SqlDbType.Decimal).Value = adjustRestHistory.ChangeHours; cmd.Parameters.Add(_ParmOccurTime, SqlDbType.DateTime).Value = adjustRestHistory.OccurTime; cmd.Parameters.Add(_ParmOperatorId, SqlDbType.Int).Value = adjustRestHistory.Operator.Id; cmd.Parameters.Add(_ParmRelevantID, SqlDbType.Int).Value = adjustRestHistory.RelevantID; cmd.Parameters.Add(_ParmRemark, SqlDbType.NVarChar, 255).Value = adjustRestHistory.Remark; // cmd.Parameters.Add(_ParmResultAdjustRestHours, SqlDbType.Decimal).Value = adjustRestHistory.ResultAdjustRestHours; SqlHelper.ExecuteNonQueryReturnPKID("AdjustRestHistoryInsert", cmd, out pkid); adjustRestHistory.AdjustRestHistoryID = pkid; return(pkid); }
public List <AdjustRestHistory> GetAdjustRestHistoryByAccountID(int accountID) { List <AdjustRestHistory> adjustRestHistoryList = new List <AdjustRestHistory>(); SqlCommand cmd = new SqlCommand(); cmd.Parameters.Add(_ParmAccountID, SqlDbType.Int).Value = accountID; try { using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetAdjustRestHistoryByAccountID", cmd)) { while (sdr.Read()) { AdjustRestHistory adjustRestHistory = new AdjustRestHistory(); GetFieldFromParm(sdr, adjustRestHistory); adjustRestHistoryList.Add(adjustRestHistory); } return(adjustRestHistoryList); } } catch { throw new ApplicationException(_DBError); } }
/// <summary> /// 所有GET数据绑定 /// </summary> /// <param name="sdr"></param> /// <param name="adjustRestHistory"></param> private static void GetFieldFromParm(SqlDataReader sdr, AdjustRestHistory adjustRestHistory) { if (adjustRestHistory == null) { adjustRestHistory = new AdjustRestHistory(); } for (int i = 0; i < sdr.FieldCount; i++) { DateTime tryDateTimeParse; int tryIntParse; decimal tryDecimalParse; switch (sdr.GetName(i)) { case _DBPKID: if (sdr[_DBPKID] != null && int.TryParse(sdr[_DBPKID].ToString(), out tryIntParse)) { adjustRestHistory.AdjustRestHistoryID = (int)sdr[_DBPKID]; } break; case _DBAdjustRestHistoryType: if (sdr[_DBAdjustRestHistoryType] != null && int.TryParse(sdr[_DBAdjustRestHistoryType].ToString(), out tryIntParse)) { adjustRestHistory.AdjustRestHistoryTypeEnum = (AdjustRestHistoryTypeEnum)sdr[_DBAdjustRestHistoryType]; } break; case _DBChangeHours: if (sdr[_DBChangeHours] != null && decimal.TryParse(sdr[_DBChangeHours].ToString(), out tryDecimalParse)) { adjustRestHistory.ChangeHours = (decimal)sdr[_DBChangeHours]; } break; case _DBOccurTime: if (sdr[_DBOccurTime] != null && DateTime.TryParse(sdr[_DBOccurTime].ToString(), out tryDateTimeParse)) { adjustRestHistory.OccurTime = (DateTime)sdr[_DBOccurTime]; } break; case _DBOperatorId: if (sdr[_DBOperatorId] != null && int.TryParse(sdr[_DBOperatorId].ToString(), out tryIntParse)) { adjustRestHistory.Operator = adjustRestHistory.Operator ?? new Account(); adjustRestHistory.Operator.Id = (int)sdr[_DBOperatorId]; } break; case _DBRelevantID: if (sdr[_DBRelevantID] != null && int.TryParse(sdr[_DBRelevantID].ToString(), out tryIntParse)) { adjustRestHistory.RelevantID = (int)sdr[_DBRelevantID]; } break; case _DBRemark: if (sdr[_DBRemark] != null) { adjustRestHistory.Remark = sdr[_DBRemark].ToString(); } break; //case _DBResultAdjustRestHours: // if (sdr[_DBResultAdjustRestHours] != null && // decimal.TryParse(sdr[_DBResultAdjustRestHours].ToString(), out tryDecimalParse)) // { // adjustRestHistory.ResultAdjustRestHours = (decimal)sdr[_DBResultAdjustRestHours]; // } // break; default: break; } } }