/// <summary>
/// 导入数据
/// </summary>
/// <returns></returns>
public ActionResult DataImport()
{
string[] tablesNameArray = new string[6]; //表名数组
tablesNameArray[0] = "商品分类";
//tablesNameArray[1] = "学院课程信息表";
List<object> TableNameList = new List<object>();
//(1)读取所有当前数据库中的表名
try
{
Database db = DBHelper.CreateDataBase("PlatformData");
DbCommand cmd = db.GetSqlStringCommand("select name from dbo.sysobjects Where XType='U' ORDER BY Name");
using (DataSet myDs = db.ExecuteDataSet(cmd))
{
DataTable tmpDT = myDs.Tables[0];
for (int i = 0; i < tmpDT.Rows.Count; i++)
{
tableName temptableName = new tableName();
string temp = ((DataRow)tmpDT.Rows[i])[0].ToString();
temptableName.tableTrueName = temp;
temptableName.tableChineseName = temp;// tablesNameArray[i];
TableNameList.Add(temptableName);
}
}
}
catch (Exception e2)
{
return null;
}
ViewBag.tableList = TableNameList;
return View();
}
//
// GET: /ImportData/
public ActionResult Index()
{
List<object> TableNameList = new List<object>();
//(1)读取所有当前数据库中的表名
try
{
Database db = DBHelper.CreateDataBase("PlatformData");
DbCommand cmd = db.GetSqlStringCommand("select * from dbo.tb_DimLib");
using (DataSet myDs = db.ExecuteDataSet(cmd))
{
DataTable tmpDT = myDs.Tables[0];
for (int i = 0; i < tmpDT.Rows.Count; i++)
{
tableName temptableName = new tableName();
string tableChineseName = ((DataRow)tmpDT.Rows[i])[1].ToString();
string tableTrueName = ((DataRow)tmpDT.Rows[i])[2].ToString();
temptableName.tableTrueName = tableTrueName;
temptableName.tableChineseName = tableChineseName;
TableNameList.Add(temptableName);
}
}
}
catch (Exception e2)
{
return null;
}
ViewBag.city = new DimAreaDAO().GetAll();
ViewBag.tableList = TableNameList;
return View();
}