protected override MDataTable Select(GridConfig.SelectType st)
{
MDataTable dt = null;
switch (ObjName)
{
case "Config_ExcelInfo":
dt = base.Select(st);
if (dt == null || dt.Rows.Count == 0)
{
sysLogic.InitExcelColumn();
//从Excel读取列写入
dt = base.Select(st);
}
break;
case "V_SYS_UserList": //重写是为了支持文本数据库
if (AppConfig.DB.DefaultDalType == DalType.Txt)
{
dt = sysLogic.GetUserList(st);
}
else
{
dt = base.Select(st);
}
break;
default:
dt = base.Select(st);
break;
}
return(dt);
}
/// <summary>
/// 针对导出重写查询
/// </summary>
/// <param name="st"></param>
/// <returns></returns>
protected override MDataTable Select(GridConfig.SelectType st)
{
MDataTable dt;
if (st.ToString() == "Export")
{
if (ObjName.Substring(0, 3).ToLower() == "vs_")
{
string spName = ObjName.Substring(3);
string conn = CrossDb.GetConn(ObjName);
dt = Select_SP(spName, conn);
}
else if (Query <string>("isCompany") == "1")
{
string spName = "sp_SelectCompany";
string conn = CrossDb.GetConn(ObjName);
dt = SelectList_SP(spName, conn);
}
else
{
dt = base.Select(st);
}
}
else
{
dt = base.Select(st);
}
return(dt);
}
/// <summary>
/// 允许重写导出的数据源（适用于存储过程的自定义数据源）
/// </summary>
protected virtual MDataTable Select(GridConfig.SelectType st)
{
MDataTable dt;
using (MAction action = new MAction(CrossObjName))
{
action.SetSelectColumns(GridConfig.GetSelectColumns(ObjName, st));//只查询要显示的列数据。
dt = action.Select(PageIndex, PageSize, GetWhere() + GetOrderBy(action.Data.PrimaryCell.ColumnName));
}
return(dt);
}
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)
{
MDataTable dt = base.Select(st);
if (ObjName == "Config_ExcelInfo")
{
if (dt == null || dt.Rows.Count == 0)
{
sysLogic.InitExcelColumn();
//从Excel读取列写入
dt = base.Select(st);
}
}
return(dt);
}
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)
{
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(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));
}
protected override MDataTable Select(GridConfig.SelectType st)
{
MDataTable dt = null;
switch (ObjName)
{
case "Config_ExcelInfo":
dt = base.Select(st);
if (dt == null || dt.Rows.Count == 0)
{
string where = GetWhere();
if (!where.Contains(" and ")) //包含其它查询条件时
{
sysLogic.InitExcelColumn();
//从Excel读取列写入
dt = base.Select(st);
}
}
break;
case "V_SYS_UserList": //重写是为了支持文本数据库
dt = sysLogic.GetUserList(st);
//if (AppConfig.DB.DefaultDalType == DalType.Txt)
//{
//}
//else
//{
// dt = base.Select(st);
//}
break;
default:
dt = base.Select(st);
break;
}
return(dt);
}
