飞川科技论坛

标题: 关于不能增加行政在职人员的问题,盼解答 [打印本页]

作者: tfgz    时间: 2010-8-25 16:42
标题: 关于不能增加行政在职人员的问题,盼解答
广东省人事工资管理系统(下级版)
当执行操作:信息管理--> 增加行政在职人员时,填完表格,其中进入单位原因为新参加工作,完成按保存时弹出下面内容:
更改界面数据修改:Salarg.DateModi.Form.Form更改失败。
执行界面数据修改:在职人员基本信息(00000000-abb8-4f0c-be35-b63177ac3fac)失败执行SQL错误,SQL:Select max(convert(int,EmployeeFix.efc02)) from (select * from EmployeeFix union select * from EmployeeFixHis where EmployeeFixHis.bgn_date<='2010-07-31 00:00:00' and EmployeeFixHis.end_date>='1993-10-01 00:00:00' and EmployeeFixHis.implement_date<='2010-07-01 00:00:00' and EmployeeFixHis.disable_date>='2010-07-01 00:00:00') as EmployeeFix,(select * from EmployeeUnFix union select * from EmployeeUnFixHis where EmployeeUnFixHis.bgn_date<='2010-07-31 00:00:00' and EmployeeUnFixHis.end_date>='1993-10-01 00:00:00' and EmployeeUnFixHis.implement_date<='2010-07-01 00:00:00' and EmployeeUnFixHis.disable_date>='2010-07-01 00:00:00') as EmployeeUnFix where dept_id = 1 and  ( EmployeeFix.emp_id=EmployeeUnFix.emp_id and EmployeeUnFix.bgn_date>=EmployeeFix.bgn_date and EmployeeUnFix.bgn_date<=EmployeeFix.end_date )
   at Salary.DataModi.Form.FormExecutorBase.AcceptData(DataSet ds, XmlElement exeInfoContainer)
   at Salary.Web.DataModi.SingleFormModule.Update(FormExecutorBase executor, ExceuteInformation eif)

不能进入下一步,盼解答,谢谢!
作者: admin    时间: 2010-8-26 08:29
这个错误是执行查询最大人员编号语句造成的,应该是与你的数据有关,请发送数据备份和此截图至gdgzsupport@126.com便于查找问题,谢谢。




欢迎光临 飞川科技论坛 (http://www.flysoft.cn/bbs/) Powered by Discuz! X3.2