public MDataTable GetUserList(GridConfig.SelectType st)
{
MDataTable dt = null;
using (MAction action = new MAction(TableNames.Sys_User))
{
dt = action.Select();
}
dt.JoinOnName = Sys_User.UserID.ToString();
MDataTable joinDt = dt.Join(TableNames.Sys_UserInfo, Sys_UserInfo.UserInfoID.ToString());
return(joinDt.Select(PageIndex, PageSize, GetWhere() + GetOrderBy(Sys_User.UserID.ToString()), GridConfig.GetSelectColumns(ObjName, st)));
}
protected override MDataTable Select(GridConfig.SelectType st)
{
switch (ObjName)
{
case "V_Test": //处理Demo中文本数据库
MDataTable dt = null;
using (MAction action = new MAction("Demo_TestA"))
{
dt = action.Select();
}
dt.JoinOnName = "id";
MDataTable joinDt = dt.Join("Demo_TestB", "id");
return(joinDt.Select(PageIndex, PageSize, GetWhere() + GetOrderBy("id"), GridConfig.GetSelectColumns(ObjName, st)));
}
return(base.Select(st));
}
protected override MDataTable Select(GridConfig.SelectType st)
{
switch (ObjName)
{
case "V_Test": //处理Demo中文本数据库
if (AppConfig.DB.DefaultDalType == DalType.Txt)
{
MDataTable dt = null;
using (MAction action = new MAction(CrossDb.GetEnum("Demo_TestA")))
{
dt = action.Select();
}
dt.JoinOnName = "ID";
MDataTable joinDt = dt.Join("Demo_TestB", "ID");
return(joinDt.Select(PageIndex, PageSize, GetWhere() + GetOrderBy("ID"), GridConfig.GetSelectColumns(ObjName, st)));
}
break;
}
return(base.Select(st));
}