public override void OnPageLoad(object sender, EventArgs e) { model = new AdvEffectMonitorVM(); model.CompanyCode = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode; model.ChannelID = "1"; QuerySection.DataContext = model; this.dpkStartDate.SelectedRangeType = RangeType.Today; facade = new AdvEffectMonitorFacade(this); filter = new AdvEffectQueryFilter(); comIsPhone.ItemsSource = EnumConverter.GetKeyValuePairs <NYNStatus>(EnumConverter.EnumAppendItemType.All); comIsEmailConfirmed.ItemsSource = EnumConverter.GetKeyValuePairs <NYNStatus>(EnumConverter.EnumAppendItemType.All); comIsValidSO.ItemsSource = EnumConverter.GetKeyValuePairs <NYNStatus>(EnumConverter.EnumAppendItemType.All); CodeNamePairHelper.GetList("MKT", "AdvEffectMonitorOperationType", CodeNamePairAppendItemType.All, (obj2, args2) => { comOperationType.ItemsSource = args2.Result; //comOperationType.SelectedIndex = 0; }); CodeNamePairHelper.GetList("MKT", "SOAmtLevel", CodeNamePairAppendItemType.All, (obj2, args2) => { cbSOAmtLevel.ItemsSource = args2.Result; loadedSoAmtLevel = true; // cbSOAmtLevel.SelectionChanged += new EventHandler<SelectionChangedEventArgs>(cbShowComment_SelectionChanged); }); base.OnPageLoad(sender, e); }
private void Button_Search_Click(object sender, RoutedEventArgs e) { if (ValidationManager.Validate(this.QuerySection)) { filter = model.ConvertVM <AdvEffectMonitorVM, AdvEffectQueryFilter>(); filterVM = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <AdvEffectQueryFilter>(filter); QueryResultGrid.QueryCriteria = this.filter; QueryResultGrid.Bind(); } }
public virtual QueryResult QueryAdvEffect(AdvEffectQueryFilter filter) { int totalCount; var dataTable = ObjectFactory <IAdvertiserQueryDA> .Instance.QueryAdvEffect(filter, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
/// <summary> /// 查询广告效果 /// </summary> /// <param name="filter"></param> /// <param name="callback"></param> public void QueryAdvEffect(AdvEffectQueryFilter filter, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback) { filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo() { PageSize = PageSize, PageIndex = PageIndex, SortBy = SortField }; string relativeUrl = "/MKTService/AdvInfo/QueryAdvEffect"; //restClient.Query<AdvEffectQueryRsp>(relativeUrl, filter, callback); restClient.QueryDynamicData(relativeUrl, filter, callback); }
/// <summary> /// 数据全部导出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void QueryResultGrid_ExportAllClick(object sender, EventArgs e) { if (filterVM == null || this.QueryResultGrid.TotalCount < 1) { Window.Alert(ResNewsInfo.Information_ExportFailed); return; } ColumnSet col = new ColumnSet(this.QueryResultGrid); filter = model.ConvertVM <AdvEffectMonitorVM, AdvEffectQueryFilter>(); filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo() //这个PagingInfo是我们在ECCentral.BizEntity里自己定义的,只有这3个属性 { PageSize = ConstValue.MaxRowCountLimit, PageIndex = 0, SortBy = string.Empty }; //col.Insert(0, "ProductId", ResRMAReports.Excel_ProductID, 20) .SetWidth("ProductName", 30); facade.ExportExcelFile(filterVM, new ColumnSet[] { col }); }
public void ExportExcelFile(AdvEffectQueryFilter filter, ColumnSet[] columns) { string relativeUrl = "/MKTService/AdvInfo/QueryAdvEffect"; restClient.ExportFile(relativeUrl, filter, columns); }
/// <summary> /// 广告效果查询 /广告总计的价格查询 /// </summary> /// <param name="filter"></param> /// <param name="totalCount"></param> /// <returns></returns> public DataTable QueryAdvEffect(AdvEffectQueryFilter filter, out int totalCount) { DataCommand cmd = DataCommandManager.GetDataCommand("AdvEffectMonitor_GetAdvEffectMonitorList"); string sortField = "SysNo"; string sortType = "Desc"; if (filter.InDateFrom.HasValue && filter.InDateTo.HasValue && filter.InDateFrom.Equals(filter.InDateTo)) { filter.InDateTo = filter.InDateTo.Value.AddDays(1); } if (filter.PageInfo != null && !string.IsNullOrEmpty(filter.PageInfo.SortBy)) { sortField = filter.PageInfo.SortBy.Split(' ')[0].ToString(); sortType = filter.PageInfo.SortBy.Split(' ')[1].ToString(); } cmd.SetParameterValue("@SortField", sortField); cmd.SetParameterValue("@SortType", sortType); cmd.SetParameterValue("@PageSize", filter.PageInfo.PageSize); cmd.SetParameterValue("@PageCurrent", filter.PageInfo.PageIndex); cmd.SetParameterValue("@CompanyCode", filter.CompanyCode); cmd.SetParameterValue("@OperationType", string.Format("%{0}%", filter.OperationType)); cmd.SetParameterValue("@CMP", string.Format("%{0}%", filter.CMP)); cmd.SetParameterValue("@IsPhone", filter.IsPhone); cmd.SetParameterValue("@IsEmailConfirmed", filter.IsEmailConfirmed); cmd.SetParameterValue("@CreateDateFrom", filter.InDateFrom); cmd.SetParameterValue("@CreateDateTo", filter.InDateTo); cmd.SetParameterValue("@SOID", string.Format("%{0}%", filter.SOID)); cmd.SetParameterValue("@CustomerID", string.Format("%{0}%", filter.CustomerID)); cmd.SetParameterValue("@IsValidSO", filter.IsValidSO.HasValue ? (int)filter.IsValidSO : -1); cmd.SetParameterValue("@SOStatus", filter.SOStatus.HasValue ? (int)filter.SOStatus : -999); if (filter.SOStatus == ECCentral.BizEntity.SO.SOStatus.OutStock && filter.IsRefund.HasValue) { cmd.SetParameterValue("@IsRefundSO", (int)filter.IsRefund); } else { cmd.SetParameterValue("@IsRefundSO", -1); } cmd.SetParameterValue("@MinSOAmt", filter.MinSOAmt); cmd.SetParameterValue("@MaxSOAmt", filter.MaxSOAmt); EnumColumnList enumList = new EnumColumnList(); enumList.Add("IsPhone", typeof(ECCentral.BizEntity.MKT.NYNStatus)); enumList.Add("IsEmailConfirmed", typeof(ECCentral.BizEntity.MKT.NYNStatus)); DataTable dt = cmd.ExecuteDataTable(enumList); if (dt != null && dt.Rows.Count > 0) { totalCount = Convert.ToInt32(cmd.GetParameterValue("TotalCount")); DataColumn dc = new DataColumn("TotalSOAmount", typeof(decimal)); dt.Columns.Add(dc); dt.Rows[0]["TotalSOAmount"] = Convert.ToDecimal(cmd.GetParameterValue("@TotalSOAmt")); return(dt); } else { totalCount = 0; return(dt); } //PagingInfoEntity pagingEntity = new PagingInfoEntity(); //pagingEntity.SortField = filter.PageInfo.SortBy; //pagingEntity.MaximumRows = filter.PageInfo.PageSize; //pagingEntity.StartRowIndex = filter.PageInfo.PageIndex * filter.PageInfo.PageSize; //var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("AdvEffectMonitor_GetAdvEffectMonitorList"); //using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "A.SysNo DESC")) //{ // //sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ChannelID", DbType.String, "@ChannelID", QueryConditionOperatorType.Equal, filter.ChannelID); // sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "A.CreateDate", DbType.DateTime, "@CreateDate", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThanOrEqual, filter.InDateFrom, filter.InDateTo); // //sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "(SO.SysNo IS NULL OR (SO.SOType <> 4 AND SO.SOType <> 5))"); // sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.CMP", DbType.String, "@CMP", QueryConditionOperatorType.Like, filter.CMP); // sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.CompanyCode", DbType.String, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); // sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.OperationType", DbType.String, "@OperationType", QueryConditionOperatorType.Like, filter.OperationType); // sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "CI.CustomerID", DbType.String, "@CustomerID", QueryConditionOperatorType.Equal, filter.CustomerID); // sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.ReferenceSysNo", DbType.Int32, "@ReferenceSysNo", QueryConditionOperatorType.Equal, filter.SOSysNo); // sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "CI.IsEmailConfirmed", DbType.Int32, "@IsEmailConfirmed", QueryConditionOperatorType.Equal, filter.IsEmailConfirmed); // sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "CC.Status", DbType.Int32, "@CellPhoneConfirmed", QueryConditionOperatorType.Equal, filter.CellPhoneConfirmed); // //订单有效性 // if (filter.IsValidSO == ECCentral.BizEntity.MKT.YNStatus.Yes) // sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "(SO.Status NOT IN (0,1,2,3,4,-6) OR (SO.Status = 4 AND SO.HaveAutoRMA=1) OR (SO.Status IS NULL AND A.OperationType NOT LIKE '%InstalmentOrder%' AND A.OperationType NOT LIKE '%Register%'))"); // else if (filter.IsValidSO == ECCentral.BizEntity.MKT.YNStatus.No) // sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "(SO.Status IN (0,1,2,3,-6) OR (SO.Status = 4 AND (SO.HaveAutoRMA <> 1 )))");//SO.HaveAutoRMA <> 1 OR SO.HaveAutoRMA IS NULL // //订单状态 // if (filter.Status != -999) // { // if (filter.Status != -99) // sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "SO.Status", DbType.Int32, "@SOStatus", QueryConditionOperatorType.Equal, filter.Status); // else // sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "SO.Status = 4 AND SO.HaveAutoRMA = 1"); // } // //if (filter.Status == 4) // // sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "(SO.HaveRefund IS NULL)"); // if (filter.MaxSOAmt > 0 && filter.MinSOAmt >= 0) // sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "(" + filter.MinSOAmt + " < SO.SOAmt - SO.DiscountAmt AND " + filter.MaxSOAmt + " >= SO.SOAmt - SO.DiscountAmt)"); // else if (filter.MaxSOAmt == 0 && filter.MinSOAmt == 0) // sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "(SO.SOAmt - SO.DiscountAmt <= 0)"); // cmd.CommandText = sqlBuilder.BuildQuerySql(); // EnumColumnList enumList = new EnumColumnList(); // enumList.Add("SOStatus", typeof(ECCentral.BizEntity.SO.SOStatus)); // enumList.Add("CellPhoneConfirmed", typeof(ECCentral.BizEntity.MKT.NYNStatus)); // enumList.Add("IsEmailConfirmed", typeof(ECCentral.BizEntity.MKT.NYNStatus)); // enumList.Add("Rank", typeof(ECCentral.BizEntity.Customer.CustomerRank)); // //CodeNamePairColumnList pairList = new CodeNamePairColumnList(); // //pairList.Add("SOAmtLevel", "MKT", "SOAmtLevel"); // var dt = cmd.ExecuteDataTable(enumList);//, pairList); // totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); // foreach (DataRow dr in dt.Rows) // { // decimal SOAmount = decimal.Parse(dr[1].ToString()); // if (SOAmount == 0) // dr["ShowSOAmtLevel"] = "Z"; // else if (0 < SOAmount && SOAmount < 100) // dr["ShowSOAmtLevel"] = "A"; // else if (100 < SOAmount && SOAmount < 300) // dr["ShowSOAmtLevel"] = "B"; // else if (300 < SOAmount && SOAmount < 500) // dr["ShowSOAmtLevel"] = "C"; // else if (500 < SOAmount && SOAmount < 800) // dr["ShowSOAmtLevel"] = "D"; // else if (800 < SOAmount && SOAmount < 1000) // dr["ShowSOAmtLevel"] = "E"; // else if (1000 < SOAmount && SOAmount < 1500) // dr["ShowSOAmtLevel"] = "F"; // else if (1500 < SOAmount && SOAmount < 2000) // dr["ShowSOAmtLevel"] = "G"; // else if (2000 < SOAmount && SOAmount < 3000) // dr["ShowSOAmtLevel"] = "H"; // else if (3000 < SOAmount && SOAmount < 5000) // dr["ShowSOAmtLevel"] = "I"; // else if (5000 < SOAmount && SOAmount < 8000) // dr["ShowSOAmtLevel"] = "J"; // else if (8000 < SOAmount && SOAmount < 10000) // dr["ShowSOAmtLevel"] = "K"; // else // dr["ShowSOAmtLevel"] = "L"; // } // return dt; //} }