private void CreateProcedure()
{
string str = richTxtStoredDef.Text;
using (SymfowareConnection conn = DbUtil.GetConnection())
{
try
{
SymfowareCommand command = new SymfowareCommand(str, conn);
command.ExecuteNonQuery();
string text1 = "result: " + command.ToString();
MessageBox.Show("できた。");
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
public static SymfowareCommand CallProcedure(SymfowareCommand command, List <ProcedureParameter> paramInfos)
{
foreach (ProcedureParameter paramInfo in paramInfos)
{
SymfowareParameter param = new SymfowareParameter();
param.ParameterName = paramInfo.colName;
param.SymfowareDbType = paramInfo.getDataType();
param.Direction = paramInfo.getDirect();
if (param.Direction == ParameterDirection.Input)
{
param.Value = DbUtil.GetUserInput(paramInfo.colName);
}
else if (param.Direction == ParameterDirection.Output)
{
param.Size = paramInfo.max;
}
command.Parameters.Add(param);
}
command.ExecuteNonQuery();
return(command);
}