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