/// <summary>
/// Gets the field special values.
/// </summary>
/// <param name="spField">The sp field.</param>
/// <param name="stringValue">The string value.</param>
/// <param name="value">The value.</param>
/// <param name="fieldEditValue">The field edit value.</param>
/// <param name="fieldTextValue">The field text value.</param>
/// <param name="fieldHtmlValue">The field HTML value.</param>
private static void GetFieldSpecialValues(SPField spField, string stringValue, object value,
out string fieldEditValue,
out string fieldTextValue, out string fieldHtmlValue)
{
fieldTextValue = string.IsNullOrEmpty(stringValue)
? string.Empty
: spField.GetFieldValueAsText(value) ?? string.Empty;
fieldHtmlValue = string.IsNullOrEmpty(stringValue)
? string.Empty
: spField.GetFieldValueAsHtml(value) ?? string.Empty;
fieldEditValue = string.IsNullOrEmpty(stringValue)
? string.Empty
: spField.GetFieldValueForEdit(value) ?? string.Empty;
}
private string GetXaxisFieldValue(string sListName, SPField xAxisField, int xAxisColumnIndex, DataRow dr)
{
var xAxisFieldValue = dr.ItemArray[xAxisColumnIndex].ToString();
if (xAxisField.InternalName.ToUpper() == "LIST")
{
xAxisFieldValue = sListName;
}
else if (xAxisFieldValue.Length > 0 && xAxisFieldValue != "No Value")
{
xAxisFieldValue = xAxisField.GetFieldValueForEdit(xAxisFieldValue);
}
if (xAxisFieldValue.Contains(";#"))
{
xAxisFieldValue = GetCleanNumberValue(xAxisFieldValue.Substring(xAxisFieldValue.IndexOf(";#") + 2)).ToString();
}
return(xAxisFieldValue);
}
/// <summary>
/// Gets the field special values.
/// </summary>
/// <param name="spField">The sp field.</param>
/// <param name="stringValue">The string value.</param>
/// <param name="value">The value.</param>
/// <param name="fieldEditValue">The field edit value.</param>
/// <param name="fieldTextValue">The field text value.</param>
/// <param name="fieldHtmlValue">The field HTML value.</param>
protected void GetFieldSpecialValues(SPField spField, string stringValue, object value,
out string fieldEditValue,
out string fieldTextValue, out string fieldHtmlValue)
{
if (spField.Type != SPFieldType.DateTime)
{
fieldTextValue = stringValue;
fieldEditValue = stringValue;
fieldHtmlValue = stringValue;
try
{
fieldTextValue = string.IsNullOrEmpty(stringValue)
? string.Empty
: spField.GetFieldValueAsText(value) ?? string.Empty;
fieldEditValue = string.IsNullOrEmpty(stringValue)
? string.Empty
: spField.GetFieldValueForEdit(value) ?? string.Empty;
fieldHtmlValue = string.IsNullOrEmpty(stringValue)
? string.Empty
: spField.GetFieldValueAsHtml(value) ?? string.Empty;
}
catch
{
}
}
else
{
string specialValue = string.IsNullOrEmpty(stringValue)
? string.Empty
: ((DateTime)value).ToShortDateString();
fieldTextValue = specialValue;
fieldHtmlValue = specialValue;
fieldEditValue = specialValue;
}
}
private static string GetCellValue(SPListItem li, SPField oField, bool bEditMode, SPWeb oWeb)
{
var currenvyCultureInfo = new CultureInfo(1033);
string val = "";
NumberFormatInfo providerEn = new System.Globalization.NumberFormatInfo();
providerEn.NumberDecimalSeparator = ".";
providerEn.NumberGroupSeparator = ",";
providerEn.NumberGroupSizes = new int[] { 3 };
if (li[oField.Id] != null)
{
val = li[oField.Id].ToString();
switch (oField.Type)
{
case SPFieldType.User:
if (bEditMode)
{
SPFieldUserValueCollection lvc = new SPFieldUserValueCollection(oWeb, val);
val = "";
foreach (SPFieldUserValue lv in lvc)
{
val += ";" + lv.LookupId;
}
val = val.Trim(';');
}
else
{
val = oField.GetFieldValueForEdit(li[oField.Id].ToString());
}
break;
case SPFieldType.Lookup:
if (bEditMode)
{
SPFieldLookupValueCollection lvc = new SPFieldLookupValueCollection(val);
val = "";
foreach (SPFieldLookupValue lv in lvc)
{
val += ";" + lv.LookupId;
}
val = val.Trim(';');
}
else
{
val = oField.GetFieldValueForEdit(li[oField.Id].ToString());
}
break;
case SPFieldType.MultiChoice:
if (bEditMode)
{
SPFieldMultiChoiceValue v = (SPFieldMultiChoiceValue)oField.GetFieldValue(li[oField.Id].ToString());
val = "";
for (int i = 0; i < v.Count; i++)
{
val += ";" + v[i];
}
val = val.Trim(';');
}
else
{
oField.GetFieldValueForEdit(val);
}
break;
case SPFieldType.Calculated:
val = li[oField.Id].ToString();
if (oField.Description == "Indicator" || val.ToLower().EndsWith(".gif") || val.ToLower().EndsWith(".png") || val.ToLower().EndsWith(".jpg"))
{
val = "<img src=\"/_layouts/15/images/" + oField.GetFieldValueAsText(val) + "\">";
}
else
{
val = val.Substring(val.IndexOf(";#") + 2);
}
break;
case SPFieldType.Currency:
try
{
val = ((double)li[oField.Id]).ToString(currenvyCultureInfo.NumberFormat);
}
catch { val = "0"; }
break;
case SPFieldType.Number:
SPFieldNumber fNum = (SPFieldNumber)oField;
if (fNum.ShowAsPercentage)
{
try
{
val = (float.Parse(val) * 100).ToString(providerEn);
}
catch { }
}
else
{
//if (bEditMode)
//{
// val = li[oField.Id].ToString();
//}
//else
// val = oField.GetFieldValueAsText(li[oField.Id].ToString());
try
{
val = ((double)li[oField.Id]).ToString(currenvyCultureInfo.NumberFormat);
}
catch { val = "0"; }
}
break;
case SPFieldType.Boolean:
val = "0";
try
{
if (li[oField.Id].ToString().ToLower() == "yes" || li[oField.Id].ToString().ToLower() == "true")
{
val = "1";
}
}
catch { }
break;
case SPFieldType.DateTime:
try
{
val = ((DateTime)li[oField.Id]).ToString("u");
}
catch { }
break;
default:
if (bEditMode)
{
val = li[oField.Id].ToString();
}
else
{
val = oField.GetFieldValueAsText(li[oField.Id]);
}
break;
}
}
return(val);
}
public string GetFieldValueForEdit(object value)
{
return(m_field.GetFieldValueForEdit(value));
}