/// <summary>
/// 获得容量
/// </summary>
/// <param name="typ">1风场 2工期 3全部</param>
/// <param name="id">id</param>
/// <returns></returns>
private double GetRl(string typ, string id)
{
if (typ == "1")
{
sql = @"SELECT SUM(double(容量)) FROM
(select t.T_ORGID T_PERIODID,(select p.T_ORGID from ADMINISTRATOR.T_BASE_PERIOD p where p.T_PERIODID=t.T_ORGID) T_ORGID,t.容量
from ADMINISTRATOR.T_INFO_RL t )
where T_ORGID='" + id + "'";
}
else if (typ == "2")
{
sql = "select sum(double(容量)) from ADMINISTRATOR.T_INFO_RL where T_ORGID='" + id + "'";
}
else if (typ == "3")
{
sql = "select sum(double(容量)) from ADMINISTRATOR.T_INFO_RL where T_ORGID in('MGYYQ-YQ','FLDFDC-QB','MGYEQ-EQ','SDFDC-QB')";
}
object obj = dl.RunSingle(sql, out errMsg);
if (obj == null)
{
return(0);
}
else
{
return(double.Parse(obj.ToString()));
}
}
/// <summary>
/// 执行SQL语句
/// </summary>
/// <param name="name"></param>
public object GetOrder(string name, string tableName)
{
sql = "select max(I_SHOWID) from " + tableName + " where T_DCNAME='" + name + "'";
object obj = dl.RunSingle(sql, out errMsg); sql = "";
return(obj);
}
/// <summary>
/// 统计小时
/// </summary>
/// <param name="qsrq"></param>
/// <param name="jsrq"></param>
/// <param name="unit"></param>
/// <returns></returns>
public string tjxs(string qsrq, string jsrq, int unit)
{
object obj = null;
//this.init();
sql = " SELECT sum(运行小时) FROM 参数运行小时统计表 where 统计参数='统计时间' and 机组=" + unit + " and 时间>='" + qsrq + "' and 时间<'" + jsrq + "'";
obj = dl.RunSingle(sql, out errMsg);
//if (rtDBType == "SQL")
//{
// sql = " SELECT sum(运行小时) FROM 参数运行小时统计表 where 统计参数='统计时间' and 机组=" + unit + " and 时间>='" + qsrq + "' and 时间<'" + jsrq + "'";
// obj = DBsql.RunSingle(sql, out errMsg);
//}
//else if (rtDBType == "DB2")
//{
// sql = " SELECT sum(运行小时) FROM 参数运行小时统计表 where 统计参数='统计时间' and 机组=" + unit + " and 时间>='" + qsrq + "' and 时间<'" + jsrq + "'";
//}
if (obj != null && obj != "" && obj != " ")
{
if (obj.ToString() != "")
{
return(obj.ToString());
}
else
{
return("0");
}
}
else
{
return("0");
}
}
/// <summary>
/// 获得容量
/// </summary>
/// <param name="typ">1风场 2工期 3全部</param>
/// <param name="id">id</param>
/// <returns></returns>
private double GetRl(string typ, string id)
{
if (typ == "1")
{
sql = @"SELECT SUM(INT(容量)) FROM
(select t.T_ORGID T_PERIODID,(select p.T_ORGID from ADMINISTRATOR.T_BASE_PERIOD p where p.T_PERIODID=t.T_ORGID) T_ORGID,t.容量
from ADMINISTRATOR.T_INFO_RL t )
where T_ORGID='" + id + "'";
}
else if (typ == "2")
{
sql = "select sum(int(容量)) from ADMINISTRATOR.T_INFO_RL where T_ORGID='" + id + "'";
}
else if (typ == "3")
{
sql = "select sum(int(容量)) from ADMINISTRATOR.T_INFO_RL where T_ORGID='FDRL'";
}
else if (typ == "all")
{
sql = "select sum(int(容量)) from ADMINISTRATOR.T_INFO_RL where T_ORGID in ('FDRL','HDRL','SDRL','TYNRL','FBSRL','SRZRL')";
}
object obj = dl.RunSingle(sql, out errMsg);
if (obj == null)
{
return(0);
}
else
{
return(double.Parse(obj.ToString()));
}
}
/// <summary>
/// 创建数据表
/// </summary>
/// <param name="tableName">数据表名称</param>
/// <returns></returns>
public string createTable(string tableName)
{
sql = "if object_id(N'" + tableName + "',N'U') is not null print '存在' else print '不存在'";
obj = db.RunSingle(sql, out errMsg);
return(obj.ToString());
}
/// <summary>
/// 获得班值信息
/// </summary>
/// <returns></returns>
public string[] DutyValue(string date)
{
object obj = null;
string[] args = new string[3];
string[] sqls = new string[3];
sqls[0] = "SELECT 班组编号 FROM 排班表 WHERE (结束时间 = '" + date + " 7:59:59')";
sqls[1] = "SELECT 班组编号 FROM 排班表 WHERE (结束时间 = '" + date + " 15:59:59')";
sqls[2] = "SELECT 班组编号 FROM 排班表 WHERE (结束时间 = '" + date + " 23:59:59')";
for (int i = 0; i < 3; i++)
{
//if (rlDBType == "SQL")
// obj = DBsql.RunSingle(sqls[i], out errMsg);
//else if (rlDBType == "DB2")
// obj = DBdb2.RunSingle(sqls[i], out errMsg);
obj = dl.RunSingle(sqls[i], out errMsg);
if (obj != null)
{
args[i] = obj.ToString();
}
}
return(args);
}
/// <summary>
/// 获取机组实时负荷
/// </summary>
/// <param name="unitId"></param>
/// <returns></returns>
public double GetPower()
{
sql = "select T_POWERTAG from T_BASE_POINT_UNIT where T_UNITID='0'";
obj = db.RunSingle(sql, out errMsg);
if (obj != null)
{
val = GetPointVal(obj.ToString());
}
return(val);
}
/// <summary>
/// 最近容量
/// </summary>
/// <param name="unitId">机组编号</param>
/// <param name="sTime">最近时间</param>
/// <returns>最近时间点容量</returns>
public double GetNewestRL(string id, string time)
{
sql = "select 容量 from T_INFO_RL where T_ORGID='" + id + "' order by T_TIME desc fetch first 1 rows only";
obj = dl.RunSingle(sql, out errMsg);
if (obj != null)
{
val = Convert.ToDouble(obj);
}
return(val);
}
/// <summary>
/// 获取机组实时负荷
/// </summary>
/// <param name="unitId">机组编号</param>
/// <param name="sTime">开始时间</param>
/// <param name="eTime">结束时间</param>
/// <returns>最大负荷</returns>
public double GetTJPowerMax(string unitId, string sTime, string eTime)
{
sql = "select max(T_VALUE) from T_INFO_STATISCS where T_UNITID='" + unitId + "' and (T_TIME between '" + sTime + "' and '" + eTime + "')";
obj = db.RunSingle(sql, out errMsg);
if (obj != null)
{
val = Convert.ToDouble(obj);
}
return(val);
}
/// <summary>
/// 获取电量
/// </summary>
/// <param name="point"></param>
/// <param name="st"></param>
/// <param name="et"></param>
/// <returns></returns>
public object GetDLAll(string point, string st, string et)
{
sql = "select sum(VALUE) value from DAYDATA where PARAID='" + point + "' and (STATCALTIME between '" + st + "' and '" + et + "')";
obj = dl.RunSingle(sql, out errMsg);
return(obj);
}