爱华网{
if (grade == null)
return false;
string strSQL = "insert into satiType values(satiType_seq.nextval,:gName,:gValue)";
try
{
OracleCommand cmd = new OracleCommand();
cmd.CommandText = strSQL;
OracleParameter param = new OracleParameter("gName", OracleType.VarChar, 80);
param.Value = grade.SatiTypeName;
cmd.Parameters.Add(param);
param = new OracleParameter("gValue", OracleType.Int32, 3);
param.Value = grade.SatiTypeValue;
cmd.Parameters.Add(param);
dbOp.ExecCommand(cmd);
return true;
}
catch(Exception e)
{
; return false;
}
}
public void ExecCommand(OracleCommand cmd)
{
OracleConnection conn = GetConn();
cmd.Connection = conn;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
}
finally
{
conn.Close();
conn.Dispose();
}
}
