标题: 无法录入在职基本信息，附上提示 [打印本页] 作者: asdf123 时间: 2010-10-13 10:17 标题: 无法录入在职基本信息，附上提示 执行界面数据修改：在职人员基本信息(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-04-30 00:00:00' and EmployeeFixHis.end_date>='1993-10-01 00:00:00' and EmployeeFixHis.implement_date<='2010-04-01 00:00:00' and EmployeeFixHis.disable_date>='2010-04-01 00:00:00') as EmployeeFix,(select * from EmployeeUnFix union select * from EmployeeUnFixHis where EmployeeUnFixHis.bgn_date<='2010-04-30 00:00:00' and EmployeeUnFixHis.end_date>='1993-10-01 00:00:00' and EmployeeUnFixHis.implement_date<='2010-04-01 00:00:00' and EmployeeUnFixHis.disable_date>='2010-04-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)