/// <summary>
/// 查询初始化
/// </summary>
/// <returns></returns>
public string SearchData_Init()
{
DataSet ds = new DataSet();
string sql = "";
string tSpan = this.GetRequestVal("TSpan");
if (tSpan == "")
{
tSpan = null;
}
#region 1、获取时间段枚举/总数.
SysEnums ses = new SysEnums("TSpan");
DataTable dtTSpan = ses.ToDataTableField();
dtTSpan.TableName = "TSpan";
ds.Tables.Add(dtTSpan);
GenerBill gb = new GenerBill();
gb.CheckPhysicsTable();
sql = "SELECT TSpan as No, COUNT(WorkID) as Num FROM Frm_GenerBill WHERE FrmID='" + this.FrmID + "' AND Starter='" + WebUser.No + "' AND BillState >= 1 GROUP BY TSpan";
DataTable dtTSpanNum = BP.DA.DBAccess.RunSQLReturnTable(sql);
foreach (DataRow drEnum in dtTSpan.Rows)
{
string no = drEnum["IntKey"].ToString();
foreach (DataRow dr in dtTSpanNum.Rows)
{
if (dr["No"].ToString() == no)
{
drEnum["Lab"] = drEnum["Lab"].ToString() + "(" + dr["Num"] + ")";
break;
}
}
}
#endregion
#region 2、处理流程类别列表.
sql = " SELECT A.BillState as No, B.Lab as Name, COUNT(WorkID) as Num FROM Frm_GenerBill A, Sys_Enum B ";
sql += " WHERE A.BillState=B.IntKey AND B.EnumKey='BillState' AND A.Starter='" + WebUser.No + "' AND BillState >=1";
if (tSpan.Equals("-1") == false)
{
sql += " AND A.TSpan=" + tSpan;
}
sql += " GROUP BY A.BillState, B.Lab ";
DataTable dtFlows = BP.DA.DBAccess.RunSQLReturnTable(sql);
if (SystemConfig.AppCenterDBType == DBType.Oracle || SystemConfig.AppCenterDBType == DBType.PostgreSQL)
{
dtFlows.Columns[0].ColumnName = "No";
dtFlows.Columns[1].ColumnName = "Name";
dtFlows.Columns[2].ColumnName = "Num";
}
dtFlows.TableName = "Flows";
ds.Tables.Add(dtFlows);
#endregion
#region 3、处理流程实例列表.
string sqlWhere = "";
sqlWhere = "(1 = 1)AND Starter = '" + WebUser.No + "' AND BillState >= 1";
if (tSpan.Equals("-1") == false)
{
sqlWhere += "AND (TSpan = '" + tSpan + "') ";
}
if (this.FK_Flow != null)
{
sqlWhere += "AND (FrmID = '" + this.FrmID + "') ";
}
else
{
// sqlWhere += ")";
}
sqlWhere += "ORDER BY RDT DESC";
string fields = " WorkID,FrmID,FrmName,Title,BillState, Starter, StarterName,Sender,RDT ";
if (SystemConfig.AppCenterDBType == DBType.Oracle)
{
sql = "SELECT " + fields + " FROM (SELECT * FROM Frm_GenerBill WHERE " + sqlWhere + ") WHERE rownum <= 50";
}
else if (SystemConfig.AppCenterDBType == DBType.MSSQL)
{
sql = "SELECT TOP 50 " + fields + " FROM Frm_GenerBill WHERE " + sqlWhere;
}
else if (SystemConfig.AppCenterDBType == DBType.MySQL || SystemConfig.AppCenterDBType == DBType.PostgreSQL)
{
sql = "SELECT " + fields + " FROM Frm_GenerBill WHERE " + sqlWhere + " LIMIT 50";
}
DataTable mydt = BP.DA.DBAccess.RunSQLReturnTable(sql);
if (SystemConfig.AppCenterDBType == DBType.Oracle || SystemConfig.AppCenterDBType == DBType.PostgreSQL)
{
mydt.Columns[0].ColumnName = "WorkID";
mydt.Columns[1].ColumnName = "FrmID";
mydt.Columns[2].ColumnName = "FrmName";
mydt.Columns[3].ColumnName = "Title";
mydt.Columns[4].ColumnName = "BillState";
mydt.Columns[5].ColumnName = "Starter";
mydt.Columns[6].ColumnName = "StarterName";
mydt.Columns[7].ColumnName = "Sender";
mydt.Columns[8].ColumnName = "RDT";
}
mydt.TableName = "Frm_Bill";
if (mydt != null)
{
mydt.Columns.Add("TDTime");
foreach (DataRow dr in mydt.Rows)
{
// dr["TDTime"] = GetTraceNewTime(dr["FK_Flow"].ToString(), int.Parse(dr["WorkID"].ToString()), int.Parse(dr["FID"].ToString()));
}
}
#endregion
ds.Tables.Add(mydt);
return(BP.Tools.Json.ToJson(ds));
}
