private FreezeQueryCondition getCondition() { var parmater = new FreezeQueryCondition(); parmater.OrderId = StringUtility.ToNullableDecimal(txtOrderId.Text.Trim()); parmater.ApplyformId = StringUtility.ToNullableDecimal(txtApplyFormId.Text.Trim()); parmater.RequestDate = new Range <DateTime>(DateTime.Parse(txtStartDate.Text.Trim()), DateTime.Parse(txtEndDate.Text.Trim())); //DateTime.Parse(txtEndDate.Text.Trim()).AddDays(1).AddTicks(-1)); if (!string.IsNullOrWhiteSpace(ddlStatus.SelectedValue)) { parmater.Success = ddlStatus.SelectedValue == "1"; } if (!string.IsNullOrWhiteSpace(ddlFreezeType.SelectedValue)) { parmater.Type = (FreezeType)int.Parse(ddlFreezeType.SelectedValue); } return(parmater); }
public IEnumerable <FreezeBaseInfo> Query(FreezeQueryCondition condition, Pagination pagination) { var result = new List <FreezeBaseInfo>(); var fields = "[Type],Id,OrderId,ApplyformId,TradeNo,Account,Amount,FreezeNo,UnfreezeNo,RequestTime,Success,ProcessTime,Remark"; var catelog = "dbo.T_OrderFreeze"; var orderbyFiled = "ApplyformId DESC,RequestTime"; var where = new StringBuilder(); if (condition.OrderId.HasValue) { where.AppendFormat("OrderId={0} AND ", condition.OrderId.Value); } if (condition.ApplyformId.HasValue) { where.AppendFormat("ApplyformId={0} AND ", condition.ApplyformId.Value); } if (condition.Type.HasValue) { where.AppendFormat("[Type]={0} AND ", (byte)condition.Type.Value); } if (condition.Success.HasValue) { where.AppendFormat("Success={0} AND ", condition.Success.Value?1:0); } where.AppendFormat("RequestTime BETWEEN '{0}' AND '{1}'", condition.RequestDate.Lower.Date, condition.RequestDate.Upper.Date.AddDays(1).AddTicks(-1)); using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("@iField", fields); dbOperator.AddParameter("@iCatelog", catelog); dbOperator.AddParameter("@iCondition", where.ToString()); dbOperator.AddParameter("@iOrderBy", orderbyFiled); dbOperator.AddParameter("@iPagesize", pagination.PageSize); dbOperator.AddParameter("@iPageIndex", pagination.PageIndex); dbOperator.AddParameter("@iGetCount", pagination.GetRowCount); var totalCount = dbOperator.AddParameter("@oTotalCount"); totalCount.DbType = System.Data.DbType.Int32; totalCount.Direction = System.Data.ParameterDirection.Output; using (var reader = dbOperator.ExecuteReader("dbo.P_Pagination", System.Data.CommandType.StoredProcedure)) { while (reader.Read()) { FreezeBaseInfo item = null; var type = (FreezeType)reader.GetByte(0); if (type == FreezeType.Freeze) { item = new FreezeInfo(reader.GetGuid(1)) { TradeNo = getString(reader["TradeNo"]), No = getString(reader["FreezeNo"]) }; } else { item = new UnfreezeInfo(reader.GetGuid(1)) { FreezeNo = getString(reader["FreezeNo"]), No = getString(reader["UnfreezeNo"]) }; } item.OrderId = reader.GetDecimal(2); item.ApplyformId = reader.GetDecimal(3); item.Account = reader.GetString(5); item.Amount = reader.GetDecimal(6); item.RequestTime = reader.GetDateTime(9); item.Success = reader.GetBoolean(10); if (!reader.IsDBNull(11)) { item.ProcessedTime = reader.GetDateTime(11); } item.Remark = reader.IsDBNull(12) ? string.Empty : reader.GetString(12); result.Add(item); } } if (pagination.GetRowCount) { pagination.RowCount = (int)totalCount.Value; } } return(result); }
public static IEnumerable <FreezeBaseInfo> Query(FreezeQueryCondition condition, Pagination pagination) { var repository = Order.Repository.Factory.CreateFreezeRepository(); return(repository.Query(condition, pagination)); }