/// <summary>
/// 根据传入where条件获取风速记录
/// </summary>
/// <param name="where"></param>
/// <returns></returns>
public static StandardHandleRecord StandardHandle(string where)
{
string strSql = "select (select nStandardMinute from TAB_HandleStep where a.strStepID=strID) as nStandardMinute,a.* from View_StandardHandleFinish a where 1=1 " + where;
DataTable dtStandardHandle = SqlHelper.ExecuteDataset(searchmaster.GetSqlConnConfig("57"), CommandType.Text, strSql).Tables[0];
StandardHandleRecord StandardHandle = new StandardHandleRecord();
return(SetValue(StandardHandle, dtStandardHandle.Rows[0]));
}
public static StandardHandleRecord SetValue(StandardHandleRecord StandardHandle, DataRow dr)
{
if (dr != null)
{
StandardHandle.nID = PageBase.static_ext_string(dr["nID"]);
StandardHandle.strID = PageBase.static_ext_string(dr["strID"]);
StandardHandle.nStepType = PageBase.static_ext_int(dr["nStepType"]);
StandardHandle.strStepID = PageBase.static_ext_string(dr["strStepID"]);
StandardHandle.JiCheID = PageBase.static_ext_int(dr["JiCheID"]);
StandardHandle.dtBeginTime = PageBase.static_ext_date(dr["dtBeginTime"]);
StandardHandle.dtEndTime = PageBase.static_ext_date(dr["dtEndTime"]);
StandardHandle.nState = PageBase.static_ext_int(dr["nState"]);
StandardHandle.banCi = PageBase.static_ext_string(dr["banCi"]);
StandardHandle.ApanageId = PageBase.static_ext_int(dr["ApanageId"]);
StandardHandle.UnitId = PageBase.static_ext_int(dr["UnitId"]);
StandardHandle.DepartmentId = PageBase.static_ext_int(dr["DepartmentId"]);
StandardHandle.strUserNumber = PageBase.static_ext_string(dr["strUserNumber"]);
StandardHandle.strUserName = PageBase.static_ext_string(dr["strUserName"]);
StandardHandle.LocoType = PageBase.static_ext_string(dr["LocoType"]);
StandardHandle.LocoNum = PageBase.static_ext_string(dr["LocoNum"]);
StandardHandle.nStandardMinute = PageBase.static_ext_int(dr["nStandardMinute"]);
}
return(StandardHandle);
}
