如何实现C#数据库筛选并求和并将结果显示在textbox中？

数据库

操作界面

选择操作窗口里的时间以及订单号，数据库进行筛选，并对于价格+vip价格进行求和，将求和结果显示到待付款的textbox控件中

不会那一步的代码

        public double GetAmountTotal(int idv,DateTime time,int isvip)
        {
  //模拟数据库查询出的所有数据
            List<Data> list = new List<Data>();
            list.Add(new Data() { Id = 1, IdV = 1, Date = Convert.ToDateTime("2021-3-15 06:10:00"), num = 1, Price = 11, VipPrice = 4 });
            list.Add(new Data() { Id = 2, IdV = 1, Date = Convert.ToDateTime("2021-3-15 06:20:00"), num = 2, Price = 11, VipPrice = 4 });
            list.Add(new Data() { Id = 3, IdV = 1, Date = Convert.ToDateTime("2021-3-15 06:30:00"), num = 1, Price = 13, VipPrice = 4 });
            list.Add(new Data() { Id = 4, IdV = 1, Date = Convert.ToDateTime("2021-3-15 06:40:00"), num = 3, Price = 11, VipPrice = 4 });
            list.Add(new Data() { Id = 5, IdV = 2, Date = Convert.ToDateTime("2021-3-15 06:50:00"), num = 1, Price = 11, VipPrice = 4 });
            list.Add(new Data() { Id = 6, IdV = 2, Date = Convert.ToDateTime("2021-3-15 07:00:00"), num = 1, Price = 11, VipPrice = 4 });
            list.Add(new Data() { Id = 7, IdV = 3, Date = Convert.ToDateTime("2021-3-16 06:10:00"), num = 1, Price = 11, VipPrice = 4 });
            list.Add(new Data() { Id = 8, IdV = 3, Date = Convert.ToDateTime("2021-3-16 06:20:00"), num = 2, Price = 11, VipPrice = 4 });
            list.Add(new Data() { Id = 9, IdV = 3, Date = Convert.ToDateTime("2021-3-16 06:30:00"), num = 1, Price = 11, VipPrice = 4 });
            list.Add(new Data() { Id = 10, IdV = 3, Date = Convert.ToDateTime("2021-3-16 06:40:00"), num = 1, Price = 11, VipPrice = 4 });
            list.Add(new Data() { Id = 11, IdV = 4, Date = Convert.ToDateTime("2021-3-16 06:50:00"), num = 1, Price = 11, VipPrice = 4 });
            list.Add(new Data() { Id = 12, IdV = 4, Date = Convert.ToDateTime("2021-3-16 07:00:00"), num = 1, Price = 11, VipPrice = 4 });
            list = list.Where(w => w.IdV == idv && w.Date.Date == time.Date).ToList();
            var price = list.Sum(s => s.Price);
            var vipprice = list.Sum(s => s.VipPrice);
            return isvip==0?price:vipprice;
        }

 class Data
    {
        public int Id { get; set; }
        public int IdV { get; set; }
        public DateTime Date { get; set; }
        public int num { get; set; }
        public double Price { get; set; }
        public double VipPrice { get; set; }
    }

你好，我是问答小助手，非常抱歉，本次您提出的有问必答问题，目前超出我们的服务范围，暂时无法为您解答。

首次提问人员可免费体验一次有问必答服务。目前首次提问的问题服务范围为：Java开发、数据库等领域专业技术问题，为您提供问题的解决思路和指导。不提供源码代写、项目文档代写、论文代写、安装包资源发送或安装指导等服务。

我们后续会持续优化，扩大我们的服务范围，为您带来更好地服务。