private string GetWorkList() { string StrQuery = Request["key"]; //当前页 string pageNumber = getUTF8ToString("pageNumber"); int iPageNumber = string.IsNullOrEmpty(pageNumber) ? 1 : Convert.ToInt32(pageNumber); //每页多少行 string pageSize = getUTF8ToString("pageSize"); int iPageSize = string.IsNullOrEmpty(pageSize) ? 9999 : Convert.ToInt32(pageSize); StrQuery = HttpUtility.UrlDecode(StrQuery, System.Text.Encoding.UTF8); string sql = ""; string wfSql = " WFState=" + (int)WFState.Askfor + " OR WFState=" + (int)WFState.Runing + " OR WFState=" + (int)WFState.Shift + " OR WFState=" + (int)WFState.ReturnSta; if (string.IsNullOrEmpty(StrQuery.Trim())) { sql = "SELECT * FROM WF_GenerWorkFlow where 1=1 and " + wfSql + " order by RDT desc"; } else { // StrQuery = Server.UrlDecode(StrQuery); sql = "select * from (SELECT * from WF_GenerWorkFlow where " + wfSql + ") as WF_GenerWorkFlow where 1=1 and " + StrQuery + " order by RDT desc "; } System.Data.DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(sql); foreach (DataRow row in dt.Rows) { if (row["StarterName"].ToString() == "Guest") { int oid = int.Parse(row["WorkID"].ToString()); if (oid != 0) { string ndXSql = "select * from ND" + int.Parse(row["FK_Flow"].ToString()) + "Rpt where OID = '" + oid + "'"; DataTable ndTable = BP.DA.DBAccess.RunSQLReturnTable(ndXSql); if (ndTable.Rows.Count > 0) { row["StarterName"] = ndTable.Rows[0]["GuestName"]; } } } } foreach (DataColumn column in dt.Columns) { column.ColumnName = column.ColumnName.ToUpper(); } return(CommonDbOperator.GetJsonFromTable(dt)); }
private void GetData() { string StrQuery = Request["key"]; StrQuery = HttpUtility.UrlDecode(StrQuery, System.Text.Encoding.UTF8); string sql = ""; string wfSql = " WFState=" + (int)WFState.Askfor + " OR WFState=" + (int)WFState.Runing + " OR WFState=" + (int)WFState.Shift + " OR WFState=" + (int)WFState.ReturnSta; if (string.IsNullOrEmpty(StrQuery.Trim())) { sql = "SELECT * FROM WF_GenerWorkFlow where 1=1 and " + wfSql + " order by RDT desc"; } else { // StrQuery = Server.UrlDecode(StrQuery); sql = "select * from (SELECT * from WF_GenerWorkFlow where " + wfSql + ") as WF_GenerWorkFlow where 1=1 and " + StrQuery + " order by RDT desc "; } System.Data.DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(sql); foreach (DataRow row in dt.Rows) { if (row["StarterName"].ToString() == "Guest") { int oid = int.Parse(row["WorkID"].ToString()); if (oid != 0) { string ndXSql = "select * from ND" + int.Parse(row["FK_Flow"].ToString()) + "Rpt where OID = '" + oid + "'"; DataTable ndTable = BP.DA.DBAccess.RunSQLReturnTable(ndXSql); if (ndTable.Rows.Count > 0) { row["StarterName"] = ndTable.Rows[0]["GuestName"]; } } } } foreach (DataColumn column in dt.Columns) { column.ColumnName = column.ColumnName.ToUpper(); } string result = CommonDbOperator.GetJsonFromTable(dt); Response.Clear(); Response.Write(result); Response.End(); }