arashavir
پنج شنبه 03 مهر 1393, 14:54 عصر
دوستان ایراد این متد کجاست
private int changeBM(string altesBaumuster, string neuesBaumuster)
{
string commandSQL = string.Empty;
commandSQL = "Update DPPLAUSIS SET DPPLAUSIS.BM = '" + fixBM(neuesBaumuster) + "' WHERE DPPLAUSIS.ACode = '700' AND DPPLAUSIS.BM LIKE '" + altesBaumuster + "%'";
try
{
cmd = new OracleCommand();
cmd.Connection = con;
cmd.CommandText = commandSQL;
return cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return -2;
}
finally
{
getTableforBM(altesBaumuster);
}
}
private int changeBM(string altesBaumuster, string neuesBaumuster)
{
string commandSQL = string.Empty;
commandSQL = "Update DPPLAUSIS SET DPPLAUSIS.BM = '" + fixBM(neuesBaumuster) + "' WHERE DPPLAUSIS.ACode = '700' AND DPPLAUSIS.BM LIKE '" + altesBaumuster + "%'";
try
{
cmd = new OracleCommand();
cmd.Connection = con;
cmd.CommandText = commandSQL;
return cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return -2;
}
finally
{
getTableforBM(altesBaumuster);
}
}