public void TestQuery()
{
using (var mDBManager = new Enterprise.Component.AdoNet.DBManager())
{
var tab = mDBManager.GetDataTable("Select * From SYS_DEPT Where SD_ORDER=21");
mCurrentController.ViewBag.Name = tab.Rows[0]["SD_NAME"].ToString();
}
}
public void TestProcedure()
{
var mDBManager = new Enterprise.Component.AdoNet.DBManager();
var name = "SP_GETDEPTLIST";
var parms = new SqlParameter[]
{
new SqlParameter("@strName", "TEST1")
};
mCurrentController.ViewBag.QueryTable = mDBManager.GetDataTable(name, parms).Rows;
}
