/// <summary>
/// 获取每个风机所在的风场信息，返回各个风机所在风场信息的数组，如果个别风机没查到风场信息，数组元素为null
/// </summary>
/// <param name="wpList">所有风机的集合</param>
/// <returns>返回所有风机对应的风场，返回值为风场数组</returns>
public static AllWindField[] GetWindFieldInformationOfPoints(List <FanPoint> fpList)
{
//创建风场数组，用于存储所有风机的风场信息，数组长度为风机个数
AllWindField[] awfArray = new AllWindField[fpList.Count];
for (int i = 0; i < fpList.Count; i++)
{
//去数据库查询当前风机对应的风场信息，正确结果只有一个
DataTable table = SqlHelper.ExecuteDataTable(ConnStr_SensorData,
"select * from T_AllWindField where BranchTableName=@BranchTableName and WindFieldName=@WindFieldName",
new SqlParameter("@BranchTableName", fpList[i].CurrentTableName),
new SqlParameter("@WindFieldName", fpList[i].WindFieldName));
if (table.Rows.Count <= 0)
{
//没查到对应的风场信息
awfArray[i] = null;
continue;
}
DataRow row = table.Rows[0];
awfArray[i] = new AllWindField();
awfArray[i].BranchTableName = (string)row["BranchTableName"];
awfArray[i].CompanyName = (string)row["CompanyName"];
awfArray[i].WindFieldName = (string)row["WindFieldName"];
awfArray[i].Province = (string)SqlHelper.FromDBValue(row["Province"]);
awfArray[i].City = (string)SqlHelper.FromDBValue(row["City"]);
awfArray[i].DetailAddress = (string)SqlHelper.FromDBValue(row["DetailAddress"]);
awfArray[i].FanCount = (int)SqlHelper.FromDBValue(row["FanCount"]);
awfArray[i].FanType = (string)SqlHelper.FromDBValue(row["FanType"]);
awfArray[i].FanModelNumber = (string)SqlHelper.FromDBValue(row["FanModelNumber"]);
awfArray[i].FanHeight = (string)SqlHelper.FromDBValue(row["FanHeight"]);
awfArray[i].AnemoscopeModelNumber = (string)SqlHelper.FromDBValue(row["AnemoscopeModelNumber"]);
awfArray[i].SignalKind = (string)SqlHelper.FromDBValue(row["SignalKind"]);
}
return(awfArray);
}
/// <summary>
/// 根据公司名和风场名获得该风场的详细信息
/// </summary>
/// <param name="companyName"></param>
/// <param name="windFieldName"></param>
/// <returns></returns>
public static AllWindField GetWindFieldByName(string companyName, string windFieldName)
{
DataTable table = SqlHelper.ExecuteDataTable(ConnStr_SensorData,
"select * from T_AllWindField where CompanyName=@CompanyName and WindFieldName=@WindFieldName",
new SqlParameter("@CompanyName", companyName),
new SqlParameter("@WindFieldName", windFieldName));
if (table.Rows.Count <= 0)
{
return(null);
}
else
{
//创建风场对象
AllWindField windField = new AllWindField();
DataRow row = table.Rows[0];
windField = new AllWindField();
windField.BranchTableName = (string)row["BranchTableName"];
windField.CompanyName = (string)row["CompanyName"];
windField.WindFieldName = (string)row["WindFieldName"];
windField.Province = (string)SqlHelper.FromDBValue(row["Province"]);
windField.City = (string)SqlHelper.FromDBValue(row["City"]);
windField.DetailAddress = (string)SqlHelper.FromDBValue(row["DetailAddress"]);
windField.FanCount = (int)SqlHelper.FromDBValue(row["FanCount"]);
windField.FanType = (string)SqlHelper.FromDBValue(row["FanType"]);
windField.FanModelNumber = (string)SqlHelper.FromDBValue(row["FanModelNumber"]);
windField.FanHeight = (string)SqlHelper.FromDBValue(row["FanHeight"]);
windField.AnemoscopeModelNumber = (string)SqlHelper.FromDBValue(row["AnemoscopeModelNumber"]);
windField.SignalKind = (string)SqlHelper.FromDBValue(row["SignalKind"]);
return(windField);
}
}
/// <summary>
/// 向数据库中插入新数据
/// </summary>
/// <param name="awf"></param>
public static int InsertData(AllWindField awf)
{
//返回受影响的行数
return(SqlHelper.ExecuteNonQuery(ConnStr_SensorData,
@"insert into T_AllWindField(BranchTableName,CompanyName,WindFieldName,Province,City,
DetailAddress,FanType,FanCount,FanModelNumber,FanHeight,AnemoscopeModelNumber,SignalKind)
values(@BranchTableName,@CompanyName,@WindFieldName,@Province,@City,@DetailAddress,
@FanType,@FanCount,@FanModelNumber,@FanHeight,@AnemoscopeModelNumber,@SignalKind)",
new SqlParameter("@BranchTableName", awf.BranchTableName),
new SqlParameter("@CompanyName", awf.CompanyName),
new SqlParameter("@WindFieldName", awf.WindFieldName),
new SqlParameter("@Province", awf.Province),
new SqlParameter("@City", awf.City),
new SqlParameter("@DetailAddress", SqlHelper.ToDBValue(awf.DetailAddress)),
new SqlParameter("@FanType", SqlHelper.ToDBValue(awf.FanType)),
new SqlParameter("@FanCount", SqlHelper.ToDBValue(awf.FanCount)),
new SqlParameter("@FanModelNumber", SqlHelper.ToDBValue(awf.FanModelNumber)),
new SqlParameter("@FanHeight", SqlHelper.ToDBValue(awf.FanHeight)),
new SqlParameter("@AnemoscopeModelNumber", SqlHelper.ToDBValue(awf.AnemoscopeModelNumber)),
new SqlParameter("@SignalKind", SqlHelper.ToDBValue(awf.SignalKind))));
}
/// <summary>
/// 获取某省某市对应业主的风场名称，若city=null，则只获取省内对应业主的风场名称
/// </summary>
/// <param name="province"></param>
/// <param name="city"></param>
/// <param name="companyName"></param>
/// <returns></returns>
public static AllWindField[] GetWindFieldNameAndFanCountByPlace(string province, string city, string companyName)
{
DataTable table;
if (city == null)
{
//获取省内对应业主的风场名称和风机数量
table = SqlHelper.ExecuteDataTable(ConnStr_SensorData,
"select WindFieldName,FanCount from T_AllWindField where Province=@Province and CompanyName=@CompanyName",
new SqlParameter("@Province", province),
new SqlParameter("@CompanyName", companyName));
}
else
{
//获取某省某市对应业主的风场名称和风机数量
table = SqlHelper.ExecuteDataTable(ConnStr_SensorData,
"select WindFieldName,FanCount from T_AllWindField where Province=@Province and @City=City and CompanyName=@CompanyName",
new SqlParameter("@Province", province),
new SqlParameter("@City", city),
new SqlParameter("@CompanyName", companyName));
}
if (table.Rows.Count <= 0)
{
//数据为空
return(null);
}
else
{
AllWindField[] windField = new AllWindField[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
windField[i] = new AllWindField();
windField[i].WindFieldName = (string)table.Rows[i]["WindFieldName"];
windField[i].FanCount = (int)table.Rows[i]["FanCount"];
}
return(windField);
}
}
/// <summary>
/// 根据公司名获取对应的风场名称和风机数量
/// </summary>
/// <param name="companyName"></param>
/// <returns></returns>
public static AllWindField[] GetWindFieldNameAndFanCountByCompanyName(string companyName)
{
DataTable table = SqlHelper.ExecuteDataTable(ConnStr_SensorData,
"select WindFieldName,FanCount from T_AllWindField where CompanyName=@CompanyName",
new SqlParameter("@CompanyName", companyName));
if (table.Rows.Count <= 0)
{
//数据为空
return(null);
}
else
{
AllWindField[] windField = new AllWindField[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
windField[i] = new AllWindField();
windField[i].WindFieldName = (string)table.Rows[i]["WindFieldName"];
windField[i].FanCount = (int)table.Rows[i]["FanCount"];
}
return(windField);
}
}
