protected override MDataTable Select(GridConfig.SelectType st) { if (ObjName == "V_WF_Task") { TaskInstance task = WF.Table.TaskInstance; if (task.BaseInfo.DataBaseType == DataBaseType.Txt || task.BaseInfo.DataBaseType == DataBaseType.Xml) { MDataTable dt; string where = GetWhere(); string orderBy = GetOrderBy(task.BaseInfo.MDataColumn.FirstPrimary.ColumnName); dt = task.Select <MDataRow>(); dt.JoinOnName = "InstanceID"; dt = dt.Join("WF_Instance", "InstanceID", "SheetID,InstanceTitle,InstanceState,StartTime,CreatorID,CreatorFullName"); dt.JoinOnName = "AppID"; dt = dt.Join("WF_App", "AppID", "AppName"); return(dt.Select(PageIndex, PageSize, GetWhere() + orderBy, 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("Demo_TestA")) { dt = action.Select(); } dt.JoinOnName = "ID"; MDataTable joinDt = dt.Join("Demo_TestA", "ID"); return(joinDt.Select(PageIndex, PageSize, GetWhere() + GetOrderBy("ID"), GridConfig.GetSelectColumns(ObjName, st))); } break; } return(base.Select(st)); }
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(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))); } return(base.Select(st)); }