public DataSet GetProductionData(string unit, string num)
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
string sql = "";
if (num == "1")
{
sql = "SELECT D_C_ar,D_H_ar,D_O_ar,D_N_ar,D_S_ar,D_Cfh_c_ulti,D_Clz_c_ulti,D_Qnet_ar_ulti,D_M_AR_ULTI,D_A_AR_ULTI from T_INFO_PROCPARA_COAL_ULTI " +
"where T_INFO_PROCPARA_COAL_ULTI.T_UNITID ='" + unit + "' order by T_INFO_PROCPARA_COAL_ULTI.T_TIME desc fetch first 1 rows only";
}
else
{
sql = "SELECT D_CFH_C_PROX,D_CLZ_C_PROX,D_M_AD,D_A_AD,D_V_DAF,D_QNET_AR_PROX,D_ST_AD,D_ST_AR,D_M_AR_PROX,D_A_AR_PROX from T_INFO_PROCPARA_COAL_PROX " +
" where T_INFO_PROCPARA_COAL_PROX.T_UNITID ='" + unit + "' order by T_INFO_PROCPARA_COAL_PROX.T_TIME desc fetch first 1 rows only";
}
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
//查询数据
public void getDS()
{
string sql = "";
// 监视设备,记录表,启动限值,停止限值,机组容量,环保机组,数字点
sql = @"select ROW_NUMBER() OVER(order by ID_KEY) as seqnum,ID_KEY,T_AREAID,T_AREANAME "
+ " from T_BASE_AREA ";
ds = DBdb2.RunDataSet(sql, out errMsg);
GridView1.DataKeyNames = new string[] { "ID_KEY" };
}
/// <summary>
/// 获取datagridview的值
/// </summary>
/// <param name="unit_id"></param>
/// <returns></returns>
public DataSet Get_GRID_DATA(string unit_id)
{
string[] str = new string[unit_id.Split(',').Length];
for (int i = 0; i < unit_id.Split(',').Length; i++)
{
str[i] = unit_id.Split(',')[i];
}
string sql_str = "";
if (str[2] != "")
{
sql_str = "and 超温考核记录表.影响电量 = " + str[2] + "";
}
this.init();
string errMsg = "";
DataSet DS = new DataSet();
string sql_num = "";
if ((Convert.ToDateTime(str[0].Split(';')[1]).Month == DateTime.Now.Month) && (Convert.ToDateTime(str[0].Split(';')[1]).Year == DateTime.Now.Year))
{
sql_num = DateTime.Now.Day.ToString();
}
else
{
sql_num = DateTime.DaysInMonth(Convert.ToDateTime(str[0].Split(';')[1]).Year, Convert.ToDateTime(str[0].Split(';')[1]).Month).ToString();
}
string sql = "select 超温考核记录表.ID_KEY,T_COMPANYDESC,T_PLANTDESC,T_UNITDESC,T_DESC,开始时间, 结束时间,T_CATEGORYDESC,T_PROPERTYDESC,T_PROFESSIONALDESC,T_REASONDESC,影响电量,T_CAPABILITYLEVEL,超温考核记录表.事件描述,超温考核记录表.原因分析,超温考核记录表.处理建议 from " +
" T_BASE_UNIT inner join T_BASE_PLANT on T_BASE_UNIT.T_PLANTID = T_BASE_PLANT.T_PLANTID and T_BASE_UNIT.T_UNITID= '" + str[1] + "' " +
"inner join T_BASE_COMPANY on T_BASE_PLANT.T_COMPANYID = T_BASE_COMPANY.T_COMPANYID " +
"inner join 超温考核记录表 on 超温考核记录表.机组 =T_BASE_UNIT.T_UNITID and 超温考核记录表.开始时间 between '" + str[0].Split(';')[0] + "-01 00:00:00' and '" + str[0].Split(';')[1] + "-" + sql_num + " 00:00:00' " +
"and 超温考核记录表.预警类别ID ='" + str[3] + "'" + sql_str + " and 超温考核记录表.预警性质ID ='" + str[4] + "' and 超温考核记录表.预警专业分类ID ='" + str[5] + "' and 超温考核记录表.预警原因分类ID ='" + str[6] + "' " +
" inner join T_BASE_CALCPARA on 超温考核记录表.考核点ID = T_BASE_CALCPARA.T_PARAID and " +
"超温考核记录表.机组 = T_BASE_CALCPARA.T_UNITID " +
"inner join T_BASE_FAULTCATEGORY on 超温考核记录表.预警类别ID = T_BASE_FAULTCATEGORY.T_CATEGORYID " +
"inner join T_BASE_FAULTPROPERTY on T_BASE_FAULTPROPERTY.T_PROPERTYID = 超温考核记录表.预警性质ID " +
"inner join T_BASE_FAULTPROFESSIONAL on T_BASE_FAULTPROFESSIONAL.T_PROFESSIONALID= 超温考核记录表.预警专业分类ID " +
"inner join T_BASE_FAULTREASON on T_BASE_FAULTREASON.T_REASONID = 超温考核记录表.预警原因分类ID";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
/// <summary>
/// 获取锅炉厂家 T_BASE_BOILER
/// </summary>
/// <returns></returns>
public DataSet GetBOILERDESC()
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
string sql = "select T_BOILERID,T_BOILERDESC from T_BASE_BOILER";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
/// <summary>
/// 煤质查询
/// </summary>
/// <param name="unit">机组编号</param>
/// <returns></returns>
public DataSet GetProductionPreData(string stime, string etime, string unit)
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
string sql = "SELECT T_UNITID,T_TIME,D_M_AR_PROX,D_M_ad,D_A_ad,D_V_DAF,D_Qnet_ar_PROX,D_St_ad FROM T_INFO_PROCPARA_COAL_PROX where T_UNITID ='" + unit + "' and T_TIME between '" + stime + "' and '" + etime + "' order by T_TIME asc";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
/// <summary>
/// 获取文件类别 T_BASE_DATUNM
/// </summary>
/// <returns></returns>
public DataSet Get_Type()
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
string sql = "select PARA_ID,PARADESC from T_BASE_DATUNM";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
/// <summary>
/// 获取所有机组类型 T_BASE_UNIT
/// </summary>
/// <returns></returns>
public DataSet GetPLANTTYPE()
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
string sql = "select T_PLANTTYPE from T_BASE_UNIT group by T_PLANTTYPE";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
public DataSet GetBoilerData(string unit)
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
string sql = "select D_Alpha_fh,D_Alpha_lz,D_D_e,D_CO,D_Tlz,D_Tlk_d,D_RH,D_Tfw_d,D_H2,D_CH4 from T_INFO_PROCPARA_BOILER where T_INFO_PROCPARA_BOILER.T_UNITID ='" + unit + "' order by T_INFO_PROCPARA_BOILER.T_TIME desc fetch first 1 rows only";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
public DataSet Get_data(string para)
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
string sql = "select 开始时间,事件描述,原因分析,处理建议 from 超温考核记录表 where ID_KEY=" + para;
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
/// <summary>
/// 获取所有机组容量等级 T_BASE_UNIT
/// </summary>
/// <returns></returns>
public DataSet GetCAPABILITYLEVEL()
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
string sql = "select T_CAPABILITYLEVEL from T_BASE_UNIT group by T_CAPABILITYLEVEL";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
/// <summary>
/// 获取预警类别 T_BASE_FAULTCATEGORY
/// </summary>
/// <returns></returns>
public DataSet GetFAULTCATEGORY()
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
string sql = "select T_CATEGORYID,T_CATEGORYDESC from T_BASE_FAULTCATEGORY";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
/// <summary>
/// 获取预警专业分类 T_BASE_FAULTPROFESSIONAL
/// </summary>
/// <returns></returns>
public DataSet GetFAULTPROFESSIONAL()
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
string sql = "select T_PROFESSIONALID,T_PROFESSIONALDESC from T_BASE_FAULTPROFESSIONAL";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
/// <summary>
/// 获取考核点描述
/// </summary>
public DataSet GETKAOHRDIAN_DESC(string uint_id)
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
string sql = "select 考核点ID,考核点描述 from 超温考核测点表 where 超温考核测点表.机组 = '" + uint_id + "'";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
/// <summary>
/// 获取数据库中分公司
/// </summary>
/// <returns></returns>
public DataSet Get_Company_Info(out string errMsg)
{
this.init();
errMsg = "";
DataSet DS = new DataSet();
string sql = "select T_COMPANYID,T_COMPANYDESC from T_BASE_COMPANY";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
/// <summary>
/// 获取数据库中电厂机组
/// </summary>
/// <param name="electric_id">电厂ID</param>
/// <returns></returns>
public DataSet Get_Unit_Info(string electric_id, out string errMsg)
{
this.init();
errMsg = "";
DataSet DS = new DataSet();
string sql = "select T_UNITID,T_UNITDESC from T_BASE_UNIT where T_PLANTID='" + electric_id + "'";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
/// <summary>
/// 获取数据库中机组参数ID
/// </summary>
/// <param name="unit_id">机组ID</param>
/// <returns></returns>
public DataSet Get_BASE_CRICPARA(string unit_id, out string errMsg)
{
this.init();
errMsg = "";
DataSet DS = new DataSet();
string sql = "select T_PARAID,T_PARADESC from T_BASE_CRICPARA where T_UNITID ='"+ unit_id + "'";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
/// <summary>
/// 获取datagridview的值
/// </summary>
/// <param name="unit_id"></param>
/// <returns></returns>
public DataSet Get_GRID_DATA(string unit_id)
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
string sql = "select 超温考核故障映射表.ID_KEY,超温考核测点表.考核点描述,超温考核故障类型表.考核下限, 超温考核故障类型表.考核上限,超温考核故障类型表.提示信息,超温考核测点表.机组,超温考核故障类型表.故障类型ID from 超温考核故障映射表 inner join 超温考核测点表 " +
"on 超温考核测点表.考核点ID = 超温考核故障映射表.考核点ID and 超温考核测点表.机组 = '" + unit_id + "' inner join 超温考核故障类型表 on 超温考核故障映射表.故障类型ID = 超温考核故障类型表.故障类型ID";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
public DataSet GetSteamTurbineData(string unit)
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
string sql = "select D_L1, D_L2, D_Delta_dtr, D_Rdtr, D_L_well, D_W_well, D_Eta_p, D_Delta_fdj, D_Delta_gcb, D_Delta_qbb, D_DK_e, D_DB_e, D_DM_e, D_DL_e, D_P_e, D_D_gbmfgs," +
"D_D_gbmfhs,D_Dphp_e ,D_DN_e,D_Djc_e,D_A,I_N_pipe,I_N_flow,D_Din,D_Dout,I_N_ball_i,D_V_xb1I,D_V_xb2I,D_Z_xb1I,D_Z_xb2I,D_W_lqt_I,D_Txhs_in_d,D_Wd ,D_Din_xb1O,D_Din_xb2O,T_Type,I_N_ball_o,D_Z_xb1O,D_Z_xb2O,D_Eta_gr_xb1,D_Eta_gr_xb2 " +
"from T_INFO_PROCPARA_TURB where T_INFO_PROCPARA_TURB.T_UNITID ='" + unit + "' order by T_INFO_PROCPARA_TURB.T_TIME desc fetch first 1 rows only";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
///下载文档
public bool DownLoadFile(string id)
{
string errMsg = "", FileName = "";
bool flag = true;
try
{
this.init();
DataSet DS = new DataSet();
string sql = "select * from T_BASE_DATUNM_DATA where ID_KEY=" + id.Split('|')[0];
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
if (DS.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in DS.Tables[0].Rows)
{
FileName = row["FILE_DESC"].ToString();
byte[] bytes = (byte[])row["FILE_DATA"];
FileStream fs = new FileStream(id.Split('|')[1] + FileName, FileMode.CreateNew);
//FileStream fs = new FileStream(FileName, FileMode.Create, FileAccess.Write);
fs.Write(bytes, 0, bytes.Length);
fs.Flush();
fs.Close();
//ht.Add("T_TIME", row["T_TIME"].ToString());
}
}
}
catch (Exception ce)
{
errMsg = ce.Message;
flag = false;
}
return(flag);
}
/// <summary>
/// 通过报表名称，ORGID,TREEID获取报表样式
/// </summary>
/// <param name="rptName"></param>
/// <param name="treeId"></param>
/// <param name="orgId"></param>
/// <returns></returns>
public DataTable GetRptStyle(string rptId, string treeId, string orgId)
{
//var query = "SELECT * FROM T_INFO_SISREPORT WHERE REPORTNAME='" + rptName + "' AND ORGID='" + orgId +
// "' AND TREEID='" + treeId + "'";
var query = "";
//if(treeId !="" && orgId!="")
// query="SELECT * FROM T_INFO_SISREPORT WHERE reportid='" + rptId + "' AND ORGID='" + orgId +
// "' AND TREEID='" + treeId + "'";
//else
query = "SELECT * FROM T_INFO_SISREPORT WHERE reportid='" + rptId + "'";
var errMsg = string.Empty;
DataSet ds;
if (dbTypeValue == "SQL")
{
ds = DBsql.RunDataSet(query, out errMsg);
}
else if (dbTypeValue == "ORACLE")
{
ds = OracleHelper.Query(query);
}
else
{
ds = DBdb2.RunDataSet(query, out errMsg);
//dt = DBdb2.RunDataTable(query, out errMsg);
}
if (string.IsNullOrEmpty(errMsg))
{
return(ds.Tables[0] ?? new DataTable());
}
else
{
throw new Exception(errMsg);
}
}
public IList <Hashtable> Get_All_data(string unit_id)
{
this.init();
ArrayList list = new ArrayList();
DataSet DS = new DataSet();
string errMsg = "";
IList <Hashtable> listdata = new List <Hashtable>();
Hashtable ht = new Hashtable();
string sql_str = "";
sql_str = "SELECT T_BASE_DATUNM_DATA.ID_KEY,FILE_DESC,PARADESC,T_TIME FROM T_BASE_DATUNM_DATA left join T_BASE_DATUNM on T_BASE_DATUNM_DATA.FILE_TYPE=T_BASE_DATUNM.PARA_ID where UNIT_ID ='" + unit_id.Split(',')[0] + "' ";
if (unit_id.Split(',')[1] != "-请选择-")
{
sql_str += " and FILE_TYPE='" + unit_id.Split(',')[1] + "' ";
}
if (unit_id.Split(',')[2] != "")
{
sql_str += " and FILE_DESC like '" + Fuzzy_Query(unit_id.Split(',')[2]) + "' ";
}
sql_str += " order by T_TIME asc";
DS = DBdb2.RunDataSet(sql_str, out errMsg);
if (DS.Tables[0].Rows.Count > 0)
{
int num = DS.Tables[0].Rows.Count;
foreach (DataRow row in DS.Tables[0].Rows)
{
ht = new Hashtable();
ht.Add("ID", num);
ht.Add("ID_KEY", row["ID_KEY"].ToString());
ht.Add("FILE_DESC", row["FILE_DESC"].ToString());
ht.Add("PARADESC", row["PARADESC"].ToString());
ht.Add("T_TIME", row["T_TIME"].ToString());
listdata.Add(ht);
num--;
}
}
return(listdata);
}
/// <summary>
/// 获取队标基准值公式
/// </summary>
/// <param name="unit">机组编号</param>
/// <returns></returns>
public DataSet GetBoilerData(string unit)
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
//"T0_t_el主蒸汽温度(℃),"P0_t_el主蒸汽压力(MPa)",,'Trh_el再热温度(℃)','PLrh_el再热压损(%)','Pdp_el凝汽器压力(kPa)','Dgrjw_el过热减温水流量(t/h)','Dzrjw_el再热减温水流量(t/h)','Dpw_el锅炉连续排污流量(t/h)','DeltaT_gl_el凝汽器过冷度(℃)','Dtur_el小机用汽量(t/h)','O2_el排烟氧量(%)','Tpy_el排烟温度(℃)','Alpha_bs_el补水率(%)','Tfw_el给水温度(℃)','Eta_H_el高压缸效率(%)','Eta_M_el中压缸效率(%)','Theta_1_el#1高加上端差(℃)','Theta_2_el#2高加上端差(℃)','Theta_3_el#3高加上端差(℃)','Theta_5_el#5高加上端差(℃)','Theta_6_el#6高加上端差(℃)','Theta_7_el#7高加上端差(℃)','Theta_8_el#8高加上端差(℃)'
string sql = "select T_PARAID,T_FORMULA from T_BASE_CALCPARA where T_UNITID = '" + unit + "' and ( T_PARAID= 'T0_t_el_B' or T_PARAID= 'P0_t_el_B' or T_PARAID= 'Trh_el_B' or T_PARAID= 'PLrh_el_B'" +
"or T_PARAID= 'Pdp_el_B' or T_PARAID= 'Dgrjw_el_B' or T_PARAID= 'Dzrjw_el_B' or T_PARAID= 'Dpw_el_B' or T_PARAID= 'Del_BtaT_gl_el_B' or T_PARAID= 'Dtur_el_B'" +
"or T_PARAID= 'O2_el_B' or T_PARAID= 'Tpy_el_B' or T_PARAID= 'Alpha_bs_el_B' or T_PARAID= 'Tfw_el_B' or T_PARAID= 'Eta_H_el_B' or T_PARAID= 'Eta_M_el_B' or " +
"T_PARAID= 'Theta_1_el_B' or T_PARAID= 'Theta_2_el_B' or T_PARAID= 'Theta_3_el_B' or T_PARAID= 'Theta_5_el_B' or T_PARAID= 'Theta_6_el_B' or " +
"T_PARAID= 'Theta_7_el_B' or T_PARAID= 'Theta_8_el_B') ";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
return(DS);
}
public IList <Hashtable> Get_Required_data(string unit_id, string[] para_id, string[] per, string hanshu, string stime, string etime, out string[] hanshu_gongshi, out string errMsg)
{
this.init();
errMsg = "";
hanshu_gongshi = new string [hanshu.Split(',').Length];
ArrayList list = new ArrayList();
DataSet DS = new DataSet();
IList <Hashtable> listdata = new List <Hashtable>();
Hashtable ht = new Hashtable();
for (int i = 0; i < per.Length; i++)
{
string sql_Required = "select T_PARAID,T_OUTTABLE from T_BASE_CALCPARA where T_UNITID ='" + unit_id + "' and (T_PARAID ='Pel' or T_PARAID='" + para_id[0] + "' or T_PARAID ='" + para_id[1] + "')";
//string sql = "select T_TYPE from T_BASE_CALCPARA where T_UNITID =" + unit_id + "' and T_PARAID='" + para_id+",";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql_Required, out errMsg);
}
if ((DS.Tables[0].Rows.Count > 0) && (DS.Tables[0].Rows[0]["T_OUTTABLE"].ToString() != "") && (DS.Tables[0].Rows[1]["T_OUTTABLE"].ToString() != "") && (DS.Tables[0].Rows[2]["T_OUTTABLE"].ToString() != ""))
{
ht = new Hashtable();
ArrayList ld = new ArrayList();
ArrayList ldd = new ArrayList();
ArrayList lt = new ArrayList();
ArrayList ltt = new ArrayList();
string str1 = "", str2 = "", str3 = "";
for (int j = 0; j < DS.Tables[0].Rows.Count; j++)
{
if (DS.Tables[0].Rows[j]["T_PARAID"].ToString() == "Pel")
{
str1 = "select ss.D_VALUE as " + para_id[0] + ",sss.D_VALUE as " + para_id[1] + " from (select s.D_VALUE,s. T_DATETIME from (select D_VALUE,T_DATETIME from " + DS.Tables[0].Rows[j]["T_OUTTABLE"].ToString() + ", " +
"(select T_UNITID,\"D_CAPABILITY\" from T_BASE_UNIT where T_UNITID ='" + unit_id + "') as a where a.T_UNITID = T_INFO_CALCDATA.T_UNITID and " +
"T_INFO_CALCDATA.T_PARAID = 'Pel' and T_INFO_CALCDATA.D_VALUE between a.\"D_CAPABILITY\"*" + Convert.ToDouble(per[i].Split('|')[0]) / 100 +
" and a.\"D_CAPABILITY\"*" + Convert.ToDouble(per[i].Split('|')[1]) / 100 + " ) as s where s.T_DATETIME between '" + stime + "' and '" + etime +
"' group by s.D_VALUE,s. T_DATETIME order by s.T_DATETIME asc) as q, ";
}
else if (DS.Tables[0].Rows[j]["T_PARAID"].ToString() == para_id[0])
{
str2 = "(select D_VALUE,T_DATETIME from " + DS.Tables[0].Rows[j]["T_OUTTABLE"].ToString() + " where T_UNITID ='" + unit_id + "' and T_PARAID='" + para_id[0] + "' ) as ss,";
}
else if (DS.Tables[0].Rows[j]["T_PARAID"].ToString() == para_id[1])
{
str3 = "(select D_VALUE,T_DATETIME from " + DS.Tables[0].Rows[j]["T_OUTTABLE"].ToString() + " where T_UNITID ='" + unit_id + "' and T_PARAID='" + para_id[1] + "' ) as sss where q.T_DATETIME = ss.T_DATETIME and q.T_DATETIME =sss.T_DATETIME ";
}
}
//string append_sql = "select ss.D_VALUE as " + para_id[0] + ",sss.D_VALUE as " + para_id[1] + " from (select s.D_VALUE,s. T_DATETIME from " +
//"(select D_VALUE,T_DATETIME from " + DS.Tables[0].Rows[0]["T_OUTTABLE"].ToString() + ", (select T_UNITID,\"D_CAPABILITY\" from T_BASE_UNIT where T_UNITID ='" + unit_id + "') as a where a.T_UNITID = T_INFO_CALCDATA.T_UNITID and "+
//"T_INFO_CALCDATA.T_PARAID = 'Pel' and T_INFO_CALCDATA.D_VALUE between a.\"D_CAPABILITY\"*" + Convert.ToDouble(per[i].Split('|')[0]) / 100 + " and a.\"D_CAPABILITY\"*" + Convert.ToDouble(per[i].Split('|')[1]) / 100 + " ) as s where s.T_DATETIME between '" + stime + "' and '" + etime + "' group by s.D_VALUE,s. T_DATETIME " +
//"order by s.T_DATETIME asc) as q,(select D_VALUE,T_DATETIME from "+DS.Tables[0].Rows[1]["T_OUTTABLE"].ToString()+ " where T_UNITID ='"+unit_id+"' and T_PARAID='"+DS.Tables[0].Rows[1]["T_PARAID"].ToString()+"' ) as ss,"+
//"(select D_VALUE,T_DATETIME from " + DS.Tables[0].Rows[2]["T_OUTTABLE"].ToString() + " where T_UNITID ='" + unit_id + "' and T_PARAID='" + DS.Tables[0].Rows[2]["T_PARAID"].ToString() + "' ) as sss where q.T_DATETIME = ss.T_DATETIME and q.T_DATETIME =sss.T_DATETIME ";
string append_sql = str1 + str2 + str3;
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(append_sql, out errMsg);
}
if (DS.Tables[0].Rows.Count > 0)
{
double[] x = new double[DS.Tables[0].Rows.Count];
double[] y = new double[DS.Tables[0].Rows.Count];
double min_data = Convert.ToDouble(DS.Tables[0].Rows[0][0].ToString());
double max_data = Convert.ToDouble(DS.Tables[0].Rows[0][0].ToString());
for (int j = 0; j < DS.Tables[0].Rows.Count; j++)
{
if ((DS.Tables[0].Rows[j][0].ToString() != "-9999") && (DS.Tables[0].Rows[j][1].ToString() != "-9999"))
{
ld = new ArrayList();
ld.Add(Math.Round(Convert.ToDouble(DS.Tables[0].Rows[j][0].ToString()), 3));
if (min_data > Convert.ToDouble(DS.Tables[0].Rows[j][0].ToString()))
{
min_data = Convert.ToDouble(DS.Tables[0].Rows[j][0].ToString());
}
if (max_data < Convert.ToDouble(DS.Tables[0].Rows[j][0].ToString()))
{
max_data = Convert.ToDouble(DS.Tables[0].Rows[j][0].ToString());
}
x[j] = Convert.ToDouble(DS.Tables[0].Rows[j][0].ToString());
ld.Add(Math.Round(Convert.ToDouble(DS.Tables[0].Rows[j][1].ToString()), 3));
//if (j == 0 || j == DS.Tables[0].Rows.Count-1)
//{
// ltt.Add(ld);
//}
y[j] = Convert.ToDouble(DS.Tables[0].Rows[j][1].ToString());
lt.Add(ld);
}
}
if (hanshu.Split(',')[0].Trim() == "多项式")
{
//double[] xx = new double[8] { 1.1, 1.24, 2.37, 5.12, 8.12, 12.19, 17.97, 24.99 };
//double[] yy = new double[8] { 2200.1, 29152.3, 47025.3, 86852.3, 132450.6, 200302.25, 284688.1, 396988.3 };
string gongshi = "";
double[] z = new double[Convert.ToInt32(hanshu.Split(',')[1]) + 1];
funPolynomial(x, y, Convert.ToInt32(hanshu.Split(',')[1]), out gongshi, out z);
hanshu_gongshi[i] = gongshi;
double num = (max_data - min_data) / 20;
for (double m = min_data; m < max_data; m = m + num)
{
ldd = new ArrayList();
ldd.Add(Math.Round(m, 2));
double y_data = 0;
for (int j = z.Length - 1; j >= 0; j--)
{
y_data += z[j] * (Math.Pow(m, j));
}
ldd.Add(Math.Round(y_data, 2));
ltt.Add(ldd);
}
}
else if (hanshu.Split(',')[0].Trim() == "线性")
{
string gongshi = "", a = "", b = "";
funXianxing(x, y, out gongshi, out a, out b);
hanshu_gongshi[i] = gongshi;
double num = (max_data - min_data) / 20;
for (double m = min_data; m < max_data; m = m + num)
{
ldd = new ArrayList();
ldd.Add(Math.Round(m, 2));
ldd.Add(Math.Round(Convert.ToDouble(a) * m + Convert.ToDouble(b), 2));
ltt.Add(ldd);
}
}
else if (hanshu.Split(',')[0].Trim() == "指数")
{
//y=a*exp(b*x)
string gongshi = "", a = "", b = "";
funExponent(x, y, out gongshi, out a, out b);
hanshu_gongshi[i] = gongshi;
double num = (max_data - min_data) / 20;
for (double m = min_data; m < max_data; m = m + num)
{
ldd = new ArrayList();
ldd.Add(Math.Round(m, 2));
ldd.Add(Math.Round(Convert.ToDouble(a) * (Math.Exp(Convert.ToDouble(b) * m)), 2));
ltt.Add(ldd);
}
}
else if (hanshu.Split(',')[0].Trim() == "对数")
{
//y=a*ln(x)+b
string gongshi = "", a = "", b = "";
funLogarithm(x, y, out gongshi, out a, out b);
hanshu_gongshi[i] = gongshi;
double num = (max_data - min_data) / 20;
for (double m = min_data; m < max_data; m = m + num)
{
ldd = new ArrayList();
ldd.Add(Math.Round(m, 2));
ldd.Add(Math.Round(Convert.ToDouble(a) * Math.Log(m) + Convert.ToDouble(b), 2));
ltt.Add(ldd);
}
}
else if (hanshu.Split(',')[0].Trim() == "幂")
{
//y=a*(x^b)
string gongshi = "", a = "", b = "";
funPower(x, y, out gongshi, out a, out b);
hanshu_gongshi[i] = gongshi;
double num = (max_data - min_data) / 20;
for (double m = min_data; m < max_data; m = m + num)
{
ldd = new ArrayList();
ldd.Add(Math.Round(m, 2));
ldd.Add(Math.Round(Convert.ToDouble(a) * (Math.Pow(m, Convert.ToDouble(b))), 2));
ltt.Add(ldd);
}
}
ht.Add("data", lt);
ht.Add("type", "scatter");
ht.Add("name", "散点图");
listdata.Add(ht);
ht = new Hashtable();
ht.Add("data", ltt);
ht.Add("type", "line");
ht.Add("name", "拟合公式曲线图");
listdata.Add(ht);
}
}
}
return(listdata);
}
public IList <Hashtable> GetChartData(string para_id)
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
DataSet DDS = new DataSet();
IList <Hashtable> listdata = new List <Hashtable>();
string[] para = new string[0];;
string sql = "select T_UNITID,T_UNITDESC from T_BASE_UNIT where T_CAPABILITYLEVEL ='" + para_id.Split(',')[0] + "' and T_PLANTTYPE='" + para_id.Split(',')[1] + "' and T_BOILERID='" + para_id.Split(',')[2] + "' and T_STEAMID ='" + para_id.Split(',')[3] + "'";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
para = new string[DS.Tables[0].Rows.Count];
}
if (DS.Tables[0].Rows.Count > 0)
{
string[] str = new string[DS.Tables[0].Rows.Count];
for (int i = 0; i < DS.Tables[0].Rows.Count; i++)
{
para[i] = DS.Tables[0].Rows[i][1].ToString();
string sql_Required = "select T_PARAID,T_OUTTABLE from T_BASE_CALCPARA where T_UNITID ='" + DS.Tables[0].Rows[i][0].ToString() + "' and (T_PARAID ='Pel' or T_PARAID='P0_t_el_B' or T_PARAID='P0_t' or T_PARAID='T0_t' or T_PARAID='T0_t_el_B' or T_PARAID='" + para_id.Trim(',').Split(',')[6] + "')";
if (rlDBType == "SQL")
{
}
else
{
DDS = DBdb2.RunDataSet(sql_Required, out errMsg);
}
string str_pel = "", str_P0_t = "", str_T0_t = "", append_sql = "";
if (DDS.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < DDS.Tables[0].Rows.Count; j++)
{
string out_table = "";
if (DDS.Tables[0].Rows[j]["T_OUTTABLE"].ToString() == "")
{
out_table = "T_INFO_CALCDATA";
}
else
{
out_table = DDS.Tables[0].Rows[j]["T_OUTTABLE"].ToString();
}
if (DDS.Tables[0].Rows[j]["T_PARAID"].ToString() == "Pel")
{
str_pel = "(select D_VALUE,a.D_CAPABILITY,T_DATETIME from " + out_table + ", (select T_UNITID,\"D_CAPABILITY\" from T_BASE_UNIT where T_UNITID ='" + DS.Tables[0].Rows[i][0].ToString() + "') as a where a.T_UNITID = T_INFO_CALCDATA.T_UNITID and T_INFO_CALCDATA.T_PARAID = 'Pel' ) as s ";
}
else if ((DDS.Tables[0].Rows[j]["T_PARAID"].ToString() == "P0_t") || (DDS.Tables[0].Rows[j]["T_PARAID"].ToString() == "P0_t_el_B"))
{
str_P0_t = ",(select " + out_table + ".D_VALUE,b.D_VALUE as b_D_VALUE, " + out_table + ".T_DATETIME from " + out_table + " inner join (select D_VALUE,T_DATETIME from " + out_table + " where T_PARAID ='P0_t_el_B') as b " +
"on " + out_table + ".T_DATETIME = b.T_DATETIME and " + out_table + ".T_PARAID ='P0_t' and T_UNITID ='" + DS.Tables[0].Rows[i][0].ToString() + "' ) as ss ";
}
else if ((DDS.Tables[0].Rows[j]["T_PARAID"].ToString() == "T0_t") || (DDS.Tables[0].Rows[j]["T_PARAID"].ToString() == "T0_t_el_B"))
{
str_T0_t = ",(select " + out_table + ".D_VALUE,c.D_VALUE as c_D_VALUE," + out_table + ".T_DATETIME from " + out_table + " inner join (select D_VALUE ,T_DATETIME from " + out_table + " where T_PARAID ='T0_t_el_B') as c" +
" on " + out_table + ".T_DATETIME = c.T_DATETIME and " + out_table + ".T_PARAID ='T0_t' and T_UNITID ='" + DS.Tables[0].Rows[i][0].ToString() + "' ) as sss ";
}
else
{
append_sql = ",(select " + out_table + ".D_VALUE," + out_table + ".T_DATETIME from " + out_table + " where T_PARAID='" + DDS.Tables[0].Rows[j]["T_PARAID"].ToString() + "' and T_UNITID='" + DS.Tables[0].Rows[i][0].ToString() + "') as ssss ";
}
}
string sql_num = "";
if ((Convert.ToDateTime(para_id.Trim(',').Split(',')[5].Split(';')[1]).Month == DateTime.Now.Month) && (Convert.ToDateTime(para_id.Trim(',').Split(',')[5].Split(';')[1]).Year == DateTime.Now.Year))
{
sql_num = DateTime.Now.Day.ToString();
}
else
{
sql_num = DateTime.DaysInMonth(Convert.ToDateTime(para_id.Trim(',').Split(',')[5].Split(';')[1]).Year, Convert.ToDateTime(para_id.Trim(',').Split(',')[5].Split(';')[1]).Month).ToString();
}
string str_sql = "select s.D_VALUE,s.D_CAPABILITY,ss.D_VALUE,ss.b_D_VALUE,sss.D_VALUE,sss.c_D_VALUE,ssss.D_VALUE,s.T_DATETIME from " + str_pel + str_P0_t + str_T0_t + append_sql + "where s.T_DATETIME = ss.T_DATETIME and s.T_DATETIME = sss.T_DATETIME and s.T_DATETIME = ssss.T_DATETIME and s.T_DATETIME between '" + para_id.Trim(',').Split(',')[5].Split(';')[0] + "-01 00:00:00' and '" + para_id.Trim(',').Split(',')[5].Split(';')[1] + "-" + sql_num + " 00:00:00' order by s.T_DATETIME asc ";
Hashtable ht = new Hashtable();
if (rlDBType == "SQL")
{
}
else
{
ht = new Hashtable();
ht.Add("name", para[i]);
ArrayList ld = new ArrayList();
ArrayList lt = new ArrayList();
DataSet DDDDS = DBdb2.RunDataSet(str_sql, out errMsg);
double data_sql = 0; int num = 0;
if (DDDDS.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < DDDDS.Tables[0].Rows.Count; j++)
{//(Convert.ToInt32(para_id.Trim(',').Split(',')[4]) + 5) * 0.01
if ((Convert.ToDouble(DDDDS.Tables[0].Rows[j][0].ToString()) / Convert.ToDouble(DDDDS.Tables[0].Rows[j][1].ToString()) > ((Convert.ToInt32(para_id.Trim(',').Split(',')[4]) - 5) * 0.01)) && (Convert.ToDouble(DDDDS.Tables[0].Rows[j][0].ToString()) / Convert.ToDouble(DDDDS.Tables[0].Rows[j][1].ToString()) < ((Convert.ToInt32(para_id.Trim(',').Split(',')[4]) + 5) * 0.01)) && (Math.Abs(Convert.ToDouble(DDDDS.Tables[0].Rows[j][2].ToString()) - Convert.ToDouble(DDDDS.Tables[0].Rows[j][3].ToString())) / Convert.ToDouble(DDDDS.Tables[0].Rows[j][3].ToString()) < 0.05) && (Math.Abs(Convert.ToDouble(DDDDS.Tables[0].Rows[j][4].ToString()) - Convert.ToDouble(DDDDS.Tables[0].Rows[j][5].ToString())) / Convert.ToDouble(DDDDS.Tables[0].Rows[j][5].ToString()) < 0.05))
{
num++;
data_sql += Convert.ToDouble(DDDDS.Tables[0].Rows[j][6]);
}
}
}
ld = new ArrayList();
ld.Add(para[i]);
if (data_sql == 0)
{
ld.Add(data_sql);
}
else
{
ld.Add(data_sql / num);
}
lt.Add(ld);
ht.Add("data", lt);
listdata.Add(ht);
}
}
}
}
return(listdata);
}
public IList <Hashtable> Get_All_data(string unit_id, string[] para_id, string per, string stime, string etime, out string errMsg)
{
this.init();
ArrayList list = new ArrayList();
string str_pel = "", str_P0_t = "", str_T0_t = "";
DataSet DS = new DataSet();
string sql_Required = "select T_PARAID,T_OUTTABLE from T_BASE_CALCPARA where T_UNITID ='" + unit_id + "' and (T_PARAID ='Pel' or T_PARAID='P0_t_el_B' or T_PARAID='P0_t' or T_PARAID='T0_t' or T_PARAID='T0_t_el_B'";
for (int i = 0; i < para_id.Length; i++)
{
sql_Required += " or T_PARAID='" + para_id[i].ToString() + "' ";
}
sql_Required += ")";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql_Required, out errMsg);
}
string[] append_sql = new string[DS.Tables[0].Rows.Count]; //呈现曲线sql语句
int num_para = 0, num_add = 0;
string para_pin = "";
for (int i = 0; i < DS.Tables[0].Rows.Count; i++)
{
string out_table = "";
if (DS.Tables[0].Rows[i]["T_OUTTABLE"].ToString() == "")
{
out_table = "T_INFO_CALCDATA";
}
else
{
out_table = DS.Tables[0].Rows[i]["T_OUTTABLE"].ToString();
}
if (DS.Tables[0].Rows[i]["T_PARAID"].ToString() == "Pel")
{
str_pel = "(select D_VALUE,a.D_CAPABILITY,T_DATETIME from " + out_table + ", (select T_UNITID,\"D_CAPABILITY\" from T_BASE_UNIT where T_UNITID ='" + unit_id + "') as a where a.T_UNITID = T_INFO_CALCDATA.T_UNITID and T_INFO_CALCDATA.T_PARAID = 'Pel' ) as s ";
}
else if ((DS.Tables[0].Rows[i]["T_PARAID"].ToString() == "P0_t") || (DS.Tables[0].Rows[i]["T_PARAID"].ToString() == "P0_t_el_B"))
{
str_P0_t = ",(select " + out_table + ".D_VALUE,b.D_VALUE as b_D_VALUE, " + out_table + ".T_DATETIME from " + out_table + " inner join (select D_VALUE,T_DATETIME from " + out_table + " where T_PARAID ='P0_t_el_B') as b " +
"on " + out_table + ".T_DATETIME = b.T_DATETIME and " + out_table + ".T_PARAID ='P0_t' and T_UNITID ='" + unit_id + "' ) as ss ";
}
else if ((DS.Tables[0].Rows[i]["T_PARAID"].ToString() == "T0_t") || (DS.Tables[0].Rows[i]["T_PARAID"].ToString() == "T0_t_el_B"))
{
str_T0_t = ",(select " + out_table + ".D_VALUE,c.D_VALUE as c_D_VALUE," + out_table + ".T_DATETIME from " + out_table + " inner join (select D_VALUE ,T_DATETIME from " + out_table + " where T_PARAID ='T0_t_el_B') as c" +
" on " + out_table + ".T_DATETIME = c.T_DATETIME and " + out_table + ".T_PARAID ='T0_t' and T_UNITID ='" + unit_id + "' ) as sss ";
}
else
{
para_pin += DS.Tables[0].Rows[i]["T_PARAID"].ToString() + ".D_VALUE as " + DS.Tables[0].Rows[i]["T_PARAID"].ToString() + ",";
append_sql[num_add] = "select " + DS.Tables[0].Rows[i]["T_OUTTABLE"].ToString() + ".D_VALUE," + DS.Tables[0].Rows[i]["T_OUTTABLE"].ToString() + ".T_DATETIME from " + out_table + " where T_PARAID='" + DS.Tables[0].Rows[i]["T_PARAID"].ToString() + "' and T_UNITID='" + unit_id + "' |" + DS.Tables[0].Rows[i]["T_PARAID"].ToString();
num_add++;
}
}
string sql = str_pel + str_P0_t + str_T0_t;
IList <Hashtable> listdata = new List <Hashtable>();
int num_pin = 0;
string sql_pin = "", str_sql = "", str_where = "";
Hashtable ht = new Hashtable();
for (int i = 0; i < append_sql.Length; i++)
{
if (append_sql[i] != null)
{
//if (num_pin==0)
//{
// //sql_pin = "select " + append_sql[i].Split('|')[2].ToString() + ".D_VALUE as " + append_sql[i].Split('|')[3].ToString() + ",q.D_VALUE as Pel," + append_sql[i].Split('|')[2].ToString() + ".T_DATETIME as T_DATETIME from " + append_sql[i].Split('|')[2].ToString() + " inner join (" + sql + ") as q on " + append_sql[i].Split('|')[2].ToString() + ".T_DATETIME =q.T_DATETIME" + append_sql[i].Split('|')[1].ToString();
// //num_pin++;
//}
//else
//{
str_sql += "(" + append_sql[i].Split('|')[0].ToString() + ") as " + append_sql[i].Split('|')[1].ToString() + ",";
if (i != append_sql.Length - 1)
{
str_where += "s.T_DATETIME=" + append_sql[i].Split('|')[1].ToString() + ".T_DATETIME and ";
}
else
{
str_where += "s.T_DATETIME=" + append_sql[i].Split('|')[1].ToString() + ".T_DATETIME ";
}
//}
}
}
if (str_where != "")
{
string sql_str = "select s.D_VALUE as Pel,s.D_CAPABILITY,ss.D_VALUE,ss.b_D_VALUE,sss.D_VALUE,sss.c_D_VALUE,Eta_b.D_VALUE as Eta_b, Eta_M.D_VALUE as Eta_M,q_fd.D_VALUE as q_fd,Eta_H.D_VALUE as Eta_H,b_g.D_VALUE as b_g, Rho.D_VALUE as Rho,s.T_DATETIME as T_DATETIME from " + sql + " ," + str_sql.TrimEnd(',') + " where s.T_DATETIME = ss.T_DATETIME and s.T_DATETIME = sss.T_DATETIME and " + str_where.Remove(str_where.Length - 5, 5) + " and s.T_DATETIME between '" + stime + "' and '" + etime + "' order by s.T_DATETIME asc ";
DS = DBdb2.RunDataSet(sql_str, out errMsg);
foreach (DataRow row in DS.Tables[0].Rows)
{
if ((row["Pel"].ToString() != "-9999") && (row["Eta_b"].ToString() != "-9999") && (row["Eta_M"].ToString() != "-9999") && (row["q_fd"].ToString() != "-9999") && (row["b_g"].ToString() != "-9999") && (row["Eta_b"].ToString() != "-9999") && (row["Rho"].ToString() != "-9999") && (Convert.ToDouble(row["Pel"].ToString()) / Convert.ToDouble(row[1].ToString()) > (Convert.ToDouble(per.Split('|')[0]))) && (Convert.ToDouble(row[0].ToString()) / Convert.ToDouble(row[1].ToString()) < (Convert.ToDouble(per.Split('|')[1]))) && (Math.Abs(Convert.ToDouble(row[2].ToString()) - Convert.ToDouble(row[3].ToString())) / Convert.ToDouble(row[3].ToString()) < 0.05) && (Math.Abs(Convert.ToDouble(row[4].ToString()) - Convert.ToDouble(row[5].ToString())) / Convert.ToDouble(row[5].ToString()) < 0.05))
{
ht = new Hashtable();
ht.Add("Pel", Math.Round(Convert.ToDouble(row["Pel"].ToString()), 3));
ht.Add("Eta_b", Math.Round(Convert.ToDouble(row["Eta_b"].ToString()), 3));
ht.Add("Eta_M", Math.Round(Convert.ToDouble(row["Eta_M"].ToString()), 3));
ht.Add("q_fd", Math.Round(Convert.ToDouble(row["q_fd"].ToString()), 3));
ht.Add("b_g", Math.Round(Convert.ToDouble(row["b_g"].ToString()), 3));
ht.Add("Eta_H", Math.Round(Convert.ToDouble(row["Eta_H"].ToString()), 3));
ht.Add("Rho", Math.Round(Convert.ToDouble(row["Rho"].ToString()), 3));
ht.Add("T_DATETIME", row["T_DATETIME"].ToString());
listdata.Add(ht);
}
}
}
errMsg = "";
return(listdata);
}
public IList <Hashtable> Get_Required_data(string unit_id, string[] para_id, string per, string stime, string etime, out string errMsg, out string max_data, out string min_data)
{
this.init();
errMsg = ""; max_data = ""; min_data = "";
ArrayList list = new ArrayList();
string str_pel = "", str_P0_t = "", str_T0_t = "";// str_b_g = "", str_q_fd = "", str_Eta_H = "", str_Eta_M = "", str_Rho = "", str_Eta_b = ""
DataSet DS = new DataSet();
//SELECT T_PARAID,T_OUTTABLE FROM ADMINISTRATOR.T_BASE_CALCPARA where T_UNITID ='GZTZ-01' and (T_PARAID ='Pel' or T_PARAID='P0_t_el_B' or T_PARAID='P0_t' or T_PARAID='T0_t' or T_PARAID='T0_t_el_B')
string sql_Required = "select T_PARAID,T_DESC,T_OUTTABLE from T_BASE_CALCPARA where T_UNITID ='" + unit_id + "' and (T_PARAID ='Pel' or T_PARAID='P0_t_el_B' or T_PARAID='P0_t' or T_PARAID='T0_t' or T_PARAID='T0_t_el_B'";
for (int i = 0; i < para_id.Length; i++)
{
sql_Required += " or T_PARAID='" + para_id[i].ToString() + "' ";
}
sql_Required += ")";
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql_Required, out errMsg);
}
string[] append_sql = new string[DS.Tables[0].Rows.Count]; //呈现曲线sql语句
for (int i = 0; i < DS.Tables[0].Rows.Count; i++)
{
string out_table = "";
if (DS.Tables[0].Rows[i]["T_OUTTABLE"].ToString() == "")
{
out_table = "T_INFO_CALCDATA";
}
else
{
out_table = DS.Tables[0].Rows[i]["T_OUTTABLE"].ToString();
}
if (DS.Tables[0].Rows[i]["T_PARAID"].ToString() == "Pel")
{
str_pel = "(select D_VALUE,a.D_CAPABILITY,T_DATETIME from " + out_table + ", (select T_UNITID,\"D_CAPABILITY\" from T_BASE_UNIT where T_UNITID ='" + unit_id + "') as a where a.T_UNITID = T_INFO_CALCDATA.T_UNITID and T_INFO_CALCDATA.T_PARAID = 'Pel' ) as s ";
}
else if ((DS.Tables[0].Rows[i]["T_PARAID"].ToString() == "P0_t") || (DS.Tables[0].Rows[i]["T_PARAID"].ToString() == "P0_t_el_B"))
{
str_P0_t = ",(select " + out_table + ".D_VALUE,b.D_VALUE as b_D_VALUE, " + out_table + ".T_DATETIME from " + out_table + " inner join (select D_VALUE,T_DATETIME from " + out_table + " where T_PARAID ='P0_t_el_B') as b " +
"on " + out_table + ".T_DATETIME = b.T_DATETIME and " + out_table + ".T_PARAID ='P0_t' and T_UNITID ='" + unit_id + "' ) as ss ";
}
else if ((DS.Tables[0].Rows[i]["T_PARAID"].ToString() == "T0_t") || (DS.Tables[0].Rows[i]["T_PARAID"].ToString() == "T0_t_el_B"))
{
str_T0_t = ",(select " + out_table + ".D_VALUE,c.D_VALUE as c_D_VALUE," + out_table + ".T_DATETIME from " + out_table + " inner join (select D_VALUE ,T_DATETIME from " + out_table + " where T_PARAID ='T0_t_el_B') as c" +
" on " + out_table + ".T_DATETIME = c.T_DATETIME and " + out_table + ".T_PARAID ='T0_t' and T_UNITID ='" + unit_id + "' ) as sss ";
}
else
{
for (int j = 0; j < para_id.Length; j++)
{
if (para_id[j] == DS.Tables[0].Rows[i]["T_PARAID"].ToString())
{
//append_sql[j] = "select " + DS.Tables[0].Rows[i]["T_OUTTABLE"].ToString() + ".D_VALUE," + DS.Tables[0].Rows[i]["T_OUTTABLE"].ToString() + ".T_DATETIME from " + DS.Tables[0].Rows[i]["T_OUTTABLE"].ToString() + " | where T_PARAID='" + DS.Tables[0].Rows[i]["T_PARAID"].ToString() + "' and T_UNITID='" + unit_id + "' |" + DS.Tables[0].Rows[i]["T_OUTTABLE"].ToString();
append_sql[j] = ",(select " + out_table + ".D_VALUE," + out_table + ".T_DATETIME from " + out_table + " where T_PARAID='" + DS.Tables[0].Rows[i]["T_PARAID"].ToString() + "' and T_UNITID='" + unit_id + "') as ssss |" + DS.Tables[0].Rows[i]["T_DESC"].ToString();
break;
}
}
}
}
//string sql = "select s.D_VALUE,s.T_DATETIME from "+str_pel+str_P0_t+str_T0_t;
string str_sql = "";
str_sql = "select s.D_VALUE,s.D_CAPABILITY,ss.D_VALUE,ss.b_D_VALUE,sss.D_VALUE,sss.c_D_VALUE,s.T_DATETIME from " + str_pel + str_P0_t + str_T0_t + "where s.T_DATETIME = ss.T_DATETIME and s.T_DATETIME = sss.T_DATETIME and s.T_DATETIME between '" + stime + "' and '" + etime + "' order by s.T_DATETIME asc ";
IList <Hashtable> listdata = new List <Hashtable>();
Hashtable ht = new Hashtable();
for (int i = 0; i < para_id.Length; i++)
{
if (para_id[i].ToString() == "Pel")
{
ht = new Hashtable();
ht.Add("name", "机组负荷");
ht.Add("yAxis", i);
ArrayList ld = new ArrayList();
ArrayList lt = new ArrayList();
DS = DBdb2.RunDataSet(str_sql, out errMsg);
if (DS.Tables[0].Rows.Count > 0)
{
double max_data1 = Convert.ToDouble(DS.Tables[0].Rows[0][0].ToString());
double min_data1 = Convert.ToDouble(DS.Tables[0].Rows[0][0].ToString());
for (int j = 0; j < DS.Tables[0].Rows.Count; j++)
{
if ((DS.Tables[0].Rows[j][0].ToString() != "- 9999") && (Convert.ToDouble(DS.Tables[0].Rows[j][0].ToString()) / Convert.ToDouble(DS.Tables[0].Rows[j][1].ToString()) > (Convert.ToDouble(per.Split('|')[0]))) && (Convert.ToDouble(DS.Tables[0].Rows[j][0].ToString()) / Convert.ToDouble(DS.Tables[0].Rows[j][1].ToString()) < (Convert.ToDouble(per.Split('|')[1]))) && (Math.Abs(Convert.ToDouble(DS.Tables[0].Rows[j][2].ToString()) - Convert.ToDouble(DS.Tables[0].Rows[j][3].ToString())) / Convert.ToDouble(DS.Tables[0].Rows[j][3].ToString()) < 0.05) && (Math.Abs(Convert.ToDouble(DS.Tables[0].Rows[j][4].ToString()) - Convert.ToDouble(DS.Tables[0].Rows[j][5].ToString())) / Convert.ToDouble(DS.Tables[0].Rows[j][5].ToString()) < 0.05))
{
ld = new ArrayList();
ld.Add(DateTimeToUTC(DateTime.Parse(DS.Tables[0].Rows[j][6].ToString())));
ld.Add(Math.Round(Convert.ToDouble(DS.Tables[0].Rows[j][0].ToString()), 3));
lt.Add(ld);
if (max_data1 < Convert.ToDouble(DS.Tables[0].Rows[j][0].ToString()))
{
max_data1 = Convert.ToDouble(DS.Tables[0].Rows[j][0].ToString());
}
if (min_data1 > Convert.ToDouble(DS.Tables[0].Rows[j][0].ToString()))
{
min_data1 = Convert.ToDouble(DS.Tables[0].Rows[j][0].ToString());
}
}
}
max_data = max_data1.ToString();
min_data = min_data1.ToString();
}
ht.Add("data", lt);
listdata.Add(ht);
}
}
for (int i = 0; i < append_sql.Length; i++)
{
if (append_sql[i] != null)
{
str_sql = "select s.D_VALUE,s.D_CAPABILITY,ss.D_VALUE,ss.b_D_VALUE,sss.D_VALUE,sss.c_D_VALUE,ssss.D_VALUE,s.T_DATETIME from " + str_pel + str_P0_t + str_T0_t + append_sql[i].Split('|')[0] + "where s.T_DATETIME = ss.T_DATETIME and s.T_DATETIME = sss.T_DATETIME and s.T_DATETIME = ssss.T_DATETIME and s.T_DATETIME between '" + stime + "' and '" + etime + "' order by s.T_DATETIME asc ";
if (rlDBType == "SQL")
{
}
else
{
ht = new Hashtable();
if (i < para_id.Length)
{
ht.Add("name", append_sql[i].Split('|')[1]);
//ht.Add("step", "left");
ht.Add("yAxis", i);
}
ArrayList ld = new ArrayList();
ArrayList lt = new ArrayList();
DS = DBdb2.RunDataSet(str_sql, out errMsg);
if (DS.Tables[0].Rows.Count > 0)
{
double max_data1 = Convert.ToDouble(DS.Tables[0].Rows[0][6].ToString());
double min_data1 = Convert.ToDouble(DS.Tables[0].Rows[0][6].ToString());
for (int j = 0; j < DS.Tables[0].Rows.Count; j++)
{
if ((DS.Tables[0].Rows[j][6].ToString() != "- 9999") && (Convert.ToDouble(DS.Tables[0].Rows[j][0].ToString()) / Convert.ToDouble(DS.Tables[0].Rows[j][1].ToString()) > (Convert.ToDouble(per.Split('|')[0]))) && (Convert.ToDouble(DS.Tables[0].Rows[j][0].ToString()) / Convert.ToDouble(DS.Tables[0].Rows[j][1].ToString()) < (Convert.ToDouble(per.Split('|')[1]))) && (Math.Abs(Convert.ToDouble(DS.Tables[0].Rows[j][2].ToString()) - Convert.ToDouble(DS.Tables[0].Rows[j][3].ToString())) / Convert.ToDouble(DS.Tables[0].Rows[j][3].ToString()) < 0.05) && (Math.Abs(Convert.ToDouble(DS.Tables[0].Rows[j][4].ToString()) - Convert.ToDouble(DS.Tables[0].Rows[j][5].ToString())) / Convert.ToDouble(DS.Tables[0].Rows[j][5].ToString()) < 0.05))
{
ld = new ArrayList();
ld.Add(DateTimeToUTC(DateTime.Parse(DS.Tables[0].Rows[j][7].ToString())));
ld.Add(Convert.ToDouble(DS.Tables[0].Rows[j][6].ToString()));
lt.Add(ld);
if (max_data1 < Convert.ToDouble(DS.Tables[0].Rows[j][6].ToString()))
{
max_data1 = Convert.ToDouble(DS.Tables[0].Rows[j][6].ToString());
}
if (min_data1 > Convert.ToDouble(DS.Tables[0].Rows[j][6].ToString()))
{
min_data1 = Convert.ToDouble(DS.Tables[0].Rows[j][6].ToString());
}
}
}
max_data += max_data1.ToString() + ",";
min_data += min_data1.ToString() + ",";
}
ht.Add("data", lt);
listdata.Add(ht);
}
}
}
return(listdata);
//return str_append;
}
public void Insert_data(string para)
{
this.init();
string errMsg = "";
DataSet DS = new DataSet();
string sql = "select * from 超温考核故障类型表 where 考核上限 =" + para.Split(',')[0] + " and 考核下限=" + para.Split(',')[1];
if (rlDBType == "SQL")
{
}
else
{
DS = DBdb2.RunDataSet(sql, out errMsg);
}
if (DS.Tables[0].Rows.Count > 0)
{
string sql1 = "update 超温考核故障类型表 set 提示信息 = '" + para.Split(',')[2] + "' where 考核上限 =" + para.Split(',')[0] + " and 考核下限=" + para.Split(',')[1];
if (rlDBType == "SQL")
{
}
else
{
bool falg = DBdb2.RunNonQuery(sql1, out errMsg);
}
string sql2 = "insert into 超温考核故障映射表(考核点ID,故障类型ID) values('" + para.Split(',')[3] + "','" + DS.Tables[0].Rows[0]["故障类型ID"].ToString() + "')";
bool falg1 = DBdb2.RunNonQuery(sql2, out errMsg);
}
else
{
string sql3 = "select 故障类型ID from 超温考核故障类型表 order by 故障类型ID desc fetch first 1 rows only";
DataSet DDS = new DataSet();
if (rlDBType == "SQL")
{
}
else
{
DDS = DBdb2.RunDataSet(sql3, out errMsg);
}
string str_sql3 = "";
if (DDS.Tables[0].Rows.Count > 0)
{
str_sql3 = (Convert.ToInt32(DDS.Tables[0].Rows[0][0].ToString()) + 1).ToString();
}
else
{
str_sql3 = "1";
}
string sql4 = "insert into 超温考核故障类型表(故障类型ID,考核下限,考核上限,过滤公式,公式参数,提示信息) values('" + str_sql3 + "'," + para.Split(',')[1] + "," + para.Split(',')[0] + ",'0','0','" + para.Split(',')[2] + "')";
string sql5 = "insert into 超温考核故障映射表(考核点ID,故障类型ID) values('" + para.Split(',')[3] + "','" + str_sql3 + "')";
if (rlDBType == "SQL")
{
}
else
{
bool falg2 = DBdb2.RunNonQuery(sql4, out errMsg);
bool falg3 = DBdb2.RunNonQuery(sql5, out errMsg);
}
}
}
