create proc NewUser
    @jobNo as varchar(35),
    @name as varchar(35),
    @type as nvarchar(20),
    @department as nvarchar(20),
    @message as nvarchar(500) output
as
begin
    set nocount on
    declare @count as int = 0
    if exists(select UserId from Users where JobNumber = @jobNo)
        begin
            set @message = N'用户已存在'
        end
    else
        begin
            declare @initialPwd as varchar(30) = '123456'
            declare @typeId as int = (select UserTypeId from UserType where UserTypeName = @type)
            declare @departId as int = (select DepartmentId from Department where DepartmentName = @department)
            begin try
                insert into ResearchUser
                (
                    JobNumber,
                    UserName,
                    UserPwd,
                    RU_DEPT_Id,
                    RU_UT_Id
                )
                values
                (
                    @jobNo,
                    @name,
                    @initialPwd,
                    @departId,
                    @typeId
                )
                set @count = @@ROWCOUNT
            end try
            begin catch
                set @message = (select error_message() as errorMessage)
            end catch
        end
    set nocount off
    select @count
end

public virtual int CreateUser(string jobNo, string userName, string userType, string department, ObjectParameter message)
        {
            var userJobNoParameter = jobNo!= null ?
                new ObjectParameter("jobNo", userJobNo) :
                new ObjectParameter("jobNo", typeof(string));
    
            var userNameParameter = userName != null ?
                new ObjectParameter("name", userName) :
                new ObjectParameter("name", typeof(string));
    
            var typeParameter = userType != null ?
                new ObjectParameter("type", userType) :
                new ObjectParameter("type", typeof(string));
    
            var departmentParameter = department != null ?
                new ObjectParameter("department", departName) :
                new ObjectParameter("department", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("CreateUser", userJobNoParameter, userNameParameter, typeParameter, departmentParameter, message);
        }

return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<int>>("NewUser", userJobNoParameter, userNameParameter, userTypeParameter, departNameParameter, message).FirstOrDefault().Value;