SELECT xiongkahao as 胸卡号, xingming as 姓名, xingbie as 性别, danweimc as 单位, gangweimc as 岗位, laobaomc as 劳保, shuliang as 数量, guige as 规格, lingqusj as 领取时间, jldanwei as 计量单位 FROM gerenjilu Where (DATEADD(month,( SELECT Top 1 qixian FROM gangweilaobao WHERE (gangweimc = '" + gangweimcTextBox.Text.ToString() + "')), lingqusj) < GETDATE()) AND (xiongkahao = '" + xiongkahaoTextBox.Text.ToString() + "')这条语句只能查出一条与劳保名称相对应的劳保用品到期的列表,问题是相同岗位的劳保用品有好几种并且每种的周期都不一样,怎么写语句才能把到期该更换的物品都查询出来?gangweilaobao表
-------------------------
gangweimc laobaomc qixiangerenjilu 表
-------------------------
xiongkahao xingming xingbie danweimc gangweimc laobaomc shuliang guige lingqusj jldanwei 其中个人记录表里gangweimc laobaomc和岗位劳保表里的gangweimc laobaomc相对应 也要用到岗位劳保表里的qixian字段和个人记录表里的lingqusj做日期比较告诉我该怎么做 先谢谢了!!!
-------------------------
gangweimc laobaomc qixiangerenjilu 表
-------------------------
xiongkahao xingming xingbie danweimc gangweimc laobaomc shuliang guige lingqusj jldanwei 其中个人记录表里gangweimc laobaomc和岗位劳保表里的gangweimc laobaomc相对应 也要用到岗位劳保表里的qixian字段和个人记录表里的lingqusj做日期比较告诉我该怎么做 先谢谢了!!!
解决方案 »
- 求助:一个c#编程题目
- win7下客户端不能使用域用户验证的问题
- 谁能给我一些c#编程题目 谢谢!!!
- C# SerialPort 类与读卡器的问题,请高手指教
- 求用安装向导打包ClickOnce的方法!
- 從 System.String 至 System.Guid 的轉換無效 高分幫忙看一下
- 再问kailong(凯龙)?class程序做成托盘后,为什么菜单出不来那?
- HttpWebRequst post 数据返回出错
- 刚入门的菜鸟一枚,求一个通讯录程序
- 查询速度如何提高?
- 在C#.NET中,如果设定了自定义绑定一个表中两列,怎样实现分页
- 用SmtpMail发送邮件时怎么样知道邮件是否发送成功?
FROM gerenjilu as x
inner join gangweilaobao as g
on g.gangweimc=x.ganweimc and g.laobaomc=x.laobaomc
where DATEADD(month,g.qixian,x.lingqusj) < GETDATE()
and x.gangweimc = '" + gangweimcTextBox.Text.ToString() + "'
and x.xiongkahao = '" + xiongkahaoTextBox.Text.ToString() + "'"另外,你的ganweilaobao表需要将(gangweimc,laobaomc)设置为主键或者唯一(unique)索引。如果不满足唯一约束,这个查询可能是错误的(有重复的)。
SELECT x.xiongkahao AS 胸卡号, x.xingming AS 姓名, x.laobaomc AS 劳保
FROM gerenjilu AS x INNER JOIN
gangweilaobao AS g ON g.gangweimc = x.gangweimc AND g.laobaomc = x.laobaomc
WHERE (DATEPART(year, DATEADD(month, g.qixian, x.lingqusj)) = DATEPART(year, @time)) AND (DATEPART(month, DATEADD(month, g.qixian, x.lingqusj))
= DATEPART(month, @time)) AND (x.gangweimc = @gangweimc) AND (x.xiongkahao = @xiongkahao)因为更换的单位时间是月 所以我加了datepart 不知道对不对 比较也改成=了 这样对单个职工可以查到当月该发的劳保,但是要查出每个单位的该发的物品不知道是在程序里写循环还是用sql就可以了