/// <summary> /// 双击修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void CheckDatas_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { string err = string.Empty; frmAddSample fas = new frmAddSample(); //string sql = "FtypeNmae='" + CheckDatas.SelectedRows[0].Cells[0].Value.ToString() + "' and Name='" + CheckDatas.SelectedRows[0].Cells[1].Value.ToString() + "'"+ // " and ItemDes='" + CheckDatas.SelectedRows[0].Cells[2].Value.ToString() + "'"; string sql = "sampleName='" + CheckDatas.SelectedRows[0].Cells[0].Value.ToString() + "' and itemName='" + CheckDatas.SelectedRows[0].Cells[1].Value.ToString() + "'" + " and standardName='" + CheckDatas.SelectedRows[0].Cells[2].Value.ToString() + "'"; DataTable dt = csql.GetDownItemID(sql, "", out err); if (dt != null && dt.Rows.Count > 0) { fas.id = dt.Rows[0][0].ToString(); } string[,] a = new string[CheckDatas.SelectedRows.Count, 6]; for (int i = 0; i < CheckDatas.SelectedRows.Count; i++) { a[i, 0] = CheckDatas.SelectedRows[i].Cells[0].Value.ToString(); a[i, 1] = CheckDatas.SelectedRows[i].Cells[1].Value.ToString(); a[i, 2] = CheckDatas.SelectedRows[i].Cells[2].Value.ToString(); a[i, 3] = CheckDatas.SelectedRows[i].Cells[3].Value.ToString(); a[i, 4] = CheckDatas.SelectedRows[i].Cells[4].Value.ToString(); a[i, 5] = CheckDatas.SelectedRows[i].Cells[5].Value.ToString(); } Global.repairSample = a; fas.SaveRepair = "修改"; DialogResult dr = fas.ShowDialog(); if (dr == DialogResult.OK) { StringBuilder sb = new StringBuilder(); dt = csql.GetDownChkItem("", "", out err); if (dt != null && dt.Rows.Count > 0) { DataDisTable.Clear(); //for (int i = 0; i < dt.Rows.Count; i++) //{ // addtable(dt.Rows[i][0].ToString(), dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString(), dt.Rows[i][3].ToString(), dt.Rows[i][4].ToString(), dt.Rows[i][5].ToString()); //} CheckDatas.DataSource = dt; CheckDatas.Columns[0].HeaderCell.Value = "样品名称"; CheckDatas.Columns[1].HeaderCell.Value = "检测项目"; CheckDatas.Columns[2].HeaderCell.Value = "检测依据"; CheckDatas.Columns[3].HeaderCell.Value = "标准值"; CheckDatas.Columns[4].HeaderCell.Value = "判定符号"; CheckDatas.Columns[5].HeaderCell.Value = "单位"; } } } catch (Exception ex) { dy.savediary(DateTime.Now.ToString(), "样品修改错误:" + ex.Message, "错误"); MessageBox.Show(ex.Message, "样品修改"); } }
private void btnAdd_Click(object sender, EventArgs e) { frmAddSample fas = new frmAddSample(); fas.SaveRepair = "新增"; DialogResult dr = fas.ShowDialog(); if (dr == DialogResult.OK) { try { StringBuilder sb = new StringBuilder(); string err = string.Empty; DataTable dt = csql.GetDownChkItem("", "", out err); if (dt != null) { if (dt.Rows.Count > 0) { DataDisTable.Clear(); //for (int i = 0; i < dt.Rows.Count; i++) //{ // addtable(dt.Rows[i][0].ToString(), dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString(), dt.Rows[i][3].ToString(), dt.Rows[i][4].ToString(), dt.Rows[i][5].ToString()); //} CheckDatas.DataSource = dt;//DataDisTable; CheckDatas.Columns[0].HeaderCell.Value = "样品名称"; CheckDatas.Columns[1].HeaderCell.Value = "检测项目"; CheckDatas.Columns[2].HeaderCell.Value = "检测依据"; CheckDatas.Columns[3].HeaderCell.Value = "标准值"; CheckDatas.Columns[4].HeaderCell.Value = "判定符号"; CheckDatas.Columns[5].HeaderCell.Value = "单位"; } } } catch (Exception ex) { dy.savediary(DateTime.Now.ToString(), "进入样品信息查询错误:" + ex.Message, "错误"); MessageBox.Show(ex.Message, "样品信息查询"); } } }