private void BindImportSourceTypes()
{
this.LoadParameters();
ImportSourceTypeQuery importSourceTypeQuery = new ImportSourceTypeQuery
{
Remark = this.remark,
CnArea = this.cnArea,
EnArea = this.enArea,
PageSize = this.pager.PageSize,
PageIndex = this.pager.PageIndex,
SortOrder = SortAction.Desc,
SortBy = "DisplaySequence",
StartDate = this.startDate,
EndDate = this.endDate
};
Globals.EntityCoding(importSourceTypeQuery, true);
DbQueryResult importSourceTypes = ImportSourceTypeHelper.GetImportSourceTypes(importSourceTypeQuery);
this.grdImportSourceTypes.DataSource = importSourceTypes.Data;
this.grdImportSourceTypes.DataBind();
this.txtCnArea.Text = importSourceTypeQuery.CnArea;
this.txtEnArea.Text = importSourceTypeQuery.EnArea;
this.txtRemark.Text = importSourceTypeQuery.Remark;
this.pager1.TotalRecords = (this.pager.TotalRecords = importSourceTypes.TotalRecords);
}
/// <summary>
/// 查询
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public DbQueryResult GetImportSourceTypes(ImportSourceTypeQuery query)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" 1=1 ");
if (!string.IsNullOrEmpty(query.CnArea))
{
stringBuilder.AppendFormat(" AND CnArea LIKE '%{0}%'", DataHelper.CleanSearchString(query.CnArea));
}
if (!string.IsNullOrEmpty(query.EnArea))
{
stringBuilder.AppendFormat(" AND EnArea LIKE '%{0}%'", DataHelper.CleanSearchString(query.EnArea));
}
if (!string.IsNullOrEmpty(query.Remark))
{
stringBuilder.AppendFormat(" AND Remark LIKE '%{0}%'", DataHelper.CleanSearchString(query.Remark));
}
if (query.StartDate.HasValue)
{
stringBuilder.AppendFormat(" AND AddTime >='{0}'", DataHelper.GetSafeDateTimeFormat(query.StartDate.Value));
}
if (query.EndDate.HasValue)
{
stringBuilder.AppendFormat(" AND AddTime <='{0}'", DataHelper.GetSafeDateTimeFormat(query.EndDate.Value));
}
string selectFields = "ImportSourceId,Icon,EnArea,CnArea,Remark,DisplaySequence,AddTime,HSCode,FavourableFlag,StandardCName";
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Ecshop_ImportSourceType", "ImportSourceId", stringBuilder.ToString(), selectFields));
}
public static DbQueryResult GetImportSourceTypes(ImportSourceTypeQuery query)
{
return(new ImportSourceTypeDao().GetImportSourceTypes(query));
}