SqlConnection conn = new SqlConnection(conn_string);
SqlCommand cmd = new SqlCommand("dbo.Week2DayFun", conn);//调用函数cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@s", SqlDbType.VarChar).Value = aResult.datecode;//Week2DayFun中需传入的参数
cmd.Parameters.Add("@Result", SqlDbType.VarChar).Direction = ParameterDirection.ReturnValue;
if (conn.State != System.Data.ConnectionState.Open)
conn.Open();
cmd.ExecuteNonQuery();
string ss = cmd.Parameters["@Result"].Value.ToString();//查询的结果
conn.Close();