private void btnupload_Click(object sender, EventArgs e) { for (int i = 0; i < cnt111; i++) { string st = filescpoy[i]; st = st.Replace("\\", "\\\\"); bool flag = new WorkBAL().Insert1107(a, i + 1, st); } MessageBox.Show("成功"); }
private void button1_Click(object sender, EventArgs e) { int i = dataGridView1.Rows.Count; int river = 0; for (int j = 0; j < i - 1; j++) { processfile p = new processfile(); // p.bh = textBoxDH.Text.Trim(); p.bh = this.dataGridView1.Rows[j].Cells[0].Value.ToString(); p.filetype = textBoxDALX.Text.Trim(); p.gdmethod = textBoxGDFS.Text.Trim(); p.getId = textBoxLQPCH.Text.Trim(); p.lzId = textBoxLZDH.Text.Trim(); p.page = textBoxYS.Text.Trim(); p.process = pppp; p.processdate = dateTimePicker1.Value; p.projectunit = textBoxXMDW.Text.Trim(); p.responseible = textBoxZRR.Text.Trim(); p.year = textBoxNX.Text.Trim(); if (nowrole == "【拆分】") { MySqlDataReader sdr = new WorkBAL().Selectinfo3(p.bh, p.getId); if (sdr.Read()) { sdr.Close(); bool flag11 = new WorkBAL().update4(p); } else { sdr.Close(); bool flag22 = new WorkBAL().Insert4(p); } river++; raiseCallBackRefreshEvent(); //将事件抛出去,在主窗体中接收,并作相应处理 } else if (nowrole == "【著录】") { MySqlDataReader sdr = new WorkBAL().Selectinfo3(p.bh, p.getId); if (sdr.Read()) { sdr.Close(); bool flag11 = new WorkBAL().update4(p); } else { sdr.Close(); bool flag22 = new WorkBAL().Insert4(p); } // 更改档案状态 river++; raiseCallBackRefreshEvent(); //将事件抛出去,在主窗体中接收,并作相应处理 } else if (nowrole == "【编码】") { MySqlDataReader sdr = new WorkBAL().Selectinfo3(p.bh, p.getId); if (sdr.Read()) { sdr.Close(); bool flag11 = new WorkBAL().update4(p); } else { sdr.Close(); bool flag22 = new WorkBAL().Insert4(p); } // 更改档案状态 bool flag2 = new WorkBAL().update14(p.getId, p.bh); if (flag2 == true) { river++; } this.Close(); raiseCallBackRefreshEvent(); //将事件抛出去,在主窗体中接收,并作相应处理 } else if (nowrole == "【还原】") { MySqlDataReader sdr = new WorkBAL().Selectinfo3(p.bh, p.getId); if (sdr.Read()) { sdr.Close(); bool flag11 = new WorkBAL().update4(p); } else { sdr.Close(); bool flag22 = new WorkBAL().Insert4(p); } // 更改档案状态 river++; raiseCallBackRefreshEvent(); //将事件抛出去,在主窗体中接收,并作相应处理 } else if (nowrole == "【扫描】") { MySqlDataReader sdr = new WorkBAL().Selectinfo3(p.bh, p.getId); if (sdr.Read()) { sdr.Close(); bool flag11 = new WorkBAL().update4(p); } else { sdr.Close(); bool flag22 = new WorkBAL().Insert4(p); } river++; raiseCallBackRefreshEvent(); //将事件抛出去,在主窗体中接收,并作相应处理 } else if (nowrole == "【编目】") { MySqlDataReader sdr = new WorkBAL().Selectinfo3(p.bh, p.getId); if (sdr.Read()) { sdr.Close(); bool flag11 = new WorkBAL().update4(p); } else { sdr.Close(); bool flag22 = new WorkBAL().Insert4(p); } river++; raiseCallBackRefreshEvent(); //将事件抛出去,在主窗体中接收,并作相应处理 } else if (nowrole == "【图处】") { MySqlDataReader sdr = new WorkBAL().Selectinfo3(p.bh, p.getId); if (sdr.Read()) { sdr.Close(); bool flag11 = new WorkBAL().update4(p); } else { sdr.Close(); bool flag22 = new WorkBAL().Insert4(p); } // 更改档案状态 bool flag2 = new WorkBAL().update16(p.getId, p.bh); river++; raiseCallBackRefreshEvent(); //将事件抛出去,在主窗体中接收,并作相应处理 } else if (nowrole == "【质检】") { MySqlDataReader sdr = new WorkBAL().Selectinfo3(p.bh, p.getId); if (sdr.Read()) { sdr.Close(); bool flag11 = new WorkBAL().update4(p); } else { sdr.Close(); bool flag22 = new WorkBAL().Insert4(p); } river++; raiseCallBackRefreshEvent(); //将事件抛出去,在主窗体中接收,并作相应处理 } else if (nowrole == "【挂接】") { MySqlDataReader sdr = new WorkBAL().Selectinfo3(p.bh, p.getId); if (sdr.Read()) { sdr.Close(); bool flag11 = new WorkBAL().update4(p); } else { sdr.Close(); bool flag22 = new WorkBAL().Insert4(p); } river++; raiseCallBackRefreshEvent(); //将事件抛出去,在主窗体中接收,并作相应处理 } else if (nowrole == "【归还】") { MySqlDataReader sdr = new WorkBAL().Selectinfo3(p.bh, p.getId); if (sdr.Read()) { sdr.Close(); bool flag11 = new WorkBAL().update4(p); } else { sdr.Close(); bool flag22 = new WorkBAL().Insert4(p); } river++; raiseCallBackRefreshEvent(); //将事件抛出去,在主窗体中接收,并作相应处理 } } if (river == i - 1) { MessageBox.Show("提交成功"); } else { MessageBox.Show("提交失败"); } }
private void button1_Click(object sender, EventArgs e) { if (ss == 0) { int i = dataGridView1.Rows.Count; int cnt = 0; for (int j = 0; j < i - 1; j++) { getfile g = new getfile(); g.dangId = textBoxDH.Text.Trim(); g.filetype = textBoxDALX.Text.Trim(); g.gdmethod = textBoxGDFS.Text.Trim(); g.getId = textBoxLQPCH.Text.Trim(); g.gettime = dateTimePickerlLQSJ.Value; g.processunit = textBoxJGDW.Text.Trim(); g.projectunit = textBoxXMDW.Text.Trim(); g.projetunit2 = textBox.Text.Trim(); g.swapdate = dateTimePickerRQ1.Value; g.swapdate2 = dateTimePickerRQ2.Value; g.year = textBoxNX.Text.Trim(); // g.page = textBoxYS.Text.Trim(); getId = g.getId; for (int s = 0; s < dataGridView1.ColumnCount; s++) { if (this.dataGridView1.Rows[j].Cells[s].Value != null) { string str = this.dataGridView1.Rows[j].Cells[s].Value.ToString(); if (s == 0) { g.bh = str; } else { g.question = str; } } else { if (s == 0) { g.bh = ""; } else { g.question = ""; } } } bool flag = new WorkBAL().Insert2(g); if (flag) { cnt++; // 更改档案状态 bool flag3 = new projectBAL().insert(pId, getId, g.bh); bool flag2 = new projectBAL().update(getId, g.bh); raiseCallBackRefreshEvent(); //将事件抛出去,在主窗体中接收,并作相应处理 // this.Close(); } else { // MessageBox.Show("提交失败失败!"); } } if (cnt == i - 1) { MessageBox.Show("提交成功!"); } else { MessageBox.Show("提交失败失败!"); } ss++; } else { MessageBox.Show("请勿重复提交"); } }
private void button1_Click(object sender, EventArgs e) { int i = dataGridView1.Rows.Count; int cnt = 0; for (int j = 0; j < i - 1; j++) { getfile g = new getfile(); g.filetype = textBoxDALX.Text.Trim(); g.gdmethod = textBoxGDFS.Text.Trim(); g.getId = textBoxLQPCH.Text.Trim(); g.gettime = dateTimePickerLQSJ.Value; g.processunit = textBoxJGDW.Text.Trim(); g.projectunit = textBoxXMDW.Text.Trim(); g.projetunit2 = textBox.Text.Trim(); g.swapdate = dateTimePicker3.Value; g.swapdate2 = dateTimePicker4.Value; g.year = textBoxNX.Text.Trim(); for (int s = 0; s < dataGridView1.ColumnCount; s++) { if (this.dataGridView1.Rows[j].Cells[s].Value != null) { string str = this.dataGridView1.Rows[j].Cells[s].Value.ToString(); if (s == 0) { g.bh = str; } else if (s == 1) { g.question = str; } else { g.solve = str; } } } if (nowrole == "【领取】") { bool flag = new WorkBAL().Insert3(g); if (flag) { cnt++; } } else if (nowrole == "【拆分】") { bool flag1 = new WorkBAL().Insert6(g); if (flag1) { cnt++; } } else if (nowrole == "【著录】") { bool flag1 = new WorkBAL().Insert7(g); if (flag1) { cnt++; } } else if (nowrole == "【编码】") { bool flag1 = new WorkBAL().Insert9(g); if (flag1) { cnt++; } } else if (nowrole == "【还原】") { bool flag1 = new WorkBAL().Insert11(g); if (flag1) { cnt++; } } else if (nowrole == "【扫描】") { bool flag1 = new WorkBAL().Insert13(g); if (flag1) { cnt++; } } else if (nowrole == "【编目】") { bool flag1 = new WorkBAL().Insert15(g); if (flag1) { cnt++; } } else if (nowrole == "【图处】") { bool flag1 = new WorkBAL().Insert17(g); if (flag1) { cnt++; } } else if (nowrole == "【质检】") { bool flag1 = new WorkBAL().Insert21(g); if (flag1) { cnt++; } } else if (nowrole == "【挂接】") { bool flag1 = new WorkBAL().Insert22(g); if (flag1) { cnt++; } } else if (nowrole == "【归还】") { bool flag1 = new WorkBAL().Insert22(g); if (flag1) { cnt++; } } } if (cnt == i - 1) { MessageBox.Show("提交成功!"); // Form待加工档案 f = new Form待加工档案(nowrole); // f.Show(); // this.Hide(); } else { MessageBox.Show("提交失败失败!"); } }