• C# 用Linq查询DataGridView行中的数据是否包含(各种操作)


    http://blog.csdn.net/xht555/article/details/38685845

    https://www.cnblogs.com/wuchao/archive/2012/12/25/2832744.html

     IEnumerable<DataGridViewRow> enumerableList = this.dataGridView1.Rows.Cast<DataGridViewRow>();
                            List<DataGridViewRow> list = (from item in enumerableList
                                                          where item.Cells["projectCode"].Value.ToString() == txt_cmd.Text.Trim()
                                                          select item).ToList();

    //数组转成字符串

    IEnumerable<DataGridViewRow> DataGridList = this.rcomdgv2.Rows.Cast<DataGridViewRow>();
     String shopArrayLinq = String.Join(",", (from item in DataGridList where item.Cells["CheckShop"].Value.ObjToInt() == 1 select item.Cells["ShopID"].Value).Distinct());

    //对应的数据赋值

    IEnumerable<DataGridViewRow> DataGridList = this.rcomdgv2.Rows.Cast<DataGridViewRow>();
                            (from item in DataGridList where shopNameArry.Contains<string>(item.Cells["ShopID"].Value.ObjToString()) select item)
                            .ToList()
                            .ForEach(item => item.Cells["CheckShop"].Value = 1);

    //求表格和

    var TotalActualWeight = from p in enumerableList group p by p.Cells["out_barcode"].Value into g select new { TotalActual = g.Sum(p => p.Cells["weight"].Value.ObjToDecimal()) };
     ActualWeight.Value = TotalActualWeight.First().TotalActual;

  • 相关阅读:
    setUP和tearDown,setUpClass和tearDownClass
    执行代码提示:Ran 0 tests in 0.000s
    Python自动化测试执行用例
    Python+webdriver自动化脚本的封装调用
    SQL之INDEX
    SQL之WHERE,GROUP,HAVING,ORDER BY
    SQL之LIMIT
    python基础之字符编码、文件处理
    python基础之列表、元组、字典、布尔值、集合
    python基础之if条件判断、while循环及数据类型
  • 原文地址:https://www.cnblogs.com/LuoEast/p/8530850.html
Copyright © 2020-2023  润新知