/// <summary>
/// 根据查询火车返回的字符串返回实体
/// </summary>
/// <param name="resultStr"></param>
/// <returns></returns>
public static QueryTrainResult GetQueryTrainResult(string resultStr)
{
var ss = resultStr.Split('|');
var result = new QueryTrainResult()
{
TrainNo = ss[2],
TrainNumber = ss[3],
StartCode = ss[4],
EndCode = ss[5],
QueryStartCode = ss[6],
QueryEndCode = ss[7],
GoTime = ss[8],
ComeTime = ss[9],
TimeSpan = ss[10]
};
return(result);
}
public static int InsertQueryTrainResult(QueryTrainResult entity)
{
var sql = "INSERT INTO QueryTrainResult(TrainNo,TrainNumber,StartCode,EndCode,QueryStartCode,QueryEndCode,GoTime,ComeTime,TimeSpan) ";
sql += "VALUES(@TrainNo,@TrainNumber,@StartCode,@EndCode,@QueryStartCode,@QueryEndCode,@GoTime,@ComeTime,@TimeSpan)";
var ps = new SqlParameter[]
{
new SqlParameter("@TrainNo", ((object)entity.TrainNo) ?? DBNull.Value),
new SqlParameter("@TrainNumber", ((object)entity.TrainNumber) ?? DBNull.Value),
new SqlParameter("@StartCode", ((object)entity.StartCode) ?? DBNull.Value),
new SqlParameter("@EndCode", ((object)entity.EndCode) ?? DBNull.Value),
new SqlParameter("@QueryStartCode", ((object)entity.QueryStartCode) ?? DBNull.Value),
new SqlParameter("@QueryEndCode", ((object)entity.QueryEndCode) ?? DBNull.Value),
new SqlParameter("@GoTime", ((object)entity.GoTime) ?? DBNull.Value),
new SqlParameter("@ComeTime", ((object)entity.ComeTime) ?? DBNull.Value),
new SqlParameter("@TimeSpan", ((object)entity.TimeSpan) ?? DBNull.Value)
};
return(ExecuteNonQuery(sql, ps));
}
