<insert id="insertUser" useGeneratedKeys="true" keyProperty="id">

        INSERT INTO sys_user(

            company_id,

            office_id,

            login_name,

            password,

            no,

            name,

            email,

            phone,

            mobile,

            user_type,

            create_by,

            create_date,

            update_by,

            update_date,

            remarks,

            login_flag,

            photo,

            del_flag,

            emp_id

        ) VALUES (

            #{company.id},

            #{office.id},

            #{loginName},

            #{password},

            #{no},

            #{name},

            #{email},

            #{phone},

            #{mobile},

            #{userType},

            #{createBy.id},

            #{createDate},

            #{updateBy.id},

            #{updateDate},

            #{remarks},

            #{loginFlag},

            #{photo},

            #{delFlag},

            #{empId}

        )

    </insert>