日期:2014-05-20 浏览次数:20917 次
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));
}