1. 水晶易表不能識(shí)別WS接口返回的DataTable或DataSet數(shù)據(jù)類型，會(huì)提示“無(wú)法加載URL”

3. C#調(diào)用Oracle的Package，并返回?cái)?shù)據(jù)列表

2. 經(jīng)查證，可以接受string類型的，如果需要返回?cái)?shù)據(jù)列表，那么需要借助數(shù)組來(lái)返回，代碼實(shí)現(xiàn)如下：
代碼如下:
public WeekSale_Table GetData(string skc1, string skc2, string week1, string week2, string week3, string week4)
        {
            try
            {
　　　　　　　　　//C#調(diào)用Oracle的包，返回?cái)?shù)據(jù)列表
                OracleConnection orcn = new OracleConnection(ConfigurationManager.AppSettings["SAPBI"].ToString());
                OracleCommand cmd = new OracleCommand("pkg_cx_Productlifecycle.skcweeksale", orcn);
                cmd.CommandType = CommandType.StoredProcedure;
                OracleParameter ip0 = new OracleParameter("skc1", OracleType.VarChar);
                OracleParameter ip1 = new OracleParameter("skc2", OracleType.VarChar);
                OracleParameter ip2 = new OracleParameter("week1", OracleType.VarChar);
                OracleParameter ip3 = new OracleParameter("week2", OracleType.VarChar);
                OracleParameter ip4 = new OracleParameter("week3", OracleType.VarChar);
                OracleParameter ip5 = new OracleParameter("week4", OracleType.VarChar);

                ip0.Value = skc1;
                ip1.Value = skc2;
                ip2.Value = week1;
                ip3.Value = week2;
                ip4.Value = week3;
                ip5.Value = week4;

                cmd.Parameters.Add(ip0);
                cmd.Parameters.Add(ip1);