日期:2014-05-20 浏览次数:20768 次
private LoadOperation<V_Store> LoadSampleEntities() { this.CanLoad = false; //return this.ds.Load(this.ds.GetV_StoreQuery().SortAndPageBy(this._view)); EntityQuery<V_Store> query = this.ds.GetV_StoreQuery(); if (!string.IsNullOrWhiteSpace(this.Tt_Company)) query = query.Where(e => e.co_Company.Contains(this.Tt_Company)); if (!string.IsNullOrWhiteSpace(this.Tt_Name)) query = query.Where(e => e.co_Name.Contains(this.Tt_Name)); if (!string.IsNullOrWhiteSpace(this.Tt_MPa)) query = query.Where(e => e.co_MPa.Contains(this.Tt_MPa)); if (!string.IsNullOrWhiteSpace(this.Tt_Spec)) query = query.Where(e => e.co_Spec.Contains(this.Tt_Spec)); if (!string.IsNullOrWhiteSpace(this.Tt_Mill)) query = query.Where(e => e.co_Mill.Contains(this.Tt_Mill)); if (!string.IsNullOrWhiteSpace(this.Tt_Remark)) query = query.Where(e => e.co_Remark.Contains(this.Tt_Remark)); if (!string.IsNullOrWhiteSpace(Tt_StartAmount)) {//数量 Decimal? SAmount = Decimal.Parse(Tt_StartAmount); query = query.Where(e => e.co_Amount >= SAmount); } if (!string.IsNullOrWhiteSpace(Tt_EndAmount)) { Decimal? EAmount = Decimal.Parse(Tt_EndAmount); query = query.Where(e => e.co_Amount <= EAmount); } if (!string.IsNullOrWhiteSpace(Tt_StartWeight)) {//重量 Decimal? SWeight = Decimal.Parse(Tt_StartWeight); query = query.Where(e => e.co_Weight >= SWeight); } if (!string.IsNullOrWhiteSpace(Tt_EndWeight)) { Decimal? EWeight = Decimal.Parse(Tt_EndWeight); query = query.Where(e => e.co_Weight <= EWeight); } if (!string.IsNullOrWhiteSpace(Dt_StartTime)) {//时间 DateTime? STime = DateTime.Parse(Dt_StartTime); query = query.Where(e => e.co_UpDateTime >= STime); } if (!string.IsNullOrWhiteSpace(Dt_EndTime)) { DateTime? ETime = DateTime.Parse(Dt_EndTime); query = query.Where(e => e.co_UpDateTime <= ETime); } if (Ci_IsZero) query = query.Where(e => e.co_Amount != 0 && e.co_Weight != 0); InvokeOperation<int> invokeOperation = ds.GetV_StoreWeightSum(query.SortAndPageBy(this._view)); 我想在这里再用上面的条件 return this.ds.Load(query.SortAndPageBy(this._view)); }