protected virtual string GetQuerySelectClause(Type modelType)
{
IEntityProxy entityProxy = EntityProxyManager.Instance.GetEntityProxyFromType(modelType);
string tableName = OrmUtil.GetTableName(modelType);
TableSchema tableSchema = DbSession.Current.GetTableSchema(tableName);
StringBuilder selectClause = new StringBuilder();
foreach (PropertySchema propertySchema in entityProxy.GetPropertyList())
{
string columnName = propertySchema.Name;
ModelPropertyAttribute modelPropertyAttribute
= propertySchema.GetCustomerAttribute <ModelPropertyAttribute>();
if (modelPropertyAttribute != null)
{
if (!modelPropertyAttribute.Visible)
{
continue;
}
}
OrmColumnAttribute ormColumnAttribute = propertySchema.GetCustomerAttribute <OrmColumnAttribute>();
if (ormColumnAttribute != null && !string.IsNullOrEmpty(ormColumnAttribute.DbColumnName))
{
columnName = ormColumnAttribute.DbColumnName;
}
if (tableSchema != null && !tableSchema.ContainsColumn(columnName))
{
continue;
}
selectClause.AppendFormat("{0},", columnName);
}
selectClause.Remove(selectClause.Length - 1, 1);
return(selectClause.ToString());
}
/*
*
* private List<BeeDataAdapter> GetSearchInfo(BeeDataAdapter dataAdapter)
* {
* List<BeeDataAdapter> result = new List<BeeDataAdapter>();
*
* EntityProxy<T> entityProxy = EntityProxyManager.Instance.GetEntityProxy<T>();
* foreach (PropertySchema propertySchema in entityProxy.GetPropertyList())
* {
* ModelPropertyAttribute modelPropertyAttribute
* = propertySchema.GetCustomerAttribute<ModelPropertyAttribute>();
* if (modelPropertyAttribute != null)
* {
* if (!modelPropertyAttribute.Visible)
* {
* continue;
* }
*
* if (!modelPropertyAttribute.Queryable)
* {
* continue;
* }
*
* BeeDataAdapter dataItem = new BeeDataAdapter();
*
* string descriptionInfo = modelPropertyAttribute.Description;
* if (string.IsNullOrEmpty(descriptionInfo))
* {
* descriptionInfo = propertySchema.Name;
* }
*
* dataItem.Add("name", propertySchema.Name);
* dataItem.Add("Type", propertySchema.PropertyType);
* dataItem.Add("QueryType", modelPropertyAttribute.QueryType);
* dataItem.Add("Description", descriptionInfo);
* dataItem.Add("MappingName", modelPropertyAttribute.MappingName);
*
* result.Add(dataItem);
* }
* }
*
* return result;
* }
*
* private List<BeeDataAdapter> GetHeaderInfo()
* {
* List<BeeDataAdapter> result = new List<BeeDataAdapter>();
* EntityProxy<T> entityProxy = EntityProxyManager.Instance.GetEntityProxy<T>();
*
* ModelAttribute modelAttribute = entityProxy.GetCustomerAttribute<ModelAttribute>();
*
* foreach (PropertySchema propertySchema in entityProxy.GetPropertyList())
* {
* ModelPropertyAttribute modelPropertyAttribute
* = propertySchema.GetCustomerAttribute<ModelPropertyAttribute>();
*
* BeeDataAdapter dataAdapter = new BeeDataAdapter();
* string descriptionInfo;
* if (modelPropertyAttribute != null)
* {
* if (!modelPropertyAttribute.Visible)
* {
* continue;
* }
*
* descriptionInfo = modelPropertyAttribute.Description;
* if (string.IsNullOrEmpty(descriptionInfo))
* {
* descriptionInfo = propertySchema.Name;
* }
*
* dataAdapter.Add("description", descriptionInfo);
* dataAdapter.Add("name", propertySchema.Name);
*
* if (modelPropertyAttribute.ColumnWidth != 0)
* {
* dataAdapter.Add("width", modelPropertyAttribute.ColumnWidth.ToString());
* }
*
* if (!string.IsNullOrEmpty(modelPropertyAttribute.Align))
* {
* dataAdapter.Add("align", modelPropertyAttribute.Align);
* }
*
* if (modelPropertyAttribute.OrderableFlag)
* {
* dataAdapter.Add("orderField", propertySchema.Name);
* }
*
* }
* else
* {
* dataAdapter.Add("description", propertySchema.Name);
* dataAdapter.Add("Name", propertySchema.Name);
* }
*
* result.Add(dataAdapter);
* }
*
*
* return result;
* }
*
* private List<BeeDataAdapter> GetDetailInfo()
* {
* List<BeeDataAdapter> result = new List<BeeDataAdapter>();
*
* EntityProxy<T> entityProxy = EntityProxyManager.Instance.GetEntityProxy<T>();
*
* ModelAttribute modelAttribute = entityProxy.GetCustomerAttribute<ModelAttribute>();
* string identityColumn = OrmUtil.GetIdentityColumnName<T>();
*
* foreach (PropertySchema propertySchema in entityProxy.GetPropertyList())
* {
* ModelPropertyAttribute modelPropertyAttribute
* = propertySchema.GetCustomerAttribute<ModelPropertyAttribute>();
* BeeDataAdapter dataAdapter = new BeeDataAdapter();
* string descriptionInfo;
* if (modelPropertyAttribute != null)
* {
* descriptionInfo = modelPropertyAttribute.Description;
* if (string.IsNullOrEmpty(descriptionInfo))
* {
* descriptionInfo = propertySchema.Name;
* }
* }
* else
* {
* descriptionInfo = propertySchema.Name;
* }
*
* dataAdapter.Add("description", descriptionInfo);
* dataAdapter.Add("name", propertySchema.Name);
* bool readOnly = false;
*
* if (string.Compare(identityColumn, propertySchema.Name, true) == 0)
* {
* readOnly = true;
* }
*
* dataAdapter.Add("readonly", readOnly);
* dataAdapter.Add("mappingname", modelPropertyAttribute.MappingName);
*
* result.Add(dataAdapter);
* }
*
* return result;
* }
*
*/
private BeeAutoModelInfo InitBeeAutoModelInfo()
{
BeeAutoModelInfo result = new BeeAutoModelInfo();
List <BeeDataAdapter> headerInfo = new List <BeeDataAdapter>();
List <BeeDataAdapter> searchInfo = new List <BeeDataAdapter>();
List <BeeDataAdapter> detailInfo = new List <BeeDataAdapter>();
Dictionary <string, string> dataMappingInfo = new Dictionary <string, string>(StringComparer.InvariantCultureIgnoreCase);
EntityProxy <T> entityProxy = EntityProxyManager.Instance.GetEntityProxy <T>();
ModelAttribute modelAttribute = entityProxy.GetCustomerAttribute <ModelAttribute>();
string identityColumn = OrmUtil.GetIdentityColumnName <T>();
TableSchema tableSchema = null;
using (DbSession dbSession = GetDbSession())
{
tableSchema = dbSession.GetTableSchema(OrmUtil.GetTableName <T>());
}
foreach (PropertySchema propertySchema in entityProxy.GetPropertyList())
{
string columnName = propertySchema.Name;
OrmColumnAttribute ormColumnAttribute = propertySchema.GetCustomerAttribute <OrmColumnAttribute>();
if (ormColumnAttribute != null && !string.IsNullOrEmpty(ormColumnAttribute.DbColumnName))
{
columnName = ormColumnAttribute.DbColumnName;
}
if (tableSchema != null && !tableSchema.ContainsColumn(columnName))
{
continue;
}
BeeDataAdapter headerItem = GetHeaderItem(propertySchema);
if (headerItem != null)
{
headerInfo.Add(headerItem);
}
BeeDataAdapter searchItem = GetSearchItem(propertySchema);
if (searchItem != null)
{
searchInfo.Add(searchItem);
}
BeeDataAdapter detailItem = GetDetailItem(propertySchema, identityColumn);
if (detailItem != null)
{
detailInfo.Add(detailItem);
}
ModelPropertyAttribute modelPropertyAttribute
= propertySchema.GetCustomerAttribute <ModelPropertyAttribute>();
if (modelPropertyAttribute != null && !string.IsNullOrEmpty(modelPropertyAttribute.MappingName))
{
dataMappingInfo.Add(propertySchema.Name, modelPropertyAttribute.MappingName);
}
if (propertySchema.PropertyType.IsEnum && !dataMappingInfo.ContainsKey("mappingname"))
{
dataMappingInfo.Add(propertySchema.Name, propertySchema.PropertyType.ToString());
}
}
result.DetailInfo = detailInfo;
result.HeaderInfo = headerInfo;
result.SearchInfo = searchInfo;
result.DataMappingInfo = dataMappingInfo;
return(result);
}
public virtual PageResult List(BeeDataAdapter dataAdapter)
{
DbSession dbSession = GetDbSession();
DataTable dataTable = null;
try
{
InitPagePara(dataAdapter);
#region datetime 处理
EntityProxy <T> entityProxy = EntityProxyManager.Instance.GetEntityProxy <T>();
//List<PropertySchema> propertyList = entityProxy.GetPropertyList();
//propertyList = (from item in propertyList
// where item.PropertyType == typeof(DateTime)
// select item).ToList();
BeeDataAdapter realDataAdapter = new BeeDataAdapter(dataAdapter);
//foreach (PropertySchema item in propertyList)
//{
// string beginkey = "{0}begin".FormatWith(item.Name);
// string endkey = "{0}end".FormatWith(item.Name);
// if (realDataAdapter.ContainsKey(item.Name))
// {
// realDataAdapter[item.Name] = ConvertUtil.CommonConvert<DateTime>(realDataAdapter[item.Name]);
// }
// if (realDataAdapter.ContainsKey(beginkey))
// {
// realDataAdapter[beginkey] = ConvertUtil.CommonConvert<DateTime>(realDataAdapter[beginkey]);
// }
// if (realDataAdapter.ContainsKey(endkey))
// {
// realDataAdapter[endkey] = ConvertUtil.CommonConvert<DateTime>(realDataAdapter[endkey]);
// }
//}
#endregion
string tableName = OrmUtil.GetTableName <T>();
SqlCriteria sqlCriteria = GetQueryCondition(realDataAdapter);
int recordCount = dataAdapter.TryGetValue <int>("recordcount", 0);
string selectClause = GetQuerySelectClause(typeof(T));
dataTable = InnerQuery(tableName, selectClause, dataAdapter, sqlCriteria);
}
catch (Exception e)
{
Logger.Error("List object({0}) Error".FormatWith(typeof(T)), e);
}
finally
{
dbSession.Dispose();
}
return(View(null, "BeeAutoList", dataTable));
}