decimal SortNum; //排序号 private void w_FollowTask_Load(object sender, EventArgs e) { try { asc.controllInitializeSize(this); BindSelectCmb(); // list = FolloTaskService.getAllTask(); //new Thread(() => { ReadDBInfo(listuinongroup[0]); }).Start(); list = FolloTaskService.getAllTask(); dgvTask.DataSource = list; } catch (Exception ex) { MessageBox.Show("数据库连接失败,请检查连接状况!"); } }
private void btnOk_Click(object sender, EventArgs e) { try { switch (cmbSelectC.SelectedItem.ToString()) { case "所有任务": if (!string.IsNullOrWhiteSpace(txtInfo.Text)) { TsakNum = Convert.ToDecimal(txtInfo.Text.Replace(" ", "")); dgvTask.DataSource = FolloTaskService.getAllTask(TsakNum); } else { dgvTask.DataSource = list; } break; case "设备号": if (!string.IsNullOrWhiteSpace(txtInfo.Text)) { Machineseq = Convert.ToDecimal(txtInfo.Text.Replace(" ", "")); dgvTask.DataSource = FolloTaskService.getAllMachineTask(Machineseq).Select(a => new { CIGARETTECODE = a.CIGARETTDECODE, CIGARETTNAME = a.CIGARETTDENAME, MACHINESEQ = a.Machineseq, UNIONTASKNUM = a.UnionTasknum, MERAGENUM = a.MERAGENUM, BILLCODE = a.Billcode, MACHINESTATE = a.MachineState }).ToList(); DgvBind(); } break; case "合流任务号": if (!string.IsNullOrWhiteSpace(txtInfo.Text) && !string.IsNullOrWhiteSpace(txtinfo2.Text)) { Machineseq = Convert.ToDecimal(txtInfo.Text.Replace(" ", "")); UnionTsakNum = Convert.ToDecimal(txtinfo2.Text.Replace(" ", "")); dgvTask.DataSource = FolloTaskService.getMachineTask(Machineseq, UnionTsakNum).Select(a => new { CIGARETTECODE = a.CIGARETTDECODE, CIGARETTNAME = a.CIGARETTDENAME, MACHINESEQ = a.Machineseq, UNIONTASKNUM = a.UnionTasknum, MERAGENUM = a.MERAGENUM, BILLCODE = a.Billcode, MACHINESTATE = a.MachineState }).ToList(); DgvBind(); } break; case "品牌": break; case "数量": break; case "组号": break; case "机械手": break; } } catch (Exception ex) { MessageBox.Show("错误:" + ex.Message); } }