| | |
| | | /// </summary> |
| | | /// <param name="orderId">订单编号</param> |
| | | /// <returns></returns> |
| | | public IEnumerable<EC_OrderBasic> GetOrderByPrintTypeId(int PrintTypeId) |
| | | public IEnumerable<EC_OrderBasic> GetOrderByPrintTypeId(int PrintTypeId, Guid MemberId) |
| | | { |
| | | |
| | | IList<EC_OrderBasic> result = _dataBase.SelectModel<EC_OrderBasic>(" * ", "EC_OrderBasic ", string.Format(" PrintTypeId = {0} and (OrderState = 4 or OrderState = 2 or OrderState = 3 )", PrintTypeId)); |
| | | //string sss = "EC_OrderBasic" + string.Format(" PrintTypeId = {0} and SellerId = '{1}' and OrderTypeId=1 and (OrderState = 4 or OrderState = 2 or OrderState = 3 or OrderState = 1)", PrintTypeId, MemberId.ToString()); |
| | | IList<EC_OrderBasic> result = _dataBase.SelectModel<EC_OrderBasic>(" * ", "EC_OrderBasic ", string.Format(" PrintTypeId = {0} and SellerId = '{1}' and OrderTypeId=1 and (OrderState = 4 or OrderState = 2 or OrderState = 3 or OrderState = 1)", PrintTypeId, MemberId.ToString())); |
| | | return result; |
| | | } |
| | | |
| | |
| | | { |
| | | IList<EC_OrderBasic> result = new List<EC_OrderBasic>(); |
| | | |
| | | result = _dataBase.SelectModel<EC_OrderBasic>(" * ", "EC_OrderBasic ", string.Format(" BuyerId = '{0}' and PayState!={1} and SellerId = '{2}'", BuyerId,PayState, SellerId)); |
| | | result = _dataBase.SelectModel<EC_OrderBasic>(" * ", "EC_OrderBasic ", string.Format(" BuyerId = '{0}' and PayState!={1} and SellerId = '{2}' and [OrderState]!=0 and [OrderState] !=-2 ", BuyerId,PayState, SellerId)); |
| | | return result; |
| | | } |
| | | /// <summary> |