DetailDataTable = DetailTableAdapter.GetData_XCXF_DETAIL(Request.QueryString["sbh"].ToString(), Session["Condition_gly"].ToString());老是提示这行
CS1501: “GetData_XCXF_DETAIL”方法没有采用“2”个参数的重载我在这个方法GetData_XCXF_DETAIL明明定义了2个参数
CS1501: “GetData_XCXF_DETAIL”方法没有采用“2”个参数的重载我在这个方法GetData_XCXF_DETAIL明明定义了2个参数
procedure proc_xcxf_detail
(v_sbh char,
v_szpq varchar2,
p_cursor OUT SYS_REFCURSOR)
is
begin
open p_cursor FOR
SELECT A.SBH, A.MC AS NSRMC, SUBSTR(A.SBH, 1, 2) AS NSR_PROVINCE,
SUBSTR(A.SBH, 3, 2) AS NSR_CITY_2, SUBSTR(A.SBH, 1, 4) AS NSR_CITY,
SUBSTR(A.SBH, 5, 2) AS NSRSZQ_2, B.DM AS NSRSZQ, B.HY AS NSRSZQMC,
SUBSTR(A.SBH, 8, 2) AS SWSID_2, C.DM AS SWSID, C.MC AS NSRSZSMC,
SUBSTR(A.SZPQ, 9, 2) AS SZPQ_2, D.DM AS SZPQ, D.HY AS SZPQMC,
E.DM AS HYDM, E.HY AS HYMC, A.SWDJZZH, F.DM AS NSRZTDM, F.HY AS NSRZT,
A.BSRYLXDH AS NSR_TEL, A.JYDZ AS NSR_ADDRESS, A.FDDBR, A.CWFZR,
A.BSRY, G.DM AS ZCLX, G.HY AS ZCLXMC, H.GLBBH AS FPLGB, I.SBH AS TEMP1,
I.SQSJ AS TEMP2, I.SPYJ AS SNZSFS, J.SBH AS YWSSYH, A.JYFWZY AS JYFW,
decode(A.GGHBZ, '1', '1', '2') AS GGHBZ
FROM GLFW_SWDJ A, FP_GLBFF H, GLFW_QYSDS_HDSQ I, GLFW_RD J, DM_ZSDW C,
DM_SZPQ D, DM_HYDM E, DM_NSRZT F, DM_ZCLX G, DM_SWJG B
WHERE A.SBH = H.SBH (+) AND A.SBH = I.SBH (+) AND A.SBH = J.SBH (+) AND
A.ZSDW = C.DM AND A.SZPQ = D.DM AND A.KTHY = E.DM AND A.NSRZT = F.DM AND
A.ZCLX = G.DM AND (H.BZW (+) = '1') AND (J.QXBZ (+) = '0') AND (J.RDZT (+) = '1') AND
(I.SQSJ (+) = func_get_max_sqsj(I.SBH (+))) AND (B.DM LIKE '%' || SUBSTR(A.SBH, 1,
6) || '%') AND (A.SBH = v_sbh) AND (A.SZPQ = v_szpq);
end proc_xcxf_detail;
建议重新编译 得到最新的dll
如果你的函数参数类型为int,你不能传string给它,要int.parse(string)一下再传过去就是了
你那方法里的两个参数也必须要string类型啊