开发者

How to Stop Auto Generate columns in Flexgrid

开发者 https://www.devze.com 2023-02-21 18:16 出处:网络
Am using component flexgrid tool in my application for binding bulk of datas from my sql server using Linq, but grid showing all columns from my entity listthan i initializedfor my flexgrid.

Am using component flexgrid tool in my application for binding bulk of datas from my sql server using Linq, but grid showing all columns from my entity list than i initialized for my flexgrid. I want only three coloumns from it itemname, PartNo, Itemcode, * Thease coloums only initialized first* But showing All Coloums that i don't want ever

  List NewList = new List();
  Itlist = objItemMgmt.GetItms(Convert.ToString(gvPurchaseEntry1.Cols[d].Index.ToString()));//d is ["ItemCode"]
 gvPurcahseItems1.DataSource = Itlist;
 gvPurcahseItems1.Focus();

Here is my Entity data list

  public List GetItms(string itemName)
        {
            var reslt = (from itm in context.ItemMasters
                         join mm in context.MultiMasters
                          on itm.ItemId equals mm.ItemId
                          join gt in context.GoodsDetails 
                          on itm.GoodsId equals gt.GoodsId 
                         join mu in context.Multiunits
                          on mm.MultiunitId equals mu.MultiunitId
                         join u in context.UnitDetails
                          on mu.UnitId equals u.UnitId
                         join s in context.StockDetails
                          on itm.ItemId equals s.ItemId
                         where (itemName == null || itm.ItemName.Contains(itemName)) ||
                               (itemName == null || itm.PartNo.Contains(itemName)) ||
                               (itemName == null || itm.ItemCode.Contains(itemName)) ||
                               //(itemName == null || itm.ArabicDescription.Contains(itemName)) ||
                               (itemName == null || (itm.GoodsDetail.GoodsType + " " + itm.GoodsDetail.GroupCatagory).Contains(itemName)
                               && (itm.StatusId != 3))
                               && (itm.StatusId != 3)
                        //where ((itemName == null) || itm.ItemName.Contains(itemName)
                        //|| itm.ItemCode.Contains(itemName) || itm.OEMNo.Contains(itemName)
                        //|| (itm.GoodsDetail.GoodsType + " " + itm.GoodsDetail.GroupCatagory).Contains(itemName) || itm.PartNo.Contains(itemName))
                        //&& itm.StatusId != 3
                         select new Entity.ItemMasterProp
                         {
                             Id = (int)itm.ItemId,
                             PartNo=(string)itm.PartNo,
                             ItemCode = (string)itm.ItemCode,
                             ItemName = (string)itm.ItemName,
                             Stock = (double)s.AvailableStock,
                             WPrice = (decimal)mm.WPrice,
                             RPrice = (decimal)mm.RetPrice,
                             value = (decimal)mm.Value,
                    开发者_StackOverflow中文版         UnitId = (int)u.UnitId,
                             UnitName = (string)u.UnitName,
                             UnitCode = (string)u.UnitCode,
                             MultiUnitId = (int)mu.MultiunitId,
                             MultiUnitName = (string)mu.MultiName,
                             MultiUnitCode = (string)mu.MultiCode,
                             GoodTyp=(string)gt.GoodsType + " " + (string)gt.GroupCatagory,
                             GoodId = (int)gt.GoodsId
                             //GoodCatogory = (string)gt.GroupCatagory

                         }).Distinct().ToList();

            var reslt1 =   (from itm in context.ItemMasters
                            join u1 in context.UnitDetails
                            on itm.UnitId equals u1.UnitId
                            join gt in context.GoodsDetails
                            on itm.GoodsId equals gt.GoodsId 
                            join s in context.StockDetails
                            on itm.ItemId equals s.ItemId
                            where (itemName == null || itm.ItemName.Contains(itemName)) ||
                             (itemName == null || itm.PartNo.Contains(itemName)) ||
                            (itemName == null) || itm.ItemCode.Contains(itemName)
                            || (itemName == null || (itm.GoodsDetail.GoodsType + " " + itm.GoodsDetail.GroupCatagory).Contains(itemName) 
                            && (itm.StatusId != 3))
                             select new Entity.ItemMasterProp
                            {
                              Id = (int)itm.ItemId,
                              PartNo = (string)itm.PartNo,
                              ItemCode = (string)itm.ItemCode,
                              ItemName = (string)itm.ItemName,
                              Stock = (double)s.AvailableStock,
                              UnitId = (int)u1.UnitId,
                              UnitName = (string)u1.UnitName,
                              WPrice = (decimal)itm.WPrice,
                              RPrice = (decimal)itm.RPrice,
                              MultiUnitName = (string)u1.UnitName,
                              value = (decimal)1,
                              GoodTyp = (string)gt.GoodsType + " " + (string)gt.GroupCatagory,
                              GoodId=(int)gt.GoodsId,
                               //GoodCatogory = (string)gt.GroupCatagory
                            }).Distinct().ToList();
           reslt = reslt.Concat(reslt1).Distinct().ToList();
            return reslt;
        }

I want only three coloumns from it itemname, PartNo, Itemcode, * Thease coloums only initialized first* But showing All Coloums that i don't want ever

Thanks in Advance


Use the delete column button:

http://helpcentral.componentone.com/nethelp/c1flexgrid/default.htm?turl=c1flexgridcolumneditor.htm

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号