public EmergentOrder QueryEmergentOrder(decimal id, DataTransferObject.Order.OrderStatus status)
{
EmergentOrder emergentOrder = new EmergentOrder();
string sql = "select Id,[Type],Content,[Time],Account from T_EmergentOrder WHERE Id =@Id AND [Type] = @Type";
using (DbOperator dboperator = new DbOperator(Provider, ConnectionString))
{
dboperator.AddParameter("Id", id);
dboperator.AddParameter("Type", status);
using (System.Data.Common.DbDataReader reader = dboperator.ExecuteReader(sql))
{
if (reader.Read())
{
emergentOrder.Id = reader.GetDecimal(0);
emergentOrder.Type = (DataTransferObject.Order.OrderStatus)reader.GetInt32(1);
emergentOrder.Content = reader.GetString(2);
emergentOrder.Time = reader.GetDateTime(3);
emergentOrder.Account = reader.GetString(4);
}
}
}
return(emergentOrder);
}
/// <summary>
/// 查询
/// </summary>
/// <param name="id">单子号</param>
/// <param name="status">订单状态</param>
/// <returns>紧急信息</returns>
public static EmergentOrder GetEmergentOrder(decimal id, DataTransferObject.Order.OrderStatus status)
{
var repository = Factory.CreateCoordinationRepository();
return(repository.QueryEmergentOrder(id, status));
}
