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