/// <summary>
/// 得到区间值,实体形式
/// </summary>
/// <returns></returns>
public static List <KPI_XLineEntity> GetAllXLineEntity()
{
List <KPI_XLineEntity> ltxls = new List <KPI_XLineEntity>();
string sql = @"SELECT ECID, ECCode, ECXLineType, ECXLineGetType,
ECXLineXRealTag, ECXLineYRealTag, ECXLineZRealTag, ECXLineXYZ, ECCurveGroup
FROM KPI_ECTag WHERE ECIsValid=1 ORDER BY ECCode ";
using (DataTable dt = DBAccess.GetRelation().ExecuteDataset(sql).Tables[0]) {
foreach (DataRow dr in dt.Rows)
{
string ecid = dr["ECID"].ToString();
string eccode = dr["ECCode"].ToString();
int xlinetype = int.Parse(dr["ECXLineType"].ToString());
int xlinegettype = int.Parse(dr["ECXLineGetType"].ToString());
string xlinexyz = dr["ECXLineXYZ"].ToString();
DataTable dtXLine = new DataTable();
double dout = 0.0;
//XYZ Tag不加''，因为有默认机组负荷的情况下，为空。
bool bResult = GetXLineXYZ(xlinetype, xlinexyz, out dtXLine, out dout);
if (xlinetype == 0)
{
KPI_XLineEntity entity = new KPI_XLineEntity();
entity.XLineID = Guid.NewGuid().ToString();
entity.ECID = ecid;
entity.ECCode = eccode;
entity.ECCurveGroup = "";
entity.XLineMonth = "";
entity.XLineCoef = "a1";
entity.XLineGet = xlinegettype;
entity.XLineXBase = "";
entity.XLineYBase = "";
entity.XLineX = 0;
entity.XLineY = 0;
entity.XLineValue = dout;
ltxls.Add(entity);
}
if (xlinetype == 1)
{
string xrealtag = dr["ECXLineXRealTag"].ToString();
//xrealtag = KPI_RealTagDal.GetRealCode(xrealtag);
//xrealtag = "'" + xrealtag + "'";
for (int i = 1; i < dtXLine.Rows.Count; i++)
{
for (int j = 1; j < dtXLine.Columns.Count; j++)
{
KPI_XLineEntity entity = new KPI_XLineEntity();
entity.XLineID = Guid.NewGuid().ToString();
entity.ECID = ecid;
entity.ECCode = eccode;
entity.ECCurveGroup = "";
entity.XLineMonth = "";
entity.XLineCoef = "a" + i.ToString();
entity.XLineGet = xlinegettype;
entity.XLineXBase = xrealtag;
entity.XLineYBase = "";
entity.XLineX = double.Parse(dtXLine.Rows[0][j].ToString());
entity.XLineY = 0;
entity.XLineValue = double.Parse(dtXLine.Rows[i][j].ToString());
ltxls.Add(entity);
}
}
}
if (xlinetype == 2)
{
//可以是默认的机组负荷点，所以为空。
string xrealtag = dr["ECXLineXRealTag"].ToString();
//xrealtag = KPI_RealTagDal.GetRealCode(xrealtag);
//xrealtag = "'" + xrealtag + "'";
string yrealtag = dr["ECXLineYRealTag"].ToString();
//yrealtag = KPI_RealTagDal.GetRealCode(yrealtag);
//yrealtag = "'" + yrealtag + "'";
for (int i = 1; i < dtXLine.Rows.Count; i++)
{
for (int j = 1; j < dtXLine.Columns.Count; j++)
{
KPI_XLineEntity entity = new KPI_XLineEntity();
entity.XLineID = Guid.NewGuid().ToString();
entity.ECID = ecid;
entity.ECCode = eccode;
entity.ECCurveGroup = "";
entity.XLineMonth = "";
entity.XLineCoef = "a1";
entity.XLineGet = xlinegettype;
entity.XLineXBase = xrealtag;
entity.XLineYBase = yrealtag;
entity.XLineX = double.Parse(dtXLine.Rows[0][j].ToString());
entity.XLineY = double.Parse(dtXLine.Rows[i][0].ToString());
entity.XLineValue = double.Parse(dtXLine.Rows[i][j].ToString());
ltxls.Add(entity);
}
}
}
//////////////////////////////////////////////////
//==3忽略
if (xlinetype == 4)
{
//在CurveDal中直接生成 XLineEntity
string curvegroup = dr["ECCurveGroup"].ToString();
List <KPI_XLineEntity> ltcurve = new List <KPI_XLineEntity>();
//因为这里不用判断是否正确，故传0进入，判断条件始终不成立即可。
//numbers
ltcurve = CurveTagDal.GetAllXLineEntity(ecid, eccode, curvegroup, 0);
ltxls.AddRange(ltcurve);
}
}
}
return(ltxls);
}
/// <summary>
/// 得到区间值,实体形式
/// </summary>
/// <returns></returns>
public static bool CheckEntityForXline(ECTagEntity ltone)
{
try {
List <KPI_XLineEntity> ltxls = new List <KPI_XLineEntity>();
string ecid = ltone.ECID;
string eccode = ltone.ECCode;
int xlinetype = ltone.ECXLineType;
int xlinegettype = ltone.ECXLineGetType;
string xlinexyz = ltone.ECXLineXYZ;
string ecscoreexp = ltone.ECScoreExp;
DataTable dtXLine = new DataTable();
double dout = 0.0;
//XYZ Tag不加''，因为有默认机组负荷的情况下，为空。
int anum = 0;
if (ecscoreexp.Contains("@a8"))
{
anum += 1;
}
if (ecscoreexp.Contains("@a7"))
{
anum += 1;
}
if (ecscoreexp.Contains("@a6"))
{
anum += 1;
}
if (ecscoreexp.Contains("@a5"))
{
anum += 1;
}
if (ecscoreexp.Contains("@a4"))
{
anum += 1;
}
if (ecscoreexp.Contains("@a3"))
{
anum += 1;
}
if (ecscoreexp.Contains("@a2"))
{
anum += 1;
}
if (ecscoreexp.Contains("@a1"))
{
anum += 1;
}
bool bResult = GetXLineXYZ(xlinetype, xlinexyz, out dtXLine, out dout);
if (xlinetype == 0)
{
KPI_XLineEntity entity = new KPI_XLineEntity();
entity.XLineID = Guid.NewGuid().ToString();
entity.ECID = ecid;
entity.ECCode = eccode;
entity.ECCurveGroup = "";
entity.XLineMonth = "";
entity.XLineCoef = "a1";
entity.XLineGet = xlinegettype;
entity.XLineXBase = "";
entity.XLineYBase = "";
entity.XLineX = 0;
entity.XLineY = 0;
entity.XLineValue = dout;
if (anum > 1)
{
return(false);
}
ltxls.Add(entity);
}
else if (xlinetype == 1)
{
string xrealtag = ltone.ECXLineXRealTag;
//xrealtag = KPI_RealTagDal.GetRealCode(xrealtag);
//xrealtag = "'" + xrealtag + "'";
for (int i = 1; i < dtXLine.Rows.Count; i++)
{
for (int j = 1; j < dtXLine.Columns.Count; j++)
{
KPI_XLineEntity entity = new KPI_XLineEntity();
entity.XLineID = Guid.NewGuid().ToString();
entity.ECID = ecid;
entity.ECCode = eccode;
entity.ECCurveGroup = "";
entity.XLineMonth = "";
entity.XLineCoef = "a" + i.ToString();
entity.XLineGet = xlinegettype;
entity.XLineXBase = xrealtag;
entity.XLineYBase = "";
entity.XLineX = double.Parse(dtXLine.Rows[0][j].ToString());
entity.XLineY = 0;
entity.XLineValue = double.Parse(dtXLine.Rows[i][j].ToString());
ltxls.Add(entity);
}
}
if (anum > (dtXLine.Rows.Count - 1))
{
return(false);
}
}
else if (xlinetype == 2)
{
//可以是默认的机组负荷点，所以为空。
string xrealtag = ltone.ECXLineXRealTag;
//xrealtag = KPI_RealTagDal.GetRealCode(xrealtag);
//xrealtag = "'" + xrealtag + "'";
string yrealtag = ltone.ECXLineYRealTag;
//yrealtag = KPI_RealTagDal.GetRealCode(yrealtag);
//yrealtag = "'" + yrealtag + "'";
for (int i = 1; i < dtXLine.Rows.Count; i++)
{
for (int j = 1; j < dtXLine.Columns.Count; j++)
{
KPI_XLineEntity entity = new KPI_XLineEntity();
entity.XLineID = Guid.NewGuid().ToString();
entity.ECID = ecid;
entity.ECCode = eccode;
entity.ECCurveGroup = "";
entity.XLineMonth = "";
entity.XLineCoef = "a1";
entity.XLineGet = xlinegettype;
entity.XLineXBase = xrealtag;
entity.XLineYBase = yrealtag;
entity.XLineX = double.Parse(dtXLine.Rows[0][j].ToString());
entity.XLineY = double.Parse(dtXLine.Rows[i][0].ToString());
entity.XLineValue = double.Parse(dtXLine.Rows[i][j].ToString());
ltxls.Add(entity);
}
}
if (anum > 1)
{
return(false);
}
}
//////////////////////////////////////////////////
//==3忽略
else if (xlinetype == 4)
{
//在CurveDal中直接生成 XLineEntity
string curvegroup = ltone.ECCurveGroup;
List <KPI_XLineEntity> ltcurve = new List <KPI_XLineEntity>();
ltcurve = CurveTagDal.GetAllXLineEntity(ecid, eccode, curvegroup, anum);
if (ltcurve == null)
{
return(false);
}
ltxls.AddRange(ltcurve);
}
return(true);
}
catch (Exception) {
return(false);
}
}
/// <summary>
/// 得到区间值,实体形式
/// </summary>
/// <returns></returns>
public static List <KPI_XLineEntity> GetAllXLineEntity(string ecid, string eccode, string curvegroup, int numbers)
{
//
//numbers 在查询时为0， 在校验时 为 系数数量。
List <KPI_XLineEntity> ltxls = new List <KPI_XLineEntity>();
string sql = @"select CurveID, CurveCode, CurveMonth, CurveType, CurveGetType, CurveXRealTag, CurveYRealTag, CurveZRealTag, CurveXYZ
from KPI_CurveTag
where CurveIsValid=1 {0}";
string condition = " and CurveGroup='" + curvegroup + "'";
sql = string.Format(sql, condition);
DataTable dt = DBAccess.GetRelation().ExecuteDataset(sql).Tables[0];
foreach (DataRow dr in dt.Rows)
{
int xlinetype = int.Parse(dr["CurveType"].ToString());
int xlinegettype = int.Parse(dr["CurveGetType"].ToString());
string xlinemonth = dr["CurveMonth"].ToString();
string xlinexyz = dr["CurveXYZ"].ToString();
DataTable dtXLine = new DataTable();
double dout = 0.0;
bool bResult = GetXLineXYZ(xlinetype, xlinexyz, out dtXLine, out dout);
if (xlinetype == 0)
{
KPI_XLineEntity entity = new KPI_XLineEntity();
entity.XLineID = Guid.NewGuid().ToString();
////////////////////////////////////////////////////////////////
//notice
entity.ECID = ecid;
entity.ECCode = eccode;
entity.ECCurveGroup = curvegroup;
entity.XLineMonth = "," + xlinemonth + ",";
entity.XLineCoef = "a1";
entity.XLineGet = xlinegettype;
entity.XLineXBase = "";
entity.XLineYBase = "";
entity.XLineX = 0;
entity.XLineY = 0;
entity.XLineValue = dout;
if (numbers > 1)
{
return(null);
}
ltxls.Add(entity);
}
else if (xlinetype == 1)
{
string xrealtag = dr["CurveXRealTag"].ToString();
//xrealtag = KPI_RealTagDal.GetRealCode(xrealtag);
//xrealtag = "'" + xrealtag + "'";
for (int i = 1; i < dtXLine.Rows.Count; i++)
{
for (int j = 1; j < dtXLine.Columns.Count; j++)
{
KPI_XLineEntity entity = new KPI_XLineEntity();
entity.XLineID = Guid.NewGuid().ToString();
////////////////////////////////////////////////////////////////
//notice
entity.ECID = ecid;
entity.ECCode = eccode;
entity.ECCurveGroup = curvegroup;
entity.XLineMonth = "," + xlinemonth + ",";
entity.XLineCoef = "a" + i.ToString();
entity.XLineGet = xlinegettype;
entity.XLineXBase = xrealtag;
entity.XLineYBase = "";
entity.XLineX = double.Parse(dtXLine.Rows[0][j].ToString());
entity.XLineY = 0;
entity.XLineValue = double.Parse(dtXLine.Rows[i][j].ToString());
ltxls.Add(entity);
}
}
if (numbers > (dtXLine.Rows.Count - 1))
{
return(null);
}
}
else if (xlinetype == 2)
{
string xrealtag = dr["CurveXRealTag"].ToString();
//xrealtag = KPI_RealTagDal.GetRealCode(xrealtag);
//xrealtag = "'" + xrealtag + "'";
string yrealtag = dr["CurveYRealTag"].ToString();
//yrealtag = KPI_RealTagDal.GetRealCode(yrealtag);
//yrealtag = "'" + yrealtag + "'";
for (int i = 1; i < dtXLine.Rows.Count; i++)
{
for (int j = 1; j < dtXLine.Columns.Count; j++)
{
KPI_XLineEntity entity = new KPI_XLineEntity();
entity.XLineID = Guid.NewGuid().ToString();
////////////////////////////////////////////////////////////////
//notice
entity.ECID = ecid;
entity.ECCode = eccode;
entity.ECCurveGroup = curvegroup;
entity.XLineMonth = "," + xlinemonth + ",";
entity.XLineCoef = "a1";
entity.XLineGet = xlinegettype;
entity.XLineXBase = xrealtag;
entity.XLineYBase = yrealtag;
entity.XLineX = double.Parse(dtXLine.Rows[0][j].ToString());
entity.XLineY = double.Parse(dtXLine.Rows[i][0].ToString());
entity.XLineValue = double.Parse(dtXLine.Rows[i][j].ToString());
ltxls.Add(entity);
}
}
if (numbers > 1)
{
return(null);
}
}
break;
}
return(ltxls);
}
