public static int GetOleDbTypeIndex(OleDbType type)
{
if (type == System.Data.OleDb.OleDbType.BigInt ||
type == System.Data.OleDb.OleDbType.UnsignedBigInt
)
{
return(FLD_Long_integer);
}
else if (EPField.IsInteger(type))
{
return(FLD_Integer);
}
else if (type == System.Data.OleDb.OleDbType.Currency)
{
return(FLD_Currency);
}
else if (EPField.IsNumber(type))
{
return(FLD_Decimal);
}
else if (EPField.IsDatetime(type))
{
if (type == System.Data.OleDb.OleDbType.DBTimeStamp)
{
return(FLD_Date_time);
}
else if (type == OleDbType.DBTime)
{
return(FLD_Time);
}
else
{
return(FLD_Date);
}
}
else if (type == System.Data.OleDb.OleDbType.Boolean)
{
return(FLD_Bool);
}
else if (type == System.Data.OleDb.OleDbType.LongVarChar ||
type == System.Data.OleDb.OleDbType.LongVarWChar)
{
return(FLD_Text);
}
else if (type == System.Data.OleDb.OleDbType.Binary ||
type == System.Data.OleDb.OleDbType.LongVarBinary ||
type == System.Data.OleDb.OleDbType.VarBinary
)
{
return(FLD_Binary);
}
else if (EPField.IsString(type))
{
return(FLD_String);
}
else
{
return(FLD_Unknown);
}
}
public override object GetValue(object component)
{
if (EPField.IsString(_field.OleDbType))
{
return(string.Format(CultureInfo.InvariantCulture, "{0}({1})", EPField.ToSystemType(_field.OleDbType).Name, _field.DataSize));
}
return(EPField.ToSystemType(_field.OleDbType).Name);
}
private void cbxField_SelectedIndexChanged(object sender, System.EventArgs e)
{
lstOP.Items.Clear();
int n = cbxField.SelectedIndex;
if (n >= 0)
{
int i;
EPField fld = cbxField.Items[n] as EPField;
if (EPField.IsString(fld.OleDbType) || EPField.IsBinary(fld.OleDbType))
{
for (i = 0; i < opList.Count; i++)
{
lstOP.Items.Add(opList[i]);
}
}
else if (EPField.IsBoolean(fld.OleDbType))
{
lstOP.Items.Add(opList[0]);
}
else
{
for (i = 0; i < opList.Count; i++)
{
if (!opList[i].bStringOnly)
{
lstOP.Items.Add(opList[i]);
}
}
}
if (lstOP.Items.Count > 0)
{
lstOP.SelectedIndex = 0;
}
}
}
private void listView1_SelectedIndexChanged(object sender, System.EventArgs e)
{
txtLookup.Enabled = false;
if (listView1.SelectedItems.Count > 0)
{
item = listView1.SelectedItems[0];
if (item != null)
{
if (fields[item.Index].OleDbType == System.Data.OleDb.OleDbType.Date)
{
cbDataType.SelectedIndex = 0;
lblDataType.Visible = true;
cbDataType.Visible = true;
}
else if (fields[item.Index].OleDbType == System.Data.OleDb.OleDbType.DBDate)
{
cbDataType.SelectedIndex = 1;
lblDataType.Visible = true;
cbDataType.Visible = true;
}
else if (fields[item.Index].OleDbType == System.Data.OleDb.OleDbType.DBTimeStamp)
{
cbDataType.SelectedIndex = 2;
lblDataType.Visible = true;
cbDataType.Visible = true;
}
else if (fields[item.Index].OleDbType == System.Data.OleDb.OleDbType.DBTime)
{
cbDataType.SelectedIndex = 3;
lblDataType.Visible = true;
cbDataType.Visible = true;
}
else
{
lblDataType.Visible = false;
cbDataType.Visible = false;
if (fields[item.Index].OleDbType != System.Data.OleDb.OleDbType.Boolean &&
!fields[item.Index].IsFile &&
!fields[item.Index].IsIdentity &&
!fields[item.Index].ReadOnly)
{
btLookup.Enabled = true;
if (fields[item.Index].editor != null)
{
txtLookup.Text = fields[item.Index].editor.ToString();
}
else
{
txtLookup.Text = "";
}
txtLookup.Enabled = true;
}
}
cbFile.SelectedIndex = (fields[item.Index].IsFile ? 0 : 1);
cbVisible.SelectedIndex = (fields[item.Index].Visible ? 0 : 1);
cbxReadOnly.SelectedIndex = (fields[item.Index].ReadOnly ? 0 : 1);
txtWidth.Text = fields[item.Index].ColumnWidth.ToString();
txtFormat.Text = fields[item.Index].Format;
chkIndexed.Checked = fields[item.Index].Indexed;
btML.Enabled = (EPField.IsBinary(fields[item.Index].OleDbType) || EPField.IsString(fields[item.Index].OleDbType));
for (int i = 0; i < cbxAlignment.Items.Count; i++)
{
if ((System.Windows.Forms.HorizontalAlignment)cbxAlignment.Items[i] == fields[item.Index].TxtAlignment)
{
cbxAlignment.SelectedIndex = i;
break;
}
}
for (int i = 0; i < cbxHdrAlign.Items.Count; i++)
{
if ((System.Windows.Forms.HorizontalAlignment)cbxHdrAlign.Items[i] == fields[item.Index].HeaderAlignment)
{
cbxHdrAlign.SelectedIndex = i;
break;
}
}
}
}
}
