public double H(double Temp, String Input2, double RHi_or_Omega, double[,] SourceTableData)
{
int FirstRow = 2801;//一般已知干球温度和相对湿度
double FirstRowValue = -40;
double FirstColValue = 0;
if (Input2 == "Omega") //有时已知干球温度和含湿量
{
FirstRow = 0; //除了求Omega，其他FirstRow都在表头所在行
}
double res = -1000;
Interpolator interpolate = new Interpolator();
if (Input2 != "Omega")
{
double deta_X = 0.1;
double deta_Y = 0.01;
int dig_X = 1;
int dig_Y = 2;
res = interpolate.Interpolate(FirstRow, FirstRowValue, FirstColValue, Temp, RHi_or_Omega, deta_X, deta_Y, dig_X, dig_Y, SourceTableData);//已知干球温度和相对湿度插值
}
else
{
double deta_X = 0.05;
double deta_Y = 0.0002;
int dig_X = 2;
int dig_Y = 4;
res = interpolate.Interpolate(FirstRow, FirstRowValue, FirstColValue, Temp, RHi_or_Omega, deta_X, deta_Y, dig_X, dig_Y, SourceTableData);//已知干球温度和相对湿度插值
}
return(res * 1000);
}
public double Ts(double H, double[,] SourceTableData)//求Tdp
{
int FirstRow = 11112;
//Model.OpenExcel OpenExcel = new Model.OpenExcel();
//DataRowCollection rowCollection = OpenExcel.ExcelRowCollection(tableCollection);//取得工作表中所有的行
double res = -1000;
double deta_X = 0.05;
int dig_X = 2;
Interpolator interpolate = new Interpolator();
res = interpolate.Interpolate_Ts(FirstRow, H / 1000, deta_X, dig_X, SourceTableData);//插值
return(res);
}
public double Cp(double Temp, double RHi, double[,] SourceTableData)
{
int FirstRow = 4203;
double FirstRowValue = -40;
double FirstColValue = 0;
//Model.OpenExcel OpenExcel = new Model.OpenExcel();
//DataRowCollection rowCollection = OpenExcel.ExcelRowCollection(tableCollection);//取得工作表中所有的行
double res = -1000;
double deta_X = 0.1;
double deta_Y = 0.01;
int dig_X = 1;
int dig_Y = 2;
Interpolator interpolate = new Interpolator();
res = interpolate.Interpolate(FirstRow, FirstRowValue, FirstColValue, Temp, RHi, deta_X, deta_Y, dig_X, dig_Y, SourceTableData);//插值
return(res * 1000);
}
public double RHI_TwetBulb(double Temp, double Twetbulb, double[,] SourceTableData)
{
int FirstRow;
double FirstColValue;
double FirstRowValue = 0;
if (Twetbulb < 37.5)
{
FirstRow = 29915;
FirstColValue = 0;
}
else
{
FirstRow = 30518;
FirstColValue = 37.5;
}
//Model.OpenExcel OpenExcel = new Model.OpenExcel();
//DataRowCollection rowCollection = OpenExcel.ExcelRowCollection(tableCollection);//取得工作表中所有的行
double res = -1000;
double deta_X = 0.15;
double deta_Y = 0.15;
int dig_X = 2;
int dig_Y = 2;
Interpolator interpolate = new Interpolator();
if (Twetbulb < 0)
{
res = 0; return(res);
}
else
{
res = interpolate.Interpolate(FirstRow, FirstRowValue, FirstColValue, Temp, Twetbulb, deta_X, deta_Y, dig_X, dig_Y, SourceTableData);
if (res > 1)
{
res = 1;
}
return(res);
}//-40是因为后面在Interpolator加了40，并非formal修改方法
}
public double RHI(double Temp, double Tdp, double[,] SourceTableData)
{
int FirstRow = 8409;//一般已知干球温度和相对湿度
double FirstRowValue = -40;
double FirstColValue = -60;
double res = -1000;
Interpolator interpolate = new Interpolator();
double deta_X = 0.05;
double deta_Y = 0.5;
int dig_X = 2;
int dig_Y = 1;
res = interpolate.Interpolate(FirstRow, FirstRowValue, FirstColValue, Temp, Tdp, deta_X, deta_Y, dig_X, dig_Y, SourceTableData);//已知干球温度和相对湿度插值
//if (res > 1)
//{
// res = 1;
//}
return(res);
}