protected void rFrequency_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType < ListItemType.Item || e.Item.ItemType > ListItemType.EditItem)
{
return;
}
LastFrequencyMetric = (MetricTrac.Bll.FrequencyMetric)e.Item.DataItem;
foreach (MetricTrac.Bll.MetricOrgValue mmv in LastFrequencyMetric.Metrics)
{
if (string.IsNullOrEmpty(mmv.InputUnitOfMeasureName))
{
continue;
}
// try to trim uom name to 4 letters or 3 letters + '.'
/*bool IsNameTooLong = false;
* if (mmv.InputUnitOfMeasureName.Length > 3)
* {
* IsNameTooLong = true;
* mmv.InputUnitOfMeasureNameTooltip = mmv.InputUnitOfMeasureName;
* mmv.InputUnitOfMeasureName = mmv.InputUnitOfMeasureName.Substring(0, 2);
* }*/
for (int i = mmv.InputUnitOfMeasureName.Length - 1; i > 0; i--)
{
mmv.InputUnitOfMeasureName = mmv.InputUnitOfMeasureName.Insert(i, "<br />");
}
/*if (IsNameTooLong)
* mmv.InputUnitOfMeasureName += "<div><img height=\"8\" width=\"8\" src=\"../images/More.gif\"></div>";*/
}
BindRepiter("rMetric", LastFrequencyMetric.Metrics, e);
}
private void AddExportPeriod(DateTime?Begin, DateTime?End, int FrequencyID, string PeriodName, string PeriodInterval)
{
if (CommonBegin != null)
{
Begin = CommonBegin;
}
if (CommonEnd != null)
{
End = CommonEnd;
}
if (Begin == null || End == null || Begin == DateTime.MinValue || End == DateTime.MinValue)
{
return;
}
DateTime dtBegin = MetricTrac.Bll.Frequency.GetNormalizedDate(FrequencyID, (DateTime)Begin);
DateTime dtEnd = MetricTrac.Bll.Frequency.GetNormalizedDate(FrequencyID, (DateTime)End);
dtEnd = MetricTrac.Bll.Frequency.AddPeriod(dtEnd, FrequencyID, 1);
AnyPeriodExist = true;
MetricTrac.Bll.FrequencyMetric fm = MetricTrac.Bll.MetricValue.List(dtBegin, dtEnd, FrequencyID, null, MF.MetricID, MF.SelectOrgLocationsID, MF.GCAID, MF.PIID, MF.PIFormID, MF.DataCollectorID, true, true, null);
workbook.Worksheets.AddCopy(0);
IWorksheet worksheet = workbook.Worksheets[workbook.Worksheets.Count - 1];
ClearWorSheet(worksheet);
worksheet.Range["D1"].Text = PeriodInterval;
worksheet.Name = PeriodName;
for (int DateIndex = 0; DateIndex < fm.Date.Count; DateIndex++)
{
string ColumnName = GetColumnName(DateIndex + 3);
worksheet.Range[ColumnName + "2"].Text = fm.Date[DateIndex].sDate.Replace("\n", " ");
worksheet.Range[ColumnName + "3"].DateTime = fm.Date[DateIndex].Date;
}
for (int MerticIndex = 0; MerticIndex < fm.Metrics.Count; MerticIndex++)
{
string RowName = (MerticIndex + 4).ToString();
var m = fm.Metrics[MerticIndex];
worksheet.Range["A" + RowName].Text = m.OrgLocationFullName;
worksheet.Range["B" + RowName].Text = m.Name;
worksheet.Range["C" + RowName].Text = m.UnitOfMeasureName;
for (int ValueIndex = 0; ValueIndex < m.MetricValues.Count; ValueIndex++)
{
var v = m.MetricValues[ValueIndex];
if (string.IsNullOrEmpty(v.Value))
{
continue;
}
string ValueColumnName = GetColumnName(ValueIndex + 3);
worksheet.Range[ValueColumnName + RowName].Text = v.Value;
}
}
}
void ReBind()
{
Guid?ApproverUserId = null;
if (DataMode == Mode.Approve)
{
ApproverUserId = MetricTrac.Bll.LinqMicajahDataContext.LogedUserId;
}
int ValueCount = 6;
LastFrequencyMetric = MetricTrac.Bll.MetricValue.RelatedValuesList(ValueCount, CurrentDate, FrequencyFirstDate, CalcMetricID, GroupByMetric, ApproverUserId);
bool FilledFormulas = false;
foreach (MetricTrac.Bll.MetricOrgValue mmv in LastFrequencyMetric.Metrics)
{
if (mmv.MetricID == CalcMetricID && !FilledFormulas)
{
List <Bll.FormulaHeader> f = new List <Bll.FormulaHeader>();
FilledFormulas = true;
Guid? LastFormulaID = mmv.MetricValues[0].RelatedFormulaID;
string Formula = mmv.MetricValues[0].Formula;
int group = 1;
for (int i = 1; i < mmv.MetricValues.Count; i++)
{
if (LastFormulaID == mmv.MetricValues[i].RelatedFormulaID)
{
group++;
}
else
{
Bll.FormulaHeader fh = new MetricTrac.Bll.FormulaHeader();
fh.ColGroup = group;
fh.sFormula = Formula;
f.Add(fh);
LastFormulaID = mmv.MetricValues[i].RelatedFormulaID;
Formula = mmv.MetricValues[i].Formula;
group = 1;
}
}
Bll.FormulaHeader fhe = new MetricTrac.Bll.FormulaHeader();
fhe.ColGroup = group;
fhe.sFormula = Formula;
f.Add(fhe);
LastFrequencyMetric.Formulas = f;
}
mmv.OrgLocationFullName = MetricTrac.Bll.Mc_EntityNode.GetHtmlFullName(mmv.OrgLocationFullName);
if (string.IsNullOrEmpty(mmv.InputUnitOfMeasureName))
{
continue;
}
// try to trim uom name to 4 letters or 3 letters + '.'
/*bool IsNameTooLong = false;
* if (mmv.InputUnitOfMeasureName.Length > 3)
* {
* IsNameTooLong = true;
* mmv.InputUnitOfMeasureNameTooltip = mmv.InputUnitOfMeasureName;
* mmv.InputUnitOfMeasureName = mmv.InputUnitOfMeasureName.Substring(0, 2);
* }*/
for (int i = mmv.InputUnitOfMeasureName.Length - 1; i > 0; i--)
{
mmv.InputUnitOfMeasureName = mmv.InputUnitOfMeasureName.Insert(i, "<br />");
}
/*if (IsNameTooLong)
* mmv.InputUnitOfMeasureName += "<div><img height=\"8\" width=\"8\" src=\"../images/More.gif\"></div>";*/
}
if (FrequencyFirstDate == DateTime.MinValue)
{
FrequencyFirstDate = MetricTrac.Bll.Frequency.GetNormalizedDate(LastFrequencyMetric.FrequencyID, CurrentDate);
}
lblFrequency.Text = LastFrequencyMetric.Name;
rFormula.DataSource = LastFrequencyMetric.Formulas;
rFormula.DataBind();
rMetric.DataSource = LastFrequencyMetric.Metrics;
rMetric.DataBind();
}
