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();
}
}
}
}
