/// <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); }