// 获取表格数据???? 流量点 还有示值误差对应的字段名核对 public static DataSet getMeterImg(string arr) { string strSql = ""; string[] Info = arr.ToString().Split('@'); string RID = Info[0].ToString(); // string MeterID = Info[0].ToString(); string Types = Info[2].ToString(); //-- 流量点 维修前示值误差 维修后示值误差 检测方式 strSql += " select ISNULL(a1,0) Flow,ISNULL(a2,0) PreData,isnull(a3,0) AftData,'" + Types + "' as Types from ("; strSql += " select a.Qmin as a1,a.Avg_Qmin as a2,b.Avg_Qmin as a3 from tk_CheckData a "; strSql += " left join (select * from tk_CheckData where RepairType='维修检测' and validate='是') b on a.RID=b.RID "; strSql += " where a.RepairType='进厂检测' and a.RID='" + RID + "' "; strSql += " union all(select a.[0.1Qmax],a.[Avg_0.1Qmax],b.[Avg_0.1Qmax] from tk_CheckData a "; strSql += " left join (select * from tk_CheckData where RepairType='维修检测' and validate='是') b on a.RID=b.RID "; strSql += " where a.RepairType='进厂检测' and a.RID='" + RID + "') "; strSql += " union all(select a.[0.2Qmax],a.[Avg_0.2Qmax],b.[Avg_0.2Qmax] from tk_CheckData a "; strSql += " left join (select * from tk_CheckData where RepairType='维修检测' and validate='是') b on a.RID=b.RID "; strSql += " where a.RepairType='进厂检测' and a.RID='" + RID + "') "; strSql += " union all(select a.[0.25Qmax],a.[Avg_0.25Qmax],b.[Avg_0.25Qmax] from tk_CheckData a "; strSql += " left join (select * from tk_CheckData where RepairType='维修检测' and validate='是') b on a.RID=b.RID "; strSql += " where a.RepairType='进厂检测' and a.RID='" + RID + "' )) k "; DataSet ds = SQLBase.FillDataSet(strSql, CommandType.Text, null, "FlowMeterDBCnn"); return(ds); }
/// <summary> /// 获取经验分析数据 /// </summary> /// <param name="month"></param> /// <returns></returns> public static DataSet GetJYFX(int month) { UIDataTable instData = new UIDataTable(); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@MONTH", month) }; DataSet DO_Order = SQLBase.FillDataSet("JYFX", CommandType.StoredProcedure, para); return(DO_Order); }
public static UIDataTable getEquipGrid(int a_intPageSize, int a_intPageIndex, string where, string order, string unit) { UIDataTable instData = new UIDataTable(); SqlParameter[] sqlPar = new SqlParameter[] { new SqlParameter("@PageSize", a_intPageSize.ToString()), new SqlParameter("@StartIndex", (a_intPageSize * a_intPageIndex).ToString()), new SqlParameter("@Where", where), new SqlParameter("@Order", order), new SqlParameter("@UnitID", unit) }; DataSet DO_Order = SQLBase.FillDataSet("getEquipNew", CommandType.StoredProcedure, sqlPar, "SupplyCnn"); if (DO_Order == null) { instData.DtData = null; instData.IntRecords = 0; instData.IntTotalPages = 0; return(instData); } DataTable dtOrder = DO_Order.Tables[0]; DataColumn c = new DataColumn(); c.ColumnName = "xu"; dtOrder.Columns.Add(c); for (int i = 0; i < dtOrder.Rows.Count; i++) { dtOrder.Rows[i]["xu"] = (i + 1); } instData.IntRecords = GFun.SafeToInt32(DO_Order.Tables[1].Rows[0][0]); if (instData.IntRecords > 0) { if (instData.IntRecords % a_intPageSize == 0) { instData.IntTotalPages = instData.IntRecords / a_intPageSize; } else { instData.IntTotalPages = instData.IntRecords / a_intPageSize + 1; } } else { instData.IntTotalPages = 0; } instData.DtData = dtOrder; return(instData); }
// 检测对比图-加载检测表列表 public static UIDataTable LoadDetecList(int a_intPageSize, int a_intPageIndex, string where) { UIDataTable instData = new UIDataTable(); SqlParameter[] sqlPar = new SqlParameter[] { new SqlParameter("@PageSize", a_intPageSize.ToString()), new SqlParameter("@StartIndex", (a_intPageSize * a_intPageIndex).ToString()), new SqlParameter("@Where", where) }; DataSet DO_Order = SQLBase.FillDataSet("GetDetecList", CommandType.StoredProcedure, sqlPar, "FlowMeterDBCnn"); // if (DO_Order == null) { instData.DtData = null; instData.IntRecords = 0; instData.IntTotalPages = 0; return(instData); } DataTable dtOrder = DO_Order.Tables[0]; instData.IntRecords = GFun.SafeToInt32(DO_Order.Tables[1].Rows[0][0]); if (instData.IntRecords > 0) { if (instData.IntRecords % a_intPageSize == 0) { instData.IntTotalPages = instData.IntRecords / a_intPageSize; } else { instData.IntTotalPages = instData.IntRecords / a_intPageSize + 1; } } else { instData.IntTotalPages = 0; } // if (dtOrder != null && dtOrder.Rows.Count > 0) { for (int i = 0; i < dtOrder.Rows.Count; i++) { dtOrder.Rows[i]["RowNumber"] = i + 1; } } instData.DtData = dtOrder; return(instData); }
public static UIDataTable getConditionGrid(int a_intPageSize, int a_intPageIndex, string where, string folderBack) { string[] arr = folderBack.Split('/'); UIDataTable instData = new UIDataTable(); SqlParameter[] sqlPar = new SqlParameter[] { new SqlParameter("@PageSize", a_intPageSize.ToString()), new SqlParameter("@StartIndex", (a_intPageSize * a_intPageIndex).ToString()), new SqlParameter("@Data", arr[0]), new SqlParameter("@Table", arr[1]), new SqlParameter("@Where", where) }; DataSet DO_Order = SQLBase.FillDataSet("getCondition", CommandType.StoredProcedure, sqlPar, "AccountCnn"); if (DO_Order == null) { instData.DtData = null; instData.IntRecords = 0; instData.IntTotalPages = 0; return(instData); } DataTable dtOrder = DO_Order.Tables[0]; instData.IntRecords = GFun.SafeToInt32(DO_Order.Tables[1].Rows[0][0]); if (instData.IntRecords > 0) { if (instData.IntRecords % a_intPageSize == 0) { instData.IntTotalPages = instData.IntRecords / a_intPageSize; } else { instData.IntTotalPages = instData.IntRecords / a_intPageSize + 1; } } else { instData.IntTotalPages = 0; } instData.DtData = dtOrder; return(instData); }
public static UIDataTable getAptitudeGrid(int a_intPageSize, int a_intPageIndex, string where, string unitid) { UIDataTable instData = new UIDataTable(); SqlParameter[] sqlPar = new SqlParameter[] { new SqlParameter("@PageSize", a_intPageSize.ToString()), new SqlParameter("@StartIndex", (a_intPageSize * a_intPageIndex).ToString()), new SqlParameter("@Where", where), new SqlParameter("@UnitID", unitid) }; DataSet DO_Order = SQLBase.FillDataSet("getAptitude", CommandType.StoredProcedure, sqlPar, "SupplyCnn"); if (DO_Order == null) { instData.DtData = null; instData.IntRecords = 0; instData.IntTotalPages = 0; return(instData); } DataTable dtOrder = DO_Order.Tables[0]; instData.IntRecords = GFun.SafeToInt32(DO_Order.Tables[1].Rows[0][0]); if (instData.IntRecords > 0) { if (instData.IntRecords % a_intPageSize == 0) { instData.IntTotalPages = instData.IntRecords / a_intPageSize; } else { instData.IntTotalPages = instData.IntRecords / a_intPageSize + 1; } } else { instData.IntTotalPages = 0; } instData.DtData = dtOrder; return(instData); }
public static UIDataTable GetPayGrid(int a_intPageSize, int a_intPageIndex, string where) { UIDataTable instData = new UIDataTable(); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PageSize", a_intPageSize), new SqlParameter("@StartIndex", (a_intPageIndex * a_intPageSize).ToString()), new SqlParameter("@Where", where) }; DataSet DO_Order = SQLBase.FillDataSet("GetPayGrid", CommandType.StoredProcedure, para); if (DO_Order == null) { instData.DtData = null; instData.IntRecords = 0; instData.IntTotalPages = 0; return(instData); } DataTable dtOrder = DO_Order.Tables[0]; instData.IntRecords = GFun.SafeToInt32(DO_Order.Tables[1].Rows[0][0]); if (instData.IntRecords > 0) { if (instData.IntRecords % a_intPageSize == 0) { instData.IntTotalPages = instData.IntRecords / a_intPageSize; } else { instData.IntTotalPages = instData.IntRecords / a_intPageSize + 1; } } else { instData.IntTotalPages = 0; } instData.DtData = dtOrder; return(instData); }