public virtual DataTable QueryCallsEventLog(CustomerCallsEventLogFilter filter, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); pagingEntity.SortField = filter.PagingInfo.SortBy; pagingEntity.MaximumRows = filter.PagingInfo.PageSize; pagingEntity.StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize; CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QueryCallsEventLog"); using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "SysNo DESC")) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "a.Customer_CallingSysNo", DbType.Int32, "@CallsEventsSysNo ", QueryConditionOperatorType.Equal, filter.CallsEventsSysNo); cmd.CommandText = sqlBuilder.BuildQuerySql(); EnumColumnList enunlist = new EnumColumnList(); enunlist.Add(3, typeof(CallsEventsStatus)); enunlist.Add(7, typeof(CustomerCallReason)); CodeNamePairColumnList cpList = new CodeNamePairColumnList(); cpList.Add(2, "Customer", "RecordOrigion"); DataTable dt = cmd.ExecuteDataTable(enunlist, cpList); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }
public QueryResult QueryCallsEventLog(CustomerCallsEventLogFilter query) { int totalCount; var dataTable = ObjectFactory <ICallingLogQueryDA> .Instance.QueryCallsEventLog(query, out totalCount); for (int i = 0; i < dataTable.Rows.Count; i++) { if (dataTable.Rows[i]["ReasonCodeSysNo"] != DBNull.Value) { int reasonCodeSysNo = (int)dataTable.Rows[i]["ReasonCodeSysNo"]; dataTable.Rows[i]["ReasonCodePath"] = ObjectFactory <CallsEventsAppService> .Instance.GetReasonCodePath(reasonCodeSysNo, query.CompanyCode); } } return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
private void dataGridLogList_LoadingDataSource(object sender, Newegg.Oversea.Silverlight.Controls.Data.LoadingDataEventArgs e) { CustomerCallsEventLogFilter filter = new CustomerCallsEventLogFilter(); filter.CompanyCode = CPApplication.Current.CompanyCode; filter.CallsEventsSysNo = viewModel.SysNo; filter.PagingInfo = new PagingInfo() { PageSize = e.PageSize, PageIndex = e.PageIndex, SortBy = e.SortField }; new CustomerCallingFacade(CPApplication.Current.CurrentPage).QueryCallsEventLog(filter, (obj, args) => { if (args.FaultsHandle()) { return; } dataGridLogList.ItemsSource = args.Result.Rows; dataGridLogList.TotalCount = args.Result.TotalCount; }); }
public void QueryCallsEventLog(CustomerCallsEventLogFilter filter, EventHandler <RestClientEventArgs <dynamic> > callback) { string relativeUrl = string.Format("/CustomerService/CallsEvents/QueryCallsEventLog"); restClient.QueryDynamicData(relativeUrl, filter, callback); }