public DataTable EIMSEventMemoQuery(EIMSEventMemoQueryFilter filter, out int totalCount)
{
CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("EIMSEventMemoQuery");
using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, HelpDA.ToPagingInfo(filter.PagingInfo), "EventDate DESC"))
{
AddEIMSEventMemoQueryParameters(filter, sb, cmd);
DataTable dt = cmd.ExecuteDataTable();
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
private void AddEIMSEventMemoQueryParameters(EIMSEventMemoQueryFilter filter, DynamicQuerySqlBuilder sb, CustomDataCommand cmd)
{
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode);
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "b.EventType", DbType.Int32, "@EventType", QueryConditionOperatorType.Equal, 195);
string tempMemo = string.Empty;
if (!string.IsNullOrEmpty(filter.Memo))
{
tempMemo = filter.Memo.Replace(" ", "%");
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "b.EventMemo", DbType.String, "@EventMemo", QueryConditionOperatorType.Like, "%" + tempMemo + "%");
}
if (filter.BeginDate.HasValue)
{
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "b.EventDate", DbType.String, "@BDate", QueryConditionOperatorType.MoreThanOrEqual, filter.BeginDate);
}
if (filter.EndDate.HasValue)
{
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "b.EventDate", DbType.String, "@EDate", QueryConditionOperatorType.LessThanOrEqual, filter.EndDate.Value.ToShortDateString() + " 23:59:59");
}
cmd.AddInputParameter("@PageSize", DbType.Int32, filter.PagingInfo.PageSize);
cmd.AddInputParameter("@PageIndex", DbType.Int32, filter.PagingInfo.PageIndex);
cmd.CommandText = sb.BuildQuerySql();
}
public override void OnPageLoad(object sender, EventArgs e)
{
base.OnPageLoad(sender, e);
m_QueryFacde = new EIMSOrderMgmtFacade(this);
spCondition.DataContext = m_QueryFilter = new EIMSEventMemoQueryFilter();
}
/// <summary>
/// EIMS结算类型变更单据查询
/// </summary>
/// <param name="filter">查询条件集合</param>
/// <param name="callback">回调函数</param>
public void QueryEIMSEventMemo(EIMSEventMemoQueryFilter filter, EventHandler <RestClientEventArgs <dynamic> > callback)
{
string relativeUrl = "ExternalSYSService/ExternalSYS/QueryEIMSEventMemo";
restClient.QueryDynamicData(relativeUrl, filter, callback);
}
public void ExportEventMemo(EIMSEventMemoQueryFilter filter, ColumnSet[] columns)
{
filter.CompanyCode = CPApplication.Current.CompanyCode;
restClient.ExportFile("/ExternalSYSService/ExternalSYS/QueryEIMSEventMemo", filter, columns);
}
public QueryResult QueryEIMSEventMemo(EIMSEventMemoQueryFilter filter)
{
return(QueryList <EIMSEventMemoQueryFilter>(filter, ObjectFactory <IEIMSEventMemoQueryFilterDA> .Instance.EIMSEventMemoQuery));
}
