private void btnAdd_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { selection.ClearSelection(); using (OracleConnection connection = new OracleConnection(FrmLogin.strDataCent)) { connection.Open(); OracleCommand command = connection.CreateCommand(); OracleTransaction transaction = connection.BeginTransaction(); command.Connection = connection; command.Transaction = transaction; FrmDeptTypeMtChild frmAdd = new FrmDeptTypeMtChild(); frmAdd.Text = "增加印刷厂类型"; frmAdd.lbName.Text = "印刷厂类型"; try { if (frmAdd.ShowDialog() == DialogResult.OK) { string strIns = "INSERT INTO JT_J_YSCLX (YSCLXID, LXBH, YSCDWLX, ZT) VALUES (JT_J_YSCLX_SEQ.nextval, :LXBH, :YSCDWLX, :ZT)"; command.CommandText = strIns; command.Parameters.Add(new OracleParameter("LXBH", OracleType.VarChar)).Value = frmAdd.getNum(); command.Parameters.Add(new OracleParameter("YSCDWLX", OracleType.VarChar)).Value = frmAdd.getName(); command.Parameters.Add(new OracleParameter("ZT", OracleType.VarChar)).Value = frmAdd.getStatus(); command.ExecuteNonQuery(); transaction.Commit(); unitOfWork1.DropIdentityMap(); xpServerCollectionSource1.Reload(); MessageBox.Show("增加成功!"); } } catch (Exception exception) { transaction.Rollback(); MessageBox.Show(exception.ToString()); } finally { connection.Close(); } } }
private void btnUpdate_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { string strYSCLXID = ""; string strLXBH = ""; string strYSCDWLX = ""; string strZT = ""; int RowHandle = 0; if (selection.SelectedCount == 0) { MessageBox.Show("请先选择需要修改的记录"); } else if (selection.SelectedCount > 1) { MessageBox.Show("一次只能修改一条记录,请重新选择!"); } else { for (int i = 0; i < selection.SelectedCount; ++i) { int RowIndex = selection.GetSelectedRowIndex(i); RowHandle = gridView1.GetRowHandle(RowIndex); strYSCLXID = gridView1.GetRowCellDisplayText(RowHandle, colYSCLXID); strLXBH = gridView1.GetRowCellDisplayText(RowHandle, colLXBH); strYSCDWLX = gridView1.GetRowCellDisplayText(RowHandle, colYSCDWLX); strZT = gridView1.GetRowCellDisplayText(RowHandle, colZT); } using (OracleConnection connection = new OracleConnection(FrmLogin.strDataCent)) { connection.Open(); OracleCommand command = connection.CreateCommand(); OracleTransaction transaction = connection.BeginTransaction(); command.Connection = connection; command.Transaction = transaction; FrmDeptTypeMtChild frmUpdate = new FrmDeptTypeMtChild(strYSCDWLX, strLXBH, strZT); frmUpdate.Text = "修改印刷厂类型"; frmUpdate.lbName.Text = "印刷厂类型"; try { if (frmUpdate.ShowDialog() == DialogResult.OK) { string strUpdate = "update JT_J_YSCLX set LXBH = :LXBH, YSCDWLX = :YSCDWLX, ZT = :ZT where YSCLXID = '" + strYSCLXID + "'"; command.CommandText = strUpdate; command.Parameters.Add(new OracleParameter("YSCDWLX", OracleType.VarChar)).Value = frmUpdate.getName(); command.Parameters.Add(new OracleParameter("LXBH", OracleType.VarChar)).Value = frmUpdate.getNum(); command.Parameters.Add(new OracleParameter("ZT", OracleType.VarChar)).Value = frmUpdate.getStatus(); command.ExecuteNonQuery(); transaction.Commit(); selection.ClearSelection(); unitOfWork1.DropIdentityMap(); xpServerCollectionSource1.Reload(); MessageBox.Show("修改成功!"); gridView1.FocusedRowHandle = RowHandle; } } catch (Exception exception) { transaction.Rollback(); MessageBox.Show(exception.ToString()); } finally { connection.Close(); } } } }