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