private void ExportNormalInfo(int i, DataRow dr)
{
dr[0] = _AssessActivityList[i].ItsEmployee.Account.Name;
if (_AssessActivityList[i].ItsEmployee.Account.Position.Grade != null)
{
dr[1] = _AssessActivityList[i].ItsEmployee.Account.Position.Grade.Name;
}
dr[2] = _AssessActivityList[i].ItsEmployee.EmployeeDetails.Work.ComeDate;
dr[3] =
_AssessActivityList[i].ItsEmployee.EmployeeDetails.Education.EducationalBackground.Name;
dr[4] = _AssessActivityList[i].ItsEmployee.Account.Dept.DepartmentName;
BindItemValueCollection collection =
_GetBindField.BindItemValueCollection(_AssessActivityList[i].ItsEmployee.Account.Id,
_AssessActivityList[i].ScopeFrom, _AssessActivityList[i].ScopeTo);
foreach (BindItemValue item in collection.BindItemValueList)
{
if (item.BindItemEnum.Id == BindItemEnum.OutCityDays.Id)
{
dr[9] = item.Value;
}
else if (item.BindItemEnum.Id == BindItemEnum.Absenteeism.Id)
{
dr[10] = item.Value;
}
}
}
/// <summary>
///
/// </summary>
public decimal Calculate(int accountid, DateTime start, DateTime end, string formula)
{
GetBindField getBindField = new GetBindField();
BindItemValueCollection collection = getBindField.BindItemValueCollection(accountid, start, end);
List <ExpressionItem> expressionItemList = new List <ExpressionItem>();
expressionItemList.Add(new ExpressionItem(AssessBindItemEnum.ImposibleID, formula, EnumDataType.Number));
foreach (BindItemValue item in collection.BindItemValueList)
{
if (item.BindItemEnum.Id == BindItemEnum.ShiJia.Id)
{
expressionItemList.Add(
new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.ShiJia.ID), item.Value.ToString(),
EnumDataType.Number));
}
else if (item.BindItemEnum.Id == BindItemEnum.BingJia.Id)
{
expressionItemList.Add(
new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.BingJia.ID), item.Value.ToString(),
EnumDataType.Number));
}
else if (item.BindItemEnum.Id == BindItemEnum.ChanQianJia.Id)
{
expressionItemList.Add(
new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.ChanQianJia.ID), item.Value.ToString(),
EnumDataType.Number));
}
else if (item.BindItemEnum.Id == BindItemEnum.BuRuJia.Id)
{
expressionItemList.Add(
new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.BuRuJia.ID), item.Value.ToString(),
EnumDataType.Number));
}
else if (item.BindItemEnum.Id == BindItemEnum.ChanJia.Id)
{
expressionItemList.Add(
new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.ChanJia.ID), item.Value.ToString(),
EnumDataType.Number));
}
else if (item.BindItemEnum.Id == BindItemEnum.BeLate.Id)
{
expressionItemList.Add(
new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.BeLate.ID), item.Value.ToString(),
EnumDataType.Number));
}
else if (item.BindItemEnum.Id == BindItemEnum.LeaveEarly.Id)
{
expressionItemList.Add(
new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.LeaveEarly.ID), item.Value.ToString(),
EnumDataType.Number));
}
else if (item.BindItemEnum.Id == BindItemEnum.Absenteeism.Id)
{
expressionItemList.Add(
new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.Absenteeism.ID), item.Value.ToString(),
EnumDataType.Number));
}
else if (item.BindItemEnum.Id == BindItemEnum.WorkAge.Id)
{
expressionItemList.Add(
new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.WorkAge.ID), item.Value.ToString(),
EnumDataType.Number));
}
else if (item.BindItemEnum.Id == BindItemEnum.OnDutyDays.Id)
{
expressionItemList.Add(
new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.OnDutyDays.ID), item.Value.ToString(),
EnumDataType.Number));
}
else if (item.BindItemEnum.Id == BindItemEnum.ExpectedOnDutyDays.Id)
{
expressionItemList.Add(
new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.ExpectOnDutyDays.ID), item.Value.ToString(),
EnumDataType.Number));
}
else if (item.BindItemEnum.Id == BindItemEnum.PuTongOverTime.Id)
{
expressionItemList.Add(
new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.PuTongOverTime.ID), item.Value.ToString(),
EnumDataType.Number));
}
else if (item.BindItemEnum.Id == BindItemEnum.ShuangXiuOverTime.Id)
{
expressionItemList.Add(
new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.ShuangXiuOverTime.ID), item.Value.ToString(),
EnumDataType.Number));
}
else if (item.BindItemEnum.Id == BindItemEnum.JieRiOverTime.Id)
{
expressionItemList.Add(
new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.JieRiOverTime.ID), item.Value.ToString(),
EnumDataType.Number));
}
else if (item.BindItemEnum.Id == BindItemEnum.OutCityDays.Id)
{
expressionItemList.Add(
new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.OutCityDays.ID), item.Value.ToString(),
EnumDataType.Number));
}
//else if (item.BindItemEnum.Id == BindItemEnum.NotEntryDays.Id)
//{
// expressionItemList.Add(
// new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.NotEntryDays.ID), item.Value.ToString(),
// EnumDataType.Number));
//}
//else if (item.BindItemEnum.Id == BindItemEnum.DimissionDays.Id)
//{
// expressionItemList.Add(
// new ExpressionItem(string.Format("A{0}", AssessBindItemEnum.DimissionDays.ID), item.Value.ToString(),
// EnumDataType.Number));
//}
}
CalculateExpressionItemList cal = new CalculateExpressionItemList(expressionItemList, "A");
cal.CalculateExpressionResult();
foreach (ExpressionItem item in expressionItemList)
{
if (item.Parameter == AssessBindItemEnum.ImposibleID)
{
return(Convert.ToDecimal(item.Result));
}
}
return(0);
}