/// <summary>
/// Show formatting dialog appropriate for data type
/// </summary>
/// <param name="qc"></param>
/// <returns></returns>
public static DialogResult Show(
QueryColumn qc)
{
ColumnFormatEnum displayFormat;
int decimals;
MetaColumn mc = qc.MetaColumn;
if (mc.IsNumeric && !mc.IsKey)
{
return(NumberFormatDialog.Show(qc));
}
else if (mc.DataType == MetaColumnType.Date)
{
return(DateFormatDialog.Show(qc));
}
else if (mc.DataType == MetaColumnType.Structure)
{
return(CriteriaStructureFormatDialog.Show(qc));
}
else if (mc.DataType == MetaColumnType.String)
{
return(TextFormatDialog.Show(qc));
}
else
{
XtraMessageBox.Show("Only numeric, date/time and chemical structure fields can be formatted");
return(DialogResult.Cancel);
}
}
public static DialogResult Show(
QueryColumn qc)
{
string tok;
if (Instance == null)
{
Instance = new DateFormatDialog();
}
DateFormatDialog dfd = Instance;
MetaColumn mc = qc.MetaColumn;
if (mc.DataType != MetaColumnType.Date)
{
XtraMessageBox.Show(mc.Label + " is not a date field");
return(DialogResult.Cancel);
}
// Setup
new JupyterGuiConverter().ConvertFormOrUserControl(Instance);
string fmt = qc.DisplayFormatString;
if (Lex.IsNullOrEmpty(fmt))
{
fmt = "d-MMM-yyyy"; // default format
}
if (Lex.Contains(fmt, "d-MMM-yyyy"))
{
dfd.d_MMM_yyyy.Checked = true;
}
else if (Lex.Contains(fmt, "d-MMM-yy"))
{
dfd.d_MMM_yy.Checked = true;
}
else if (Lex.Contains(fmt, "M/d/yyyy"))
{
dfd.M_d_yyyy.Checked = true;
}
else if (Lex.Contains(fmt, "M/d/yy"))
{
dfd.M_d_yy.Checked = true;
}
else if (Lex.Contains(fmt, "none"))
{
dfd.DateNone.Checked = true;
}
else
{
dfd.d_MMM_yyyy.Checked = true; // in case of no match
}
if (Lex.Contains(fmt, "h:mm:ss tt"))
{
dfd.h_mm_ss_tt.Checked = true; // check in reverse order to get correct hit
}
else if (Lex.Contains(fmt, "h:mm tt"))
{
dfd.h_mm_tt.Checked = true;
}
else if (Lex.Contains(fmt, "H:mm:ss"))
{
dfd.H_mm_ss.Checked = true;
}
else if (Lex.Contains(fmt, "H:mm"))
{
dfd.H_mm.Checked = true;
}
else
{
dfd.TimeNone.Checked = true;
}
// Show form & get new values
DialogResult dr = dfd.ShowDialog(SessionManager.ActiveForm);
if (dr == DialogResult.OK)
{
if (dfd.d_MMM_yyyy.Checked)
{
fmt = "d-MMM-yyyy";
}
else if (dfd.d_MMM_yy.Checked)
{
fmt = "d-MMM-yy";
}
else if (dfd.M_d_yyyy.Checked)
{
fmt = "M/d/yyyy";
}
else if (dfd.M_d_yy.Checked)
{
fmt = "M/d/yy";
}
else if (dfd.DateNone.Checked)
{
fmt = "none";
}
if (dfd.H_mm.Checked)
{
fmt += " H:mm";
}
else if (dfd.H_mm_ss.Checked)
{
fmt += " H:mm:ss";
}
else if (dfd.h_mm_tt.Checked)
{
fmt += " h:mm tt";
}
else if (dfd.h_mm_ss_tt.Checked)
{
fmt += " h:mm:ss tt";
}
else if (dfd.TimeNone.Checked)
{
}
; // nothing if no time
qc.DisplayFormatString = fmt;
}
return(dr);
}