List<trademark_category_asso> List_group = db. Select<trademark_category_asso> (exp). Skip (operation. Page-1) *operation. Limit). Take (operation. Limit). ToList (); List<Trademark_Category_AssoParams> List1 =NewList<trademark_category_assoparams>(); for(inti =0; i < List_group.count; i++) { for(intj = (i +1); J < List_group.count; J + +) { if(List_group[j]. ProductModelID = = List_group[i]. ProductModelID && List_group[j]. CategoryId = =List_group[i]. CategoryId) {list_group.removeat (j);//Remove the same itemi =0;//from the beginning to the heavy, if the array has a large number of duplicate items, only one-time deduplication does not solve the problem. This usage will slow down the efficiency 1/3j =0; } } } foreach(Trademark_category_asso AinchList_group) {trademark_category_assoparams param=NewTrademark_category_assoparams (); TRADEMARKCP CP=db. Select<TrademarkCP> (s = s.cptrademarkid = =a.trademarkcpid). FirstOrDefault (); PartCP1 PCP= db. Select<partcp1> (s = = S.cpnameid = =A.categoryid). FirstOrDefault (); Partcp CP1= db. Select<partcp> (s = = S.cptypeid = =PCP. Cptypeid). FirstOrDefault (); ProductModel pm= db. Select<productmodel> (s = = S.modelid = =a.productmodelid). FirstOrDefault (); Param. Bigcategoryid=CP1. Cptypeid; Param. Bigcategoryname=CP1. Parttypename; Param. CategoryId=PCP. Cpnameid; Param. CategoryName=PCP. PartName; Param. ProductModelID=pm. ModelID; Param. ProductModelName=pm. modelname; Param. Tcassoid=a.tcassoid; Param. Tcnote=A.tcnote; Param. Trademarkcpid=CP. Cptrademarkid; Param. Trademarkcpname=CP. Cptrademarkname; List1. ADD (param); }
Main code:
for(inti =0; i < List_group.count; i++) { for(intj = (i +1); J < List_group.count; J + +) { if(List_group[j]. ProductModelID = = List_group[i]. ProductModelID && List_group[j]. CategoryId = =List_group[i]. CategoryId) {list_group.removeat (j);//Remove the same itemi =0;//from the beginning to the heavy, if the array has a large number of duplicate items, only one-time deduplication does not solve the problem. This usage will slow down the efficiency 1/3j =0; } } }
List Group
var New {S.categoryid, s.productmodelid}); foreach (var in t) { "" + t1. key.productmodelid); }
C # List Go heavy