public List<TyFieldsSelect> CreateFieldsFromSchemaTable(DataTable schemaTable, TySearchx sx, string tableName)
{
List<TyFieldsSelect> list = new List<TyFieldsSelect>();
UnitOfWork currentUnitOfWork = this.CurrentUnitOfWork;
foreach (DataRow row in schemaTable.Rows)
{
TyFieldsSelect select = new TyFieldsSelect();
select.Id = StringHelper.GetNewGuid();
select.TableName = tableName;
select.TySearchx = sx;
select.Name = row["ColumnName"].ToString();
select.Type = row["DataType"].ToString();
select.DisplayIndex = list.Count * 10;
select.DisplayName = select.Name;
select.ConditionName = select.Name;
currentUnitOfWork.RegisterNew(select);
list.Add(select);
}
currentUnitOfWork.Commit();
return list;
}
public TySearchx CreateSearchX()
{
TySearchx searchx = new TySearchx();
searchx.Id = StringHelper.GetNewGuid();
searchx.Name = "新查询X";
UnitOfWork currentUnitOfWork = this.CurrentUnitOfWork;
currentUnitOfWork.RegisterNew(searchx);
currentUnitOfWork.Commit();
return searchx;
}
public TySearchtable CreateSearchtable(TySearchx sx)
{
TySearchtable searchtable = new TySearchtable();
searchtable.Id = StringHelper.GetNewGuid();
searchtable.TableName = "新查询表";
searchtable.TySearchx = sx;
searchtable.TableOrder = sx.TySearchtables.Count;
UnitOfWork currentUnitOfWork = this.CurrentUnitOfWork;
currentUnitOfWork.RegisterNew(searchtable);
currentUnitOfWork.Commit();
return searchtable;
}
