/// <summary> /// 获取计划变动日志 /// </summary> public InterfaceOutPut GetChangeTrainPlanLog(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InGetChangeTrainPlanLog InParams = javaScriptSerializer.Deserialize <InGetChangeTrainPlanLog>(Data); OutGetChangeTrainPlanLog OutParams = new OutGetChangeTrainPlanLog(); string strSql = "select * from TAB_Plan_ChangeLog where strTrainPlanGUID = @strTrainPlanGUID ORDER BY dtChangeTime DESC"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strTrainPlanGUID", InParams.TrainPlanGUID) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { TrainPlanChangeLog log = new TrainPlanChangeLog(); PS.PSPlan.TrainPlanChangeLogFromDB(log, dt.Rows[i]); OutParams.Logs.Add(log); } output.data = OutParams; output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.GetChangeTrainPlanLog:" + ex.Message); throw ex; } return(output); }
//从数据行中读取数据到TrainPlanChangeLog中 public static void TrainPlanChangeLogFromDB(TrainPlanChangeLog Log, DataRow dr) { Log.nid = ObjectConvertClass.static_ext_int(dr["nid"]); Log.strLogGUID = ObjectConvertClass.static_ext_string(dr["strLogGUID"]); Log.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]); Log.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]); Log.strTrainNumber = ObjectConvertClass.static_ext_string(dr["strTrainNumber"]); Log.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]); Log.dtStartTime = ObjectConvertClass.static_ext_Date(dr["dtStartTime"]); Log.strTrainJiaoluGUID = ObjectConvertClass.static_ext_string(dr["strTrainJiaoluGUID"]); Log.strTrainJiaoluName = ObjectConvertClass.static_ext_string(dr["strTrainJiaoluName"]); Log.strStartStation = ObjectConvertClass.static_ext_string(dr["strStartStation"]); Log.strStartStationName = ObjectConvertClass.static_ext_string(dr["strStartStationName"]); Log.strEndStation = ObjectConvertClass.static_ext_string(dr["strEndStation"]); Log.strEndStationName = ObjectConvertClass.static_ext_string(dr["strEndStationName"]); Log.nTrainmanTypeID = ObjectConvertClass.static_ext_int(dr["nTrainmanTypeID"]); Log.nPlanType = ObjectConvertClass.static_ext_int(dr["nPlanType"]); Log.nDragType = ObjectConvertClass.static_ext_int(dr["nDragType"]); Log.nKehuoID = ObjectConvertClass.static_ext_int(dr["nKehuoID"]); Log.nRemarkType = ObjectConvertClass.static_ext_int(dr["nRemarkType"]); Log.strRemark = ObjectConvertClass.static_ext_string(dr["strRemark"]); Log.nPlanState = ObjectConvertClass.static_ext_int(dr["nPlanState"]); Log.dtCreateTime = ObjectConvertClass.static_ext_Date(dr["dtCreateTime"]); Log.strOperateSiteGUID = ObjectConvertClass.static_ext_string(dr["strOperateSiteGUID"]); Log.strOperateSiteName = ObjectConvertClass.static_ext_string(dr["strOperateSiteName"]); Log.strOperateUserGUID = ObjectConvertClass.static_ext_string(dr["strOperateUserGUID"]); Log.strOperateUserName = ObjectConvertClass.static_ext_string(dr["strOperateUserName"]); Log.strOperateUserID = ObjectConvertClass.static_ext_string(dr["strOperateUserID"]); Log.dtChangeTime = ObjectConvertClass.static_ext_Date(dr["dtChangeTime"]); }