【webservice】水晶易表调用C#的WebService 返回数据集合的应用分析-数据集合

欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【水晶易表调用C#的WebService,返回数据集合的应用分析】，下面是详细的讲解！

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

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);
                cmd.Parameters.Add(ip2);
                cmd.Parameters.Add(ip3);
                cmd.Parameters.Add(ip4);
                cmd.Parameters.Add(ip5);

                OracleParameter p1=new OracleParameter("p_rc", OracleType.Cursor);
                p1.Direction=System.Data.ParameterDirection.Output;
                cmd.Parameters.Add(p1);

                OracleDataAdapter command=new OracleDataAdapter(cmd);
                DataSet ds=new DataSet();
                command.Fill(ds, "Table");
                DataTable dt=ds.Tables["Table"];
                WeekSale_Table wt=new WeekSale_Table();
                wt.row=new WeekSale_Row[dt.Rows.Count];
                int rcount=dt.Rows.Count;
                for (int i=0; i < rcount; i++)
                {
                    DataRow dr=dt.Rows[i];
                    WeekSale_Row row=new WeekSale_Row();
                    row.DISCOUNT1=dr["DISCOUNT1"].ToString();
                    row.DISCOUNT2=dr["DISCOUNT2"].ToString();
                    row.FCALCSUMS1=dr["FCALCSUMS1"].ToString();
                    row.FCALCSUMS2=dr["FCALCSUMS2"].ToString();
                    row.NUMS1=dr["NUMS1"].ToString();
                    row.NUMS2=dr["NUMS2"].ToString();
                    row.SKC1=dr["SKC1"].ToString();
                    row.SKC2=dr["SKC2"].ToString();
                    row.WEEK=dr["WEEK"].ToString();
                    row.WEEKS=dr["WEEKS"].ToString();
                    wt.row[i]=row;
                }
                return wt;
            }
            catch
            {
                return null;
            }
        }

关于水晶易表调用C#的WebService,返回数据集合的应用分析的用户互动如下：

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细