private void Init()
{
//_persistBroker = PersistBrokerManager.PersistBroker(@"Provider=Microsoft.Jet.OLEDB.4.0;Password=;Data Source=" + this.FullPath + ";Persist Security Info=True", null);
//add by klaus
_persistBroker = PersistBrokerManager.PersistBroker(@"Provider=Microsoft.ACE.OLEDB.12.0;Password=;Data Source=" + this.FullPath + ";Persist Security Info=False", null);
//end
_domainDataProvider = DomainDataProviderManager.DomainDataProvider(_persistBroker, null);
_languageHashtable = new System.Collections.Hashtable();
this.CacheLanguage();
}
public static IDomainDataProvider DomainDataProvider(IPersistBroker persistBroker, System.Globalization.CultureInfo cultureInfo)
{
if (cultureInfo == null)
{
cultureInfo = new System.Globalization.CultureInfo("en-US", false);
}
if (persistBroker == null)
{
return(new SQLDomainDataProvider(PersistBrokerManager.PersistBroker(cultureInfo), cultureInfo));
}
else
{
return(new SQLDomainDataProvider(persistBroker, cultureInfo));
}
}
public virtual string GetDisplayText(string fieldName)
{
string returnValue = string.Empty;
FieldInfo info = this.GetType().GetField(fieldName);
if (info != null)
{
returnValue = info.GetValue(this).ToString();
if (info.IsDefined(typeof(FieldDisplayAttribute), true))
{
object[] fieldDisplayList = info.GetCustomAttributes(typeof(FieldDisplayAttribute), true);
foreach (FieldDisplayAttribute fieldDisplay in fieldDisplayList)
{
string descString = string.Empty;
if (fieldDisplay.RemoteTable.Trim().Length <= 0 &&
fieldDisplay.RemoteField.Trim().Length > 0)
{
FieldInfo[] fieldInfoList = this.GetType().GetFields();
if (fieldInfoList != null)
{
foreach (FieldInfo fieldInfo in fieldInfoList)
{
if (fieldInfo.IsDefined(typeof(FieldMapAttribute), true))
{
FieldMapAttribute fieldMap = (FieldMapAttribute)Attribute.GetCustomAttribute(fieldInfo, typeof(FieldMapAttribute));
if (string.Compare(fieldMap.FieldName.Trim(), fieldDisplay.RemoteField.Trim(), true) == 0)
{
descString = fieldInfo.GetValue(this).ToString();
break;
}
}
}
}
}
else
{
string sql = "SELECT {0} FROM {1} WHERE {2} = '{3}' ";
sql = string.Format(sql, fieldDisplay.RemoteField, fieldDisplay.RemoteTable, fieldDisplay.RemoteKey, info.GetValue(this).ToString());
IPersistBroker persistBroker = PersistBrokerManager.PersistBroker(true);
DataSet result = persistBroker.Query(sql);
if (result != null && result.Tables.Count > 0 && result.Tables[0].Rows.Count > 0)
{
descString = result.Tables[0].Rows[0][0].ToString();
}
}
if (descString.Trim().Length > 0)
{
if (fieldDisplay.ModifyType == FieldDisplayModifyType.Append)
{
returnValue += " - " + descString;
}
else if (fieldDisplay.ModifyType == FieldDisplayModifyType.Replace)
{
returnValue = descString;
}
}
}
}
}
return(returnValue);
}
//added by carey.cheng on 2010-05-20 for muti db support
public static IDomainDataProvider DomainDataProvider(string ConnectDB)
{
return(new SQLDomainDataProvider(PersistBrokerManager.PersistBroker(ConnectDB), new System.Globalization.CultureInfo("en-US", false)));
}
private void Init()
{
_persistBroker = PersistBrokerManager.PersistBroker(@"Provider=Microsoft.Jet.OLEDB.4.0;Password=;Data Source=" + this.FullPath + ";Persist Security Info=True", null);
_domainDataProvider = DomainDataProviderManager.DomainDataProvider(_persistBroker, null);
}