public ActionResult GetTable(string tableName)
{
TableEnum tt = (TableEnum)Enum.Parse(typeof(TableEnum), tableName);
switch (tt)
{
case TableEnum.None:
return(new EmptyResult());
case TableEnum.Clients:
return(RedirectToAction("GetClients", "ClientTable"));
case TableEnum.Managers:
return(RedirectToAction("GetManagers", "ManagerTable"));
case TableEnum.Products:
return(RedirectToAction("GetProducts", "ProductTable"));
case TableEnum.FileInformations:
return(RedirectToAction("GetFileInformations", "FileInformationTable"));
case TableEnum.SaleInfos:
return(RedirectToAction("GetSaleInfos", "SaleInfoTable"));
case TableEnum.Users:
return(RedirectToAction("GetUsers", "UserTable"));
default:
return(View("Error"));
}
}
public ActionResult GetTable(string tableName)
{
TableEnum tt = (TableEnum)Enum.Parse(typeof(TableEnum), tableName);
switch (tt)
{
case TableEnum.None:
return(new EmptyResult());
case TableEnum.CustomerSet:
return(RedirectToAction("Index", "Customers"));
case TableEnum.ManagerSet:
return(RedirectToAction("Index", "Manager"));
case TableEnum.ItemSet:
return(RedirectToAction("GetProducts", "Item"));
case TableEnum.OrderSet:
return(RedirectToAction("GetFileInformations", "FileInformationTable"));
case TableEnum.Order_ItemSet:
return(RedirectToAction("GetSaleInfos", "SaleInfoTable"));
case TableEnum.Users:
return(RedirectToAction("GetUsers", "UserTable"));
default:
return(View("Error"));
}
}
public static AccessTable GetTableCreater(TableEnum tableEnum)
{
switch (tableEnum)
{
case TableEnum.InspTable:
return(new InspTable());
default:
return(new InspTable());
}
}
public static string GetTableDimPrefix(TableEnum _table)
{
var lst = typeof(DimPrefixEnum).GetProperties().Where(x => x.Name == Enum.GetName(typeof(TableEnum), _table)).FirstOrDefault();
if (lst != null)
{
var ret = lst.GetValue(null).ToString();
return(ret);
}
else
{
return(EmptyDimPrefix);
}
}
private DataTable BuildDummyDataTable <T>(TableEnum tableName, ParameterEnum columnName, T[] columnValues)
{
DataTable returnValue;
returnValue = new DataTable(tableName.ToString());
returnValue.Columns.Add(columnName.ToString());
returnValue.Columns[0].DataType = typeof(T);
if (columnValues != null)
{
foreach (object Item in columnValues)
{
returnValue.Rows.Add(Item);
}
}
return(returnValue);
}
private static TableInfo ReadClassInfo(Type _type, TableEnum le_TableName, MyEnums.TableType le_TableType)
{
TableInfo ret = new TableInfo();
//var TableNameProp = _type.GetProperty("TableName");
//var tableName = (TableEnum)TableNameProp.GetValue(null);
ret.TableId = (int)le_TableName;
ret.Name = _type.Name;
ret.DBName = GetTableAttribute(_type);
//var tableTypeProp = _type.GetProperty("TableType");
//var tableType = tableTypeProp.GetValue(null);
ret.TableType = (MyEnums.TableType)le_TableType;
ret.DimensionPrefix = DimPrefixEnum.GetTableDimPrefix(le_TableName);
ret.AssemblyName = _type.Assembly.GetName().Name;
ret.ClassName = _type.FullName;
return(ret);
}
public BaseDal(TableEnum tableName)
{
this._tableName = tableName.ToString();
}
public static TableBase GetTable(Session session, TableEnum _table)
{
return(session.GetObjectByKey <TableBase>((int)_table));
}
/// <summary>
/// 构造，注入accdb文件名
/// </summary>
/// <param name="dbPath"></param>
public AccessHelper(string dbPath, TableEnum tableEnum)
{
strCon = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + dbPath + @"'";
InitDB();
acTable = TableFactory.GetTableCreater(tableEnum);
}
