我补充一句就是,这些函数是我自定义的函数.我使用如下 myData.MySql = "select Bill_No as 系统单号,case when degree=1 then '一般'when degree=2 then '很急'when degree=3 then '特急' end as '紧急程度', case when PRI=1 then '低' when PRI=2 then '中' when PRI=3 then '高' end as '优先级',dbo.fn_itsys_getuserchname(Registrar,1) as 登记人,Presenter as 问题提出人,dbo.fn_itsys_getdeptcn(Department) as 部门,dbo.fn_itsys_MisNameCn(Intent_System) as 系统,dbo.fn_itsys_getuserchname(Accepter,1) as 维护员,b.Description as 状态,Register_Time as 登记时间,StartTime as 开始处理时间,Plan_SolveTime as 计划完成时间,Solve_Time as 实际完成时间 from Maintenance_Register a join Maintenance_StatusList b on a.status = b.status where " + Request["Where"];出现的错误如下 Page Error ! System.Data.SqlClient.SqlException: 对象名 'dbo.fn_itsys_getdeptcn' 无效。 at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SoftVindicate.DataClass.myDataTable() in \\get-ittest03\c$\inetpub\wwwroot\softvindicate\dataclass.cs:line 59 at SoftVindicate.Query.Page_Load(Object sender, EventArgs e) in \\get-ittest03\c$\inetpub\wwwroot\softvindicate\query.aspx.cs:line 27
myData.MySql = "select Bill_No as 系统单号,case when degree=1 then '一般'when degree=2 then '很急'when degree=3 then '特急' end as '紧急程度', case when PRI=1 then '低' when PRI=2 then '中' when PRI=3 then '高' end as '优先级',dbo.fn_itsys_getuserchname(Registrar,1) as 登记人,Presenter as 问题提出人,dbo.fn_itsys_getdeptcn(Department) as 部门,dbo.fn_itsys_MisNameCn(Intent_System) as 系统,dbo.fn_itsys_getuserchname(Accepter,1) as 维护员,b.Description as 状态,Register_Time as 登记时间,StartTime as 开始处理时间,Plan_SolveTime as 计划完成时间,Solve_Time as 实际完成时间 from Maintenance_Register a join Maintenance_StatusList b on a.status = b.status where " + Request["Where"];出现的错误如下
Page Error !
System.Data.SqlClient.SqlException: 对象名 'dbo.fn_itsys_getdeptcn' 无效。 at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SoftVindicate.DataClass.myDataTable() in \\get-ittest03\c$\inetpub\wwwroot\softvindicate\dataclass.cs:line 59 at SoftVindicate.Query.Page_Load(Object sender, EventArgs e) in \\get-ittest03\c$\inetpub\wwwroot\softvindicate\query.aspx.cs:line 27