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