這篇文章主要講解了“怎么調(diào)用C#的WebService”,文中的講解內(nèi)容簡(jiǎn)單清晰,易于學(xué)習(xí)與理解,下面請(qǐng)大家跟著小編的思路慢慢深入,一起來(lái)研究和學(xué)習(xí)“怎么調(diào)用C#的WebService”吧!
創(chuàng)新互聯(lián)是專業(yè)的代縣網(wǎng)站建設(shè)公司,代縣接單;提供成都網(wǎng)站建設(shè)、成都網(wǎng)站設(shè)計(jì),網(wǎng)頁(yè)設(shè)計(jì),網(wǎng)站設(shè)計(jì),建網(wǎng)站,PHP網(wǎng)站建設(shè)等專業(yè)做網(wǎng)站服務(wù);采用PHP框架,可快速的進(jìn)行代縣網(wǎng)站開(kāi)發(fā)網(wǎng)頁(yè)制作和功能擴(kuò)展;專業(yè)做搜索引擎喜愛(ài)的網(wǎng)站,專業(yè)的做網(wǎng)站團(tuán)隊(duì),希望更多企業(yè)前來(lái)合作!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)如下:
復(fù)制代碼 代碼如下:
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);
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;
}
}
復(fù)制代碼 代碼如下:
//定義Row,一行
public class WeekSale_Row
{
public string WEEKS;
public string SKC1;
public string SKC2;
public string FCALCSUMS1;
public string FCALCSUMS2;
public string NUMS1;
public string NUMS2;
public string DISCOUNT1;
public string DISCOUNT2;
public string WEEK;
}
//定義Table
public class WeekSale_Table
{
public WeekSale_Row[] row;
}
感謝各位的閱讀,以上就是“怎么調(diào)用C#的WebService”的內(nèi)容了,經(jīng)過(guò)本文的學(xué)習(xí)后,相信大家對(duì)怎么調(diào)用C#的WebService這一問(wèn)題有了更深刻的體會(huì),具體使用情況還需要大家實(shí)踐驗(yàn)證。這里是創(chuàng)新互聯(lián)網(wǎng)站建設(shè)公司,,小編將為大家推送更多相關(guān)知識(shí)點(diǎn)的文章,歡迎關(guān)注!
當(dāng)前名稱:怎么調(diào)用C#的WebService-創(chuàng)新互聯(lián)
文章位置:http://aaarwkj.com/article16/ccoedg.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供域名注冊(cè)、動(dòng)態(tài)網(wǎng)站、關(guān)鍵詞優(yōu)化、云服務(wù)器、網(wǎng)站設(shè)計(jì)、品牌網(wǎng)站制作
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來(lái)源: 創(chuàng)新互聯(lián)
猜你還喜歡下面的內(nèi)容