dev gridview循环所有选中的明细行（需要判断明细行选择或者有选择列）

原创已于 2023-08-25 15:31:43 修改 · 105 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #前端 #javascript

于 2020-02-14 10:34:17 首次发布

devexpress 同时被 2 个专栏收录

21 篇文章

订阅专栏

gridview

7 篇文章

订阅专栏

本文介绍了一种使用C#在GridView中选取特定行，并将这些行的数据批量插入到数据库的方法。通过循环遍历选中的行，获取各列的值，如订单批次号、投产批次号、发货日期等，并利用ProcSqlHelper执行SQL语句，实现数据的高效批量导入。同时，对每条记录进行出入库标记，以跟踪库存变化。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

for (int i = 0; i < this.gridView1.GetSelectedRows().Length; i++)
            {
                //循环遍历gridview明细行中已选中的行
                string batchcode = this.gridView1.GetRowCellValue(this.gridView1.GetSelectedRows()[i], "订单批次号").ToString();
                string obatchcode = this.gridView1.GetRowCellValue(this.gridView1.GetSelectedRows()[i], gridView1.Columns[@"投产批次号"]).ToString();
                DateTime senddate = Convert.ToDateTime(this.gridView1.GetRowCellValue(this.gridView1.GetSelectedRows()[i], gridView1.Columns[@"发货日期"]));
                decimal qtys = Convert.ToInt32(this.gridView1.GetRowCellValue(this.gridView1.GetSelectedRows()[i], "发货数量"));
                string TCCPhaseFactory = this.gridView1.GetRowCellValue(this.gridView1.GetSelectedRows()[i], gridView1.Columns[@"合同工厂"]).ToString();
                string submemo = this.gridView1.GetRowCellValue(this.gridView1.GetSelectedRows()[i], gridView1.Columns[@"备注"]).ToString();

                //循环遍历整个gridview明细行
                //string batchcode = this.gridView1.GetRowCellValue(i, gridView1.Columns[@"订单批次号"]).ToString();
                //string obatchcode = this.gridView1.GetRowCellValue(i, gridView1.Columns[@"投产批次号"]).ToString();
                //DateTime senddate = Convert.ToDateTime(this.gridView1.GetRowCellValue(i, gridView1.Columns[@"发货日期"]));
                //decimal qtys = Convert.ToInt32(this.gridView1.GetRowCellValue(i, gridView1.Columns[@"发货数量"]));
                //string TCCPhaseFactory = this.gridView1.GetRowCellValue(i, gridView1.Columns[@"合同工厂"]).ToString();
                //string submemo = this.gridView1.GetRowCellValue(i, gridView1.Columns[@"备注"]).ToString();

ProcSqlHelper.ExecuteDatatable("insert into MultilayerTccPhaseFactoryKcdj(kctype,batchcode,obatchcode,senddate,Qtys,TCCPhaseFactory,submemo) values('入',@batchcode,@obatchcode,@senddate,@Qtys,@TCCPhaseFactory,@submemo)", CommandType.Text, new SqlParameter[] { new SqlParameter("@batchcode", batchcode), new SqlParameter("@obatchcode", obatchcode), new SqlParameter("@senddate", senddate), new SqlParameter("@qtys", qtys), new SqlParameter("@TCCPhaseFactory", TCCPhaseFactory), new SqlParameter("@submemo", submemo) });
ProcSqlHelper.ExecuteDatatable("insert into MultilayerTccPhaseFactoryKcdj(kctype,batchcode,obatchcode,senddate,Qtys,TCCPhaseFactory,submemo) values('出',@batchcode,@obatchcode,@senddate,@Qtys,@TCCPhaseFactory,@submemo)", CommandType.Text, new SqlParameter[] { new SqlParameter("@batchcode", batchcode), new SqlParameter("@obatchcode", obatchcode), new SqlParameter("@senddate", senddate), new SqlParameter("@qtys", qtys*(-1)), new SqlParameter("@TCCPhaseFactory", TCCPhaseFactory), new SqlParameter("@submemo", submemo) });