public override double ExecStoreReturn(string StoreName, string[] param1, object[] value)
{
string _sql = StoreName;
SqlService _sqlservice = new SqlService(connectionString);
for (int i = 0; i < param1.Length; i++)
{
_sqlservice.AddParameter(new SqlParameter(param1[i], value[i]));
}
SqlParameter paraOutput = new SqlParameter("@ReturnValue", SqlDbType.Float);
paraOutput.Value = 0;
paraOutput.Direction = ParameterDirection.Output;
_sqlservice.AddParameter(paraOutput);
try
{
_sqlservice.ExecuteSP(_sql);
return((double)paraOutput.Value);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sqlservice.CloseConnect();
_sqlservice.Disconnect();
}
}
