SoFunction
Updated on 2025-04-08

Crystal easy table calls C# WebService, and returns application analysis of data collection


public WeekSale_Table GetData(string skc1, string skc2, string week1, string week2, string week3, string week4)
        {
            try
            {
//C# calls Oracle's package and returns the data list
                OracleConnection orcn = new OracleConnection(["SAPBI"].ToString());
                OracleCommand cmd = new OracleCommand("pkg_cx_Productlifecycle.skcweeksale", orcn);
                = ;
                OracleParameter ip0 = new OracleParameter("skc1", );
                OracleParameter ip1 = new OracleParameter("skc2", );
                OracleParameter ip2 = new OracleParameter("week1", );
                OracleParameter ip3 = new OracleParameter("week2", );
                OracleParameter ip4 = new OracleParameter("week3", );
                OracleParameter ip5 = new OracleParameter("week4", );

                = skc1;
                = skc2;
                = week1;
                = week2;
                = week3;
                = week4;

                (ip0);
                (ip1);
                (ip2);
                (ip3);
                (ip4);
                (ip5);

                OracleParameter p1 = new OracleParameter("p_rc", );
                = ;
                (p1);

                OracleDataAdapter command = new OracleDataAdapter(cmd);
                DataSet ds = new DataSet();
                (ds, "Table");
                DataTable dt = ["Table"];
                WeekSale_Table wt = new WeekSale_Table();
                = new WeekSale_Row[];
                int rcount = ;
                for (int i = 0; i < rcount; i++)
                {
                    DataRow dr = [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();
                    = dr["WEEK"].ToString();
                    = dr["WEEKS"].ToString();
                    [i] = row;
                }
                return wt;
            }
            catch
            {
                return null;
            }
        }