private SqlParameter buildOutputParameter(proceTuple pt)
{
SqlParameter sqlParam = new SqlParameter(pt.ParamName, getSqlDbType(pt.TypeName), pt.TypeLegnth);
sqlParam.Direction = ParameterDirection.Output;
return(sqlParam);
}
// 全部都上
public void execProcedure(string ProcedureName, ArrayList paramList, ArrayList outValueList, proceTuple returnValue)
{
conn.Open();
_inputProcList = paramList;
_outputProcList = outValueList;
_returnProc = returnValue;
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = ProcedureName;
cmd.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < _inputProcList.Count; i++)
{
cmd.Parameters.Add(buildInputParameter(_inputProcList[i] as proceTuple));
}
for (int i = 0; i < _outputProcList.Count; i++)
{
cmd.Parameters.Add(buildOutputParameter(_outputProcList[i] as proceTuple));
}
SqlParameter sqlParam = new SqlParameter(_returnProc.ParamName, getSqlDbType(_returnProc.TypeName), _returnProc.TypeLegnth);
sqlParam.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(sqlParam);
cmd.ExecuteNonQuery();
}
conn.Close();
return;
}
private SqlParameter buildInputParameter(proceTuple pt)
{
SqlParameter sqlParam = new SqlParameter(pt.ParamName, getSqlDbType(pt.TypeName), pt.TypeLegnth);
sqlParam.Value = pt.inputData;
return(sqlParam);
}
