private void button1_Click(object sender, EventArgs e) { PageCondition.Visible = true; BaseAccess dbhelper = BaseAccess.CreateDataBase(); dbhelper.ExecuteNonQuerySQL("".AsSQLQuery() + "delete ZBO"); if (dbhelper.Insert <Excel>(excels) > 0) { lvw.Clear(); lvw.Items.Clear(); lvw.Columns.AddRange(new ColumnHeader[] { new ColumnHeader { Text = "物料编码", Width = 100, TextAlign = HorizontalAlignment.Center }, new ColumnHeader { Text = "物料名称", Width = 100, TextAlign = HorizontalAlignment.Center }, new ColumnHeader { Text = "在库数量", Width = 100, TextAlign = HorizontalAlignment.Center }, new ColumnHeader { Text = "待验收数量", Width = 100, TextAlign = HorizontalAlignment.Center }, new ColumnHeader { Text = "一次验收完成数量", Width = 110, TextAlign = HorizontalAlignment.Center }, new ColumnHeader { Text = "二次验收完成数量", Width = 110, TextAlign = HorizontalAlignment.Center }, new ColumnHeader { Text = "入库待处理数量", Width = 110, TextAlign = HorizontalAlignment.Center }, }); PageCondition.PageSize = 50; PageCondition.SqlSort = "order by MaterialId"; listTask = dbhelper.GetList <MaterialStatus>("".AsSQLQuery() + "select * from View_ZBO", PageCondition.PageCondition); page = listTask.rows.Count(); PageCondition.DataQuery(new Func <int>(() => { if (listTask != null && listTask.rows != null && listTask.rows.Count > 0) { Invoke(new Action(() => { lvw.Items.Clear(); for (int i = 0; i < listTask.rows.Count; i++) { ListViewItem item = new ListViewItem(); item.Tag = listTask.rows[i]; item.Text = listTask.rows[i].MaterialId; item.SubItems.Add(listTask.rows[i].MaterialName); item.SubItems.Add(listTask.rows[i].AllQuantity); item.SubItems.Add(listTask.rows[i].Checkquantity); item.SubItems.Add(listTask.rows[i].FCheckquantity); item.SubItems.Add(listTask.rows[i].SCheckquantity); item.SubItems.Add(listTask.rows[i].Inquantity); lvw.Items.Add(item); } })); } return(listTask == null ? 0 : listTask.total); }), true); } else { MessageBox.Show("请重试", "提示"); } buttonoutport.Visible = true; }