// 获取表格数据???? 流量点 还有示值误差对应的字段名核对
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);
}