16,554
社区成员
发帖
与我相关
我的任务
分享
SELECT j.wk_no, j.jb_no, j.jb_name, j.dept_no,CONVERT(varchar(12) , j.jb_date, 111 ) as jb_date,
j.wk_stat, j.jbr_sq_dat, j.jb_note, j.ow_no, s.jbr_no, s.jbr_name,
s.jbr_date_s, s.jbr_date_e, s.jbr_tnum, e.emp_cnam,
(
select sum(jb) from srv_lnk3.[kqxt1].dbo.kq where userid=@emp_no
and rq =@rq
) as aaa
FROM its.dbo.jb1001 j ,
its.dbo.jb1001s s ,
its.dbo.emp e ,
srv_lnk3.[kqxt1].dbo.kq
WHERE (j.wk_no = @wk_no)and j.wk_no = s.wk_no
and j.ow_no = '01' + e.emp_no
Me.sqldtsr1001app.SelectParameters("emp_no").DefaultValue = Me.GridView4.Rows(0).Cells(9).Text.ToString
'日期字符串转换失败
Me.sqldtsr1001app.SelectParameters("rq").DefaultValue = CDate(Me.GridView4.Rows(0).Cells(4).Text)
’其中CDate(Me.GridView4.Rows(0).Cells(4).Text)在后台输出的值是'2009/04/03'
SELECT j.wk_no, j.jb_no, j.jb_name, j.dept_no, j.jb_date,
j.wk_stat, j.jbr_sq_dat, j.jb_note, j.ow_no, s.jbr_no, s.jbr_name,
s.jbr_date_s, s.jbr_date_e, s.jbr_tnum, e.emp_cnam,
(
select sum(jb) from srv_lnk3.[kqxt1].dbo.kq
where username='徐宁'
and rq='2009/04/18'
) as aaa
FROM its.dbo.jb1001 j ,
its.dbo.jb1001s s ,
its.dbo.emp e ,
srv_lnk3.[kqxt1].dbo.kq
WHERE (j.wk_no = '2010000001')and j.wk_no = s.wk_no and j.ow_no = '01' + e.emp_no