水晶易表调用C#的WebService,返回数据集合的应用解析

水晶易表调用C#的WebService,返回数据集合的应用解析：

1. 水晶易表不能识别WS接口返回的DataTable或DataSet数据类型，会提示“无法加载URL”

3. C#调用Oracle的Package，并返回数据列表

2. 经查证，可以接受string类型的，如果需要返回数据列表，那么需要借助数组来返回，代码实现如下：

代码如下:

public WeekSale_Table GetData(string skc1, string skc2, string week1, string week2, string week3, string week4)

       {

           try

           {

//C#调用Oracle的包，返回数据列表

               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);

（编辑：银川站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!