//删除行 void tsdelete_Click(object sender, EventArgs e) { dgvYj.CancelEdit(); dgvYj.EndEdit(); if (dgvYj.SelectedRows.Count > 0) { DialogResult result = MessageBox.Show("确实要删除原件吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (result == DialogResult.OK) { for (int i = 0; i < dgvYj.SelectedRows.Count; i++) { object YjID = dgvYj.Rows[dgvYj.SelectedRows[i].Index].Cells["原件ID"].Value; object path = dgvYj.Rows[dgvYj.SelectedRows[i].Index].Cells["路径"].Value; object fileName = dgvYj.Rows[dgvYj.SelectedRows[i].Index].Cells["保存名称"].Value; if (Object.Equals(YjID, "") || Object.Equals(YjID, null) || Object.Equals(YjID, DBNull.Value)) { continue; } else { if (!Object.Equals(path, string.Empty) && !Object.Equals(path, null) && !Object.Equals(path, DBNull.Value)) { if (!Object.Equals(fileName, string.Empty) && !Object.Equals(fileName, null) && !Object.Equals(fileName, DBNull.Value)) { UpLoadDownLoad.DeleteFile(path.ToString(), fileName.ToString()); } } CJ_yj.DeleteYj(Convert.ToInt32(YjID)); } } //MessageBox.Show("删除成功!"); ds = CJ_yj.getData(DocID); dgvYj.DataSource = ds.Tables[0]; table = ds.Tables[0]; lbldgvNum.Text = "共有纪录数:" + Convert.ToString(dgvYj.Rows.Count - 1); if (dgvYj.Rows.Count == 1) { txtYjIndex.Text = "1"; } else { txtYjIndex.Text = Convert.ToString(dgvYj.CurrentCell.RowIndex + 1); } int num = dgvYj.Rows.Count; publicDgv.DataGridView导航(dgvYj, num); } } else { MessageBox.Show("请选择要删除的行!"); return; } }
//查看详细信息 private void dgvYj_CellClick(object sender, DataGridViewCellEventArgs e) { #region 查看和下载原件 if (e.ColumnIndex >= 0 && e.RowIndex >= 0) { object YjID = dgvYj.Rows[e.RowIndex].Cells["原件ID"].Value; object desc = dgvYj.Rows[e.RowIndex].Cells["描述"].Value; object ext = dgvYj.Rows[e.RowIndex].Cells["扩展名"].Value; object path = dgvYj.Rows[e.RowIndex].Cells["Ftp目录"].Value; object fileName = dgvYj.Rows[e.RowIndex].Cells["Ftp保存名称"].Value; if (dgvYj.Columns[e.ColumnIndex].Name == "载入") { //新增行,直接调用添加原件 if (e.RowIndex == (dgvYj.Rows.Count - 1)) { InputYJ(false, 0); } else//修改原件 { if (!Object.Equals(YjID, "") && !Object.Equals(YjID, null) && !Object.Equals(YjID, DBNull.Value)) { //如存在原件文件,先删除原有文件,再载入新的文件 if (!Object.Equals(path, string.Empty) && !Object.Equals(path, null) && !Object.Equals(path, DBNull.Value)) { DialogResult result = MessageBox.Show("已经存在原件文件,是否要替换原有文件?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (result == DialogResult.OK) { UpLoadDownLoad.DeleteFile(path.ToString(), fileName.ToString()); } else { return; } } //单个原件加载 InputYJ(false, Convert.ToInt32(YjID)); } } if (dgvYj.Rows.Count > 1) { dgvYj.CurrentCell = dgvYj.Rows[e.RowIndex].Cells[dgvYj.FirstDisplayedCell.ColumnIndex]; } } if (dgvYj.Columns[e.ColumnIndex].Name == "查看" && e.RowIndex != (dgvYj.Rows.Count - 1)) { if (!Object.Equals(path, string.Empty) && !Object.Equals(path, null) && !Object.Equals(path, DBNull.Value)) { if (!Object.Equals(fileName, string.Empty) && !Object.Equals(fileName, null) && !Object.Equals(fileName, DBNull.Value)) { UpLoadDownLoad.OpenFile(path.ToString(), fileName.ToString()); } } } if (dgvYj.Columns[e.ColumnIndex].Name == "下载" && e.RowIndex != (dgvYj.Rows.Count - 1)) { if (!Object.Equals(path, string.Empty) && !Object.Equals(path, null) && !Object.Equals(path, DBNull.Value)) { if (!Object.Equals(fileName, string.Empty) && !Object.Equals(fileName, null) && !Object.Equals(fileName, DBNull.Value)) { UIPublicClass.PublicClass.DownLoadFile(Convert.ToString(path), Convert.ToString(fileName), Convert.ToString(desc), Convert.ToString(ext)); } } } if (dgvYj.Columns[e.ColumnIndex].Name == "删除" && e.RowIndex != (dgvYj.Rows.Count - 1)) { DialogResult result = MessageBox.Show("确实要删除原件吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (result == DialogResult.OK) { if (!Object.Equals(YjID, "") && !Object.Equals(YjID, null) && !Object.Equals(YjID, DBNull.Value)) { if (!Object.Equals(path, string.Empty) && !Object.Equals(path, null) && !Object.Equals(path, DBNull.Value)) { if (!Object.Equals(fileName, string.Empty) && !Object.Equals(fileName, null) && !Object.Equals(fileName, DBNull.Value)) { UpLoadDownLoad.DeleteFile(path.ToString(), fileName.ToString()); } } gd_yj.DeleteYj(Convert.ToInt32(YjID)); } MessageBox.Show("删除成功!"); ds = gd_yj.getData(DocID); dgvYj.DataSource = ds.Tables[0]; table = ds.Tables[0]; lblCount.Text = Convert.ToString(dgvYj.Rows.Count - 1); if (dgvYj.Rows.Count == 1) { txt行号.Text = "1"; } else { txt行号.Text = Convert.ToString(dgvYj.CurrentCell.RowIndex + 1); } } } } #endregion }