private void SetCellValue(object value, CellExportedEventArgs e, WorksheetCell cell, IMeasure measured)
{
if (e.Field.Name == "Item.ManageRequestStatus" ||
e.Field.Name == "Item.Request.ManageRequestStatus")
{
cell.Value = Expl_User_Journal_ManagePU_Request_List.StatusToString(Convert.ToInt16(value));
return;
}
ExportHelper.SetCellValue(cell, value, measured, e.Field.Tag, e.Field.Name);
}
protected void ugrdEEP_CellExported(object sender, CellExportedEventArgs e)
{
int iRdex = e.CurrentRowIndex;
int iCdex = e.CurrentColumnIndex;
if (iRdex > 6)
{
if (iCdex % 3 == 2 && e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value != null)
{
if (e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value.ToString() != "-")
{
string str = e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value.ToString();
char[] sep = { '<', '>' };
Array a = str.Split(sep);
e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value = a.GetValue(2);
}
}
}
}
void FormatExportValue(CellExportedEventArgs e, IMeasure measured)
{
if (e.Record.Cells.Count <= e.Field.Index)
{
return;
}
var value = e.Record.Cells[e.Field.Index].Value;
if (value is string)
{
FilteringString(e, value as string);
return;
}
var cell = e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[e.CurrentColumnIndex];
SetCellValue(value, e, cell, measured);
}
/// <summary>
/// Отфильтровываем недо символы
/// </summary>
/// <param name="e"></param>
/// <param name="value"></param>
void FilteringString(CellExportedEventArgs e, string value)
{
if (e == null || e.Field == null)
{
return;
}
switch (e.Field.Name)
{
case "StringData":
value = FileAdapter.RemoveBadChar(value, 1024, " ");
break;
default:
return;
}
var cell = e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[e.CurrentColumnIndex];
cell.Value = value;
}
protected void ugrdEEP_CellExported(object sender, CellExportedEventArgs e)
{
int iRdex = e.CurrentRowIndex;
int iCdex = e.CurrentColumnIndex;
string strEname = string.Empty;
if (iRdex > 4)
{
if (iCdex > 6)
{
strEname = ugridKpiTargetList.Rows[iRdex - 5].Cells.FromKey("THRESHOLD_ENAME").Text;
string[] strEnameA = strEname.Split('*');
string strEname1 = strEnameA.GetValue(iCdex - 7).ToString().Split('^').GetValue(0).ToString();
string strEname2 = strEnameA.GetValue(iCdex - 7).ToString().Split('^').GetValue(1).ToString();
string str = e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value.ToString();
char[] sep = { '<', '>' };
Array a = str.Split(sep);
e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value
= a.GetValue(0).ToString().Replace(" ", " [") + (strEname1.Length > 4 ? strEname1.Substring(0, 4) : strEname1) + "] \n"
+ a.GetValue(4).ToString().Replace(" ", " [") + (strEname2.Length > 4 ? strEname2.Substring(0, 4) : strEname2) + "] ";
e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].CellFormat.WrapText = ExcelDefaultableBoolean.True;
}
}
}
protected void ugrdEEP_CellExported(object sender, CellExportedEventArgs e)
{
}
protected void UltraWebGridExcelExporter_CellExported(object sender, CellExportedEventArgs e)
{
int iRdex = e.CurrentRowIndex;
int iCdex = e.CurrentColumnIndex;
if (iRdex != 0)
{
if ((((iCdex == 0) || (iCdex == 4)) || ((iCdex == 8) || (iCdex == 11))) && (e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value != null))
{
e.CurrentWorksheet.Columns[iCdex].Width = 0x1964;
}
e.CurrentWorksheet.Rows[iRdex].Height = 350;
}
else if (iRdex != 0)
{
e.CurrentWorksheet.Rows[iRdex].Height = 350;
}
}
protected void UltraWebGridExcelExporter_CellExported(object sender, CellExportedEventArgs e)
{
int iRdex = e.CurrentRowIndex;
int iCdex = e.CurrentColumnIndex;
if (iRdex != 0)
{
if ((e.GridColumn.Key.ToLower() == "otdate") && (e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value != null))
{
e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value = string.Format("{0:" + "yyyy/MM/dd" + "}", Convert.ToDateTime(e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value));
}
e.CurrentWorksheet.Rows[iRdex].Height = 350;
}
}
void OnCellExported(object sender, CellExportedEventArgs e)
{
var value = e.Value;
if (value == null)
{
return;
}
var exporter = sender as ProryvDataPresenterExcelExporter;
var measured = exporter != null ? exporter.Measured : null;
if (value is string)
{
FormatExportValue(e, measured);
return;
}
WorksheetRow row = null;
try
{
row = e.CurrentWorksheet.Rows[e.CurrentRowIndex];
}
catch { }
if (row == null)
{
return;
}
WorksheetCell cell = null;
try
{
cell = row.Cells[e.CurrentColumnIndex];
}
catch {}
if (cell == null)
{
return;
}
//var value = e.Value;
System.Windows.Style cellStyle = e.Field.Settings.EditorStyle;
if (cellStyle != null)
{
var cSetter = cellStyle.Setters.FirstOrDefault(s => s is Setter && (s as Setter).Property.Name.Equals(TextEditorBase.ValueToDisplayTextConverterProperty.Name)) as Setter;
if (cSetter != null)
{
var c = cSetter.Value as IValueConverter;
if (c != null)
{
cell.Value = c.Convert(value, null, null, null);
return;
}
//e.FormatSettings.FontColor = (fgSetter.Value as SolidColorBrush).Color;
//e.FormatSettings.FillPatternForegroundColor = (bgSetter.Value as SolidColorBrush).Color;
}
}
//var measured = e.Record.DataPresenter.FindParent<IMeasure>();
SetCellValue(value, e, cell, measured);
}
