/// <summary>
/// 通过主键值，获取用于显示的字段值
/// </summary>
/// <param name="pkid">主键值</param>
/// <returns></returns>
/// <remarks>主要用于设置SelectedValue后，自动带出SelectedText</remarks>
public string GetDisplayValueFromPKID(string pkid)
{
if (pkid == null || pkid == string.Empty)
{
pkid = "-1";
}
BusinessFilter filter = new BusinessFilter(this.BusinessObjectName);
filter.AddFilterItem(this.PKField.FieldName, pkid, Operation.Equal, FilterType.NumberType, AndOr.AND);
this.BusinessObject.SessionInstance = new Wicresoft.Session.Session();
this.BusinessObject.ClearFilter();
this.BusinessObject.AddFilter(filter);
this.BusinessObject.Load();
if (this.BusinessObject.HaveRecord)
{
FieldInfo fldInfo = this.BusinessObject.GetType().GetField(this.DisplayField.FieldName);
Field field = fldInfo.GetValue(this.BusinessObject) as Field;
PropertyInfo proInfo = fldInfo.FieldType.GetProperty("Value");
return(proInfo.GetValue(field, null).ToString());
}
return(string.Empty);
}
public void AddFilter(BusinessFilter _filter, AndOr andor)
{
string strfilter;
if (_filter == null || _filter.Filter == null || _filter.Filter.Equals(string.Empty))
{
return;
}
strfilter = _filter.Filter.Trim();
if (strfilter.IndexOf(AndOr.AND.ToString(), 0, strfilter.Length) == 0)
{
strfilter = strfilter.Substring(4, strfilter.Length - 4);
}
else
{
strfilter = strfilter.Substring(3, strfilter.Length - 3);
}
if (this.filter == null || this.filter.Equals(string.Empty))
{
this.filter = string.Format(" {0} ( {1} ) ", andor.ToString(), strfilter);
}
else
{
this.filter = string.Format("{0} {1} {2} )", this.filter, andor.ToString(), strfilter);
}
}
public void AddFilter(BusinessFilter filter)
{
if (!filter.Filter.Equals(string.Empty))
{
this.Where = this.Where + filter.Filter + " )";
}
}
public void AddFilter(BusinessFilter filter)
{
if (filter == null || filter.Filter == null || filter.Filter.Equals(string.Empty))
{
return;
}
if (filter != null)
{
businessfilter = filter;
this.businessobject.AddFilter(filter);
}
}
/// <summary>
/// Test Version 2006-5-17 Tony Zhang
/// </summary>
/// <param name="key"></param>
/// <param name="value"></param>
/// <returns></returns>
public BusinessObject GetBindingObject(string key, string value)
{
BusinessFilter filter = new BusinessFilter(this.BusinessObjectName);
filter.AddFilterItem(key, value, Operation.Equal, FilterType.StringType, AndOr.AND);
this.BusinessObject.SessionInstance = new Wicresoft.Session.Session();
this.BusinessObject.ClearFilter();
this.BusinessObject.AddFilter(filter);
this.BusinessObject.Load();
return((this.BusinessObject.HaveRecord)?this.BusinessObject:null);
}
/// <summary>
/// 根据PKID获取对象，用于获取外键对象
/// </summary>
/// <param name="objectName">外键对象名</param>
/// <returns></returns>
public BusinessObject GetBusinessObject(string objectName)
{
BusinessFilter filter = new BusinessFilter(objectName);
filter.AddFilterItem("PKID", this.Value.ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND);
BusinessObjectCollection boc = new BusinessObjectCollection(objectName);
boc.AddFilter(filter);
boc.SessionInstance = new Wicresoft.Session.Session();
boc.Query();
if (boc.Count > 0)
{
boc[0].HaveRecord = true;
return(boc[0]);
}
return(null);
}
