private void GetBrand(int?brandSysNo, string brandName) { BrandQueryFacade serviceFacade = new BrandQueryFacade(CurrentPage); BrandQueryFilter queryFilter = new BrandQueryFilter(); if (!string.IsNullOrEmpty(brandName)) { queryFilter.BrandNameLocal = brandName; } if (brandSysNo.HasValue) { queryFilter.BrandSysNo = brandSysNo; } queryFilter.PagingInfo = new ECCentral.QueryFilter.Common.PagingInfo() { PageSize = 10, PageIndex = 0 }; serviceFacade.QueryBrands(queryFilter, (obj, args) => { if (args.FaultsHandle()) { return; } var vendorList = args.Result.Rows; if (vendorList != null) { List <dynamic> rows = vendorList.ToList(); if (rows.Count > 0) { var row = rows[0]; this.SelectedBrandSysNo = row.SysNo.ToString(); this.SelectedBrandName = row.BrandName_Ch; ManufacturerSysNo = row.ManufacturerSysNo; ManufacturerName = row.ManufacturerName; if (selectedBrandCompletedHandler != null) { EventArgs argse = new EventArgs(); selectedBrandCompletedHandler(obj, args); } } else { txtBrandNameLocal.Text = ""; txtBrandSysNo.Text = ""; this.SelectedBrandSysNo = ""; this.SelectedBrandName = ""; } } else { txtBrandNameLocal.Text = ""; txtBrandSysNo.Text = ""; this.SelectedBrandSysNo = ""; this.SelectedBrandName = ""; } }); }
/// <summary> /// 查询品牌 /// </summary> /// <returns></returns> public virtual DataTable QueryBrand(BrandQueryFilter queryCriteria, out int totalCount) { CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("GetBrandListByQuery"); dataCommand.SetParameterValue("@BrandName", string.IsNullOrEmpty(queryCriteria.BrandNameLocal)?null:string.Format("%{0}%", queryCriteria.BrandNameLocal)); dataCommand.SetParameterValue("@ManufacturerName", string.IsNullOrEmpty(queryCriteria.ManufacturerName) ? null : string.Format("%{0}%", queryCriteria.ManufacturerName)); dataCommand.SetParameterValue("@Status", queryCriteria.Status); dataCommand.SetParameterValue("@BrandSysNo", queryCriteria.BrandSysNo); dataCommand.SetParameterValue("@ManufacturerSysNo", queryCriteria.ManufacturerSysNo); dataCommand.SetParameterValue("@Category1SysNo", queryCriteria.Category1SysNo); dataCommand.SetParameterValue("@Category2SysNo", queryCriteria.Category2SysNo); dataCommand.SetParameterValue("@Category3SysNo", queryCriteria.Category3SysNo); dataCommand.SetParameterValue("@IsAuthorized", queryCriteria.IsAuthorized); dataCommand.SetParameterValue("@AuthorizedStatus", queryCriteria.AuthorizedStatus); dataCommand.SetParameterValue("@BrandStory", queryCriteria.IsBrandStory); dataCommand.SetParameterValue("@SortField", queryCriteria.PagingInfo.SortBy); dataCommand.SetParameterValue("@PageSize", queryCriteria.PagingInfo.PageSize); dataCommand.SetParameterValue("@PageCurrent", queryCriteria.PagingInfo.PageIndex); dataCommand.SetParameterValue("@Priority", queryCriteria.Priority == "" ? null : queryCriteria.Priority); EnumColumnList enumList = new EnumColumnList { { "Status", typeof(ValidStatus) }, }; DataTable dt = new DataTable(); dt = dataCommand.ExecuteDataTable(enumList); totalCount = (int)dataCommand.GetParameterValue("@TotalCount"); return(dt); }
public ActionResult AjaxQueryBrandList() { BrandQueryFilter qFilter = BuildQueryFilterEntity <BrandQueryFilter>(); var result = CommonService.QueryBrandList(qFilter); return(AjaxGridJson(result)); }
public void QueryAllBrand(EventHandler <RestClientEventArgs <dynamic> > callback) { BrandQueryFilter filter = new BrandQueryFilter(); filter.Status = ValidStatus.Active; filter.PagingInfo = new PagingInfo { PageSize = 100000, PageIndex = 0 }; string relativeUrl = "/IMService/Brand/QueryBrand"; restClient_IM.QueryDynamicData(relativeUrl, filter, (obj, args) => { if (args.FaultsHandle()) { return; } if (!(args == null || args.Result == null || args.Result.Rows == null)) { foreach (var item in args.Result.Rows) { item.IsChecked = false; } } callback(obj, args); } ); }
public UCBrandQuery() { InitializeComponent(); this.Loaded += new RoutedEventHandler(UCBrandQuery_Loaded); serviceFacade = new BrandQueryFacade(CurrentPage); queryFilter = new BrandQueryFilter(); }
static void Main(string[] args) { //初始化商家代理商品的数据,商家编号在appsetting的配置中 //所有的代理级别都是原厂 //init c3 Console.WriteLine("init c3..."); List <Nesoft.SellerPortal.Entity.Product.CategoryInfo> c1 = ProductMaintainService.GetAllCategory1List(); List <Nesoft.SellerPortal.Entity.Product.CategoryInfo> c2 = new List <Nesoft.SellerPortal.Entity.Product.CategoryInfo>(); List <Nesoft.SellerPortal.Entity.Product.CategoryInfo> c3 = new List <Nesoft.SellerPortal.Entity.Product.CategoryInfo>(); c1.ForEach(p => c2.AddRange(ProductMaintainService.GetAllCategory2List(p.SysNo))); c2.ForEach(p => c3.AddRange(ProductMaintainService.GetAllCategory3List(p.SysNo))); Console.WriteLine("C3 total is : {0}", c3.Count); //init brand Console.WriteLine("init brand..."); BrandQueryFilter filter = new BrandQueryFilter(); filter.Status = ValidStatus.Active; filter.PageIndex = 0; filter.PageSize = 100000; var brands = CommonService.QueryBrandList(filter); Console.WriteLine("brand total is : {0}", brands.ResultList.Count); brands.ResultList.ForEach(b => { c3.ForEach(c => { VendorAgentInfo agent = new VendorAgentInfo(); agent.C3SysNo = c.SysNo; agent.C3Name = c.CategoryName; //agent.C2SysNo = 10; agent.AgentLevel = "原厂"; agent.BrandInfo = new BrandInfo { SysNo = b.SysNo, BrandNameLocal = b.BrandNameLocal }; agent.Status = VendorAgentStatus.Draft; agent.CompanyCode = "8601"; AppendToSeller(new List <VendorAgentInfo> { agent }); }); }); Console.ReadKey(); }
public static QueryResult <BrandInfo> QueryBrandList(BrandQueryFilter queryFilter) { CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("GetBrandInfo"); using (var sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, queryFilter, "c.SysNo DESC")) { if (queryFilter.Status.HasValue) { if (queryFilter.Status.Value.ToString().Equals("Active")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.Status", DbType.StringFixedLength, "@Status", QueryConditionOperatorType.Equal, "A"); } else { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.Status", DbType.StringFixedLength, "@Status", QueryConditionOperatorType.Equal, "D"); } } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.BrandName_Ch", DbType.String, "@BrandName_Ch", QueryConditionOperatorType.Like, queryFilter.BrandName); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "m.ManufacturerName", DbType.String, "@ManufacturerName", QueryConditionOperatorType.Like, queryFilter.ManufacturerName); dataCommand.CommandText = sqlBuilder.BuildQuerySql(); List <BrandInfo> resultList = dataCommand.ExecuteEntityList <BrandInfo>(); int totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); return(new QueryResult <BrandInfo>() { PageInfo = new PageInfo() { PageIndex = queryFilter.PageIndex, PageSize = queryFilter.PageSize, TotalCount = totalCount, SortBy = queryFilter.SortFields }, ResultList = resultList }); } }
public QueryResult QueryBrandInfo(BrandQueryFilter request) { if (request == null) { throw new BizException(ResouceManager.GetMessageString("IM.Brand", "BrandCondtionIsNull")); } int totalCount; var dataTable = ObjectFactory <IBrandQueryDA> .Instance.QueryBrandInfo(request, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
private void btnChooseManufacturer_Click(object sender, RoutedEventArgs e) { UCManufacturerQuery selectDialog = new UCManufacturerQuery(); selectDialog.Dialog = CPApplication.Current.CurrentPage.Context.Window.ShowDialog("查询代理厂商", selectDialog, (obj, args) => { if (args.DialogResult == Newegg.Oversea.Silverlight.Controls.Components.DialogResultType.OK) { DynamicXml getSelectedManufacturer = args.Data as DynamicXml; if (null != getSelectedManufacturer) { this.SelectedManufacturerSysNo = getSelectedManufacturer["SysNo"].ToString(); this.SelectedManufacturerName = getSelectedManufacturer["ManufacturerNameLocal"].ToString(); BrandQueryFilter requestBrand = new BrandQueryFilter() { ManufacturerSysNo = int.Parse(SelectedManufacturerSysNo), ManufacturerName = SelectedManufacturerName, PagingInfo = new QueryFilter.Common.PagingInfo() { PageIndex = 0, PageSize = 1 } }; serviceFacade.QueryBrands(requestBrand, (obj2, args2) => { if (args2.FaultsHandle()) { return; } var brandList = args2.Result.Rows; if (null != brandList) { try { SelectedBrandSysNo = null != brandList[0]["SysNo"] ? brandList[0]["SysNo"].ToString() : string.Empty; SelectedBrandName = brandList[0]["BrandName_Ch"]; } catch { SelectedBrandSysNo = null; SelectedBrandName = null; } } }); } } }, new Size(750, 500)); }
public UCBrandQuery(string manufacturerSysNo, string manufacuturerName) { InitializeComponent(); this.Loaded += new RoutedEventHandler(UCBrandQuery_Loaded); serviceFacade = new VendorManufacturerFacade(CurrentPage); queryFilter = new BrandQueryFilter(); if (null == manufacturerSysNo || string.IsNullOrEmpty(manufacturerSysNo)) { queryFilter.ManufacturerSysNo = null; } else { queryFilter.ManufacturerSysNo = int.Parse(manufacturerSysNo); } queryFilter.ManufacturerName = (string.IsNullOrEmpty(manufacuturerName) ? string.Empty : manufacuturerName); this.txtManufacturerName.Text = queryFilter.ManufacturerName; }
public DataTable QueryBrandInfo(BrandQueryFilter queryCriteria, out int totalCount) { CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("GetBrandInfo"); var pagingInfo = new PagingInfoEntity { SortField = queryCriteria.PagingInfo.SortBy, StartRowIndex = queryCriteria.PagingInfo.PageIndex * queryCriteria.PagingInfo.PageSize, MaximumRows = queryCriteria.PagingInfo.PageSize }; using (var sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, "C.SysNo DESC")) { if (queryCriteria.Status != null) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "C.Status", DbType.StringFixedLength, "@Status", QueryConditionOperatorType.Equal, queryCriteria.Status.Value); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.BrandName_Ch", DbType.String, "@BrandName_Ch", QueryConditionOperatorType.Like, queryCriteria.BrandNameLocal); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "m.ManufacturerName", DbType.String, "@ManufacturerName", QueryConditionOperatorType.Like, queryCriteria.ManufacturerName); dataCommand.CommandText = sqlBuilder.BuildQuerySql(); EnumColumnList enumList = new EnumColumnList { { "Status", typeof(ValidStatus) }, }; DataTable dt = new DataTable(); dt = dataCommand.ExecuteDataTable(enumList); totalCount = (int)dataCommand.GetParameterValue("@TotalCount"); return(dt); } }
public void QueryBrand(EventHandler <RestClientEventArgs <dynamic> > callback) { //BrandQueryVM model = new BrandQueryVM(); //model.Status = ValidStatus.Active; //model.AuthorizedStatus = AuthorizedStatus.Active; int PageSize = int.MaxValue; int PageIndex = 0; string SortField = "case when Brand.Priority is null then 1 else 0 end,Brand.Priority"; BrandQueryFilter filter = new BrandQueryFilter(); //filter.Status = ValidStatus.Active; //filter.AuthorizedStatus = AuthorizedStatus.Active; filter.PagingInfo = new PagingInfo { PageSize = PageSize, PageIndex = PageIndex, SortBy = SortField }; string relativeUrl = "/IMService/Brand/QueryBrand"; restClient.QueryDynamicData(relativeUrl, filter, (obj, args) => { if (args.FaultsHandle()) { return; } //if (!(args == null || args.Result == null || args.Result.Rows == null)) //{ // foreach (var item in args.Result.Rows) // { // item.IsChecked = false; // } //} callback(obj, args); } ); }
public static QueryResult <BrandInfo> QueryBrandList(BrandQueryFilter queryFilter) { return(CommonDA.QueryBrandList(queryFilter)); }
void UCBrandPicker_Loaded(object sender, RoutedEventArgs e) { serviceFacade = new BrandQueryFacade(CurrentPage); queryFilter = new BrandQueryFilter(); this.Loaded -= UCBrandPicker_Loaded; }
public void QueryBrands(BrandQueryFilter request, EventHandler <RestClientEventArgs <dynamic> > callback) { string relativeUrl = "/IMService/Brand/QueryBrand"; restClient.QueryDynamicData(relativeUrl, request, callback); }
private void txtManufacturerSysNo_KeyDown(object sender, KeyEventArgs e) { if (e.Key == Key.Enter) { int manufacturerSysNo = 0; if (!int.TryParse(this.txtManufacturerSysNo.Text.Trim(), out manufacturerSysNo)) { CurrentWindow.Alert("无效的厂商编号!"); this.SelectedManufacturerName = null; this.SelectedManufacturerSysNo = null; this.txtManufacturerSysNo.Text = string.Empty; return; } serviceFacade.QueryManufacturerBySysNo(manufacturerSysNo.ToString(), (obj, args) => { if (args.FaultsHandle()) { return; } if (args.Result.ManufacturerNameLocal == null) { CurrentWindow.Alert("无效的厂商编号!"); this.SelectedManufacturerName = null; this.SelectedManufacturerSysNo = null; this.txtManufacturerSysNo.Text = string.Empty; return; } this.SelectedManufacturerSysNo = args.Result.SysNo.Value.ToString(); this.SelectedManufacturerName = args.Result.ManufacturerNameLocal.Content; BrandQueryFilter requestBrand = new BrandQueryFilter() { ManufacturerSysNo = int.Parse(SelectedManufacturerSysNo), ManufacturerName = SelectedManufacturerName, PagingInfo = new QueryFilter.Common.PagingInfo() { PageIndex = 0, PageSize = 1 } }; serviceFacade.QueryBrands(requestBrand, (obj2, args2) => { if (args2.FaultsHandle()) { return; } var brandList = args2.Result.Rows; if (null != brandList) { try { SelectedBrandSysNo = null != brandList[0]["SysNo"] ? brandList[0]["SysNo"].ToString() : string.Empty; SelectedBrandName = brandList[0]["BrandName_Ch"]; } catch { SelectedBrandName = null; SelectedBrandSysNo = null; } } }); }); } }